techone / database
PDO数据库库
v1.0.0
2022-10-23 10:12 UTC
Requires
- php: >=5.4.0
- ext-pdo: *
This package is auto-updated.
Last update: 2024-09-23 14:16:12 UTC
README
PHP的PDO数据库库。
当前支持的数据库名称如下
安装
使用Composer
composer require leeqvip/database
使用方法
require_once './vendor/autoload.php'; use Leeqvip\Database\Manager; $config = [ 'type' => 'mysql', // mysql,pgsql,sqlite,sqlsrv 'hostname' => '127.0.0.1', 'database' => 'test', 'username' => 'root', 'password' => 'abc-123', 'hostport' => '3306', ]; $manager = new Manager($config); $connection = $manager->getConnection(); $connection->query('SELECT * FROM `users` WHERE `id` = :id', ['id' => 1]); $connection->execute('UPDATE `users` SET `name` = "joker" where `id` = :id', ['id' => 1]);
许可协议
本项目采用Apache 2.0许可协议。