ADOdb: How to show tables



Show all tables using ADOdb is very easy. You just need MetaTables(). Look at sample code.
<?php 
    include('adodb/adodb.inc.php'); 
    $db = ADONewConnection('mysql'); 
    $db->debug = true; 
    $db->Connect('localhost', 'root', 'admin', 'scanner'); 
    print_r($db->MetaTables()); 
?>
You can assign value of $db->MetaTables() to a array variable then do something with that variable.


Series this article:
ADOdb: Introduction
ADOdb: Connection Statement
ADOdb: Advance Select Statement
ADOdb: How to show tables
ADOdb: How to show fields
ADOdb: How to show databases
ADOdb: Caching of Recordset
ADOdb: Recordset to HTML
ADOdb: Multi Database Connection
ADOdb: Data Dictionary
ADOdb: Quick Export Data
ADOdb: Insert data style
ADOdb: Replace Data
ADOdb: Log Query
PHP ADOdb: Understanding Pivot Table For Reporting
PHP ADOdb: Creating Pivot Table
PHP ADOdb: Creating Query to Build Pivot Table


Tag: adodb, database, database layer Category: PHP Database Post : October 30th 2007 Read: 5,979 Bookmark and Share

blog comments powered by Disqus