POD方式:
try {
$db = new PDO(
'mysql:host=127.0.0.1;dbname=db_name',//dsn
'root', // username
''); // password
echo '连接成功';
} catch (PDOException $e){
throw $e;
}
//简单查询
$res = $db->query('select * from test');
//检出结果
$arr = $res->fetchAll(PDO::FETCH_CLASS);
var_dump($arr);
MySQLi方式:
$host = "127.0.0.1";
$user = "root";
$pass = "";
$db = 'test';
// 创建连接
$conn = new mysqli($host, $user, $pass,$db);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$res = $conn->query('select * from test');
$arr = $res->fetch_all(MYSQLI_ASSOC);
var_dump($arr);