I am trying to get a grasp of web form data getting passed to PHP, then dumped into a SQL Database (2005).
I have created the form in html. but because the form is an employee application there are a lot of text boxes, radio button, etc etc. I do not want to use that as my starting point to learn the following:
When the user hits submit-outside of the $_Post array what code needs to be put on the PHP form the HTML form submits to?
Does the validation and SQL injection checks get performed here or on the HTML form?
Once the PHP form gets the HTML form data, is there a way to see what was passed?
So I guess what I am asking for is this:
Can someone give me an exaample of say 3 text boxes on a html form-pass it to a PHP form-then dump it into SQL 2005 DB. I have seen a few examples at w3schools and other blogs but for some reason I can not get my head around it. I would like to get this to work, see the data in the DB before I start to do validation and security.
This will be my test environment:
Web server running IIS in DMZ, SQL 2005 on local machine but might want to connect to SQL inside the local network but that I can handle.
I am new to web forms and php. So my understanding is limited but I learn fast so any help is much appreciated.