Several ways to connect php to mysql

PHP 5 and above versions recommend using the following method to connect to MySQL:

MySQLi: MySQLi is only for MySQL database, MySQLi also provides API interface.

PDO (PHP Data Objects): PDO is used in 12 different databases.

Common points: (Recommended learning: PHP programming from entry to proficiency)

1. Both are object-oriented

2. Both support prepared statements. Prepared statements can prevent SQL injection and are very important for the security of web projects.

Make sure MySQLi or PDO has been installed in wamp, view method: echo phpinfo();

The following three methods will be used to demonstrate PHP operation of MySQL:

MySQLi - Object-oriented

<?php
header(&#39;Content-Type: text/html;charset=utf-8&#39;);

//echo phpinfo();

// MySQLi面向对象
// 在我们访问MySQL数据库之前，我们需要先连接到数据库服务器
$servername = "localhost";
$username = "root";
$password = "";

// 创建连接
$conn = new mysqli($servername, $username, $password);

// 检测连接
if($conn -> connect_error)
{
    die("连接失败：". $conn->connect_error);
}

echo "连接成功";
?>

MySQLi - Process-oriented

<?php
header(&#39;Content-Type: text/html; charset=utf-8&#39;);
// MySQLi - 面向过程
$servername = "localhost";
$username = "root";
$password = "";
// 创建连接
$conn = mysqli_connect($servername, $username, $password);
// 检测连接
if(!$conn)
{
    die("连接失败：" . mysqli_connect_error());
}
echo "连接成功";
?>

PDO connects to MySQL database

PDO needs to set the database name. If it is not specified, an exception will be thrown

<?php
header(&#39;Content-Type: text/html; charset=utf-8&#39;);
// PDO连接MySQL数据库
// PDO要设置数据库名，如果没有指定，则会抛出异常
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mugua";
try
{
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    echo "连接成功";
}
catch(PDOException $e)
{
    echo $e->getMessage();
}
?>

The above is the detailed content of Several ways to connect php to mysql. For more information, please follow other related articles on the PHP Chinese website!