PHP and MS Acces database

glitz

Does anyone know how I can get the information from an MS Access database to load onto a web page using PHP? I would greatly appreciate any help in this topic.
Thank you.😕

dougal85

Google for it! 🙂 I searched for "ms access php" and found plenty... ie. http://www.phpfreaks.com/tutorials/61/0.php

mark_kccs

This is a small script that I use on an access db

$sql = "SELECT TBLCUSTOMER.CELLNUMBER FROM TBLCUSTOMER WHERE (((TBLCUSTOMER.CELLNUMBER) Is Not Null) AND ((TBLCUSTOMER.CURRENT)=False));";

$db = 'C:\db.mdb';
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=$db");

$rs = $conn->Execute($sql);
while (!$rs->EOF) {
$new_arr[] = $rs->Fields['CELLNUMBER']->Value;
$rs->MoveNext();
}
$rs->Close();
$conn->Close();
$rs = null;
$conn = null;

glitz

Hi Mark

Thanks for the reply every thing I have researched required using an ODBC and I have no clue on it because my server is run by someone else I'm just creating it and uploading it onto the server. But is 'C:\db.mdb'; the pathe to where my database resides on the server?

mark_kccs

Yes that's the path, so would would need to get this info from your ISP.

glitz

Hi,
I do have the server path but when I try using your form and connecting to the database I only get a blank page.

Thank you

mark_kccs

You will need to alter the script to represent your db tables and fields and then display the results with either echo or print_r command.

glitz

Hi, thanks for the reply. Here is a copy of my working code could you help me out I am new to PHP so I hardly know what I am doing. Can you explain your code in more detail to me. Thanks.

This is the webpage that gets the information loaded from the MySQL database
<?php
//variables for database and table
$table_name="staff";
//quering the database
require("phpinclude.php");
$sql = "SELECT * FROM " .$table_name. " ORDER BY lname";
$results = @($sql, $connection) or die(mysql_error());
//database array
while ($row=mysql_fetch_array($results))
{
$lname=$row[lname];
$fname=$row[fname];
$email=$row[email];
$phone=$row[phone];
$room=$row[room];
$picture=$row[picture];
$id=$row[id];
$department=$row[department];
$display_block= $display_block .
"
<p><a href='formpage2.php?id=".$id."'><img src='database/".$picture."'/></a>

<br /> 
".$fname." ".$lname."
<br /><strong>".$department."</strong>
<br />ph.".$phone."
<br />Rm.".$room."
</p>"
;

}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>

This is the connection to the database page
<?
//database name
$db_name="Database1";
//connect to MySQL and select manit
$connection=mysql_connect("", "", "") or die(mysql_error());
$db=@mysql_select_db($db_name, $connection) or die(mysql_error());
?>

mark_kccs

This script is to connect to a mysql database so you will need to change the values accordingly. I would suggest that you hit the books for PHP or you will find a good tutorial here http://hudzilla.org/phpwiki/index.php?title=Main_Page
I'm afraid there is no quick fix to learning php but you should be able to grasp the basics to get this working quite quickly.

glitz

Thank you for your reply and help Mark, but I didn't find any thing on MS Access on the web site you gave me. I am still open to suggestion as I look further.