Run MySQL Queries Class with MySQLi Extension (Database Abstractions)

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

Download Run MySQL Queries Class with MySQLi Extension (Database Abstractions)

Leave a Reply

Your email address will not be published. Required fields are marked *