| Re: solved [message #186105 is a reply to message #186103] |
Sat, 14 June 2014 00:48   |
Mr Oldies
Messages: 241
Registered: October 2013
Karma:
|
Senior Member |
|
|
On Fri, 13 Jun 2014 19:43:52 -0400, Jerry Stuckle wrote:
> 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.
Jerry, you have stepped down to evan's level for sure.
this is a string: "It's Late".
this is a variable string: $x="It's Late".
The variable is nothing more than a shortcut.
The variable allows us to use the same information over and over and at
numerous places. We don't have to use a variable but it is there.
It is cvalled a variable because the content can change as desired.
I'm done with you here, asswipe.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]