dongtuoao7987 2011-07-22 17:16
浏览 120
已采纳

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

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

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

5条回答 默认 最新

  • duanfuchi7236 2011-07-22 17:18
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?