can I use acces database with php? how?

[franko17]

Hi,
at first I thought trying MySQL database, but I have no
idea how to create one. (I don't want to install MySQL server on my pc - I really don't need it. I just want a simple database that I can upload to lycos and use it for very simple stuff)

so, I have 2 options - to find an easy way to create a MySQL database in order to upload it, or I can use an acces database which is all i need, I just don't know how to make the connection to the database in PHP (I did it before with asp but it doesn't seem to work with PHP)

please help me,

🙂

[barand]

Download the mySQL ODBC driver from the mySQL website and connect using [man]odbc_connect[/man]. See also the other ODBC PHP functions in the manual.

hth

[franko17]

does the odbc_connect works with acces database or do I have to use MySQL?

[barand]

Sorry, I was thinking of connecting a mysql database to access - different problem.

Forget earlier post.

Create an ODBC DSN using Microsoft Access driver (if you don't have such a DSN already) and specify that DSN's name in the connection with odbc_connect

$conn = odbc_connect('accessdsn', 'admin', 'pwd');

Use the other odbc_ functions to query the database, get results etc.