dokakoka/db-wrapper

php数据库mysql封装器

v1 2022-08-31 15:57 UTC

This package is not auto-updated.

Last update: 2024-09-27 00:11:32 UTC


README

dbwrapper 是一个针对mysql数据库的小型php封装器。

安装

使用composer一次性安装

composer require dokakoka/db-wrapper

然后将以下内容添加到您的项目中

require __DIR__ . '/vendor/autoload.php';
use dokakoka\DbWrapper\db;
$db = new db();

使用

/* connect to database */
$db = new db('127.0.0.1', 'username', 'password', 'database', 3306);

/* insert/update/delete */
$id = $db->insert('tablename', ['col1' => 'foo'])->excute();
$db->update('tablename', ['col1' => 'bar'], ['id' => $id])->excute();
$db->delete('tablename', ['id' => $id])->excute();

/* select */
$db->select("*", 'tablename', ['id' => $id]);