<?php
$q= $_REQUEST["q"];
$r = $_REQUEST["r"];
$s = $_SESSION['empid'];
$max = 0;
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = '';
$dbname = 'employeesurvey';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$sql1 = "SELECT QuestionID FROM question";
if(!mysqli_query($conn,$sql1)){
    echo 'error2 php';
}
while($rw1 = mysqli_fetch_array($sql1)){
   $Q = $rw1['QuestionID'] ;
   if ($max<$Q){
       $max = $Q;
   }
}
$Q = $Q+1;
$sql = "INSERT INTO question VALUES (".$Q.",'".$r."',".$s.",CURRENT_DATE(),".$q.",0)";
if(!mysqli_query($conn,$sql)){
   echo "Error";
}

xmlhttp = new XMLHttpRequest();
xmlhttp.open("GET", "gethint1.php?q=" + cid + "&r=" + question, true);

if(!mysqli_query($conn,$sql1)){

$resultSet = mysqli_query($conn,$sql1);
if(!$resultSet){

while($rw1 = mysqli_fetch_array($sql1)){

while($rw1 = mysqli_fetch_array($resultSet)){