Welcome to WebmasterWorld Guest from 54.166.146.212

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

validating form input

need to validate apostrophe

     
7:18 am on Aug 4, 2013 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 9, 2006
posts: 177
votes: 0


Hello all,

I am having an issue where if there is an apostrophe in a field, the data is not being accepted into the database and errs out.

Sample:

$field1=mysql_real_escape_string(stripslashes(ucwords(strtolower($_POST['input']))));



insert into database
$insert=mysql_query("INSERT INTO $tablename values (\"\", '$field1', '$field2', '$field3', '$field4')")


Any help appreciated.
4:49 pm on Aug 4, 2013 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts: 15756
votes: 0


is it field1 that is giving the error? what is the exact error?

I do find it much easier when I build my queries separate from the mysql_query call, like so

$q = "INSERT INTO $tablename values ('', '$field1', '$field2', '$field3', '$field4')";
echo $q;
$insert = mysql_query($q);

then I can echo the exact thing I am sending and paste that into the command line or phpmyadmin, or whatever you use for mysql, and look at the precise error.

you also should use only single quotes inside your qeury and double around, makes things easier
5:25 pm on Aug 4, 2013 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 9, 2006
posts: 177
votes: 0


Thanks, the double/single worked.