RE: [PHP] Submiting Data with an '
or you could roll your own
function db_quote($data) {
$data = preg_replace("/'/", "''", $data);
return $data;
}
> -Original Message-
> From: ReDucTor [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 05, 2001 19:54
> To: Chris Anderson
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Submiting Data with an '
>
>
> addslashes()
> php.net/addslashes
> - Original Message -
> From: Chris Anderson <[EMAIL PROTECTED]>
> To: Matthew Loff <[EMAIL PROTECTED]>; 'Mike Mike' <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]>
> > To: "'Mike Mike'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > 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:[EMAIL PROTECTED]]
> > > Sent: Thursday, July 05, 2001 3:19 PM
> > > To: [EMAIL PROTECTED]
> > > 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: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED] To
> > > contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> > >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Submiting Data with an '
addslashes() php.net/addslashes - Original Message - From: Chris Anderson <[EMAIL PROTECTED]> To: Matthew Loff <[EMAIL PROTECTED]>; 'Mike Mike' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > To: "'Mike Mike'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > 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:[EMAIL PROTECTED]] > > Sent: Thursday, July 05, 2001 3:19 PM > > To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] To > > contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]> To: "'Mike Mike'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 3:19 PM > To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] To > contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 3:19 PM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
