| Re: solved [message #186103 is a reply to message #186102] |
Fri, 13 June 2014 23:43   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 6/13/2014 6:29 PM, richard wrote:
> On Fri, 13 Jun 2014 16:38:04 -0400, Jerry Stuckle wrote:
>
>> On 6/13/2014 4:16 PM, Tim Streater wrote:
>>> In article <157nwayhe47ig(dot)1exa9x5yqxi59$(dot)dlg(at)40tude(dot)net>, richard
>>> <noreply(at)example(dot)com> wrote:
>>>
>>>> On Fri, 13 Jun 2014 15:01:53 -0400, Jerry Stuckle wrote:
>>>>
>>>> > On 6/13/2014 2:43 PM, richard wrote:
>>>> >> On Fri, 13 Jun 2014 10:14:06 -0400, Jerry Stuckle wrote:
>>>> >>>>> On 6/13/2014 9:57 AM, richard wrote:
>>>> >>>> On Fri, 13 Jun 2014 00:57:10 -0400, richard wrote:
>>>> >>>>
>>>> >>>>> When attempting to transfer records from one table to another,
>>>> certain
>>>> >>>>> records refuse to be.
>>>> >>>>> Such as those with words like "I'm".
>>>> >>>>> What's even more confusing is, "It's" won't work, but "Cathy's"
>>>> is ok?
>>>> >>>>>
>>>> >>>>> I know there is a procedure in PHP for dealing with this.
>>>> >>>>> I just can't find it right now.
>>>> >>>>> Can anyone help on this?
>>>> >>>>
>>>> >>>> $a=str_replace("'","\'",$a);
>>>> >>>> Works just fine.
>>>> >>>> Thanks for the reminder tim.
>>>> >>>>
>>>> >>>
>>>> >>> That might work for sqllite, but it's definitely the WRONG way to
>>>> do it
>>>> >>> in MySQL.
>>>> >>>> As you continously remind me, this is not an mysql issue.
>>>> >> The table data could care less what characters are in it.
>>>> >> mysqli doesn't give a shit either.
>>>> >>>> if I code the data with a \ in the column cell, the output will
>>>> show that
>>>> >> \.
>>>> >>>> One again you are WRONG! As evidenced by the failure of the
>>>> insertions.
>>>> >> And if you would have checked for errors (as you've been told many
>>>> times
>>>> > before), you would have found a MySQL error.
>>>> >> I remind you if something is not a MySQL issue when it's not a MySQL
>>>> > issue. However, you can't learn the difference between PHP and MySQL.
>>>> >> Here's a hint: PHP doesn't care what's in a string. So if neither
>>>> one
>>>> > cares, why should the INSERT fail?
>>>>
>>>> Jerry, you are argumentative here just to be arguing.
>>>> I did put in an error check.
>>>> That confirmed that it was the single quotes causing the problem.
>>>>
>>>> What's going to happen when you say:
>>>> insert into tabe VALUES('it's').
>>>> PHP, not mysqli, kicks back an error right?
>>>> PHP sees the third single quote as a mismatch.
>>>> To correct this, you must include a \.
>>>> Insert into table VALUES('it\'s') is now acceptable.
>>>
>>> Can you post the exact PHP statement you were using?
>>>
>>> See, if you were doing something like (I don't know the syntax exactly):
>>>
>>> $dbh->mysqli ("insert into table VALUES('it's')");
>>>
>>> then if you're using double-quotes (") to delimit the SQL string, PHP
>>> won't care that you have three single quotes inside it. That's just
>>> string data to PHP. What will happen is that mysqli will complain,
>>> because what it gets passed is wrong SQL.
>>>
>>> It would still be mysqli complaining if you did this:
>>>
>>> $dbh->mysqli ("three coins in a fountain, said Fred");
>>>
>>
>> Tim,
>>
>> No, RTS can't tell the difference between a string containing a single
>> quote and a string variable containing a single quote.
>
> Jerry, all you're doing now is bashing me.
> Makes no difference what the issue is, you just have to bash.
> Besides, you fucked up.
> You said single quote twice.
> (Oh but I meant to say that)
>
> You have stepped down to Evan's level.
>
I'm just telling the truth, RTS. And I know I said single quote twice -
I meant to. And anyone with half a brain understands what I said.
--
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]