php和mysql组合_PHP与MYSQL组合

<?php $host="localhost";$user="joe";$pass="ercret";$db="db123";$connection=mysql_connect($host,$user,$pass)ordie("Unabletoco...

$host = "localhost";

$user = "joe";

$pass = "ercret";

$db = "db123";

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect !");

mysql_select_db($db) or die ("Unable to select database !");

$query = "SELECT * FROM employees";

$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

if (mysql_num_rows($result) > 0)

{

echo "

while($row = mysql_fetch_row($result))

{

echo "

";

echo "

" . $row[0] . "";

echo "

" . $row[1] . "";

echo "

";

}

echo "

"

}

else

{

echo "No rows found!";

}

mysql_free_result($result);

mysql_close($connection);

?>

不知道错哪了，确定MySQL数据库里有数据

顺便请推荐一个PHP的开发工具，谢谢

展开