| Bastien Koert 2007-03-28, 7:59 am |
| use
mysql_real_escape_string($_POST['field']
IN the query
use addslashes
use htmlspecialentities
use str_replace to switch it to an ascii equivalent
hth
bastien
>From: "Stephen Smith" <kd8con@bex.net>
>To: <php-db@lists.php.net>
>Subject: [PHP-DB] Using apostrophe's within a text field
>Date: Wed, 28 Mar 2007 00:15:03 -0400
>
>OK guys, here is my delima, which is probably very easy to solve, but I
>can't seem to find it. I am trying to get form fields to accept
>apostrophes within the input and stop crashing on me. I'm writing forms
>into a mysql database and everything works great unless the user enters a
>word like "won't" or "can't". Them it crashes during the form submit.
>What can I do to fix this stupid thing anyway?
>
>thanks in advance.
>
>Steve Smith
________________________________________
_________________________
http://local.live.com/?mkt=en-ca/?v...6D6BDB4586E357F!420
|