PHP Classes

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

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

Author

Bijaya Kumar Behera

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: 56035 in India India
Week rank: 195 Up19 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: [email protected]
* @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: [email protected]
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 (5)  
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 (5)  /  .configs  
File Role Description
  Accessible without login Plain text file system.cron.config.php Conf. Configuration script

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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadphp-ezy-query-2016-03-01.zip 9KB
Downloadphp-ezy-query-2016-03-01.tar.gz 8KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:150
This week:0
All time:9,088
This week:455Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.