我的引号有问题。我不能为$gname使用"或"。我能为此做些什么。
$new_post = array( 'post_content' => ' ..CODES.. $result = mysqli_query($con,"SELECT * FROM wp_games WHERE name = $gname "); ..CODES..
我正试图在wordpress上创建一个帖子。我有一个插件可以在帖子上使用php。[insert_php]就是这个插件。我也不能使用像"…"这样的引号。下面是更多的代码。
$new_post = array(
'post_content' => '[insert_php]$con=mysqli_connect("localhost","root","","wordpress");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM wp_games WHERE name = '$gname' ");
while($row = mysqli_fetch_assoc($result)) {
echo $row["name"];
}
mysqli_close($con);
[/insert_php]',
您可以使用chr(39)创建一个引号并将其附加到字符串中。您还应该逃离$gname 的内容
mysqli_query($con,"SELECT * FROM wp_games WHERE name = " . chr(39) . mysqli_real_escape_string($con, $gname) . chr(39));