PHP Classes

File: tbssql_demo.php

Recommend this page to a friend!
  Classes of Skrol29   TbsSQL   tbssql_demo.php   Download  
File: tbssql_demo.php
Role: Example script
Content type: text/plain
Description: Demo that display some info about your db
Class: TbsSQL
easy and powerfull tool for working with SQL
Author: By
Last change: New version 2.0
Date: 17 years ago
Size: 1,531 bytes
 

Contents

Class file image Download
<?php

   
echo "* TbSQL demo: <br />\r\n";

 
// Include TbsSQL in order to use it..
 
include_once('tbssql_mysql.php');
 
 
// Connection with a global variable which will be destroyed
 
$con_info = array('srv'=>'localhost','uid'=>'root', 'pwd'=>'', 'db'=>'mysql');
   
$Db = new clsTbsSQL('con_info'); // $con_info is destroyed. Also available: $Db = new clsTbsSQL('localhost','root','','mysql');

    // Retrieve a single value
   
$now = $Db->GetVal('SELECT NOW()');
    echo
"-> <b>Current time:</b> {".$now."} <br />\r\n";

   
// Using text argument
   
$text = "that's true";
   
$now = $Db->GetVal('SELECT @1@',$text);
    echo
"-> <b>Text:</b> {".$text."} <br />\r\n";

   
// Using numeric argument
   
$numeric = 29.54;
   
$now = $Db->GetVal('SELECT %1%',$numeric);
    echo
"-> <b>Numeric:</b> {".$numeric."} <br />\r\n";

   
// Retrieve a single row
   
$row = $Db->GetRow('SHOW TABLES');
    echo
"-> <b>Single row:</b> ".var_export($row,true)." <br />\r\n";

   
// Retrieve all rows
   
$rows = $Db->GetRows('SHOW TABLES');
    echo
"-> <b>All row:</b> ".var_export($rows,true)." <br />\r\n";

   
// Retrieve a list of values
   
$list = $Db->GetList('SHOW TABLES');
    echo
"-> <b>List of values:</b> ".var_export($list,true)." <br />\r\n";

   
// Rows affected by the last SQL action
   
$n = $Db->AffectedRows();
    echo
"-> <b>Affected rows:</b> ".$n." <br />\r\n";

   
// Last inserted sequence
   
$n = $Db->LastRowId();
    echo
"-> <b>Last Row Id:</b> ".$n." <br />\r\n";

   
// Close the connection
   
$Db->Close();
    echo
"* End";

?>