newbie

[Pam]

just found this newsgroup - I hope someone here can help me figure out the
best place to go to get this all straight in my head.

I have a site that I've designed that the customer now wants a database
inserted that will allow members to log into the record section with a
password, and then be able to type in the horse's name that they are looking
for and pull up various information on the horse - wins, total points, shows
...... ect....

I have Access 2002- my server supports php/MySQL - can someone give me an
idea of how to design this or where I can go to get a good handle on it?


thanks a bunch!

Pam

 

[Ben]

Pam-
Not to scare you, but that's a pretty big question, and I'm not sure you'll
get a lot of help from the Access newsgroups, or even Access. At the same
time, I may have misunderstood the question, so I'll try to clarify what I
got out of it.
1) You're working with a webserver that supports PHP and MySQL. Neither are
MS products, so you might get a few hits here with people who have worked
with them, but you won't get much.
2) Access the only database you're really familiar with. In this situation,
Access will probably only help you look at data and enter dummy test data.
Please correct me if I'm wrong on these assuptions. Anyway, on to something
(hopefully) helpful.

The steps you'll need to go through are essentially the same no matter what
technology you are using, but the implementation can be wildly different.
1) Authenticate and authorize the user. The username & password will
probably be stored in a DB table.
2) Based on step 1, redirect the user to an appropriate page.
3) If the user is authorized, provide an interface for the data selection
criteria.
4) Execute a query against the database, and display it in HTML to the user.

So, basically, you'll have to learn how to use PHP to process the HTTP POST
from the web form to the MySQL server and the how to use PHP to process the
data from MySQL to TTP and back to the client.

I hope this helps a little bit, good luck.
Ben

 

[Pam]

Thanks Ben for trying to help me out - I may be in way over my head here
(probably am) but figured it must be time to learn something new

you pretty much got the picture and your steps at least make sense to me -
now my question is - do you know of a good site that will walk me thru the
process you described: "learn how to use PHP to process the HTTP POST from
the web form to the MySQL server and the how to use PHP to process the data
from MySQL to TTP and back to the client." ??

thanks for your help!

Pam