Code Examples -> Database Connectivity with MS Access - The Easy way to work with PHP and MS Access

	Submit Your Code
	SEO Monitor
	UpTime Monitor
	PHP Code Contest
	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 Index
	PHP Web Logs (BLogs)
	Web Development Resources
	Web Development Content

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
	Submit Site
	Forex Trading Online forex trading platform


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

PHP Code Examples

Title :	Database Connectivity with MS Access - The Easy way to work with PHP and MS Access
Categories :	PHP, ADO, MS Access, Databases	Mohammad Rahman
Date :	Aug 14th 2001
Grade :	3 of 5 (graded 21 times)
Viewed :	22026
File :	dbConnection.zip
Images :	No Images for this code example.

Search :	More code by Mohammad Rahman
Action :	Grade This Code Example
Tools :	My Examples List

Code

<body bgcolor="lightBlue" text="navy" topmargin=0 leftmargin=0>
<Center><H2><font color="#800000">THIS IS PHP EXAMPLE
PAGE</font></H2></Center>
<p align=right>Created By:<BR><B>Mohammad Jahidur Rahman</b><br>
<a
href="mailto:j.rahman@grameensoftware.com">j.rahman@grameensoftware.com</a></
p><HR>
<Center><B><U><font color="#008000">Page Profile</font></U></B><BR>

<?PHP

                // Place the location of files into variables
$location_counter = "count.txt";
$location_ip = "ip.txt";

                // Finds how many people have visited and adds one to it
$counter = join('', file($location_counter));
trim($counter);
$counter++;

                // Print lines to the screen
echo "You are visitor number: $counter<br>";
echo "Your IP address is: $REMOTE_ADDR<BR><HR>";
echo "</center>";

                // Changes the value of the counter in the count.txt file
$fp = fopen($location_counter,"w");
fputs($fp, $counter);
fclose($fp);
// Adds one more ip address to the end of the ip.txt file
$date = date("H:i:s d M, Y");
$fp = fopen($location_ip,"a");
fputs($fp, "Date: $date IP: $REMOTE_ADDR \n");
fclose($fp);
?>

<?PHP
                echo "<center><font color=\"#008000\"><b><U>Connection with
MS Access Database</U></B></font><BR>";

        //Connecting Database
                require_once "connection.inc";

                // SQL statement to build recordset.
        $rs = $conn->Execute("SELECT * FROM tblGuest ORDER BY Guest_ID ASC");


        //combobox
?>
        <B>Guest Name Combobox: </B><select name="sname">
        <option value="" selected>All Names From Database</option>
<?
        while (!$rs->EOF) {
        $fv = $rs->Fields("Name");
        $n = $fv->value
?>
        <option value="<?= $n?>"><?= $n?></option>
<?
        //echo "<option value=".$fv->value.">".$fv->value."</option>";
        //echo "Value: ".$n."<br>\n";
        $rs->MoveNext();
        }
?>
        </select><br><br>
<div align="center">
<table border="1" width="516" height="27">
<tr>
<td width="2" height="3"></td>
<td width="488" height="3" colspan="3"></td>
<td width="4" height="3"></td>
</tr>
<tr>
<td width="2" height="10"></td>
<td width="488" height="10" colspan="3">
<p align="center"><b>All Result of Guest Database </b></td>
<td width="4" height="10"></td>
</tr>
<tr>
<td width="2" height="5"></td>
<td width="109" height="5">
<p align="center"><b>Guest ID</b></td>
<td width="162" height="5">
<p align="center"><b>Guest Name</b></td>
<td width="205" height="5">
<p align="center"><b>E-mail</b></td>
<td width="4" height="5"></td>
</tr>
<?
                $rs->MoveFirst();
        while (!$rs->EOF) {
        $id = $rs->Fields("Guest_ID");
         $name = $rs->Fields("Name");
         $email = $rs->Fields("Email");
echo "<tr>";
echo "<td width=2 height=8></td>";
echo "<td width=109 height=8>$id->value</td>";
echo "<td width=162 height=8>$name->value</td>";
echo "<td width=205 height=8><a href=mailto:$email->value>$email-
>value</a></td>";
echo "<td width=4 height=8></td>";
echo "</tr>";

                $rs->MoveNext();
        }
?>
<tr>
<td width="2" height="3"></td>
<td width="488" height="3" colspan="3"></td>
<td width="4" height="3"></td>
</tr>
<tr>
<td width="2" height="10"></td>
<td width="488" height="10" colspan="3">
<p align="center"><input type=button value="BACK" onclick="history.go(-
1);"></p>
</td>
<td width="4" height="10"></td>
</tr>
<tr>
<td width="2" height="7"></td>
<td width="488" height="7" colspan="3"></td>
<td width="4" height="7"></td>
</tr>
</table>
</div>

<?
        $rs->Close();

                //Disconnecting Database
        require_once "disconnect.inc";
?>
</center>
</body>

Related Code Examples

	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
	Problem with Database Connectivity in PHP and MS Access? Don't worry, The easy way is...... Categories : ADO, PHP, Databases
	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
	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

User Comments

	azhar mehmood wrote :1201 `I get the following Error: Fatal error: Cannot instantiate non-existent class: com in /home/connection.inc on line 8`