Login   Register  
PHP Classes
elePHPant
Icontem

File: ez_demo.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Justin Vincent  >  ezSQL  >  ez_demo.php  >  Download  
File: ez_demo.php
Role: Example script
Content type: text/plain
Description: Demo that maps out your db schema
Class: ezSQL
Makes using mySQL ridiculously easy (great docs)
Author: By
Last change:
Date: 12 years ago
Size: 468 bytes
 

Contents

Class file image Download
<?php

    
// Include ezSQL in order to use it..
    
include_once "ez_sql.php";

    
// Get list of tables from current database..
    
$my_tables $db->get_results("SHOW TABLES",ARRAY_N);

    
// Print out last query and results..
    
$db->debug();
    
    
// Loop through each row of results..
    
foreach ( $my_tables as $table )
    {
        
// Get results of DESC table..
        
$db->get_results("DESC $table[0]");
        
        
// Print out last query and results..
        
$db->debug();
    }
    
?>