mateodioev/db

简单的 sql-db 连接

维护者

详细信息

github.com/Mateodioev/db

源代码

问题

安装: 151

依赖项: 1

建议者: 0

安全性: 0

星标: 3

关注者: 0

分支: 1

公开问题: 0

v2.0-beta 2022-10-01 03:25 UTC

Requires

MIT f5d373c9400fe51fff2162b7832688e5642eb991

  • Mateodioev

sqldbmysql

This package is auto-updated.

Last update: 2024-09-22 05:04:48 UTC

README

CodeFactor

安装

Github

git clone https://github.com/Mateodioev/db
cd db
composer install

Composer

composer require mateodioev/db

用法

设置数据库数据

use Mateodioev\Db\Connection;

Connection::Prepare('DB_HOST', 'DB_PORT', 'DB_NAME', 'DB_USER', 'DB_PASS');
# or 
$dir = 'path/to/.env/file';
Connection::PrepareFromEnv($dir);

执行查询

use Mateodioev\Db\Query;
$db = new Query();

// Return one afect row
$db->Exec('SELECT * FROM users'); // Simple sql query
$db->Exec('SELECT * FROM users WHERE id = :id', [':id' => 'random_id']); // With params

// Return all afect rows
$db->GetAll('SELECT * FROM users'); // Simple sql query
$db->GetAll('SELECT * FROM users WHERE id = :id', [':id' => 'random_id']); // With params

异常

  • Connection::PrepareFromEnv($dir); 如果目录找不到或不可读，则抛出异常

  • $db->Exec($sql_query) 或 $db->GetAll($sql_query) 如果 SQL 查询无效或凭据无效，则抛出异常