Topic awaiting preservation: databases

can i use microsoft access to make databases that i can edit from php scripts as all i can find are tutorials on mysql and i dont know what that is

PHP does support a number of different databases. MySQL is one of them and it is a very popular one. You can get more information on MySQL at http://www.mysql.com if you want to work with Access then you will have to use ODBC which is a connection protocal, http://www.phpfreaks.com/tutorials/61/0.php has some information on working with access via php. I didn't read the artical, it was just what popped up when I did a simple search via google. If you need more information search yourself, I simply searched for "php microsoft access" and it was the first thing that popped up.

Dan @ Code Town

Its quite simple, the queries you do are just as you would do them in vba. I have done substantial access work with php, and offline access too, if you need help with anything specific just post it here.

i was given this code but i cant seem to get it to work i made a simple 1 row table in access with colum headers 1,2,3 and enterd infromation into all of them

<sql:query var="test" dataSource="db1.mdb">

  SELECT * from thistable

</sql:query>

<c:out value="${row.1}"/>

<c:out value="${row.2}"/>

<c:out value="${row.3}"/>

well... that ain't php for sure - what are you actually trying to do?

so long,
Tyberius Prime

PS: Punctuation helps - but I've a feeling we've had this conversation before.

wait are u another one or the same one, well i dont care i dont smart arsedness
that code is meant to read from a database called db1
then the table is called this table and select from is meant to read the table
then the bit below is meant to write the first line of column 1 the column 2 then column 3
what ireallly would like to be able to do is read from it and write to it as i am making my own mamber section

Read This.. http://php.weblogs.com/adodb_tutorial

Personally i use the ADODB connection type. Quoted from the link.. I think this means u can change your database to SQL, mySQL or whatever - without having to go through and change all of your queries. Still some query operations might not be supported i expect such as 'limit' for an access database.

quote:

---

A database wrapper library such as ADODB comes in handy when you need to ensure portability. It provides you with a common API to communicate with any supported database so you don't have to call things off.



ADODB stands for Active Data Objects DataBase (sorry computer guys are sometimes not very original). ADODB currently supports MySQL, PostgreSQL, Oracle, Interbase, Microsoft SQL Server, Access, FoxPro, Sybase, ODBC and ADO.

---