PHP 中的 mysqli real escape string函

mysqli real escape string - 语法

mysqli_real_escape_string(connection,escapestring);

它函数转义SQL语句的字符串中的特殊字符。

mysqli real escape string - 返回值

它返回转义字符串。

mysqli real escape string - 示例

<?php
   $con=mysqli_connect("localhost","my_user","my_password","my_db");
   
   if (mysqli_connect_errno($con)){
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }
   $myName="Jr's";
   $myName=mysqli_real_escape_string($con,$myName);
   
   mysqli_query($con,"INSERT into emp (name) VALUES ('$myName')");
   mysqli_close($con);
?>