I desperately need assistance in getting this right before Monday and could use anybody's assistance to get this to work. Here is the question I need to answer:

Create a Web site for tracking, documenting, and managing the process of interviewing candidates for professional positions. On the main page, include a form with ?elds for the interviewers name, position, and date of interview. Also include ?elds for entering the candidates name, communication abilities, professional appearance, computer skills, business knowledge, and interviewers comments. Clicking the Submit button should save the data in a MySQL database. Include a link for opening a document that displays each candidates interview information?i?In php with html document.

Here is what I currently have so far:

interview.php

Interviewing Candidates for Professional Positions

Interviewers name:
Position:
Date of interview:
Candidate's Name:
Communication Abilities:
Professionlal Apperance:
Computer Skills:
Business Knowldge:
Interviewers Comment:

candidate.php

$compskills=$_POST['Compskill'];

$dbc=mysqli_connect("localhost","root","AidanCT11", "interview") or die("mysql_error()"); $que = mysqli_query($connect,"INSERT INTO candidate(iname,pos,dofin,cdname,cabilities,papp,compskill,bkno,icomm) VALUES('".$interviewer_name."','".$position."','".$date_of_interview."','".$candidates_name."','".$communicationab."','".$professionalap."','".$compskills."','".$businessknd."','".$inter_comment."')");

if(mysqli_affected_rows($que) > 0){ echo "

One record Added

"; echo 'Go Back'; } else { echo "No records added
"; echo mysqli_error($connect); } ?> Thank u for submitting the details.The information has been saved.Click here to check the details

demo.php

The webpage comes up perfectly fine and I am able to place in all the information into the text boxes. Below is an image of the main page for the site:

Once I hit the submit button with all the information filled out, I receive the following:

This is also supposed to have a link to open a document with each candidate that has been interviewed. My head is spinning right now and I could really use some help. I am using Wampserver64 to run MySQL and there hasn't been a database created to store the information, other than the one annotated in the code. I could really use some help if someone could please assist me.

ClecelhostPHP.PrctChapter09/Projsctlinterview.ph ntervieringCandidates for Professioaal Pos tions Irteewer s name Position Cundudate's Na Compoter Skills Business Knowldge: aubmi O lvoe here to search