PHP Classes

PHP Ezy Query: Execute queries to MySQL, MongoDB and memcached

Recommend this page to a friend!
  Info   View files Example   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 150 This week: 1All time: 9,080 This week: 560Up
Version License PHP version Categories
php-ezy-query 1.0The PHP License5PHP 5, Databases
Description 

Author

This class can execute queries to MySQL, MongoDB and memcached.

It reads a configuration array and connects to one of the supported databases servers like MySQL, MongoDB, memcached or PostGreSQL.

The class can execute several database access operations like ping the server, execute single queries, execute multi-queries, or retrieve any errors.

Picture of Bijaya Kumar  Behera
Name: Bijaya Kumar Behera <contact>
Classes: 6 packages by
Country: India India
Age: ???
All time rank: 56135 in India India
Week rank: 411 Up26 in India India Up
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

Example

<?php
/*
* @File: PHP_Ezy_Query_Example.php
* @Description: Example file
* @Version: 1.0.0
* @Autore: Bijaya Kumar
* @Email: it.bijaya@gmail.com
* @Mobile: +91 9911033016
* @Country: India
*/
?>
<?php
    $verbose
= 0;
    global
$_CONFIGS;

   
// Load Lib
   
require_once ('./systems/tgr_db.class.php');

   
// Load DB Confiuration file
   
$_CONFIGS = require_once ('./.configs/system.cron.config.php');

   
# verbose
   
$verbose ? var_dump($_CONFIGS) : null;

   
$TEST = 4 ;
   
#######################################################
    # This example uses of MySQLi Extension
    # Create a new connection useing config TESTCONFIG1
    ########################################################
   
$TEST == 1 ? Example1 (): '';


   
#######################################################
    # This example uses of MySQL Extension
    # Create a new connection useing config TESTCONFIG2
    ########################################################
   
$TEST == 2 ? Example2 (): '';

   
#######################################################
    # This example uses of pdo_mysql
    # Create a new connection useing config TESTCONFIG3
    ########################################################
   
$TEST == 3 ? Example3 (): '';

   
#######################################################
    # This example uses of mongo
    # Create a new connection useing config TESTCONFIG4
    ########################################################
   
$TEST == 4 ? Example4 (): '';




function
dump($lable, $data) {
    echo
"<pre> <b><u>{$lable}::</b></u><br />";
    
print_r($data);
     echo
"</pre>";
}

function
Example4 () {
 global
$verbose;

 
# Initialise a connection
 
$TCDB = TGR_DB::init("TESTCONFIG4");

 
# Error check
 
if (TGR_DB::error($TCDB, true)) {
    echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB, false ) . "</h4>";
    exit(
1);
 }

 
###################################################
 # Simple Query
 
$qry=array( 'database' => 'test',
             
'table' => '@@_table1',
             
'commnd' => 'find',
             
'where' => array( 'id' => array( '$gt' => 1 ) ),
             
'fields' => array('id' => true),
             
'limit'=>0,
             
'skip'=>0,
             
'sort' => array()
             );
 
$ExampleResult1 = TGR_DB::query($TCDB, $qry);
 
// Error Check
 
if ( TGR_DB::error($TCDB1, true) ) {
    echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB1, false ) . "</h4>";
    exit(
1);
 }
 
$verbose? dump("Query Output", $ExampleResult1) : false;
 
###################################################
 
 ###################################################
 # Execute Query and return the native result set
 
$qry=array( 'database' => 'test',
             
'table' => '@@_table1',
             
'commnd' => 'find',
             
'where' => array( 'id' => array( '$gt' => 1 ) ),
             
'fields' => array('id' => true),
             
'limit' => 0,
             
'skip' => 0,
             
'sort' => array()
             );
 
$ExampleResult4 = TGR_DB::query($TCDB, $qry, null);
 
// Get Last Error No
 
if ( TGR_DB::error($TCDB, true) ) {
   echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB, false ) . "</h4>";
   exit(
1);
 }
 
$ExampleResult_4=array();
 while( (
$rec= @$ExampleResult4->getNext()) )
       
$ExampleResult_4[]=$rec;
 
$verbose?dump("Native Result Set Output::", $ExampleResult_4):false;
 
###################################################


 ###################################################
 # Close a active connection
 
TGR_DB::close($TCDB);
 
###################################################
 
exit(0);
}

function
Example3 () {
 global
$verbose;

 
# Initialise a connection
 
$TCDB = TGR_DB::init("TESTCONFIG3");
 
 
# Error check
 
if (TGR_DB::error($TCDB, true)) {
    echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB, false ) . "</h4>";
    exit(
1);
 }

 
###################################################
 # Execute Simple Query
 
$qry = "SELECT * FROM @@_table1";
 
$ExampleResult1 = TGR_DB::query($TCDB, $qry);
 
// Error Check
 
