ini_set('display_startup_errors', 1);
error_reporting(-1);
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
require_once '../src/mysqli.php';
$DBServer = 'localhost';
// e.g 'localhost' or '192.168.1.100'
$DBUser = '******';
$DBPass = '******';
$DBName = 'mysqli_ex';
$conn = new mysqli_db($DBServer, $DBUser, $DBPass, $DBName);
$arrParams = array("i", 1);
$obj = $conn->query("SELECT * FROM sample WHERE type=?", $arrParams);
echo "<br /><h1> Rows Count </h1> <br />";
echo $obj->num_rows;
echo "<h1> Rows </h1> <br />";
print_r($obj->rows->data);
echo "<h1> Rows With no Field Keys </h1> <br />";
print_r($obj->rows->ndata);
echo "<br /><h1> fields </h1> <br />";
print_r($obj->fields->all);
echo "<br /><h1> fields Names Array </h1> <br />";
print_r($obj->fields->names);
echo "<br /><h1> fields Original Names Array </h1> <br />";
print_r($obj->fields->orgnames);
echo "<br /><h1> Table Primary Keys fields Names Array </h1> <br />";
print_r($obj->fields->primary);
$obj = $conn->query("INSERT INTO sample2 (number) VALUES (" . rand(0, 100000) . ")");
