如何在MYSQL查询中转义引号？

Question

Example: The follwing query give me Quotes error in the field -> GET['email']

    mysql_query(" select * from user_info where user_mail = '$_GET['email']' ")

Answer 1

You might want to escape the string first:

$_GET['email'] = mysql_real_escape_string($_GET['email']);

And then:

mysql_query(" select * from user_info where user_mail = '" . $_GET['email'] . "' ");

The dots put the strings together.