pdo连接

qq_40862242

已于 2022-03-21 12:24:22 修改

阅读量221

点赞数

分类专栏： PHP 数据库文章标签：数据库 php

于 2022-03-21 12:23:58 首次发布

本文链接：https://blog.csdn.net/qq_40862242/article/details/123632106

版权

PHP 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

数据库

2 篇文章 0 订阅

订阅专栏

$username = "root";
$password = "123456";

# pgsql
$pdo = new \PDO('pgsql:dbname=test;host=127.0.0.1;port=5432', $username, $password);
# sqlserver
$pdo = new PDO('dblib:host=127.0.0.1;dbname=cyryqr', $username, $password);
# oracle
$pdo = new \PDO('oci:dbname=127.0.0.1:1521/jw;charset=utf8;', $username, $password);
# oraclesid
$pdo = new \PDO("oci:dbname= (DESCRIPTION =
                    (ADDRESS_LIST =
                        (ADDRESS = (PROTOCOL = TCP )(HOST = 127.0.0.1)(PORT = 1251))
                    )
                    (CONNECT_DATA =
                        (SID = yjsdb1)
                    )
                );charset=utf8;", $username, $password);

# mysql
$pdo = new \PDO('mysql:dbname=test;host=127.0.0.1', $username, $password);

$sql = "select * from users";
$stmt = $pdo->prepare($sql);
$stmt->execute();
echo json_encode($stmt->fetchAll(\PDO::FETCH_ASSOC),256);