How i can submit answers based on data retreived from DB?
Posted: Tue Nov 04, 2008 3:57 pm
Hi ...
i'm working project and in this project i have many College student records and each student will login through login page and but each student register in some course based on number of courses i will display survey for each course .
the survey is same 23 questions with 3 answers for each question .
let me explain more what will happened in real
let's assume student is registered in 5 courses and he wants to login into login page (i called form.html) and student will answer on 5 surveys (i called the file that conatain the questions main_login.php) .
what i did it i made a new file (Copy_main_login.php) in the first i checked if student have answer on all surveys or not if he did not the code get into loop ....
Here is Copy_main_login.php
my problem is in the included file (line 26 include_once("main_login.php");)
each student will answer on the questions and he will answer additional time because i can not remove the included file .
is there any cleaver way to do that ? i attach all files in attachment
thanks
i'm working project and in this project i have many College student records and each student will login through login page and but each student register in some course based on number of courses i will display survey for each course .
the survey is same 23 questions with 3 answers for each question .
let me explain more what will happened in real
let's assume student is registered in 5 courses and he wants to login into login page (i called form.html) and student will answer on 5 surveys (i called the file that conatain the questions main_login.php) .
what i did it i made a new file (Copy_main_login.php) in the first i checked if student have answer on all surveys or not if he did not the code get into loop ....
Here is Copy_main_login.php
Code: Select all
<?php
session_start();
require_once('conn.php');
$id = $_SESSION['id'];
$q = "SELECT courses.material_number FROM results_sp_08 INNER JOIN courses ON results_sp_08.material_number = courses.material_number AND results_sp_08.id='$id' AND evalution=0";
$r = mysql_query($q,$conn);
//$_SESSION['count']
$_SESSION['count'] = mysql_num_rows($r);
$material_number = array();
while($row = mysql_fetch_array($r,MYSQLI_ASSOC)){
array_push($material_number,$row['material_number']);
}
if($_SESSION['count'] == 0){
header("location:show_materials.php");
} else if ($_SESSION['count'] > 0 ) {
include_once("main_login.php");
for($i=0;$i < count($material_number); $i++) {
if($_POST['submit']){
//Question 1
if($_POST['q1'][0] == "3"){
$q1_best = 1;
} else {
$q1_best = 0;
}
if($_POST['q1'][0] == "2"){
$q1_med = 1;
} else {
$q1_med = 0;
}
if($_POST['q1'][0] == "1"){
$q1_worse = 1;
} else {
$q1_worse = 0;
}
//Question 2
if($_POST['q2'][0] == "3"){
$q2_best = 1;
} else {
$q2_best = 0;
}
if($_POST['q2'][0] == "2"){
$q2_med = 1;
} else {
$q2_med = 0;
}
if($_POST['q2'][0] == "1"){
$q2_worse = 1;
} else {
$q2_worse = 0;
}
//Question 3
if($_POST['q3'][0] == "3"){
$q3_best = 1;
} else {
$q3_best = 0;
}
if($_POST['q3'][0] == "2"){
$q3_med = 1;
} else {
$q3_med = 0;
}
if($_POST['q3'][0] == "1"){
$q3_worse = 1;
} else {
$q3_worse = 0;
}
//Question 4
if($_POST['q4'][0] == "3"){
$q4_best = 1;
} else {
$q4_best = 0;
}
if($_POST['q4'][0] == "2"){
$q4_med = 1;
} else {
$q4_med = 0;
}
if($_POST['q4'][0] == 1){
$q4_worse = 1;
} else {
$q4_worse = 0;
}
if($_POST['q5'][0] == "3"){
$q5_best = 1;
} else {
$q5_best = 0;
}
if($_POST['q5'][0] == "2"){
$q5_med = 1;
} else {
$q5_med = 0;
}
if($_POST['q5'][0] == 1){
$q5_worse = 1;
} else {
$q5_worse = 0;
}
if($_POST['q6'][0] == "3"){
$q6_best = 1;
} else {
$q6_best = 0;
}
if($_POST['q6'][0] == "2"){
$q6_med = 1;
} else {
$q6_med = 0;
}
if($_POST['q6'][0] == 1){
$q6_worse = 1;
} else {
$q6_worse = 0;
}
if($_POST['q7'][0] == "3"){
$q7_best = 1;
} else {
$q7_best = 0;
}
if($_POST['q7'][0] == "2"){
$q7_med = 1;
} else {
$q7_med = 0;
}
if($_POST['q7'][0] == 1){
$q7_worse = 1;
} else {
$q7_worse = 0;
}
if($_POST['q8'][0] == "3"){
$q8_best = 1;
} else {
$q8_best = 0;
}
if($_POST['q8'][0] == "2"){
$q8_med = 1;
} else {
$q8_med = 0;
}
if($_POST['q8'][0] == 1){
$q8_worse = 1;
} else {
$q8_worse = 0;
}
if($_POST['q9'][0] == "3"){
$q9_best = 1;
} else {
$q9_best = 0;
}
if($_POST['q9'][0] == "2"){
$q9_med = 1;
} else {
$q9_med = 0;
}
if($_POST['q9'][0] == 1){
$q9_worse = 1;
} else {
$q9_worse = 0;
}
if($_POST['q10'][0] == "3"){
$q10_best = 1;
} else {
$q10_best = 0;
}
if($_POST['q10'][0] == "2"){
$q10_med = 1;
} else {
$q10_med = 0;
}
if($_POST['q10'][0] == 1){
$q10_worse = 1;
} else {
$q10_worse = 0;
}
if($_POST['q11'][0] == "3"){
$q11_best = 1;
} else {
$q11_best = 0;
}
if($_POST['q11'][0] == "2"){
$q11_med = 1;
} else {
$q11_med = 0;
}
if($_POST['q11'][0] == 1){
$q11_worse = 1;
} else {
$q11_worse = 0;
}
if($_POST['q12'][0] == "3"){
$q12_best = 1;
} else {
$q12_best = 0;
}
if($_POST['q12'][0] == "2"){
$q12_med = 1;
} else {
$q12_med = 0;
}
if($_POST['q12'][0] == 1){
$q12_worse = 1;
} else {
$q12_worse = 0;
}
if($_POST['q13'][0] == "3"){
$q13_best = 1;
} else {
$q13_best = 0;
}
if($_POST['q13'][0] == "2"){
$q13_med = 1;
} else {
$q13_med = 0;
}
if($_POST['q13'][0] == 1){
$q13_worse = 1;
} else {
$q13_worse = 0;
}
//Question 14
if($_POST['q14'][0] == "3"){
$q14_best = 1;
} else {
$q14_best = 0;
}
if($_POST['q14'][0] == "2"){
$q14_med = 1;
} else {
$q14_med = 0;
}
if($_POST['q14'][0] == 1){
$q14_worse = 1;
} else {
$q14_worse = 0;
}
//Question 15
if($_POST['q15'][0] == "3"){
$q15_best = 1;
} else {
$q15_best = 0;
}
if($_POST['q15'][0] == "2"){
$q15_med = 1;
} else {
$q15_med = 0;
}
if($_POST['q15'][0] == 1){
$q15_worse = 1;
} else {
$q15_worse = 0;
}
//Question 16
if($_POST['q16'][0] == "3"){
$q16_best = 1;
} else {
$q16_best = 0;
}
if($_POST['q16'][0] == "2"){
$q16_med = 1;
} else {
$q16_med = 0;
}
if($_POST['q16'][0] == 1){
$q16_worse = 1;
} else {
$q16_worse = 0;
}
//Question 17
if($_POST['q17'][0] == "3"){
$q17_best = 1;
} else {
$q17_best = 0;
}
if($_POST['q17'][0] == "2"){
$q17_med = 1;
} else {
$q17_med = 0;
}
if($_POST['q17'][0] == 1){
$q17_worse = 1;
} else {
$q17_worse = 0;
}
//Question 18
if($_POST['q18'][0] == "3"){
$q18_best = 1;
} else {
$q18_best = 0;
}
if($_POST['q18'][0] == "2"){
$q18_med = 1;
} else {
$q18_med = 0;
}
if($_POST['q18'][0] == 1){
$q18_worse = 1;
} else {
$q18_worse = 0;
}
//Question 19
if($_POST['q19'][0] == "3"){
$q19_best = 1;
} else {
$q19_best = 0;
}
if($_POST['q19'][0] == "2"){
$q19_med = 1;
} else {
$q19_med = 0;
}
if($_POST['q19'][0] == 1){
$q19_worse = 1;
} else {
$q19_worse = 0;
}
//Question 20
if($_POST['q20'][0] == "3"){
$q20_best = 1;
} else {
$q20_best = 0;
}
if($_POST['q20'][0] == "2"){
$q20_med = 1;
} else {
$q20_med = 0;
}
if($_POST['q20'][0] == 1){
$q20_worse = 1;
} else {
$q20_worse = 0;
}
//Question 21
if($_POST['q21'][0] == "3"){
$q21_best = 1;
} else {
$q21_best = 0;
}
if($_POST['q21'][0] == "2"){
$q21_med = 1;
} else {
$q21_med = 0;
}
if($_POST['q21'][0] == 1){
$q21_worse = 1;
} else {
$q21_worse = 0;
}
//Question 22
if($_POST['q22'][0] == "3"){
$q22_best = 1;
} else {
$q22_best = 0;
}
if($_POST['q22'][0] == "2"){
$q22_med = 1;
} else {
$q22_med = 0;
}
if($_POST['q22'][0] == 1){
$q22_worse = 1;
} else {
$q22_worse = 0;
}
//Question 23
if($_POST['q23'][0] == "3"){
$q23_best = 1;
} else {
$q23_best = 0;
}
if($_POST['q23'][0] == "2"){
$q23_med = 1;
} else {
$q23_med = 0;
}
if($_POST['q23'][0] == 1){
$q23_worse = 1;
} else {
$q23_worse = 0;
}
//Question 24
if($_POST['q24'][0] == "3"){
$q24_best = 1;
} else {
$q24_best = 0;
}
if($_POST['q24'][0] == "2"){
$q24_med = 1;
} else {
$q24_med = 0;
}
if($_POST['q24'][0] == 1){
$q24_worse = 1;
} else {
$q24_worse = 0;
}
$q = "UPDATE evaluation SET
q1_best=q1_best+'$q1_best' , q1_med=q1_med +'$q1_med' , q1_worse=q1_worse +'$q1_worse'
,q2_best=q2_best +'$q2_best' , q2_med=q2_med +'$q2_med' , q2_worse =q2_worse +'$q2_worse'
,q3_best = q3_best +'$q3_best' , q3_med=q3_med +'$q3_med' , q3_worse=q3_worse +'$q3_worse'
,q4_best = q4_best +'$q4_best', q4_med=q4_med +'$q4_med' , q4_worse=q4_worse +'$q4_worse'
,q5_best=q5_best +'$q5_best' , q5_med=q5_med +'$q5_med' , q5_worse=q5_worse +'$q5_worse'
,q6_best=q6_best +'$q6_best' , q6_med=q6_med +'$q6_med' , q6_worse=q6_worse +'$q6_worse'
,q7_best=q7_best +'$q7_best' , q7_med=q7_med +'$q7_med' , q7_worse=q7_worse +'$q7_worse'
,q8_best= q8_best+'$q8_best' , q8_med=q8_med +'$q8_med' , q8_worse=q8_worse +'$q8_worse'
,q9_best= q9_best+'$q9_best' , q9_med=q9_med +'$q9_med' , q9_worse=q9_worse +'$q9_worse'
,q10_best= q10_best+'$q10_best' , q10_med=q10_med +'$q10_med', q10_worse=q10_worse +'$q10_worse'
,q11_best= q11_best+'$q11_best' , q11_med=q11_med +'$q11_med', q11_worse=q11_worse +'$q11_worse'
,q12_best= q12_best+'$q12_best' , q12_med=q12_med +'$q12_med', q12_worse=q12_worse +'$q12_worse'
,q13_best= q13_best+'$q13_best' , q13_med=q13_med +'$q13_med', q13_worse=q13_worse +'$q13_worse'
,q14_best= q14_best+'$q14_best' , q14_med=q14_med +'$q14_med', q14_worse=q14_worse +'$q14_worse'
,q15_best= q15_best+'$q15_best' , q15_med=q15_med +'$q15_med', q15_worse=q15_worse +'$q15_worse'
,q16_best= q16_best+'$q16_best' , q16_med=q16_med +'$q16_med', q16_worse=q16_worse +'$q16_worse'
,q17_best= q17_best+'$q17_best' , q17_med=q17_med +'$q17_med', q17_worse=q17_worse +'$q17_worse'
,q18_best= q18_best+'$q18_best' , q18_med=q18_med +'$q18_med', q18_worse=q18_worse +'$q18_worse'
,q19_best= q19_best+'$q19_best' , q19_med=q19_med +'$q19_med', q19_worse=q19_worse +'$q19_worse'
,q20_best= q20_best+'$q20_best' , q20_med=q20_med +'$q20_med', q20_worse=q20_worse +'$q20_worse'
,q21_best= q21_best+'$q21_best' , q21_med=q21_med +'$q21_med', q21_worse=q21_worse +'$q21_worse'
,q22_best= q22_best+'$q22_best' , q22_med=q22_med +'$q21_med', q22_worse=q22_worse +'$q22_worse'
,q23_best= q23_best+'$q23_best' , q23_med=q23_med +'$q23_med', q23_worse=q23_worse +'$q23_worse'
,q24_best= q24_best+'$q24_best' , q24_med=q24_med +'$q24_med', q24_worse=q24_worse +'$q24_worse' WHERE material_number='$material_number[$i]'";
$r = mysql_query($q,$conn);
$_POST['submit']= false;
$q = "UPDATE results_sp_08 SET evalution = 1 WHERE material_number='$material_number[$i]'";
$r = mysql_query($q,$conn);
$material_number = array_shift($material_number);
print_r($material_number);
--$_SESSION['count'];
echo count($material_number)."<br />";
echo $_SESSION['count']."<br />";
} // End of if($_POST['submit'])
} // End of loop
}
$_SESSION['count'] = 0;
?>
my problem is in the included file (line 26 include_once("main_login.php");)
each student will answer on the questions and he will answer additional time because i can not remove the included file .
is there any cleaver way to do that ? i attach all files in attachment
thanks