abdelrahman1 / db-wrapper
数据库包装器
v1
2022-07-05 15:20 UTC
This package is not auto-updated.
Last update: 2024-09-26 00:12:35 UTC
README
dbwrapper 是一个小型的 PHP 包装器,用于 MySQL 数据库。
安装
使用 composer 一次性安装
composer require abdelrahman1/db-wrapper
然后将其添加到您的项目中
require __DIR__ . '/vendor/autoload.php'; use main\DbWrapper\dbwrapper; $db = new dbwrapper();
使用方法
/* connect to database */ $db = new dbwrapper('127.0.0.1', 'username', 'password', 'database', 3306); /* insert/update/delete */ $id = $db->insert('tablename', ['col1' => 'foo'])->excute(); $db->update('tablename', ['col1' => 'bar'])->where(['id' => $id])->excute(); $db->delete('tablename')->where(['id' => $id])->excute(); /* select */ $db->select('tablename', 'columns')->getAll(); $db->select('tablename', 'columns')->getRow(); $db->select('tablename', 'columns')->where(['id' => $id])->getRow(); $db->select('tablename', 'columns')->where(['id' => $id])->andWhere(['id' => $id])->getRow(); $db->select('tablename', 'columns')->where(['id' => $id])->orWhere(['id' => $id])->getRow();