[arya054]

Hey guys, I've been stuck in a small project I volunteered for. I'am trying to create a website that allows users to input information & update it as needed.

Let me explain myself. We work at a small insurance office, and we got too many papers going around. I saw once a business that had something like it.

I want to know if it is possible to integrate php into HTML layouts and connect it to MYSQL.

Kind of like a forum. We want to be able to:

Login to the website (has to be password protected)

- input customers name (text area)
- input Customer last name (text area)

-choose marital status (drop down menu)
-Choose Car (drop down menu)
-Choose year (drop down menu)

- Input notes (text box)

- Be able to Search for records, display entered information and also to be able to update/edit the information as needed

Got any suggestions? looks kind of complicated to me, but perhaps some of you may point me to any good tutorials or apps that allow me to get there faster. Sorry if this has been already addressed somewhere on these forums. I wasn't able to find any content like it. Please forgive my lack of knowledge

Thanks for reading.

[hilda_mateiu]

I don't have the time to write the code for you but php can easily be integrated into HTML but you have to change the file extension from .html to .php for it to work. The html will still work fine with the .php extension. The .php extension simply tells the program to expect some php code somewhere in the script. To use php in your html code use the <?php and ?> opening and closing tags to indicate to the program where the php code starts and where it ends.

You would have to set up a MySQL database and add a table with the fields that you need to hold the information from your form. Use $_POST to get the info from the form.

Since you will be storing the username and password in the database you should have your script encrypt the password before adding it to the database. You could use MD5 encryption.

For really good tutorials and PHP syntax guides try www w3schools com
Note that I left the dots out of the w3schools com address. I'm not sure that they like links posted here.

Good Luck