sql语句中的文本变量- PHP

Question

我试图在sql语句中获取变量，put sql不会将其视为字符串。我花了很长时间寻找解决方案，但我想不出来。

<?php ob_start(); ?>
    <h2 class="title_test"></h2>
    <?php $contents = ob_get_contents(); 
    $test = 'Singer/Songwriter Nadine Shah Interview';
    $myText = (string)$contents;
    $result = mysqli_query($con, "SELECT channel_id FROM guestlist_tvs WHERE title = '$myText'");
    $row = mysqli_fetch_array($result);
    echo $row[0];
?>

ob_start从h2获取文本

myText从$contents (h2之间的值)生成一个字符串。但是如果我运行sql语句，我得不到任何结果。

如果我把它作为SQL语句；

$result = mysqli_query($con, "SELECT channel_id FROM guestlist_tvs WHERE title = '$test'");

它返回正确的标题。所以把我的变量转换成字符串有问题，我不知道怎么修复它。

我们将非常感谢您的每条评论。

谢谢

Answer 1

<?php ob_start(); ?>
<h2 class="title_test"></h2>
<?php $contents = ob_get_contents(); 
$test = 'Singer/Songwriter Nadine Shah Interview';
$myText = mysqli_real_escape_string($con, trim(strip_tags($contents)));
$result = mysqli_query($con, "SELECT channel_id FROM guestlist_tvs WHERE title = '$myText'");
$row = mysqli_fetch_array($result);
echo $row[0]; 
?>

这个怎么样？

Answer 2

尝试这种方式"SELECT title FROM guestlist_tvs WHERE title=‘“.$test.”“