Re: MySQL and apostrophes, interesting problem. 42082
| From: | Robert Weeks | Date: | Sun, 10 Mar 2002 16:37:07 +0000 |
| Subject: | Re: MySQL and apostrophes, interesting problem. 42082 | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-general+get-87908@lists.php.net to get a copy of this message | ||
See the manual at php.net:
addslashes()
stripslashes()
I've found it easier to just turn on magic-quotes in the php.ini file
This is all covered at php.net
Robert
----- Original Message -----
From: "Nick Patsaros" <npatsaros@yahoo.com>
To: <php-db@lists.php.net>; <php-general@lists.php.net>
Cc: <npatsaros@yahoo.com>
Sent: Sunday, March 10, 2002 11:23 AM
Subject: [PHP-DB] MySQL and apostrophes, interesting problem. 42082
> I'm working with a simple form which submits field
> data to a MySQL database. This is for the purpose of
> generating a dynamic news page for my site.
> Interestingly enough I've found that any time I try to
> submit data that contains an apostrophe "'" it gives
> me an error and will not send the data (any of it) to
> the database.
>
> How can I change my database query, or escape out
> apostrophes? I'm looking for the easiest fix out
> there of course. Below is my current DB query. I
> realize I'm using apostrophes for my variables... is
> this acceptable syntax and/or is there a replacement?
>
> $query = "INSERT into $table values ('0', '$year',
> '$month', '$day', '$hour', '$minutes',
> '$seconds',
> '$article_name', '$content', '$admin_name')";
>
>
> __________________________________________________
> Do You Yahoo!?
> Try FREE Yahoo! Mail - the world's greatest free email!
> http://mail.yahoo.com/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>