Access database and php :(

[Katie]

Hi all,

I'm a genetic student at uni, and am doing a final year web project.

But I have a problem. I've found a web hosting place, and in the site
have created a microsoft access database. But for the life of me I
can not find out how to connect and input data using php! There seems
to be not tutorials on the internet :(

Basically I have a response form, people fill it in and hit submit
then the data is stored in the database.

I'm thinking using php, would it be easier to use another language,
e.g. asp?

Can anyone help me with this? - point me towards any
information/tutorials or suggest some code etc to connect and input
data into a access db?

I'm really stuck and the deadline is comming quite close :(

Any help would be so much greatly be appreciated!

Thanks for reading, Katie x

[Manuel Lemos]

Hello,

On 03/14/2004 11:42 PM, Katie wrote:

I'm a genetic student at uni, and am doing a final year web project.

But I have a problem. I've found a web hosting place, and in the site
have created a microsoft access database. But for the life of me I
can not find out how to connect and input data using php! There seems
to be not tutorials on the internet :(

Basically I have a response form, people fill it in and hit submit
then the data is stored in the database.

I'm thinking using php, would it be easier to use another language,
e.g. asp?

Can anyone help me with this? - point me towards any
information/tutorials or suggest some code etc to connect and input
data into a access db?

If you are using Windows hosting you can use ODBC to connect to MS
Access databases.

In that case you may also use this database API that has MS Access
drivers using ODBC and comes with a tutorial:

http://www.phpclasses.org/metabase

--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

[Geoff Berrow]

I noticed that Message-ID:
<cb**************************@posting.google.com > from Katie contained
the following:

Basically I have a response form, people fill it in and hit submit
then the data is stored in the database.

If the webspace has MySql and phpMyAdmin you may find it easier to use
these.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[R. Rajesh Jeba Anbiah]

ka*****************@hotmail.com (Katie) wrote in message news:<cb**************************@posting.google. com>...

Hi all,

I'm a genetic student at uni, and am doing a final year web project.

But I have a problem. I've found a web hosting place, and in the site
have created a microsoft access database. But for the life of me I
can not find out how to connect and input data using php! There seems
to be not tutorials on the internet :(

I wonder, what was your search keywords?

1. http://www.google.com/search?q=php+access+database
2. http://www.google.com/search?q=php+MS+access+database
3. http://webokay.net/~siddarth/Main.html
4. http://in2.php.net/manual/en/ref.odbc.php
5. http://in2.php.net/manual/en/ref.dbx.php

--
"Democracy: Where all citizens are politicians and all politicians are citizens"
Email: rrjanbiah-at-Y!com

[Katie]

Hi

Thanks for all your responses. I researched asp up and it seems so
much easeir. Unfortunatly I can not do an mysql database but I've
information for the asp and example scripts and explanations on all
the functions off of web wizrd I think it was called.

Thats for helping, Katie xx

[Tim Van Wassenhove]

On 2004-03-17, Katie <ka*****************@hotmail.com> wrote:

Hi

Thanks for all your responses. I researched asp up and it seems so
much easeir. Unfortunatly I can not do an mysql database but I've
information for the asp and example scripts and explanations on all
the functions off of web wizrd I think it was called.

You could connect to you mysql db through odbc.

--
http://home.mysth.be/~timvw