|
|
|
<?
//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]<br>";
$i++;
$b++;
}
while($i<=$n);
echo"<br>";
}
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 "<b>$myArray[$x]</b><br><br>";
$query= "select * from $myArray[$x]";
getinfo($query);
$x++;
}
while($x<$arra);
?> |
|
| 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 | | | Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0.
Categories : Databases, PHP, mSQL, 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 | | | Database Connectivity with MS Access - The Easy way to work with PHP and MS Access
Categories : PHP, ADO, MS Access, Databases | | | Report Generation in Microsoft Access from a MYSQL database
Categories : PHP, MySQL, Databases, MS Access | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.
Categories : Databases, PHP, MySQL, Complete Programs | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | | | phpAds, a complete banner and ad management system with detailled tracking and stats.
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | | | Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | Displaying records of database in more than one page (paging)
Categories : Databases, MySQL, PHP | | | Message of the Day - Random Message (Needs MySQL!)
Categories : Databases, HTML and PHP, PHP, MySQL | | | Function Query2Array will read an PEAR-DB-Query-Result into an Array.
You may specify a Column used as Array-Keys,
and you may specify the Number of Rows to skip at the beginning and the
Number to fetch (-1 = infinite).
Categories : Functions, PHP, Databases | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Tropicalm Genetree Family (MySQL based family tree)
Categories : PHP, Interfaces, Databases, MySQL, Complete Programs | | | mysql_escape_string
Categories : PHP, MySQL, Databases, Strings | |
|
|
|
