mysqli语法

连接测试：

<?php
//创建对象并打开连接，最后一个参数是选择的数据库名称
$mysqli = new mysqli('localhost','root','YES','db1');
//检查连接是否成功
if (mysqli_connect_errno()){
    //注意mysqli_connect_error()新特性
    die('Unable to connect!'). mysqli_connect_error();
}
$sql = "select * from emp";
//执行sql语句，完全面向对象的
$result = $mysqli->query($sql);
while($row = $result->fetch_array()){
    echo $row[0];
}
?>

面向过程的连接方式：

<?php

/* Connect to a MySQL server  连接数据库服务器 */
$link = mysqli_connect(
    'localhost',  /* The host to connect to 连接MySQL地址 */
    'root',      /* The user to connect as 连接MySQL用户名 */
    'YES',  /* The password to use 连接MySQL密码 */
    'db1');    /* The default database to query 连接数据库名称*/

if (!$link) {
    printf("Can't connect to MySQL Server. Errorcode: %s ", mysqli_connect_error());
    exit;
}
    print("connect success!<br>");
/* Send a query to the server 向服务器发送查询请求*/
if ($result = mysqli_query($link, 'SELECT * FROM emp')) {

    echo "The information of employers is:\n "."<br>";

    /* Fetch the results of the query 返回查询的结果 */
    while( $row = mysqli_fetch_assoc($result) ){
        printf("%s %s %s<br>", $row['eid'], $row['ename'],$row['salary']);
    }
    /* Destroy the result set and free the memory used for it 结束查询释放内存 */
    mysqli_free_result($result);
}

/* Close the connection 关闭连接*/
mysqli_close($link);
?>