zeWEBHOST Knowledge Base - MS Access Databases Connection Strings in PHP Without DSN

zeWEBHOSTAffordable Web Hosting Services Beyond Your Expectations

Home Web Hosting Guide Compare Hosting Plans Basic Hosting Plan Professional Hosting Plan Extreme Hosting Plan Email Only Hosting Web Forwarding Advanced Features Hosting Control Panel SSL Certificates Hosting Order Page

WISDOM

The Essence of Knowledge is Having it to Apply it.

Confocious

Knowledge Base IP Location Contact Us Login Order Free Toolbar
KNOWLEDGE BASE / CONNECTION STRINGS / CONNECTING TO DATABASES IN PHP

The Full Script

CONNECTING TO MS ACCESS IN PHP WITHOUT A DSN

This script demonstrates connecting to a MS Access database in PHP without a DSN. The script will make the connection and then output all the rows of a specified table. Any lines beginning with a // are comments.

$db_location = "c:websitesyoursite22yoursite.comdb est.mdb";
Sets a variable to hold the physical path to the database. You should change this to the path for your database.

$table = "testtable";
Sets a variable to hold the name of the table to be displayed by the script. This should be changed to your table name.

$userid = "";
$password = "";
These are the username/password to use for the database. These are only necessary if your Access database has a username/password set.

$dbc = new COM("ADODB.Connection");
Creates a new ADO object for the connection.

$connstr = "DRIVER={Microsoft Access Driver (*.mdb)};";
$connstr .= "DBQ=$db_test;uid=$userid;pwd=$password;";
Creates the connection string from the specified parameters.

$dbc->open($connstr);
Attempts to connect to the database.

$rs = $dbc->execute("SELECT * FROM $tablename");
Executes the specified query on the database.

if(!$rs->eof()){
If there was a result from the query.

print "<TR>";
Starts a new HTML row.

$numfields = $rs->fields->count;
Gets the number of fields in the table.

for($loop = 0; $loop < $numfields; $loop++){
     //print the name of each field
     $fld = $rs->fields($loop);
     print "<TH>$fld->name</TH>";
}
Loops through each field and prints the name of the field as the first row in the HTML table.

print "</TR>";
Ends the HTML row.

while(!$rs->eof()) {
Goes through the remaining rows from the result set.

$numfields = $rs->fields->count;
Gets the number of fields in the row.

print "<TR>";
Starts a new row in the HTML table.

for($loop = 0; $loop < $numfields; $loop++){
     //print each field's value
     $fld = $rs->fields($loop);
     print "<TH>$fld->value</TH>";
}
Loops through each field in the row and prints the value in the HTML table.

print "</TR>";
Ends the HTML row.

$rs->movenext();
Moves to the next row in the result.

print "</TABLE>";
Ends the HTML table.

$dbc->close();
Closes the database connection.

--Here is the full script, the filename should be: access-dsnless.php--

<html>
<head>
<title>Sample script for accessing a MS Access database in PHP without a DSN</title>
</head>
<body>
<?php

//zeWEBHOST Test script for connecting to an Access database in PHP without a DSN
//This script will connect to the database and output the results in an HTML table

// Change these values to point to your database
// --------------------------------------------
// this is the physical location of the database
$db_location = "c:websitesyoursite22yoursite.comdb est.mdb";
// the name of the table to display
$tablename = "testtable";
// username and password for the database
$userid = "";
$password = "";
// ----------------------------------------------

//create the connection string
$dbc = new COM("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)};";
$connstr .= "DBQ=$db_test;uid=$userid;pwd=$password;";

$dbc->open($connstr);

//execute a query
$rs = $dbc->execute("SELECT * FROM $tablename");

//print the results to a table
print "<TABLE BORDER=1>";

//print the column names
if(!$rs->eof()){
     print "<TR>";
     $numfields = $rs->fields->count;
     for($loop = 0; $loop < $numfields; $loop++){
          //print the name of each field
          $fld = $rs->fields($loop);
          print "<TH>$fld->name</TH>";
     }
     print "</TR>";
}

//while not the end of the result set
while(!$rs->eof()) {
     $numfields = $rs->fields->count;
     print "<TR>";
     for($loop = 0; $loop < $numfields; $loop++){
          //print each field's value
          $fld = $rs->fields($loop);
          print "<TH>$fld->value</TH>";
     }
     print "</TR>";
     //move to next row
     $rs->movenext();
}

print "</TABLE>";

//dont forget to close connection
$dbc->close();

?>
</body></html>

--End Script--

To Top