This class can run MySQL queries with MySQLi extension from,
It can connect to a MySQL database using the MySQLi extension and executes queries with “prepared” statements. The results: returns results as an array.
Features
- OOP
- Results in list of array
- Unlimited queries for listings
- Two types querying and retrieval of results function: Query – NoQuery
- Very safe and perform
- Basics uses
- Getting the last id from insert queries
- Count rows from select queries
- Uses mysqli extension with prepare
- Multiple Queries
- With example sql
Example Queries
include 'class/mysqli.class.php';
$db = new dbmysqli;
$rows = $db->Query("SELECT * FROM offices");
print_r($rows);
echo $rows[0]['column name'] // first rows
// Insert Query
$oN = '10307';
$pCode = 'S12_1099';
$qO = '7';
$pE = '1453.3';
$oLN = '7';
// Query 1
$row = $db->NoQuery("INSERT INTO orderdetails VALUES(?,?,?,?,?)","isidi",$oN,$pCode,$qO,$pE,$oLN);
echo $row; // true or false