mysqli和pdo链接方式

最新推荐文章于 2024-06-30 16:59:44 发布

Taoooooo1990

最新推荐文章于 2024-06-30 16:59:44 发布

阅读量249

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/geishel/article/details/53392019

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

//pdo 可扩展的数据库链接方式，可链接sql oracle 等其他数据库
$pdo = new PDO("mysql:host=localhost;dbname=tao", 'root', '123456');
$a = $pdo->query('SELECT * from test');
while($row = $a->fetchAll()){
print_r($row);
}

//mysqli 面向过程
$mysqli = mysqli_connect('localhost', 'root', '123456', 'tao');
if (mysqli_connect_errno()) {
echo mysqli_connect_error();
exit();
}

$sql = 'SELECT * FROM test';
$result = mysqli_query($mysqli, $sql);

while ($row = mysqli_fetch_array($result))
{
print_r($row);
}

//mysqli 面向对象
$mysqli = new mysqli("localhost","root","123456","tao");
if(mysqli_connect_errno()){
echo mysqli_connect_error();
exit();
}
$sql = "select * from test";
$result = $mysqli->query($sql);
while($row = $result->fetch_array()){
print_r($row);
}