connect_error){
die("Connection failed: ".$mysqli->connect_error);
}
$sql = "SELECT COUNT(*) AS numbq FROM poll";
$resultrand = $mysqli->query($sql);
$data = $resultrand->fetch_row();
echo "There are $data[0] questions.
";
if($resultrand) {
session_start(); // start the session
if(isset($_SESSION['random'])) {
$pollq = $_SESSION['random'];
} else {
$pollq = mt_rand(1,intval($data[0]));
$_SESSION['random'] = $pollq;
}
}
else
{
echo "Error querying table: ".$mysqli->error;
}
$sql = "SELECT * FROM poll WHERE pollid = ".intval($pollq);
$resultquest = $mysqli->query($sql);
if($resultquest) {
while($row = $resultquest->fetch_row()){
$quest = $row[1];
$a1 = $row[2];
$a2 = $row[3];
$a3 = $row[4];
}
}
else
{
echo "Error querying table: ".$mysqli->error;
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$pollchoice = $_POST["Question"];
if ($pollchoice == "0"){
$sql = "UPDATE poll SET total1 = total1+1 WHERE pollid=".intval($pollq);
$resultchoice = $mysqli->query($sql);
}
elseif ($pollchoice == "1"){
$sql = "UPDATE poll SET total2 = total2+1 WHERE pollid=".intval($pollq);
$resultchoice = $mysqli->query($sql);
}
elseif ($pollchoice == "2"){
$sql = "UPDATE poll SET total3 = total3+1 WHERE pollid=".intval($pollq);
$resultchoice = $mysqli->query($sql);
}
$mysqli->close();
header("Location: results.php");
}
?>