Login   Register  
PHP Classes
elePHPant
Icontem

File: example1.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  >  example1.php  >  Download  
File: example1.php
Role: Example script
Content type: text/plain
Description: example1
Class: DBMysqli
Access MySQL databases with mysql and mysqli
Author: By
Last change:
Date: 2013-03-24 12:04
Size: 1,583 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);


 
$result=$DB->fetchRow('members',"ID ='1'");
 
 
$data='<pre> ID : '.$result['ID']."<br/>";
 
$data.='name : '.$result['name']."<br/>";
 
$data.='email : '.$result['email']."<br/></pre>";
print(
$data);
/*
output
 ID : 1
name : osama salama
email : osama_eg@outlook.com
*/
 
 
 
 
 //different database connetion
$forum['vb']['Host']="localhost";
$forum['vb']['UserDb']="root";
$forum['vb']['PassDb']="";
$forum['vb']['Dbname']="ora";
$forum['vb']['Prefix']="";  //table prefix
$forum['vb']['Charset']="utf8";

/*
choose MYSQL  or MYSQLi 
active other database by key  vb


$DB2=Database::getInstance("mysqli",$forum,'vb');
 $result2=$DB2->fetchRow('cat'," ID='1' ");
  $data2='<pre> ID : '.$result2['ID']."<br/>";
 $data2.='name : '.$result2['name']."<br/></pre>";

print($data2);
 */
 
 //fetch data
 /*
  $result1=$DB->fetch('orders',"ID != '1'",'ID asc');
 foreach($result1 as $row){
     echo $row['ID']."==".$row['name']."<br/>\n";
     }
    
    output
    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
15==dnsadn
16==bjkhbk*/
      
 
?>