mysqli连接数据库

<?php

header( "charset=UTF-8");

$link = mysqli_connect(

'localhost', /* The host to connect to 连接MySQL地址 */

'root', /* The user to connect as 连接MySQL用户名 */

'xuex', /* The password to use 连接MySQL密码 */

'ssm'); /* The default database to query 连接数据库名称*/

if(!$link){

printf( "Can't connect to Mysql ",mysqli_connect_error());

}

if ($result = mysqli_query($link, ' SELECT emp_id, gender FROM tbl_emp ORDER BY emp_name DESC LIMIT 5 ')) {

//print("Very large cities are: ");

/* Fetch the results of the query 返回查询的结果 */

while( $row = mysqli_fetch_assoc($result) ){

printf( "%s (%s) ", $row[ 'emp_id'], $row[ 'gender']);

}

/* Destroy the result set and free the memory used for it 结束查询释放内存 */

mysqli_free_result($result);

}

/* Close the connection 关闭连接*/

mysqli_close($link);

? >