MySQL PHP：无法获得任何结果[重复]

Question

This question already has an answer here:

• Why shouldn't I use mysql_* functions in PHP? 15 answers

I was trying to just print the content of my MySQL Database with PHP.

This is how my database looks like:

mysql> show tables;
+-------------------+
| Tables_in_myTable |
+-------------------+
| users             |
+-------------------+
1 row in set (0,00 sec)

mysql> select * from users;
+------------+
| name       |
+------------+
| Nick       |
+------------+
1 row in set (0,00 sec)

My PHP code looks like this:

    <?php
echo "HI"; //to see, that the php gets runned at all.

$connection = mysql_connect('localhost', 'root', ''); //The Blank string is the password
mysql_select_db('myTable');

$query = "SELECT * FROM users"; 
$result = mysql_query($query);

echo "<table>"; 

while($row = mysql_fetch_array($result)){    
    echo "<tr><td>" . $row['name'] . "</td></tr>"; 
}

echo "</table>"; 

mysql_close(); 
?>

But on the website, the only output I get is

"HI"

I checked the username, passwd and DB-Names in my PHP.

I'm running an apache2 Server on Ubuntu (Ubuntu Gnome, if that matters) 16.10 and the community version of MySQL

</div>

Answer 1

mysql_select_db selects a database, yet you pass your table name as a parameter. Table name is different from database name. Check your database name using

show databases;

and use that instead of table name on mysql_select_db

Also, mysql_* functions are deprecated, you need to use mysqli_* functions or PDO.

It is also a bad idea to run queries like

SELECT * FROM users

it is better to select the columns you need explicitly, like

SELECT name FROM users

EDIT

I was confused by the database name, which seems to be myTable indeed. The problem was that the deprecated functions were not found.