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]);