Accessing .mdb files.

djumaka

Hi folks!

I want to ask you something:
Is there a way to access the Microsoft Access(I think) .mdb files from PHP like some server or data source as it's done in the ASP?

Alternative:
Is there any way to create databases without using any SQL server(I mean something like MDB or so.)

barand

Use ODBC. Set up a system DSN on the server and connect via that. I've only got it to work when the mdb file is on the same machine as the web server.

Check out the php manual for odbc functions. eg:-

$cnxn = odbc_connect ("dsnname","usr","pwd");

$result = odbc_exec($cnxn,"select * from tablename");

hth

djumaka

Hi there!

Thanks for the answer bu it will be more easy for me to understand it if you apply any active code(a part of a php page or so).

Also how do I disconnect the mdb?

TIA,
Djum@ka.

barand

Here's a sample from one of my apps:-

function getcontracts() {
	global $cnx;
	$sql = "SELECT contract.contract_id, contract.enddate, Operator.OperatorName, route.rtedesc ".
	"FROM (Operator INNER JOIN contract ON Operator.op_id = contract.op_id) ".
	"INNER JOIN route ON route.rte_id = contract.rte_id ".
	"order by contract.enddate ";
	$Q = odbc_exec($cnx,$sql);
	$res = "";
	while (odbc_fetch_into($Q,$array)) {
		list($contract,$exp,$op,$rte)=$array;
		$days = daysLeft($exp);
		$class = ($days<90)?"class=\"renew\"":"";
		$res .= "<tr><td class=\"con\">$contract</td><td>$op</td><td>$rte</td><td $class> ".formDate($exp)."</td>";
	}
	odbc_free_result($Q);
	odbc_close($cnx); /*disconnect*/
	return $res;
}

hth

djumaka

Ok the example is good but what do I need to write in that ODBC_Connect and its fields to make it work. For example the files is messages.mdb and is in the same directory as the php script.

Sorry for troubling you again

Thank's for all!
Djumaka

barand

As I said in my post of Nov 13

$cnx = odbc_connect("DSNname", "username", "password");

where DSNname is the the name you gave to your ODBC DSN via control panel.

If you have no system.mda file, you only need

$cnx = odbc_connect("DSNname", "", "");

hth

djumaka

I'm using a free hosting and the did not give me any DSN so what do I need to know so that I can menage that. In ASP it is easy - the ADO is called to access the .mdb file.

barand

Tried a Google search for PHP ADO and came up with this

phph/ado