how to use ms access database in php

hey frnds i want to know how to use MS ACCESS in the php ....

 

Depending on what you are trying to achieve, you will need to create a DSN and use the ODBC functions that are built in.

Start here for more information:
http://php.net/manual/en/function.odbc-connect.php

If you arent sure about DSN' and need mroe information, see here:
http://www.w3schools.com/PHP/php_db_odbc.asp

Of course, it could be argued that it would be better to export your database to mysql, postgres or something else rather than using access, but as said above, it depends what you are trying to achieve.

 

As lukeg32 mentionned,

You first need to create the ODBC on the machine the script will run then use the php functions to connect to it. eg:

$odbc = odbc_connect ('odbc_name', 'username', 'password') or die('Could Not Connect to ODBC Database!');

$query = odbc_exec($odbc, "SELECT * FROM mytable") or die (odbc_errormsg());
while ($row = odbc_fetch_array($query))
{
	// Do something here
}
odbc_close ($odbc);

Code (markup):

aXe