Access Database

[dniezby]

Anyone ever tried creating a program that opens a Microsoft Access database, find a record and post it?

If so, how?

As with any database access, I want to be able to add and view records in the database.

[blanius]

You'll need either PHP or ASP on the server to get the data and pass it to the flash.

[dniezby]

I have PHP on my server...
Now what?

[blanius]

Originally posted by dniezby
I have PHP on my server...
Now what?

Well to point a fine point to it uh well you'll have to learn PHP.
I've never accessed an Access db via PHP but I'm pretty sure you can. We always use MySql for our web db's. I'll have to look around for info on Access DB via PHP

Good forums and articles for PHP are at:
http://phpbuilder.com/

Some threads that look on target there:
this first one looks esp good:

http://www.phpbuilder.com/board/show...ghlight=access


http://www.phpbuilder.com/board/show...ghlight=access
http://www.phpbuilder.com/board/show...ghlight=access
http://www.phpbuilder.com/board/show...ghlight=access
http://www.phpbuilder.com/board/show...ghlight=access

The relevant section of the PHP manual regarding ODBC db usage is
http://www.php.net/manual/en/ref.odbc.php

Apparently that is how you handle MS Access DB.

Also looking in my copy of the book "Programming PHP"
Pages 371-373

$handle = odbc_connect(dsn,user,password [,cursor_type]);
$success = odbc_autocommit(handle, status);
$result = odbc_exec(handle, sql);
$col = odbc_fetch_into(result [, rownumber, result_array]);

well it goes on from there, but that may get you started.

From there you buld sql statments and send them to the db via it's handle with odbc_exec

Hope that is helpful. Dave you can contact me directly for more help on this if you need to.

[blanius]

any followup on this? Did you get it to work? If you do care to share?

[dniezby]

Bret,
No, I didn't try. I actually decided to get mySQL activated on my website.
Now, I just need to learn how to get the two to work together.
I've never tried it till now. I still don't really need to know but I'm sure it will allow me to create some cool stuff.

[blanius]

Originally posted by dniezby
Bret,
No, I didn't try. I actually decided to get mySQL activated on my website.
Now, I just need to learn how to get the two to work together.
I've never tried it till now. I still don't really need to know but I'm sure it will allow me to create some cool stuff.

There are a couple of threads on this. The Guestbook uses PHP/MySql and Phil Long used it in his Yahtzee. Anything you learn doing PHP/Mysql will help you, The main thing is sending the data to the load variables function which expects a URL encoded string like this

&var=whatever&var2=something

thats about it.