php - 检查表(phpmyadmin、php、mysql)中的值，仅返回 0

Question

我正在尝试创建一个页面来查找您输入的文本是否存在于我的数据库表中。但即使存在，它也只返回 0。

<?php
    $db = mysql_connect("database", "user", "password") or die("Could not connect to MySQL. ".MySQL_error());
    mysql_select_db("myData",$db);
?>
<form method = "POST" action = "website.php">
<input type = "text" name = "text">
<input type = "submit" name = "button1" value = "check">
</form>
<?php
    if(isset($_POST["button1"])) {
        $txt = $_POST['text'];
        $sql = mysql_query("SELECT COUNT(*) as total FROM myText WHERE text = $txt");
        $quantity = mysql_fetch_assoc($sql);
        echo $quantity['total'];
    }
?>

Answer 1

<?php
    $db = mysqli_connect("host", "user", "password", "database");
?>
<form method = "POST" action = "website.php">
    <input type = "text" name = "text">
    <input type = "submit" name = "button1" value = "check">
</form>
<?php
    if(isset($_POST["button1"])) {
        $txt = $_POST['text'];
        $sql = mysqli_query($db, "SELECT COUNT(*) as total FROM myText WHERE text = '".$txt."'");
        $quantity = mysqli_fetch_object($sql);
        echo $quantity->total;
    }
?>