ms-access & php

[wo1olf]

Is it hard to do or it is better to use mysql instead?

[biznuge]

I guess this would be a good basic introduction to db stuff, but I've only ever tried asp with access, so I'm not even sure how you'd go about constructing the connection string, or whether php would actually have an interface for msaccess.

I'd say try mySQL instead though. save yourself a lot of hassle.

[hl]

obdc or odbc (i forget) connect

www.php.net/obdc_connect
www.php.net/odbc_connect

edit:/ it's odbc

www.php.net/odbc

[biznuge]

odbc huh. I have to use that at work for MS SQL as we have to run server 2000, but it's a little flaky on some of the more useful functions such as getting back insert indexes and so on.

I'd still say forget about msaccess and simply go at it with mysql, or MS SQL.

Can you do anything that emulates stored procedures with access...?

[Neolumi]

php & mysql seems easier than access/odbc/mssql but its possible. MySQL 5 and up has stored procedures:

http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html

[Utech22]

Check: http://www.w3schools.com/php/php_db_odbc.asp