problem inserting data to PHP Database using mysqli Options

[dariusd7]

Don't laugh but I figured out what the problem is. First I want to think you for all your suggestions..As it did help me find other errors and make some correction to my code. But what the problem was.. I needed to actually type the URL in for the HTML page.. when I did that and entered the data, click submit..the data got inserted into the database and the PHP code did not show up in the browser window.. What I was doing was while I was in Notepad++ i would go to run and click on chrome.. or I would go into the Htdoc file and click on the html page there.. neither of those ways worked..but when I typed in the url..it worked..

[Brian Chandler]

Your description is not 100% clear, but it sound like exactly what you would expect. If you just load a php file into your *browser*, obviously you will see the php file, which is a program. If you want to *run* the php program, normally you use a web *server* (either remote, or on your own machine) to run the php program, and send the output to a browser.

[CharlesEF]

You should also consider some validation messages to the user. This test (mis-spellings need correction):

CODE

  if(isset($_POST['first_name'], $_POST['lats_name'],$_POST['student_id'],$_POST['email'],
            $_POST['major'],$_POST['examName'],$_POST['taken_class'],$_POST['className'],
            $_POST['prepare'],$_POST['measureUpKey'],$_POST['examDate']))

will prevent a submit if any required field is blank but it doesn't tell the user anything. The user will just click submit and nothing will happen and they won't know why. You should not depend on javascript validation because users can turn it off. You should also sanitize the user input and escape it using mysqli_real_escape_string before posting it into the database (to help guard against SQL injection attacks).