Closed Thread Icon

Topic awaiting preservation: databases Pages that link to <a href="https://ozoneasylum.com/backlink?for=22443" title="Pages that link to Topic awaiting preservation: databases" rel="nofollow" >Topic awaiting preservation: databases\

 
Author Thread
EDDII
Bipolar (III) Inmate

From:
Insane since: May 2004

posted posted 07-05-2004 18:32

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

WarMage
Maniac (V) Mad Scientist

From: Rochester, New York, USA
Insane since: May 2000

posted posted 07-05-2004 20:58

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

H][RO
Bipolar (III) Inmate

From: Australia
Insane since: Oct 2002

posted posted 07-11-2004 15:59

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.

EDDII
Bipolar (III) Inmate

From:
Insane since: May 2004

posted posted 07-16-2004 16:31

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

code:
<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}"/>

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 07-16-2004 17:17

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.

EDDII
Bipolar (III) Inmate

From:
Insane since: May 2004

posted posted 07-17-2004 02:28

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

H][RO
Bipolar (III) Inmate

From: Australia
Insane since: Oct 2002

posted posted 07-17-2004 02:48

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.

« BackwardsOnwards »

Show Forum Drop Down Menu