How to connect to the database in php7

The methods to use native PHP to connect to MySQL include the MySQL library, MySQLi library and PDO. Since PHP 7 has abolished the MySQL library, it is recommended to use MySQLi and PDO.

There are two styles for connecting to MySQLi:

Object-oriented style ( Recommended) (Recommended learning:PHP video tutorial)

connect_error){ die('connect error:'.$mysqli->connect_errno); } $mysqli->set_charset('UTF-8'); // 设置数据库字符集 $result = $mysqli->query('select * from customers'); $data = $result->fetch_all(); // 从结果集中获取所有数据 print_r($data); ?>

Procedural style

PDO connection database

query('select * from customers'); $data = $result->fetchAll(PDO::FETCH_ASSOC); // PDO::FETCH_ASSOC表示将对应结果集中的每一行作为一个由列名索引的数组返回 print_r($data); } catch (PDOException $error){ echo 'connect failed:'.$error->getMessage(); } ?>

The above is the detailed content of How to connect to the database in php7. For more information, please follow other related articles on the PHP Chinese website!