PHP Classes
elePHPant
Icontem

File: demo.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of satyam kumawat  >  PHP Database Adapter class  >  demo.php  >  Download  
File: demo.php
Role: Example script
Content type: text/plain
Description: example script
Class: PHP Database Adapter class
Perform SQL database access operations using PDO
Author: By
Last change:
Date: 2 years ago
Size: 4,023 bytes
 

Contents

Class file image Download
<?php
require_once 'DbAdapter.php';
$connection = array ('dsn' => 'mysql:dbname=databasename;host=localhost', //dsn: data source name
                    
'username' => 'root',
                    
'password' => '',
                  
        );

$dbObj = new DbAdapter($connection); //First of all creating an object
$table = 'book';

/* DEMO EXAMPLES
 *
 * //SIMPLE SELECT
 * 1. $dbObj->select() //or select('*') || select("'field1',field2") || select(array('field1','field2'))
             ->from($table) // pass second argument as alias
 * ->fetch(); will select only one row || fetchAll () for all rows
 *
 *
 * //SELECT WITH WHERE
 * 2. $dbObj->select()
             ->from($table)
 * ->where("field = 'value'") // or where(array('field'=>'value')) // Always put ANd between multiple condtions if array is passed
 * ->fetchAll();
 *
 * //SELECT WITH FETCH MODE
 * 3. $dbObj->select(array('field1','field2'))
             ->from($table)
 * ->setFetchMode('FETCH_OBJ') // set fetch mode for current operation see all AVAILABLE FETCH MODES in (INTERFACE DbAdapterInterface)
 * ->where(array('field'=>'value'))
 * ->fetchAll();
 *
 * //INSERT A RECORD MANUALLY
 * 4. $dbObj->insert($table,array('field'=>'field_value'));
 *
 * //INSERT A RECORD AUTOMATICALLY
 * 5. $dbObj->insert($table,$_POST,TRUE); // THIRD ARGUMENT SET TO TRUE FOR AUTO INSERT
 *
 * //UPDATE A RECORD AUTOMATICALLY
 * 6. $dbObj->update($table,$_POST); // IF COMPLETE FORM IS POSTED WITH HIDDEN PRIMARY KEY THEN IT WILL AUTO UPDATE
 *
 * 7. //UPDATE A RECORD MANUALLY
 * $dbObj->update($table,array('field'=>'field_value'),array('condition'=>'value'));
 *
 * 8. //DELETE RECORS
 * $dbObj->delete($table,array('key'=>'value'));
 *
 * //Query
 * 9. $dbObj->query("SELECT * FROM $table")->fetch();
 *
 *
 * //GROUP BY,ORDER BY ,LIMIT
 * 10. $dbObj->select()
             ->from($table)
 * ->orderBy('field1,field1') // or orderBy(array('field1','field2'))
             ->groupBy('field1') // or groupBy(array('field1','field2'))
 * ->limit('1') or limit('0,10')
 * ->fetchAll();
 *
 * //JOIN (join type,table,join conditions)
 * 11. $dbObj->select(array('field1','field2'))
             ->from(table1,'tbl1')
             ->join('left','table2 as tbl2','tbl1.id = tbl2.someid')
             ->join('left','table3 as tbl3','tbl2.someid = tbl3.someid')
 * ->fetchAll();
 *
 *
 * 12. //OR WHERE
 * $dbObj->select('*')
                     ->from(table1,'tbl1')
 * ->orWhere(array('field1'=>'value','field2'=>'value')) // Always put OR between multiple condtions if array is passed
 * ->fetchAll();
 *
 * 13. //MIX OF ORWHERE AND WHERE
 * $dbObj->select('*')
                     ->from(table1,'tbl1')
 * ->where(array('field1'=>'value','field2'=>'value'))
 * ->orWhere(array('field1'=>'value','field2'=>'value')) // ALWAYS SHOULD BE USED AFTER WHERE OR STATND ALONE
 * ->fetchAll();
 *
 * if orWhere is used with where then it will just put OR between two statement
 * The syntex will create syntex below :
 * SELECT * FROM {table} where (table.field1 ='value' AND table.field1 ='value' ) OR (table.field1 ='value' AND table.field1 ='value' )
 *
 * 14. OPERATOR USE
 * (A) <> OR != :- NOT EQUAL
 * (B) < :- LESS THAN
 * (C) > :- GREATOR THAN
 * (D) >= : GREATOR THAN EQUAL
 * (E) <= : LESS THAN EQUAL
 *
 *
 *
 */
 

  
$data = $dbObj->select()
                     ->
from($table)
                   ->
fetchAll();
           
   echo
'<prE>';
  
print_r($data);
?>