mysqliDB封装好的

https://github.com/ThingEngineer/PHP-MySQLi-Database-Class

引用

require_once ('MysqliDb.php');

初始化

$db = new MysqliDb ('host', 'username', 'password', 'databaseName');
$db = new MysqliDb (Array (
                'host' => 'host',
                'username' => 'username', 
                'password' => 'password',
                'db'=> 'databaseName',
                'port' => 3306,
                'prefix' => 'my_',
                'charset' => 'utf8'));
$db->autoReconnect = false;

 

 增

$data = Array ("login" => "admin",
               "firstName" => "John",
               "lastName" => 'Doe'
);
$id = $db->insert ('users', $data);
if($id)
    echo 'user was created. Id=' . $id;

 改

$data = Array (
	'firstName' => 'Bobby',
	'lastName' => 'Tables',
	'editCount' => $db->inc(2),
	// editCount = editCount + 2;
	'active' => $db->not()
	// active = !active;
);
$db->where ('id', 1);
if ($db->update ('users', $data))
    echo $db->count . ' records were updated';
else
    echo 'update failed: ' . $db->getLastError();

查

$db->where ('id', 1);
$db->where ('login', 'admin');
$results = $db->get ('users');

 

删

$db->where('id', 1);
if($db->delete('users')) echo 'successfully deleted';