php - 当字符串中存在唯一数据时，如何使用php插入数据

Question

我试图在 wordpress 表中手动插入一些数据，但每当我运行查询时，它都会给我这个错误:--

PHP Parse error:  syntax error, unexpected T_LNUMBER in /home/yogi/public_html/shontp/wp-content/themes/bridge-child/jut-login.php on line 19

这是插入查询的代码:--

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO `ssdcu_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '15', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}')";

if ($conn->multi_query($sql) === TRUE) {
    echo "New records created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

Answer 1

替换

$sql = "INSERT INTO `ssdcu_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '15', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}')";

与

$sql = "INSERT INTO `ssdcu_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
VALUES (NULL, '15', 'wp_capabilities', 'a:1:{s:13:\"administrator\";s:1:\"1\";}')";