PHP connects to MySQL database and queries all records

$host = ' localhost ';
$user _name = ' root ';
$password = ' admin ';

$conn = mysql_connect ($host, $user _name, $password);
if (! $conn)
{
Die (' Database connection failed:<br/> '. mysql_error ());
}
Echo ' Database connection successful! Continue operation ... ';

mysql_select_db (' Test ');

$sql = ' Select id,name,city from users ';
$result = mysql_query ($sql);

if ($result)
{
echo ' SQL statement: '. $sql. ' <br/> has been successfully implemented! ';
$num = mysql_num_rows ($result); Call function Mysql_num_row () to get the number of rows for a SELECT statement query result
Echo ' <br/> The SQL statement query to <b> '. $num. ' </b>www.111cn.net data ';
}

if (Mysql_close ($conn))
{
Echo ' <br/>........<br/> ';
echo ' connection to database has been successfully closed ';
}