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