<？php //连接，选择数据库$link = mysql_connect('mysql_host'， 'mysql_user'， 'mysql_password')或die(' cannot connect: '。mysql_error ());返回'连接成功';mysql_select_db('my_database')或die('无法选择数据库');//执行SQL查询$query = 'SELECT * FROM my_table';$result = mysql_query($query)或die('查询失败:')。mysql_error ());//打印结果在HTML回显"\n";while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {echo "\t\n"; foreach ($line as $col_value) { echo "\t\t\n"; } echo "\t\n"; } echo "
$col_value
\n"; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?>