Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #13836

Re: solved

Show all headers | View raw

In article <157nwayhe47ig.1exa9x5yqxi59$.dlg@40tude.net>, richard
<noreply@example.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");

-- 
"People don't buy Microsoft for quality, they buy it for compatibility
with what Bob in accounting bought last year. Trace it back - they buy
Microsoft because the IBM Selectric didn't suck much" - P Seebach, afc

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

function for preserving special characters? richard <noreply@example.com> - 2014-06-13 00:57 -0400
  Re: function for preserving special characters? Tim Streater <timstreater@greenbee.net> - 2014-06-13 10:03 +0100
    Re: function for preserving special characters? Christoph Michael Becker <cmbecker69@arcor.de> - 2014-06-13 15:32 +0200
      Re: function for preserving special characters? Tim Streater <timstreater@greenbee.net> - 2014-06-13 14:42 +0100
        Re: function for preserving special characters? Christoph Michael Becker <cmbecker69@arcor.de> - 2014-06-13 16:26 +0200
          Re: function for preserving special characters? Tim Streater <timstreater@greenbee.net> - 2014-06-13 18:23 +0100
  Re: function for preserving special characters? Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-13 10:39 +0000
    Re: function for preserving special characters? Paul Herber <paul@pherber.com> - 2014-06-13 12:37 +0100
      Re: function for preserving special characters? Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-13 12:59 +0000
      Re: function for preserving special characters? richard <noreply@example.com> - 2014-06-13 14:45 -0400
  solved  (was: function for preserving special characters?) richard <noreply@example.com> - 2014-06-13 09:57 -0400
    Re: solved Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-13 10:14 -0400
      Re: solved richard <noreply@example.com> - 2014-06-13 14:43 -0400
        Re: solved Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-13 15:01 -0400
          Re: solved richard <noreply@example.com> - 2014-06-13 15:44 -0400
            Re: solved Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-13 16:09 -0400
            Re: solved Tim Streater <timstreater@greenbee.net> - 2014-06-13 21:16 +0100
              Re: solved Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-13 16:38 -0400
                Re: solved richard <noreply@example.com> - 2014-06-13 18:29 -0400
                Re: solved Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-13 19:43 -0400
                Re: solved richard <noreply@example.com> - 2014-06-13 20:48 -0400
                Re: solved Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-13 21:39 -0400
                Re: solved Evan Platt <evan@theobvious.espphotography.com.invalid> - 2014-06-13 21:20 -0700
                Re: solved Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-14 19:50 +0000
              Re: solved richard <noreply@example.com> - 2014-06-13 18:23 -0400
                Re: solved Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-14 20:01 +0000
            Re: solved Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-13 20:50 +0000
  Re: function for preserving special characters? Richard Damon <Richard@Damon-Family.org> - 2014-06-13 20:45 -0400
    Re: function for preserving special characters? Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-13 20:51 -0400
      Re: function for preserving special characters? Richard Damon <Richard@Damon-Family.org> - 2014-06-13 22:08 -0400

csiph-web