PHP Classes
elePHPant
Icontem

File: dbMysqli/test.php

Recommend this page to a friend!
  Classes of Kemal GENIS  >  DB Classes  >  dbMysqli/test.php  >  Download  
File: dbMysqli/test.php
Role: Example script
Content type: text/plain
Description: Example script
Class: DB Classes
Access different types of databases
Author: By
Last change: .update
Date: 7 months ago
Size: 1,010 bytes
 

 

Contents

Class file image Download
<?php
header
('Content-Type: text/html; charset=utf-8');
include_once
"dbMysqli.class.php";

# CONNECTION & SETTINGS
$db = new dbMysqli('db_server', 'db_user', 'db_pass', 'db_name');
$db->setDebug(true);

# SELECT fetchArray
echo "<h4>SELECT fetchArray TEST</h4>";
$sqlSelect = "SELECT * FROM pages";
$rowSelect = $db->fetchArray($sqlSelect);
$rowSelect = $db->fetchArray('select * from pages_trans');
$rowSelect = $db->fetchArray($sqlSelect);
echo
"<pre>".var_export($rowSelect, true);

# SELECT fetchObject
echo "<h4>SELECT fetchObject TEST</h4>";
$sqlSelect = "SELECT * FROM pages";
$rowSelect = $db->fetchObject($sqlSelect);
echo
"<pre>".var_export($rowSelect, true);

# NUM ROWS
echo "<h4>NUM ROWS TEST</h4>";
$sqlSelect = "SELECT * FROM pages";
$rowSelect = $db->numRows($sqlSelect);
echo
"<pre>".var_export($rowSelect, true);


# NUM ROWS COUNT
echo "<h4>NUM ROWS COUNT TEST</h4>";
$sqlSelect = "SELECT * FROM pages";
$rowSelect = $db->numRowsCount($sqlSelect);
echo
"<pre>".var_export($rowSelect, true);