001.PHP 面向过程连接数据库

请参考 天龙八"步",知识点,这里比较粗浅,勿喷!

<meta charset="UTF-8">
<?php
//1.配置数据的基本信息
$servername = "127.0.0.1";
$username = "root";
$password = "";
$database = "php";
$port = "3306";

//2.连接数据库
//$conn=mysqli_connect("主机","用户名","密码","数据库","端口号");
$conn = mysqli_connect($servername, $username, $password, $database, $port);

//3.检查连接
if (!$conn) {
    die("连接数据库失败->" . mysqli_connect_error());
} else {
    echo "连接成功";
    //4.选择一个需要操作的数据库 -
    //因为上面我们已经确定了连接的数据所以可以省略该步骤
    //mysqli_select_db($database,$conn);

    //5.设置字符集
    mysqli_set_charset($conn, "utf8");
    //6.定义SQL指令
    $sql = 'select * from sys_user';

    //7.执行SQL指令
    $resultSet = mysqli_query($conn, $sql);
    //处理结果集
    //var_dump(mysqli_fetch_array($resultSet));
    //数组迭代方式
   /* $data = mysqli_fetch_array($resultSet);
    foreach ($data as $key => $value) {
        echo $key . '=' . $value . '<br/>';
    }*/

    //个人推荐方式
    while (list($id, $account, $password, $user_name) = mysqli_fetch_row($resultSet)) {
        echo $id . '--' . $account . '--' . $password. '--' . $user_name. '<br/>';
    }

    //8.释放资源
    mysqli_close($conn);

}


//$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or die(‘Unable to connect, please check connection paremeters’);
?>