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 fields for the interviewer’s name, position, and date of interview. Also include fields for entering the candidate’s name, communication abilities, computer skills, business knowledge, and interviewer’s comments. Clicking the Submit button should save the data in a MySQL database. Include a link for opening a document that displays each candidate’s interview information.

What will be an ideal response?

Answer: According to the given data the following code follows,i.e.,

CODE:

interview.html

interview program

Interviewing Candidates for Professional Positions

candidate.php
$interviewer_name=$_POST['iname'];
$position=$_POST['pos'];
$date_of_interview=$_POST['dofin'];
$candidates_name=$_POST['cdname'];
$communicationab=$_POST['cabilities'];
$professionalap=$_POST['papp'];
$compskills=$_POST['compskill'];
$businessknd=$_POST['bkno'];
$inter_comment=$_POST['icomm'];

$dbc=mysql_connect("localhost","root","") or die("mysql_error()");
mysql_select_db("regisdb")or die("mysql_error()");
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_co

mment')");

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

One record Added

";
echo "Go Back";
} else {
echo "No records added
";
echo mysqli_error ($connect);
}
?>
Details

Thank u for submitting the details.The information has been saved.Click here to check the details

demo.php

information

$interviewer_name=$_POST['iname'];
$position=$_POST['pos'];
$date_of_interview=$_POST['dofin'];
$candidates_name=$_POST['cdname'];
$communicationab=$_POST['cabilities'];
$professionalap=$_POST['papp'];
$compskills=$_POST['compskill'];
$businessknd=$_POST['bkno'];
$inter_comment=$_POST['icomm'];
$dbc=mysql_connect("localhost","root","") or die("mysql_error()");
mysql_select_db("regisdb")or die("mysql_error()");
$query=mysql_query("select * from candidate");
$numrows=mysql_num_rows($query);
if($numrows!=0)
{
while ($line = mysql_fetch_array($numrows, MYSQL_ASSOC)) {
echo $line['iname'];
echo $line['pos'];
echo $line['dofin'];
echo $line['cdname'];
echo $line['cabilities'];
echo $line['papp'];
echo $line['compskill'];
echo $line['bkno'];
echo $line['icomm'];
echo "
\n";
;
}

Therefore by using the above data we can go through our requirement