# class.DB
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();