PHP连接Mysql的实例

< html >
< head >
< title > connect . php

< body >
/* PHP手册中的PHP连接Mysql的实例 */
/* 连接选择数据库 */

$link = mysql_connect ( " mysql_host " , " mysql_user " , " mysql_password " ) or die ( " Could not connect " );
print " Connected successfully " ;
mysql_select_db ( " my_database " ) or die ( " Could not select database " );
/* 执行 SQL 查询 */

$query = " SELECT * FROM my_table " ;
$result = mysql_query ( $query ) or die ( " Query failed " );

/* 在 HTML 中打印结果 */

print " \n " ;
while ( $line = mysql_fetch_array ( $result , MYSQL_ASSOC))
{
print " \t\n " ;
foreach ( $line as $col_value )
{
print " \t\t\n " ;
}
print " \t\n " ;
}
print "

$col_value

\n " ;

/* 释放资源 */

mysql_free_result ( $result );

/* 断开连接 */

mysql_close ( $link );
?>