Login   Register  
PHP Classes
elePHPant
Icontem

File: example.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Sinan  >  MySqli Plus  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/plain
Description: Usage
Class: MySqli Plus
MySQL database access wrapper based on MySQLi
Author: By
Last change: - Connection type changed
Date: 6 months ago
Size: 1,119 bytes
 

Contents

Class file image Download
<?php   
/**  
* @table : users   
*  | id | first_name | last_name | 
*  ------------------------------- 
*    1  | joe         | fox 
*    2  | exm         | example 
*    3  | admin       | admin 
**/
$myConfig = include "config.php";
require_once(
"class.mySqliPlus.php");


    
$mysqli  = new mySqliPlus($myConfig);
    
$table 'users';
     
    
//row count
    
echo '<pre>';
    echo  
$mysqli->rowCount($table,"where first_name ='joe'");
    echo 
'</pre>';


    
//get rows
    
echo '<pre>'
    
print_r($mysqli->getRows($table,'*',"where first_name ='joe'"));  
    echo 
'</pre>';

    
//insert data
    
$data_arr = array(
        
'id' => '',
        
'first_name' => "joe's data",
        
'last_name' => "test",
        );

    
$rowID $mysqli->insert($table$data_arr);
    echo 
$rowID// it returns inserted id

    //update data
    
$data_arr = array(
        
'first_name' => "joe's Updated Data",
        
'last_name' => "testUpdated",
        );
    
$mysqli->update($table$data_arr,'where id=1');

    
//delete data
    
echo $mysqli->delete($table,'id=2');