Re: problem with ' or "

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



George B wrote:
Jasper Bryant-Greene wrote:

George B wrote:

I made a script that posts data into a database but it has a problem whenever I enter a ' or a ". How do I bypass this problem?

If it is MySQL, use mysql_real_escape_string() [1]. If any other database, have a look in the PHP manual [2] for the relevant function, or as a last resort use addslashes().

Jasper

[1] http://www.php.net/mysql_real_escape_string
[2] http://www.php.net/docs.php

Where do I put the code in?


Example:

$value = mysql_real_escape_string($_POST['value']);
$results = mysql_query("SELECT * FROM sometable WHERE field='$value'");

Jasper

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux