PHP面向过程方式操作数据库（扩展增强库MySQLi）

文件：mysqliDemo1.php

<?php
    header("Content-type:text/html;charset=utf-8");
    //1.得到mysqli链接
    $mysqli = mysqli_connect("localhost","root","xxxx","test");
    if(!$mysqli){
        die("链接失败！".mysqli_connect_error($mysqli));
    }else{
        echo "链接成功<br/>";
    }
    //2.向数据库发送sql语句
    $sql = "select * from user1";
    mysqli_query($mysqli,"set names utf8");
    $res = mysqli_query($mysqli,$sql);
    //var_dump($res);
    //3,处理结果
    while($row=mysqli_fetch_row($res)){
        foreach($row as $key=>$val){
            echo "--$val";
        }
        echo "<br/>";
    }
    //4，关闭资源
    mysqli_free_result($res);
    mysqli_close($mysqli);
?>