README

dbWrapper is a small php wrapper for mysql databases.

installation

install once with composer:

composer require zedan/database-package

then add this to your project:

require __DIR__ . '/vendor/autoload.php';
use Zedan\DatabasePackage\DbWrapper;
$db = new DbWrapper();

usage

/* connect to database */
$db = new DbWrapper('localhost', 'username', 'password', 'database', 3306);


/* insert/update/delete */
$id = $db->insert('tablename', ['col1' => 'foo'])->execute();
$db->update('tablename', ['col1' => 'bar'])->where('id','=',$id)->execute();
$db->delete('tablename')->where('id','=',$id)->execute();
$db->select('tablename',$cols|)->where()->getRow();
$db->select('tablename',$cols|)->getAll()
$db->select('tablename',$cols|)->where()->andWhere()->getRow();
$db->select('tablename',$cols|)->where()->orWhere()->getRow();