bulio

Hi everyone,

For my company, I need to create a PHP site which does the following:

1. Allow a user to enter warranty information in a form (ex. part number, cost, make, etc.)
2. E-Mail the form to a person
3. Store the form information in a MySQL database
4. Allow people to view the form information contained in the database

My PHP is a little rusty, so I'm just wondering how I would do this. I assume I create a regular PHP form, and then somehow store the forms in a MySQL database.

My question is how do I store this information in the database, and create a web frontend for people to view the entered information? I know how to send the e-mail, thats no problem, its just the MySQL part that is getting me confused.

Thanks!

Fatima

http://www.w3schools.com/php/php_mysql_insert.asp
http://www.w3schools.com/php/php_mysql_select.asp

all the best

MiKuS

you would also send mails with the php mail() function.

We wont write code for you, but will push you in the right direction.
Here is a step by step process to doing what you want:
1. Create a form in html to accept the information you'll need
2. Once the form has been submitted run a function which will email the results to a specified person(s)
3. Insert the information into a database
4. Make a page which pulls hte information out of the database and displays it.

In between these steps there will be more smaller steps - see if you can figure them out.

FERDIKUCUK

http://www.programlamadili.net/PHP/
All in one