如何从PHP中的数据库中获取单个数字[重复]

Question

This question already has an answer here:

• Can I mix MySQL APIs in PHP? 4 answers

I need to echo the number 1 or 0 whatever the database has in that cell. I cant seem to get it to work. What am I doing wrong people of the internet?

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "testfp";
$conn = new mysqli($servername, $username, $password, $dbname);


$sql = "SELECT hookup FROM testfp WHERE name = 100100" ;
$bob = mysql_query($sql);
echo $bob;
?>

</div>

Answer 1

You can not use mysql and mysqli together. So you can try the following code (using mysqli only, since mysql is deprecated) :

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "testfp";
$conn = new mysqli($servername, $username, $password, $dbname);
//Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT hookup FROM testfp WHERE name = 100100" ;
$result = $conn->query($sql);
if($result->num_rows>0)
{
    while($row = $result->fetch_assoc()) {
        echo $row["hookup"];
    }
}
else
{
    echo "No results found!";
}
?>