php怎么写MySQL代码_PHP5链接MYSQL的代码怎么写

PHP5链接mysql有2个方法

一、使用和连接MYSQL数据库一样的方法，代码如下：<?php

//php连接MySQLI

$link = mysqli_connect('localhost','user','password','world');

if (!$link){

printf("不能连接到MySQL. 错误代码: %sn", mysqli_connect_error());

exit;

}

/*发送查询指令*/

if ($result = mysqli_query($link, 'SELECT Name, Population FROM City ORDER BY Population DESC LIMIT 5')){

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

//开始获取查询结果

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

printf("%s (%s)n", $row['Name'], $row['Population']);

}

mysqli_free_result($result);//注销结果集。释放内存

}

mysqli_close($link); //关闭连接

?>

二、使用内置OO接口方式<?php

//php连接MySQLI

$mysqli=new mysqli('localhost','user','password','world');

if(mysqli_connect_errno()){

printf("找不到MySQL服务. 错误编号: %sn", mysqli_connect_error());

exit;

}

/* 发送查询请求 */

if ($result = $mysqli->query('SELECT Name, Population FROM City ORDER BY Population DESC LIMIT 5')){

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

/* 查询结果 */

while( $row = $result->fetch_assoc() ){

printf("%s (%s)n", $row['Name'], $row['Population']);

}

/* 注销查询释放内存*/

$result->close();

}

/*关闭连接*/

$mysqli->close();

?>