abosaber/db-wrapper

php wrapper for mysql db

v1 2022-09-17 07:25 UTC

MIT

• Ahmed saber

README

dbwrapper

dbwrapper is a small php wrapper for mysql/ databases.

installation

install once with composer:

composer require abosaber/db-wrapper

then add this to your project:

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

usage

/* connect to database */
$db->connect("localhost", "root", "", "slms", 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')->Get_All_Rows();
$db->select('tablename', 'Row')->Get_Row();
$db->select('tablename', 'Row')->where(['id'=>$id])->Get_Row();