Code Examples -> This script will return all of the information in every table listed in $myarray, and will return lists of field names and information for each item,

	Join us on FaceBook
	Submit Your Code
	Poker Tournaments
	Poker Guide for Developers
	SEO Monitor
	UpTime Monitor
	My Favorite Examples
	My Favorite Articles
	Update Your Profile

More Weber Sites
	PHP Code Search
	Web Development Forums
	Learn MySQL Playing Trivia
	PHPBB2 Templates
	Web Development Resources
	Web Development Content
	Internet Security Software

Recommended Links
	PHPClasses
	PHP Editor
	PHP Jobs
	Vision.To Design
	Ajax Tutorials
	PHP Programming Help
	PHP/MySQL Programming
	Webmaster Resources
	Webmaster Forum
	XML meta language
	website builder

Recommended
	פרייסז - הכח לקנות עובר לידיים שלך
	Texas Holdem Poker Evangelists


BACK		ADD A COMMENT		SEND TO A FRIEND		ADD TO MY FAVORITES		ADD CODE EXAMPLES		PRINT

PHP Code Examples

Title :	This script will return all of the information in every table listed in $myarray, and will return lists of field names and information for each item,
Categories :	PHP, MS Access, Databases	mike down
Date :	Apr 13th 2001
Grade :	2 of 5 (graded 2 times)
Viewed :	6728
File :	access.php
Images :	No Images for this code example.

Search :	More code by mike down
Action :	Grade This Code Example
Tools :	My Examples List

Code

<?
//array of table names///
//these are some of the tables in the Access Sample database "Contact Management"///
//if you have another database you would put the table names in this array///
$myArray = array("Company","Calls","ContactTypes");
///count the array//
$arra = count($myArray);

// function to get all the info from the database///
function getinfo($query)
{
$connection= odbc_connect("Contact","","");
$result= odbc_do($connection,$query);

while(odbc_fetch_into($result, &$fields))
{
$n =odbc_num_fields($result);
$i=1;
$b=0;
do{
$fieldname=(odbc_field_name($result,$i));
$names[$b]=$fieldname;
print "$names[$b]: $fields[$b] ";
$i++;
$b++;
}
while($i<=$n);
echo" ";
}
odbc_close($connection);
}

///end o function///
///start of script///
//loop through the count of the array and get all of the tables's info
$x=0;

do
{
echo "$myArray[$x] ";
$query= "select * from $myArray[$x]";
getinfo($query);

$x++;
}
while($x<$arra);
?>

Related Code Examples

	Report Generation in Microsoft Access from a MYSQL database Categories : PHP, MySQL, Databases, MS Access
	Database Connectivity with MS Access - The Easy way to work with PHP and MS Access Categories : PHP, ADO, MS Access, Databases
	Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0. Categories : Databases, PHP, mSQL, Databases
	mediaCat-GTK v2.0.0 - an mp3/cd/dvd cataloging utility written in php-gtk which interfaces with mysql and ms access (or db supported by PHP's Unified ODBC Functions) Categories : PHP, MySQL, MS Access, Utilities, Databases
	This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases
	XDT Topsite (Gold v1.0) Categories : Databases, CSS, PHP, HTML and PHP, Sessions
	This class splits the results of the query into multiple pages like what the search engine does. Categories : PHP Classes, PHP, MySQL, Databases
	This simple function will take a few arguments and easily set a associative array for each column in a result from a MySQL query Categories : Databases, PHP, MySQL, Arrays
	Shopping Cart e-Commerce Solution Categories : Complete Programs, PHP, MySQL, Databases
	Finds the median in an array of numbers - Can be used with a MySql database column read into an array Categories : PHP, Arrays, Databases, MySQL
	Newbie Notes #10 - Generating drop downs Categories : PHP, MySQL, HTML, Beginner Guides, Databases
	This function will populate the options in a drop down HTML select list in a form from a database query. Categories : MySQL, General SQL, PHP, HTML and PHP, Databases
	StoredProcedure, Stored Procedure, Oracle, OCI8, OCI8i Categories : OCI8, Oracle, Databases, PHP
	A script to generate a report from a valid mysql connection. The user has to supply which fields he wants to display in table. All properties are changable. Categories : PHP, PHP Classes, Databases, MySQL, HTML and PHP
	AJAX Data Grid System using php and mysql. A complete login system with the ability to display data in a grid using ajax. Add , update and delete the records without reloading the page. Categories : PHP, AJAX, Databases, MySQL, Java Script