How to connect to Access data base

Anon

Hi All,

I was trying to connect to access database and using php script want to retreive data.I don't know whether I can do this or not. Question is how to connect to access database???

I had done the following things to connect to ACcess:

1) First created datasourcename as "student" using ODBC datasouec(32bit) from control pannel.

2)Created a table in access.

3) here is the php script which I am trying to retreive data.

<title>
<b>This programme is dedicated to Sai Baba</b></title>
<body>
<? php
@ $db=mysql_pconnect("localhost","student","student");

	if(!$db)
	{
		echo "Error:could  not connect to database.please try again later";
		exit;
	} 
mysql_select_db("db1"); 

$query = "select * from stu";
$result =mysql_query($query);
$num_results = mysql_num_rows($result);
echo "<p> number of books found: ".$num_results."</p>";

?>
</body>

When I try to run this getting the following error:

Parse error: parse error in c:\program files\apache group\apache\htdocs\data.php on line 6

Please help me.

Thanks in advance.
sankar.

plutoplanet

This will work:

<title>
This programme is dedicated to Sai Baba</title>
<body>
<?
@ $db=mysql_pconnect("localhost","student","student");

if(!$db)
{
echo "Error:could not connect to database.please try again later";
exit;
}
mysql_select_db("db1");

$query = "select * from stu";
$result =mysql_query($query);
$num_results = mysql_num_rows($result);
echo "<p> number of books found: ".$num_results."</p>";
?>
</body>

find the difference? ;-)

Anon

Hi Herwig,
I tried with your code,Now I am getting another error,
i.e
Error:could not connect to database.please try again later

I am using Access as back end database,
please check what ever code I have given to Access the Access database is correct or not.
Thanks ,
Sankar

Anon

If you are connecting to an Access database why are you using a mySQL connection? Shouldn't you be connecting through access?

Anon

Hi Icehawg,
thank you,
But I did not know how to access data from Access database.
Can you please help me?
Sankar

Anon

While I am not too familiar with the Access product, I do understand that it is a Microsoft product using a bastardized SQL for its db work.

I would suggest trying out mssql instead of mysql. Check the php.net site for info on the functions.

Anon

Hi Sankar,

ok, I see the problem - but I'm sorry I can't test any code for an access database, because I don't use any Micro$oft.

If you really plan to go on with an Access Database you should try to connect it via ODBC (I think so...).

however, I think this would be a little bit difficult and is not documented too good. I think it would be more useful and efficient for you to become familiar with a real Database like mysql or informix instead of any Micro$oft Products.

Herwig

reagent

herwig was on the right track when he/she told you to look into using odbc

http://php.net/manual/en/ref.odbc.php

look into using odbc_connect() to get a connection to your database and odbc_exec() to execute queries

to get results, use odbc_fetch_row() and odbc_result()

Sounds as if you have the first step of creating the datasource taken care of.