用php查询数据库

Question

I am trying to query my database using php, to then display the results of the query. For this example, I only want the number of elements in my MySQL database.

My code is:

<?php
    print("This is just a test");
    print("This is another test");
    // Create connection
    $con=mysqli_connect("mysql.netsons.com","****","****","****");

    // Check connection
    if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    print("A third test");

    $result = mysqli_query($con, "SELECT COUNT(*) FROM MyGames");
    echo $result;
    echo mysqli_fetch_array($result);
    print("A forth test");
    mysqli_close($con);
?>

This is the result:

This is just a testThis is another testA third test

What am I doing wrong?

Answer 1

mysql_fetch_array fetches ... an array.

$row = mysqli_fetch_array($result);
echo $row["COUNT(*)"];

I think it would be better to alias that column too:

SELECT COUNT(*) AS count FROM MyGames
...
echo $row['count'];