phpeveryday.com

The best tutorial of php, php framework, php strategies, object oriented oriented,


ADOdb: How to show fields

Tag: adodb, database, database layer   Category: PHP Database
post: 30 Oct 2007 read: 1,626


Now, I will show you simple code that can show all fields in a table and their meta data. Just using MetaColumns(). 

<?php 
    include('adodb/adodb.inc.php'); 
    $db = ADONewConnection('mysql'); 
    $db->debug = true; 
    $db->Connect('localhost', 'root', 'admin', 'scanner'); 
	$arr = $db->MetaColumns('name_table'); 
	echo "<pre>";
	print_r($arr);
	echo "</pre>";
?>


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

| Give Your Opinion | Recommend
Share and Bookmark to: These icons link to social bookmarking sites where readers can share and discover new web pages.
digg del.icio.us technorati Ma.gnolia BlinkList

Recommended articles by other readers:
Web Services: How PHP Kiss VB.NET? (Part 1)
Chart: How to Build Cool Animation Real Time Chart
Joomla: Fast Road to Understand Component Programming
Email: Send Attachement Mail
mod_rewrite - Part 1: create your "fantasy" URL

What do You Think?
Your Name *:
Email *:
(Will not be published)
Website/URL:
Your Comment *:
* Required


615
posting