RE: [PHP-DB] Re: Stuck in apostrophe hell
| From: | Ford, Mike | Date: | Wed, 04 Aug 2010 08:20:28 +0000 |
| Subject: | RE: [PHP-DB] Re: Stuck in apostrophe hell | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47292@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Simcha Younger [mailto:simcha@syounger.com]
> Sent: 04 August 2010 08:19
>
> > Paul_S_Johnson@mnb.uscourts.gov wrote:
>
> > >
> > > THE INPUT:
> > >
> > > $sql_insert_registration = sprintf("INSERT INTO
> > > Registrations (
> > > Class_ID,
> > > prid,
> > > Registrant,
> > > Company,
> > > Phone,
> > > Email
> > > )
> > > VALUES (
> > > $_POST[Class_ID],
> > > $_POST[prid],
> > > '%s',".
>
> You need double-quotes here,
> \"%s\",
No, he doesn't. Single quotes are fine. Doubles would more than likely be a SQL error.
> > > parseNull($_POST['Company']).",
> > > '$_POST[Phone]',
> > > '$_POST[Email]'
> > > )", mysql_real_escape_string($_POST['Registrant']));
> > >
>
>
> --
> Simcha Younger <simcha@syounger.com>
Cheers!
Mike
--
Mike Ford,
Electronic Information Developer, Libraries and Learning Innovation,
Leeds Metropolitan University, C507 City Campus,
Woodhouse Lane, LEEDS, LS1 3HE, United Kingdom
Email: m.ford@leedsmet.ac.uk
Tel: +44 113 812 4730
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm