- Beranda
- Komunitas
- Tech
- Programmer Forum
Help php letak querry sql
TS
bbsnafw
Help php letak querry sql
Permisi mod dan kaskuser programmer forum ijin post thread, kalau tidak berkenan boleh dihapus 
Ane sedang mengedit lms yang open source nah, ane kesulitan untuk meletakkan query ini :
ke source code ini :
jadi ketika Button NEXT QUESTION diklik bisa mentrigger sql saya diatas, sampai sekarang udah beberapa hari nggak berhasil gan
Sekiranya agan disini bisa bantu, kalau kurang jelas maksudnya mohon juga komen gan
Ane sedang mengedit lms yang open source nah, ane kesulitan untuk meletakkan query ini :
Code:
[php]if(isset($_POST['next_b'])) {
$student_ans = $_POST['student_ans'];
mysql_query("insert into student_question_answer (student_id,class_quiz_id,quiz_question_id,answer_question) values ('$session_id','$class_quiz_id','".$roww['quiz_question_id']."','$student_ans')")or die(mysql_error());
}[/php]ke source code ini :
Spoiler for Soucer code full:
Code:
<?php include('header_dashboard.php'); ?>
<?php include('session.php'); ?>
<?php $get_id = $_GET['id']; ?>
<?php $class_quiz_id = $_GET['class_quiz_id']; ?>
<?php $quiz_id = $_GET['quiz_id']; ?>
<?php $quiz_time = $_GET['quiz_time']; ?>
<?php $query1 = mysql_query("select * from student_class_quiz where student_id = '$session_id' and class_quiz_id = '$class_quiz_id' ")or die(mysql_error());
$count = mysql_num_rows($query1);
?>
<?php
if ($count > 0){
}else{
mysql_query("insert into student_class_quiz (class_quiz_id,student_id,student_quiz_time) values('$class_quiz_id','$session_id','$quiz_time')");
}
?>
<body>
<?php include('navbar_student.php'); ?>
<div class="container-fluid">
<div class="row-fluid">
<?php include('student_quiz_link.php'); ?>
<div class="span9" id="content">
<div class="row-fluid">
<!-- breadcrumb -->
<?php $class_query = mysql_query("select * from teacher_class
LEFT JOIN class ON class.class_id = teacher_class.class_id
LEFT JOIN subject ON subject.subject_id = teacher_class.subject_id
where teacher_class_id = '$get_id'")or die(mysql_error());
$class_row = mysql_fetch_array($class_query);
$class_id = $class_row['class_id'];
$school_year = $class_row['school_year'];
?>
<ul class="breadcrumb">
<li><a href="#"><?php echo $class_row['class_name']; ?></a> <span class="divider">/</span></li>
<li><a href="#"><?php echo $class_row['subject_code']; ?></a> <span class="divider">/</span></li>
<li><a href="#">School Year: <?php echo $class_row['school_year']; ?></a> <span class="divider">/</span></li>
<li><a href="#"><b>Practice Quiz</b></a></li>
</ul>
<!-- end breadcrumb -->
<!-- block -->
<div id="block_bg" class="block">
<div class="navbar navbar-inner block-header">
<?php
if($_GET['test'] == 'ok'){
/* $sqlp = mysql_query("SELECT * FROM groupcode WHERE course_code = '".$row['course_code']."'"); */
$sqlp = mysql_query("SELECT * FROM class_quiz WHERE class_quiz_id = '$class_quiz_id'")or die(mysql_error());
$rowp = mysql_fetch_array($sqlp);
/* mysql_query("UPDATE students SET `time-left` = ".$rowp['time']." WHERE stud_id = '".$_SESSION['user_id']."'"); */
/* echo $rowp['time']; */
$x=0;
?>
[removed]
jQuery(document).ready(function(){
var timer = 1;
jQuery(".questions-table input").hide();
setInterval(function(){
var timer = jQuery("#timer").text();
jQuery("#timer").load("timer.ajax.php");
if(timer == 0){
jQuery(".questions-table input").hide();
jQuery("#submit-test").show();
jQuery("#msg").text("Time's up!!!\nPlease Submit your Answers");
} else {
jQuery(".questions-table input").show();
}
},990);
});
[removed]
<form action="take_test.php<?php echo '?id='.$get_id; ?>&<?php echo 'class_quiz_id='.$class_quiz_id; ?>&<?php echo 'test=done' ?>&<?php echo 'quiz_id='.$quiz_id; ?>&<?php echo 'quiz_time='.$quiz_time; ?>" name="testform" method="POST" id="test-form">
<?php
$sqla = mysql_query("select * FROM class_quiz
LEFT JOIN quiz ON quiz.quiz_id = class_quiz.quiz_id
where teacher_class_id = '$get_id'
order by date_added DESC ")or die(mysql_error());
/* $row = mysql_fetch_array($sqla); */
$rowa = mysql_fetch_array($sqla);
/* $rowa = $row['quiz_id']; */
/* $sqla = mysql_query("SELECT * FROM class_quiz WHERE course_code = '".$row['course_code']."'"); */
?>
<h3>Test Title: <b><?php echo $rowa['quiz_title'];?></b></h3>
<p><b>Description:<?php echo $rowa['quiz_description'];?></b></p>
<p></p>
Time Remaining:<div id="timer">1</div>
<div id="msg"></div>
[removed]
jQuery(document).ready(function(){
jQuery(".questions").each(function(){
jQuery(this).hide();
});
jQuery("#q_1").show();
});
[removed]
[removed]
jQuery(document).ready(function(){
var nq = 0;
var qn = 0;
jQuery(".nextq").click(function(){
qn = jQuery(this).attr('qn');
nq = parseInt(qn) + 1;
jQuery('#q_' + qn ).fadeOut();
jQuery('#q_' + nq ).show();
});
});
[removed]
<table class="questions-table table">
<tr>
<th>#</th>
<th>Question</th>
</tr>
<?php
$sqlw = mysql_query("SELECT * FROM quiz_question where quiz_id = '$quiz_id' ORDER BY RAND()");
$qt = mysql_num_rows($sqlw);
while($roww = mysql_fetch_array($sqlw)){
?>
<tr id="q_<?php echo $x=$x+1;?>" class="questions">
<td width="30" id="qa"><?php echo $x;?></td>
<td id="qa">
<?php echo $roww['question_text'];?>
<br>
<hr>
<?php
if ($roww['question_type_id']=='3'){
// $sqle = mysql_query("SELECT answer FROM quiz_question where quiz_id = '$quiz_id' and quiz_question_id = '".$roww['quiz_question_id']."'");
// $kuis_id = mysql_fetch_row($sqle);
?> <form method="post">
<TextArea name="student_ans"></TextArea>
<!-- <input type="hidden" name="key_ans" value="<?php echo $kuis_id[0]; ?>">
<input type="hidden" name="class_qid" value="<?php echo $class_quiz_id; ?>">
<input type="hidden" name="student_id" value="<?php echo $session_id; ?>"> -->
<!-- <input type="submit" name="submit" value="Cek"> -->
</form>
<?php
} else if($roww['question_type_id']=='2'){
?>
<input name="q-<?php echo $roww['quiz_question_id'];?>" value="True" type="radio"> True | <input name="q-<?php echo $roww['quiz_question_id'];?>" value="False" type="radio"> False
<?php
} else if($roww['question_type_id']=='1') {
$sqly = mysql_query("SELECT * FROM answer WHERE quiz_question_id = '".$roww['quiz_question_id']."'");
while($rowy = mysql_fetch_array($sqly)){
if($rowy['choices'] == 'A') {
?>
A.)<input name="q-<?php echo $roww['quiz_question_id'];?>" value="A" type="radio"> <?php echo $rowy['answer_text'];?><br /><br />
<?php } else if ($rowy['choices'] == 'B') {?>
B.) <input name="q-<?php echo $roww['quiz_question_id'];?>" value="B" type="radio"> <?php echo $rowy['answer_text'];?><br /><br />
<?php } else if ($rowy['choices'] == 'C') {?>
C.) <input name="q-<?php echo $roww['quiz_question_id'];?>" value="C" type="radio"> <?php echo $rowy['answer_text'];?><br /><br />
<?php } else if ($rowy['choices'] == 'D') {?>
D.) <input name="q-<?php echo $roww['quiz_question_id'];?>" value="D" type="radio"> <?php echo $rowy['answer_text'];?><br /><br />
<?php
}
}
}
?>
<br/>
<button>NEXT QUESTION <i class="icon-arrow-right"></i></button>
<?php
if(isset($_POST['next_b'])) {
$student_ans = $_POST['student_ans'];
mysql_query($sqlerror="insert into student_question_answer (student_id,class_quiz_id,quiz_question_id,answer_question) values ('$session_id','$class_quiz_id','".$roww['quiz_question_id']."','$student_ans')")or die("$sqlerror<br>".mysql_error());
echo "[removed]alert('$sqlerror');[removed]";
}
?>
<input type="hidden" name="x-<?php echo $x;?>" value="<?php echo $roww['quiz_question_id'];?>"
</td>
</tr>
<?php
}
?>
<tr>
<td></td>
<td>
<button class="btn btn-info" id="submit-test" name="submit_answer"><i class="icon-check"></i> Submit Answer</button>
<!-- <input type="submit" value="Submit My Answers" class="btn btn-info" id="submit-test" name="submit_answer"><br /> -->
</td>
</tr>
</table>
<input type="hidden" name="x" value="<?php echo $x;?>">
</form>
<?php
} else if(isset($_POST['submit_answer'])){
$x1 = $_POST['x'];
$score = 0;
for($x=1;$x<=$x1;$x++){
$x2 = $_POST["x-$x"];
$q = $_POST["q-$x2"];
$sql = mysql_query("SELECT * FROM quiz_question WHERE quiz_question_id = ".$x2."");
$row = mysql_fetch_array($sql);
if($row['answer'] == $q) {
$score= $score + 1;
}
} ?>
<a href="student_quiz_list.php<?php echo '?id='.$get_id; ?>"><i class="icon-arrow-left"></i> Back</a>
<center>
<h3><br>Your score is <b><?php echo $score; ?></b> out of <b><?php echo ($x-1); ?></b><br/></h3>
</center>
<?php
/* echo "Your Percentage Grade is : <b>".$per."%</b>"; */
mysql_query("UPDATE student_class_quiz SET `student_quiz_time` = 3600, `grade` = '".$score." out of ".($x-1)."' WHERE student_id = '$session_id' and class_quiz_id = '$class_quiz_id'")or die(mysql_error());
?>
[removed]
[removed] = 'student_quiz_list.php<?php echo '?id='.$get_id; ?>';
[removed]
<?php
} /* else { */
?>
<br />
<?php
/* $sql = mysql_query("SELECT * FROM students WHERE stud_id = '".$_SESSION['user_id']."'");
$row = mysql_fetch_array($sql);
if(is_null($row['grade']) AND $row['time-left'] == 3600){ */
?>
<!-- <a href="?test=ok">Take the test now</a> -->
<?php
/* } else if(is_null($row['grade']) AND $row['time-left'] < 3600 AND $row['time-left'] > 0){ */
?>
<!-- <a href="?test=ok">Continue your test</a> -->
<?php
/* } else if(!is_null($row['grade'])){
$sqlg = mysql_query("SELECT * FROM groupcode WHERE course_code = '".$row['course_code']."'");
$rowg = mysql_fetch_array($sqlg);
echo "You have already taken <b>".$rowg['course_title']."</b> - <b>".$rowg['course_code']."</b> test.";
}
if($row['grade']!=''){
mysql_query("UPDATE students SET `time-left` = 3600 WHERE stud_id = '".$_SESSION['user_id']."'");
echo "<br />Your Grade for this Test is : <b>".$row['grade']."</b>";
}
} */
?>
</div>
<div class="block-content collapse in">
<div class="span12">
</div>
</div>
</div>
<!-- /block -->
</div>
</div>
</div>
<?php include('footer.php'); ?>
</div>
<?php include('script.php'); ?>
</body>
</html>
jadi ketika Button NEXT QUESTION diklik bisa mentrigger sql saya diatas, sampai sekarang udah beberapa hari nggak berhasil gan
Sekiranya agan disini bisa bantu, kalau kurang jelas maksudnya mohon juga komen gan
0
793
Kutip
0
Balasan
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan