flaneurette/mysqli-db-class

There is no license information available for the latest version (dev-master) of this package.

A lightweight mysqli hook

dev-master 2022-12-17 22:07 UTC

Requires

• php: >=5.6

Unknown License

README

Minimal PHP mysqli database class.

A minimal and lean PHP mysqli database class. 256 lines of code.

Installing

The class can be installed via two methods, composer and manual installation.

Composer:

composer require flaneurette/mysqli-db-class:dev-main 

Manual:

Clone or download the dev-main.

Examples of use:

OPEN DB

$db = new sql();

SELECT:

$table    = 'test';
$column   = 'id';
$value    =  1;
$operator = '*';

// becomes: select * from test where id = 1

$test = $db->select($table,$operator,$column,$value); 
echo "<pre>". print_r($test) . "</pre>";

SELECT:

$table    = 'test';
$column   = 'id';
$value    =  100;
$operator = 'name,email';

// becomes: select name,email from test where id = 100

$test = $db->select($table,$operator,$column,$value); 
echo "<pre>". print_r($test) . "</pre>";

COUNT:

$table  = 'test';
$column = 'foo'
$value  = 'abc';
$lock   = 'LOCK';  // optional, locks the table to prevent race condition.
$db->countrows($table,$column,$value,$lock);

INSERT:

$table   = 'test';
$columns = ['foo','bar'];
$values  = ['abc','efg'];
$db->insert($table,$columns,$values);

UPDATE:

$id = 2;
$table    = 'test';
$columns  = ['foo','bar'];
$values   = ['abc','efg'];
$db->update($table,$columns,$values,$id);

DELETE ON ID:

$table  = 'test';
$id 	= 2;
$db->delete($table,$id);

QUERY (direct query, no security):

$test = $db->query("SELECT * FROM test");
echo "<pre>". print_r($test) . "</pre>";

CLOSE DB

$db->close();