今天给大家介绍了关于mysql语句插入含单引号或反斜杠值的相关内容,下面话不多说了,来一起看看详细的介绍吧
比如说有个表,它的结构是这个样子的
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5yYihDZ3MTNwcjNiBDNzAzNxQzYyIzM4ATOkJmZ0IWN38CX0JXZ252bj91Ztl2Lc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
比如说往里面插入记录,示例代码如下:
$servername = "xxxxservername";$port = 3306;$username = "xxxusername";$password = "xxxpwd";$dbname = "xxxxxxdb"; // 创建连接$conn = new mysqli($servername, $username, $password, $dbname, 8306); // 检测连接if ($conn->connect_error) { die("connect failed: " . $conn->connect_error);} $item['title'] = 'happy new year!';$sql = sprintf("INSERT INTO activity (title) VALUES ( '%s');