Share two methods of connecting to MySQL in PHP7

php7 Two ways to connect to mysql

Users of PHP 5 can use the MySQL extension, mysqli and PDO_MYSQL. PHP 7 has removed the mysql extension, leaving only the latter two options.

Recommendation: "mysql video tutorial"

This document explains the functions of each API Terminology to help us use the API and understand information about the API.

PHP provides three different APIs to connect to the mysql database. The sample code below shows 3 different ways to connect to the mysql database.

/*
 * mysqli
 * 数据库地址，登陆账号，密码，数据库名称
 */
    $mysqli = new mysqli("localhost", "root", "", "student");
    $sql = "SELECT * FROM tb_user";
    $result = $mysqli->query($sql);
    $row = $result->fetch_assoc(); // 从结果集中取得一行作为关联数组
    echo $row["password"];
    /* free result set */
    $result->free();  
    /* close connection */
    $mysqli->close();

/*
 * 第一个参数是mysql:host,第二是dbname,第三个账户名，第四个密码
 */
try {
    $pdo = new PDO("mysql:host=localhost;dbname=student", "root", "");
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}
$sql = "select * from tb_user";
echo $sql . "
";
$pdo->query('set names utf8;');
$result = $pdo->query($sql);
$rows = $result->fetchAll();
foreach ($rows as $row) {
    $username = $row[1];
    $pwd = $row[2];
    echo $username;
}

The above is the detailed content of Share two methods of connecting to MySQL in PHP7. For more information, please follow other related articles on the PHP Chinese website!