Login   Register  
PHP Classes
elePHPant
Icontem

File: example3.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Osama Salama  >  DBMysqli  >  example3.php  >  Download  
File: example3.php
Role: Example script
Content type: text/plain
Description: example3
Class: DBMysqli
Access MySQL databases with mysql and mysqli
Author: By
Last change:
Date: 1 year ago
Size: 2,029 bytes
 

Contents

Class file image Download
<?php
require_once "Database.php";

$config['default']['Host']="localhost";
$config['default']['UserDb']="root";
$config['default']['PassDb']="";
$config['default']['Dbname']="cms";
$config['default']['Prefix']="";
$config['default']['Charset']="";



/*
choose MYSQL  or MYSQLi 
*/
$DB=Database::getInstance("mysqli",$config);

 
/* 
//fetchAll  and pagination
$fileds="*"; // you can use ( * ) or array contains column array('ID','email','name');
$tablename="orders"; //tablename
$con=false;  //where condition  like  category='sport' or category='sport'  :if no condition type false
$join=false;  //if no join type false or array like array("left join cm_cat on cm_articles.cat=cm_cat.ID")
$group=false; //    :if no group type false     ex.      like "cm_articles.ID";
$order='ID asc'; //if no order type false
$start=false;  // if you are using pagination write page number if not type false
$limit=false; // all record type false if not type record limit
    
    $rs1=$DB->fetchAll($fileds,$tablename,$con,$join,$group,$order,$start,$limit);
 foreach($rs1 as $row){
     echo $row['ID']."==".$row['name']."<br/>\n";
     }

     output
1==osama salama
2==ali ahmed ali
3==Tamer sami
4==Mohammed ali
5==ahmed mahmmod
6==ali elsied ali
7==walled sami
8==waeel helal
9==joen apo
10==mostafa hafez
11==alaa elsedd ali
12==abdo hablex
13==galall
14==hani
     */
/*
example inline fetch
$rs1=$DB->fetchAll('*','orders',false,false,false,false,false,flase);
*/     
     

//use in pagination
echo "<hr/>";
/*
if(!isset($_GET['page']) or $_GET['page']==0){
    $page=1;
    }
    else {
    $page=$_GET['page'];    
        }
$limit=15; //for record in page    
$rs2=$DB->fetchAll('*','orders',false,false,false,false,$page,$limit);

 foreach($rs2 as $row){
     echo $row['ID']."==".$row['name']."<br/>\n";
     }


 $rowcount=$DB->rowCount("orders");
 $link='&cat=5'; // like $link="&cat=5"; like
 
echo $DB->pagination($page,$limit,$link,$rowcount,'Next Page','Prev Page','First Page','Last Page');

    */