Code: Select all
<?php
if (isset($_POST['submit_1']))
{
$candidateID = $_GET['candidateID'];
require 'open_db.php';
$resp_1 = filter_input(INPUT_POST, 'resp_1', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
If ($resp_1){
mysql_query("UPDATE prelim_db SET resp_1 = '$resp_1' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_2 = filter_input(INPUT_POST, 'resp_2', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_2)){
mysql_query("UPDATE prelim_db SET resp_2 = '$resp_2' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_3 = filter_input(INPUT_POST, 'resp_3', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_3)){
mysql_query("UPDATE prelim_db SET resp_3 = '$resp_3' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_4 = filter_input(INPUT_POST, 'resp_4', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_4)){
mysql_query("UPDATE prelim_db SET resp_4 = '$resp_4' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_5 = filter_input(INPUT_POST, 'resp_5', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_5)){
mysql_query("UPDATE prelim_db SET resp_5 = '$resp_5' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_6 = filter_input(INPUT_POST, 'resp_6', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_6)){
mysql_query("UPDATE prelim_db SET resp_6 = '$resp_6' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_7 = filter_input(INPUT_POST, 'resp_7', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_7)){
mysql_query("UPDATE prelim_db SET resp_7 = '$resp_7' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_8 = filter_input(INPUT_POST, 'resp_8', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_8)){
mysql_query("UPDATE prelim_db SET resp_8 = '$resp_8' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_9 = filter_input(INPUT_POST, 'resp_9', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_9)){
mysql_query("UPDATE prelim_db SET resp_9 = '$resp_9' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_10 = filter_input(INPUT_POST, 'resp_10', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_10)){
mysql_query("UPDATE prelim_db SET resp_10 = '$resp_10' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_11 = filter_input(INPUT_POST, 'resp_11', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_11)){
mysql_query("UPDATE prelim_db SET resp_11 = '$resp_11' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_12 = filter_input(INPUT_POST, 'resp_12', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_12)){
mysql_query("UPDATE prelim_db SET resp_12 = '$resp_12' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_13 = filter_input(INPUT_POST, 'resp_13', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_13)){
mysql_query("UPDATE prelim_db SET resp_13 = '$resp_13' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_14 = filter_input(INPUT_POST, 'resp_14', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_14)){
mysql_query("UPDATE prelim_db SET resp_14 = '$resp_14' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
$resp_15 = filter_input(INPUT_POST, 'resp_15', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES);
if ($resp_15){
mysql_query("UPDATE prelim_db SET resp_15 = '$resp_15' WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
}
mysql_query("UPDATE prelim_db SET q_count = q_count + 1 WHERE candidateID = '$candidateID'")or die('Query failed: ' . mysql_error());
$prelim_db = mysql_query("SELECT * FROM prelim_db WHERE candidateID = '$candidateID'")
or die(mysql_error());
$row4 = mysql_fetch_array( $prelim_db );
}
mysql_close();
header("Location: ".$row4['interv'].".php?candidateID=$candidateID");
?>Any takers?
Thanks in advance,
Batoe