RE: [PHP] Submiting Data with an '
| From: | ..s.c.o.t.t.. | Date: | Fri, 06 Jul 2001 06:14:01 +0000 |
| Subject: | RE: [PHP] Submiting Data with an ' | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-56435@lists.php.net to get a copy of this message | ||
or you could roll your own
function db_quote($data) {
$data = preg_replace("/'/", "''", $data);
return $data;
}
> -----Original Message-----
> From: ReDucTor [mailto:sjdtmv@tpg.com.au]
> Sent: Thursday, July 05, 2001 19:54
> To: Chris Anderson
> Cc: php-general@lists.php.net
> Subject: Re: [PHP] Submiting Data with an '
>
>
> addslashes()
> php.net/addslashes
> ----- Original Message -----
> From: Chris Anderson <chrisderson@ameritech.net>
> To: Matthew Loff <matt@willetts.com>; 'Mike Mike'
> <hatchman2000@yahoo.com>;
> <php-general@lists.php.net>
> Sent: Friday, July 06, 2001 12:45 PM
> Subject: Re: [PHP] Submiting Data with an '
>
>
> > On the same subject, can I make it automatically addslahes to my
> variables?
> > Or should I just make my own mysql class?
> > ----- Original Message -----
> > From: "Matthew Loff" <matt@willetts.com>
> > To: "'Mike Mike'" <hatchman2000@yahoo.com>;
> > <php-general@lists.php.net>
> > Sent: Thursday, July 05, 2001 3:29 PM
> > Subject: RE: [PHP] Submiting Data with an '
> >
> >
> > >
> > > Use the addslashes() call to automatically escape characters like that.
> > >
> > > MySQL will not add the slashes into the table cell, so no need to
> > > stripslashes() after you SELECT it back out.
> > >
> > >
> > > -----Original Message-----
> > > From: Mike Mike [mailto:hatchman2000@yahoo.com]
> > > Sent: Thursday, July 05, 2001 3:19 PM
> > > To: php-general@lists.php.net
> > > Subject: [PHP] Submiting Data with an '
> > >
> > >
> > > Hello everyone,
> > > I'm having a problem of submiting an ' into a mysql
> > > database. When I have a ' it doesn't update or submit
> > > the data. but if I use \' it works fine. Does anyone
> > > know of a way around this.
> > > Thanks
> > > --Mike
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Get personalized email addresses from Yahoo! Mail
> > > http://personal.mail.yahoo.com/
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > > For additional commands, e-mail: php-general-help@lists.php.net To
> > > contact the list administrators, e-mail: php-list-admin@lists.php.net
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > > For additional commands, e-mail: php-general-help@lists.php.net
> > > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> > >
> > >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-general-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>