Re: [PHP] MySQL and apostrophes, interesting problem. 42082
Read the manual about magic_quotes_gpc and addslashes() I prefer to add slashes myself, that way I can verify input lengths but it has the risk that I might miss a field. The trouble with magic_quotes_gpc is that if you have to re-display a variable you have to stripslashes() first. - Original Message - From: "Nick Patsaros" <[EMAIL PROTECTED]> Subject: [PHP] 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] 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 General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php