MySQL and PHP interface

[george123456724]

Hi,

I have a MySql database running with a list of all my work engagements. At the moment, I am the only person who can use it, but I want to be able to use it on my business website.

I want my customers to fill in their enquiry date on a simple text field on a form, click 'submit', and for a script (my server supports PHP, but not ASP) to check the date field on the database and return either 'available' or 'currently has an enquiry' for the date.

As I have no knowledge of PHP, I want to find a fairly simple solution if possible!

Will I have to write the script myself, or will a suitable one be on a script archive somewhere?

Also, can I embed the password for the database inside the PHP script, so my users cannot access the *whole* database?!!!

Thanks,

George

 

[DumTech]

I don't know if you'll find a script to do just what you're looking for, but some groupware scripts at sourceforge might be adaptable.

Wouldn't be that difficult from scratch though, if you just want to check a date. That amounts to adding a form to your page and a few lines of PHP code to do the query and compare the dates.

Matt
matt@paperlove.org
If I can help, I will.