if ( TGR_DB::error($TCDB, true) ) {
    echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB, false ) . "</h4>";
    exit(
1);
 }
 
$verbose?dump("Query Output ", $ExampleResult1):false;
 
###################################################

 ###################################################
 # Execute Multi Query
 
$qry2 = "SELECT * FROM @@_table1; SELECT * FROM @@_table2;";
 
$ExampleResult2 = TGR_DB::multi_query($TCDB1, $qry2);
 
// Get Last Error No
 
if ( TGR_DB::error($TCDB, true) ) {
   echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB, false ) . "</h4>";
   exit(
1);
 }
 
$verbose?dump("Multi Query Output", $ExampleResult2):false;
 
###################################################

 ###################################################
 # Execute Store Procedure
 
$qry3 = "call mysp1();";
 
$ExampleResult3 = TGR_DB::query($TCDB, $qry3);
 
// Get Last Error No
 
if ( TGR_DB::error($TCDB, true) ) {
   echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB, false ) . "</h4>";
   exit(
1);
 }
 
$verbose?dump("Store Procedure Output", $ExampleResult3);
 
###################################################

 ###################################################
 # Execute Query and return the native result set
 
$qry4 = "SELECT * FROM @@_table1";
 
$ExampleResult4 = TGR_DB::query($TCDB, $qry4, null);
 
// Get Last Error No
 
if ( TGR_DB::error($TCDB, true) ) {
   echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB, false ) . "</h4>";
   exit(
1);
 }
 
$ExampleResult_4=array();
 while( (
$rec= @$ExampleResult4->fetch()) )
       
$ExampleResult_4[]=$rec;
 
$ExampleResult4->closeCursor();
 
$verbose?dump("Native Result Set Output", $ExampleResult_4);
 
###################################################

 ###################################################
 # Close a active connection
 
TGR_DB::close($TCDB);
 
###################################################
 
}
function
Example2 () {
 global
$verbose;

 
$TCDB = TGR_DB::init("TESTCONFIG2");

 
// Get Last Error No
 
if (TGR_DB::error($TCDB, true)) {
     echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB, true) . " <hr /><h4>" . TGR_DB::error($TCDB, false ) . "</h4>";
    exit(
1);
 }

// Execute Query
$qry = "SELECT * FROM @@_table1";
$ExampleResult1 = TGR_DB::query($TCDB1, $qry);
$verbose?dump("Simple Query Output", $ExampleResult_4);
$verbose ? var_dump($ExampleResult1) : null;

// Error Check
if ( TGR_DB::error($TCDB1, true) ) {
    echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB1, true) . " <hr /><h4>" . TGR_DB::error($TCDB1, false ) . "</h4>";
    exit(
1);
}

// Execute Multi Query
$qry2 = "SELECT * FROM @@_table1; SELECT * FROM @@_table2;";
$ExampleResult2 = TGR_DB::multi_query($TCDB1, $qry2);
$verbose ? var_dump($ExampleResult2) : null;

// Get Last Error No
if ( TGR_DB::error($TCDB1, true) ) {
    echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB1, true) . " <hr /><h4>" . TGR_DB::error($TCDB1, false ) . "</h4>";
    exit(
1);
}

echo
"<pre> <b><u>Output ::</b></u><br />";
print_r($ExampleResult2);

// Execute Store Procedure
$qry2 = "call mysp1();";
// Not implemented yet


// Execute Query and return the native result set
$qry2 = "SELECT * FROM @@_table1";
$ExampleResult3 = TGR_DB::query($TCDB1, $qry2, null);
$verbose ? var_dump($ExampleResult3) : null;
echo
"<pre> <b><u>Output from result set::</b></u><br /> ";
while( (
$rec= @mysql_fetch_array( $ExampleResult3) ) )
print_r($rec );
@
mysql_free_result( $ExampleResult3);


// Execute Query using mysqli native object
$qry4 = "SELECT * FROM tgr_table1";
$ExampleResult4 = mysql_query ($qry4, $TCDB1[0]) ;
if (!
$ExampleResult4) {
   
print_r(mysql_error($TCDB1[0]));exit(1);
}
echo
"<pre> <b><u>Output from result set::</b></u><br /> ";
while( (
$rec= @mysql_fetch_array($ExampleResult4) ) )
   
print_r($rec );
@
mysqli_free_result( $ExampleResult4);

###################################################
# Close a active connection
   
TGR_DB::close($TCDB1);
   
###################################################
exit(0);
    }

    function
Example1 () {
        global
$verbose;

       
       
$TCDB1 = TGR_DB::init("TESTCONFIG1");

       
// Get Last Error No
       
if (TGR_DB::error($TCDB1, true)) {
            echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB1, true) . " <hr /><h4>" . TGR_DB::error($TCDB1, false ) . "</h4>";
            exit(
1);
        }

       
