Does PHP support MySQL?

PHP supports MySQL; MySQL is the database most commonly used with PHP, and they are often called the "golden combination". PHP provides complete functions for operating the MySQL database. These functions include everything from connecting to the database, executing SQL statements, processing data result sets, and closing the database. Through these functions, web development based on the MySQL database is made efficient and simple.

The operating environment of this tutorial: windows7 system, PHP8.1&&mysql8 version, Dell G3 computer.

The database can be said to be an indispensable part of a website. Nowadays, there are many kinds of databases in the database field. As a popular web page programming technology, the interaction between PHP and databases is inevitable.

PHP can operate a variety of databases, and MySQL is the most commonly used database with PHP. They are often called the "golden combination".

PHP provides complete functions for operating the MySQL database. These functions include everything from connecting to the database, executing SQL statements, processing data result sets to closing the database; through these functions, the Web based on the MySQL database Development is efficient and simple.

Usually the steps for PHP to access the MySQL database are as shown below:

Before this, we need to ensure that the mysqli extension in PHP is turned on. Taking the Windows system as an example, to enable the mysqli extension is to remove the comment extension=mysqli (php7) or extension=php_mysqli.dll (php5) in the php.ini configuration file. Can.

php connects to MySQL database

#When we successfully enable the mysqli extension in PHP, we can use the mysqli_connect() function in the extension. MySQL database connection, the function syntax format is as follows:

mysqli_connect(
    [string $host = ini_get("mysqli.default_host")
    [, string $username = ini_get("mysqli.default_user")
    [, string $password = ini_get("mysqli.default_pw")
    [, string $dbname = ""
    [, int $port = ini_get("mysqli.default_port")
    [, string $socket = ini_get("mysqli.default_socket")
]]]]]] )

Parameter description is as follows:

• $host: Optional parameter, the server to be connected. It can be a host name or an IP address;

• $username: optional parameter, the MySQL user name used to log in;

• $password : Optional parameter, the password used to log in;

• $dbname: Optional parameter, the default database used when executing queries;

• $ port: optional parameter, specifies the port number to connect to the MySQL server;

• $socket: optional parameter, specifies the socket or named pipe to be used, this parameter is very important during development Use sparingly.

It should also be noted that the mysqli_connect() function is an alias of the mysqli::__construct() function, and all objects using mysqli() can also be used to connect to the database.

[Example] The following is a simple code to connect to the database.

1) Process-oriented writing method

<?php
    $host     = &#39;localhost&#39;;
    $username = &#39;root&#39;;
    $password = &#39;root&#39;;
    $dbname   = &#39;test&#39;;
    $port     = &#39;3306&#39;;
    $link     = @mysqli_connect($host,$username,$password,$dbname,$port);   // 连接到数据库
    if($link){
        mysqli_set_charset($link,&#39;UTF-8&#39;);      // 设置数据库字符集
        $sql    = &#39;select * from user&#39;;         // SQL 语句
        $result = mysqli_query($link, $sql);    // 执行 SQL 语句，并返回结果
        $data   = mysqli_fetch_all($result);    // 从结果集中获取所有数据
        mysqli_close($link);
    }else{
        die(&#39;数据库连接失败！&#39;);
    }
    echo &#39;<pre class="brush:php;toolbar:false">&#39;;
    print_r($data);
?>

2) Object-oriented writing method

<?php
    $host     = &#39;localhost&#39;;
    $username = &#39;root&#39;;
    $password = &#39;root&#39;;
    $dbname   = &#39;test&#39;;
    $mysql    = new Mysqli($host, $username, $password, $dbname);
    if($mysql -> connect_errno){
        die(&#39;数据库连接失败：&#39;.$mysql->connect_errno);
    }else{
        $mysql -> set_charset(&#39;UTF-8&#39;); //  设置数据库字符集
        $sql = &#39;select * from user&#39;;         // SQL 语句
        $result = $mysql -> query($sql);
        $data = $result -> fetch_all();
        $mysql -> close();
    }
    echo &#39;<pre class="brush:php;toolbar:false">&#39;;
    print_r($data);
?>

The running results are as follows:

【Related recommendations: mysql video tutorial】

The above is the detailed content of Does PHP support MySQL?. For more information, please follow other related articles on the PHP Chinese website!