连接数据库代码3种方式

肖晓飞

已于 2022-10-14 00:21:44 修改

阅读量301

点赞数

文章标签：数据库 php

于 2022-10-13 23:56:41 首次发布

本文链接：https://blog.csdn.net/m0_64577422/article/details/127310918

版权

<?php
header('Content-type:text/html;charset=utf8');
$config = [
    'host' => 'localhost',
    'user' => 'root',
    'password' => '',
    'db' => 'houdunren',
    'charset'=>'utf8'
];
try {
    $dsn = sprintf('mysql:host=%s;dbname=%s;charset=utf8', $config['host'], $config['db'],$config['charset']);
    $pdo =  new PDO($dsn, $config['user'], $config['password']);
} catch (PDOException $e) {
    die($e->getMessage());
}

<?php
$username = 'root';
$password = '123456';
$DNS = 'mysql:host=localhost;port=3306;dbname=studb';

try {
    $pdo = new PDO($DNS, $username, $password);
} catch (PDOException $e) {
    $e->getMessage();
}

// database.php文件
<?php
return [
    'type' => $type ?? 'mysql',
    'username' => $username ?? 'root',
    'password' => $password ?? '123456',
    'host' => $host ?? 'localhost',
    'port' => $username ?? '3306',
    'charset' => $charset ?? 'utf8',
    'dbname' => $dbname ?? 'studb'
];

?>

// 链接文件
<?php
$config = require_once __DIR__ . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'database.php';
extract($config);
$DNS = sprintf('%s:host=%s;port=%s;dbname=%s;charset=%s', $type, $host, $port, $dbname, $charset);
try {
    $pdo = new PDO($DNS, $username, $password);
} catch (Exception $e) {
    die('连接错误' . $e->getMessage());
}