// Execute Query
       
$qry = "SELECT * FROM @@_table1";
       
$ExampleResult1 = TGR_DB::query($TCDB1, $qry);
       
$verbose ? var_dump($ExampleResult1) : null;

       
// Get Last Error No
       
if ( TGR_DB::error($TCDB1, true) ) {
            echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB1, true) . " <hr /><h4>" . TGR_DB::error($TCDB1, false ) . "</h4>";
            exit(
1);
        }

       
// Execute Multi Query
       
$qry2 = "SELECT * FROM @@_table1; SELECT * FROM @@_table2;";
       
$ExampleResult2 = TGR_DB::multi_query($TCDB1, $qry2);
       
$verbose ? var_dump($ExampleResult2) : null;

       
// Get Last Error No
       
if ( TGR_DB::error($TCDB1, true) ) {
            echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB1, true) . " <hr /><h4>" . TGR_DB::error($TCDB1, false ) . "</h4>";
            exit(
1);
        }

        echo
"<pre> <b><u>Output ::</b></u><br />";
       
print_r($ExampleResult2);

       
// Execute Store Procedure
       
$qry2 = "call mysp1()";
       
$ExampleResult4 = TGR_DB::multi_query($TCDB1, $qry2);
       
$verbose ? var_dump($ExampleResult4) : null;
       
// Get Last Error No
       
if ( TGR_DB::error($TCDB1, true) ) {
            echo
"<br /><b>Err No </b>: " . TGR_DB::error($TCDB1, true) . " <hr /><h4>" . TGR_DB::error($TCDB1, false ) . "</h4>";
            exit(
1);
        }
        echo
"<pre> <b><u>Out of Store Procedure Call ::</b></u><br />";
       
print_r($ExampleResult4);


       
// Execute Query and return the native result set
       
$qry2 = "SELECT * FROM @@_table1";
       
$ExampleResult3 = TGR_DB::query($TCDB1, $qry2, null);
       
$verbose ? var_dump($ExampleResult3) : null;
        echo
"<pre> <b><u>Output from result set::</b></u><br /> ";
        while( (
$rec= @mysqli_fetch_array( $ExampleResult3) ) )
       
print_r($rec );
        @
mysqli_free_result( $ExampleResult3);


       
// Execute Query using mysqli native object
       
$qry4 = "SELECT * FROM tgr_table1";
       
$ExampleResult4 = mysqli_query ($TCDB1[0], $qry4) ;
        if (!
$ExampleResult4) {
           
print_r($TCDB1[0]->errno);exit(1);
        }
        echo
"<pre> <b><u>Output from result set::</b></u><br /> ";
        while( (
$rec= @mysqli_fetch_array( $ExampleResult4) ) )
           
print_r($rec );
        @
mysqli_free_result( $ExampleResult4);

       
###################################################
        # Close a active connection
        
TGR_DB::close($TCDB1);
        
###################################################
       
exit(0);
    }

?>


Details

___ _ _ ___ ___ ___ | _ \ || | _ \ | __|____ _ / _ \ _ _ ___ _ _ _ _ | _/ __ | _/ | _||_ / || | | (_) | || / -_) '_| || | |_| |_||_|_| |___/__|\_, | \__\_\\_,_\___|_| \_, | |__/ |__/ 1.0.0 ***************************************** # `PHP_Ezy_Query 1.0.0` Version: 1.0.0 Author: Bijaya Kumar Email: it.bijaya@gmail.com Mobile: +91 9911033016 A simple, Eazy and light weightPHP Database wrapper class includes mysql, mongo and memcache and best for runable services like cron job Feature: *. support mysqli, pdo, mongo drives *. auto reconnection before query *. support multi query / store procedure *. support IP or sock base connection *. support escape Eaxmple: # Use it as global global $_CONFIGS; # Load config $_CONFIGS = require './.configs' . DS . 'system.cron.config.php'; # Load PHP Ezy DB class file require_once( './systems/tgr_db.class.php'); # Initialise a connection $TCDB = TGR_DB::init("TESTCONFIG4"); # Query $rows = TGR_DB::query($TCDB, $qry); # Close a active connection TGR_DB::close($TCDB);

  Files folder image Files  
File Role Description
Files folder image.configs (1 file)
Files folder imagesystems (1 file)
Accessible without login Plain text file PHP_Ezy_Query.sql Data Auxiliary data
Accessible without login Plain text file PHP_Ezy_Query_Example.php Example Example script
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  .configs  
File Role Description
  Accessible without login Plain text file system.cron.config.php Conf. Configuration script

  Files folder image Files  /  systems  
File Role Description
  Plain text file tgr_db.class.php Class Class source

 Version Control Unique User Downloads Download Rankings  
 100%
Total:150
This week:1
All time:9,080
This week:560Up