检查表(phpmyadmin、php、mysql）中的值，只返回0 - Checking for values in table (phpmyadmin, php, mysql), only returns a 0

Checking for values in table (phpmyadmin, php, mysql), only returns a 0

我正在尝试创建一个页面，以查看您输入的文本是否存在于我的数据库中的表中。但它只返回一个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'];
    }
?>

<?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;
    }
?>