Hi Ken,
Thanks for reply.
Here is what that custom file do:
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<?php
// The number of lines in front of config file determine the // hierarchy of files.
require_once('config.php');
$PAGE->set_context(get_system_context());
$PAGE->set_pagelayout('admin');
$PAGE->set_title("Results");
$PAGE->set_heading("Results");
//$PAGE->set_url($CFG->wwwroot.'/blank_page.php');
echo $OUTPUT->header();
// Actual content goes here
$iud = $_POST['student_id'];
$ard=explode(",",$iud);
$id=$ard['0'];
$st_name= $ard['1'];
///////////////////////////////////////////////////////////db
$dbhost = $CFG->dbhost;
$dbname=$CFG->dbname;
$dbuser = $CFG->dbuser;
$dbpass = $CFG->dbpass;
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($dbname);
///////////////////////////////////////////////////////////////////////////////db
$sql = "SELECT id,username
FROM `mdl_user` ";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
$cid=$row['quiz'];
$option .='<option value="'.$row['id'].','.$row['username'].'"> '.$row['username'].'</option>';
$op2.='<option value="'.$row['id'].'"> '.$row['username'].'</option>';
// $option .= "<tr>".get_quiz_name($conn,$row['quiz'],$row['grade'])."<td><a href='".$CFG->wwwroot."/mod/quiz/grade.php?id=".$cid."&userid=".$id."'>Detail Report</a><td></tr>";
//$det_rr.="<iframe width='100%' height='100%' src='".$CFG->wwwroot."/mod/quiz/grade.php?id=".$cid."&userid=".$id."'/>";
// //echo "Tutorial ID :{$row['id']} <br> ".
// //"Title: {$row['username']} <br> ".
// "Author: {$row['tutorial_author']} <br> ".
// "Submission Date : {$row['submission_date']} <br> ".
"--------------------------------<br>";
}
echo '<form id="myform" action="" method="post" class="hide_from_print" >
<h1>Select Student</h1> <select name="student_id">'.$option.'</select> <input class="ajj"value="Get Result" type="submit"></form>';
//echo "Fetched data successfully\n";
echo '<div class="result"></div>';
echo '<form id="form2" action="'.$CFG->wwwroot.'/void_attempt.php" method="get" class="hide_from_print" ><select name="userid">'.$op2.'</select> <input value="Delete Attempt" type="submit"></form>';
echo $OUTPUT->footer();
?>
<script>
$(document).ready(function(){
$( ".ajj" ).click(function(){
var formData = $("#myform").serializeArray();
$.ajax({
url : "<?php echo $CFG->wwwroot;?>/get_marks.php",
type: "POST",
data : formData,
success: function(data, textStatus, jqXHR)
{
$(".result").html(data);
//data - response from server
},
error: function (jqXHR, textStatus, errorThrown)
{
}
});
return false;
});
});
function capture() {
window.print();
}
</script>
<style type="text/css" media="print">
@media print {
/*.header, .hide { visibility: hidden }*/
.hide_from_print{display:none;}
.block_navigation{ visibility: hidden ;}
.block_settings{ visibility: hidden; }
.block_navigation{ display:none;}
.block_settings{ display:none;}
.history{ display:none;}
.comment{ display:none;}
.othernav{ visibility: hidden; }
.othernav{ display:none;}
.editquestion{ display:none; }
body {
font-size: 10px;
line-height: 1.428571429;
}
.outcome {
padding: 0px;
margin-bottom: 0px;
border: 1px solid transparent;
border-radius: 0px;
}
.que .ablock {
margin:1px;
}
.que .qtext {
margin-bottom: 1px;
}
.formulation {
padding: 1px;
margin-bottom: 1px;
}
#page-footer{display:none;}
}</style>
In Moodle 3.4 it looks like:
In Moodle 3.1 it looks like:
