include 'dbapi/db_utils.php';
$host = "localhost";
$user = "******";
$password = "";
$database = "dbapi";
$dbutils = new db_utils($host, $user, $password, $database);
//Insert Data
$table = "test";
$columns = array("name");
$records = array("Victor");
$dbutils->insert_records($table, $columns, $records, true);
//BULK INSERT
$columns = array("name");
$records = array("Mwenda", "Marvik", "Victor");
$dbutils->bulk_insert_records($table, $columns, $records, true);
//UPDATE DATA
$where_columns = array("name");
$where_records = array("Mwenda");
$columns = array("name");
$records = array("Vicky");
$dbutils->update_record($table, $columns, $records, $where_columns, $where_records, true);
//DELETE_DATA
$columns = array("name");
$records = array("Marvik");
$dbutils->delete_record($table, $columns, $records, true);
//COMPLEX METHODS
//QUERY && FETCH ASSOC
$columns = array("name");
$records = array("Vic");
$results = $dbutils->fetch_assoc($table, $columns, $records, true);
