Programming

  • 4 {{ upvoteCount | shortNum }}

    Why does mysql db stop saving when it detects a single qoute even if I escape them?

    jalicia18 in Programming

    Code: $firstname=mysql_real_escape_string("joh'n"); $middlename=mysql_real_escape_string("do'e"); $lastname=mysql_real_escape_string("smit'h"); $home_address=mysql_real_escape_string("addres's") ; UPDATE `users` SET `firstname`='$firstname',`middlename`='$middlename ',`lastname`='$lastname',`home_address`='$home_add ress' WHERE `user_id`=$userid What will be saved are: joh do smit addres All other characters can be saved but ... [read more]