MAINHACK

Viewing / Editing File: all_answers.php

<?php

ob_start();
session_start();
include('database.php');
include('header.php');
?>
	<link href="src/facebox.css" media="screen" rel="stylesheet" type="text/css" />
<script src="src/facebox.js" type="text/javascript"></script>
  <script type="text/javascript">
	jQuery(document).ready(function($) {
	  $('a[rel*=facebox]').facebox({
		loadingImage : 'src/loading.gif',
		closeImage   : 'src/closelabel.png'
	  })
	})
	
	function send(){
		
		if(window.confirm("Do You Really Want To Delete The Answer??")){
			
			return true;
		}
		else return false;
		
		
	}
  </script>

<div id="page-wrapper">
			<div class="main-page">
				
					<div class="tables">
					
						<h3 class="title1">All Exams</h3>
					<div class="panel-body widget-shadow">
			
	
			<table class="table" id='example'>
							<thead>
								<tr>  
								  <th>Sl</th>
								  <th>paper Id</th>
								   <th>paper NO</th>
									<th>User ID</th> 
									 <th>Student Name/Email/Phone</th>
								    <th>Date of Setting</th>
								    <th>Date of Exam</th>	 
								    <th>Total Marks</th>
								    <th>Status</th>
								<th>Delete</th>
								</tr>
							</thead>
							<tbody>

<?php
$count=1;
$sq="SELECT * from exam group by user_id order by id desc";
$r=mysqli_query($con,$sq) or die(mysqli_error($con));
while($row=mysqli_fetch_array($r)){
      $p=$row['paper_no']; 
       $exam_id=$row['exam_id']; 
$paper='PAPER'.$p;

$sq1="select sum(marks) as marks,count(paper_no) as p from exam_score where paper_no='".$paper."' and exam_id='".$exam_id."'";
        $r1=mysqli_query($con,$sq1);
       
        $c=mysqli_num_rows($r);
        $row1=mysqli_fetch_array($r1);
        $marks=$row1['marks'];
        $p1=$row['p'];
          if($marks>=6){ $exam_status='<font color="green">PASS</font>';}else{$exam_status='<font color="red">FAIL</font>';}
	//$status=$row['status'];
	echo "<tr>
								  <td>$count</td>
								  <td>".$row['paper_id']."</td>
								   <td>".$row['paper_no']."</td>
	                              <td>".$row['user_id']."</td>
	                               <td>".$row['name']."<br>".$row['email']."<br>".$row['phone']."</td>
                                    <td>".date('d-m-Y',strtotime($row['date_of_setting_question']))."</td>
                                <td>".date('d-m-Y',strtotime($row['date_of_exam']))."</td>
                                     <td>".$marks."</td>
                                     <td>".$exam_status."</td>
								<td>  <a href='delete_ans.php?id=".$row['id']."' class='label label-danger' onclick='return send();'>Delete</a>
								 </td>
								</tr>";

++$count;
								}

?>							
								</tbody></table>
					</div></div>
			</div>
		</div>
		
		<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all_answers.php

Server Info

System Features

User Info