abosaber / db-wrapper
php wrapper for mysql db
v1
2022-09-17 07:25 UTC
This package is not auto-updated.
Last update: 2025-03-01 22:52:55 UTC
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();