PHP, how to do this?
 

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!

Re: PHP, how to do this?
 

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

all the best

Re: PHP, how to do this?
 

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.

Re: PHP, how to do this?
 

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