mysqli语法

来源：互联网发布：mysql 时间小于等于编辑：程序博客网时间：2024/04/30 08:23

连接测试：

<?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);?>

0 0