MysqliDb 快速上手

composer require thingengineer/mysqli-database-class:dev-master

require "MysqliDb.php";

$db = new MysqliDb ('host', 'username', 'password', 'databaseName');

$db = new MysqliDb ([
  'host' => 'host',
  'username' => 'username', 
  'password' => 'password',
  'db'=> 'databaseName',
  'port' => 3306,
  'prefix' => 'my_',
  'charset' => 'utf8'
]);

$mysqli = new mysqli ('host', 'username', 'password', 'databaseName');
$db = new MysqliDb ($mysqli);

$data = [
  "name" => "boo",
  "age" => 21,
  "gender" => "man"
];
$success = $db->insert("user", $data);

$data = [
  "age" => 22,
];
$success = $db->where(["name" => "boo"])
   ->update("user", $data);

$result = $db->get("user", null, "*");

$result = $db->getOne("user",  "*");

$result = $db->where("name", "boo")
	 ->getValue("user", "*");

$result = $db->getValue("user", "count(*)");

$success = $db->where("user_id", "boo")
  ->delete("user);

$result = $db->rawQuery("select * from user where name = \"boo\"")