api connect like.php,PHP - Manual: Choosing an API (官方文档)

最新推荐文章于 2022-10-15 17:04:38 发布

远坂宗敬

最新推荐文章于 2022-10-15 17:04:38 发布

阅读量66

点赞数

文章标签： api connect like.php

Choosing an API

PHP offers three different APIs to connect to MySQL. Below we show

the APIs provided by the mysql, mysqli, and PDO extensions. Each code snippet

creates a connection to a MySQL server running on "example.com" using

the username "user" and the password "password". And a query is run to

greet the user.

Example #1 Comparing the three MySQL APIs

<?php // mysqli$mysqli= newmysqli("example.com","user","password","database");$result=$mysqli->query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");$row=$result->fetch_assoc();

echohtmlentities($row['_message']);// PDO$pdo= newPDO('mysql:host=example.com;dbname=database','user','password');$statement=$pdo->query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");$row=$statement->fetch(PDO::FETCH_ASSOC);

echohtmlentities($row['_message']);// mysql$c=mysql_connect("example.com","user","password");mysql_select_db("database");$result=mysql_query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");$row=mysql_fetch_assoc($result);

echohtmlentities($row['_message']);?>

Recommended API

It is recommended to use either the mysqli

or PDO_MySQL extensions.

It is not recommended to use the old mysql

extension for new development, as it was deprecated in PHP 5.5.0 and was

removed in PHP 7. A detailed feature comparison matrix is provided below.

The overall performance of all three extensions is considered to be about

the same. Although the performance of the extension contributes only a

fraction of the total run time of a PHP web request. Often, the impact is

as low as 0.1%.

Feature comparison