bnmbnmbnmnbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbn

]nbmbmbnmbnmbnmnbnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn bnmbnmbnmnbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbn

<?php

require_once("../config.php");

require_once("function-file.php");

require_once("function-menu.php");

cookiecheck();

if((!empty($_GET['action']))&&($_GET['action']=='delete')){

$que_id=$_GET['id'];

$conn->exec("delete from test_papers where id='$que_id'");

header("location:test-papers-essay.php");

}?>

<!DOCTYPE html>

<html>

<head>

<title>Test Papers</title>

<?php  cssfile();datatablecss();?>

</head>

<?php headermenu();?>

<h3 class="box-title">Test Papers</h3>

<a href="test-papers-essay-insert.php" class="btn btn-primary btn-sm" ><i class="fa fa-plus"></i> Add New Question</a>

</div>

<thead><tr><th>Question</th><th>Chapter</th><th>Subject</th><th>Course Name</th><th>Year</th><th>Action</th></tr></thead>

<tfoot><tr><th>Question</th><th>Chapter</th><th>Subject</th><th>Course Name</th><th>Year</th><th>Action</th></tr></tfoot>

<tbody>

<?php  /*$data=$conn->prepare("select * from test_papers t 
                    inner join courses c on c.course_id=t.course_id
                    inner join subjects s on s.subject_id=t.subject_id
                    inner join chapters c2 on c2.chapter_id=t.chapter_id
                    ");*/
                    $data=$conn->prepare("select * from test_papers t 
                    inner join courses c on c.course_id=t.course_id
                    WHERE t.question_type = 2
                    ");

$data->execute();$result=$data->fetchall();$i=1;

foreach($result as $row){

echo "<tr>";

echo "<td>".substr(strip_tags($row['question']),0,40)."</td>";

echo "<td>".substr(strip_tags($row['chapter']),0,40)."</td>";

echo "<td>".substr(strip_tags($row['subject']),0,40)."</td>";

echo "<td>".substr(strip_tags($row['course_name']),0,40)."</td>";

echo "<td>".strip_tags($row['year'])."</td>";

// echo "<td><a class='btn btn-info btn-xs'>Edit</a>&nbsp;&nbsp;<a class='btn btn-danger btn-xs'>Delete</a></td>";
						echo "<td><a href='test-papers-essay-edit.php?id=$row[id]' title='Edit Sample' class='btn btn-info btn-xs'>Edit</a>&nbsp;&nbsp;";?><a href='test-papers-essay.php?action=delete&id=<?php echo $row['id'];?>' onclick="return confirm('Are you sure you want to delete?')" title='Delete Sample' class='btn btn-danger btn-xs'>Delete</a></td><?php

echo "</tr>";

$i++;

}

</tbody>

</table>

</div>

</div>

</section>

</div>

</div></div>

<?php footer();?>

</div>

<?php jsfile();datatablejs();?>

$('#data-table').dataTable({

initComplete: function () {
        this.api().columns().every( function () {
            var column = this;
            var select = $('<select><option value=""></option></select>')
                .appendTo( $(column.header()) )
                .on( 'change', function () {
                    var val = $.fn.dataTable.util.escapeRegex(
                        $(this).val()
                    );

column
                        .search( val ? '^'+val+'$' : '', true, false )
                        .draw();
                } );

column.data().unique().sort().each( function ( d, j ) {
                select.append( '<option value="'+d+'">'+d+'</option>' )
            } );
        } );
    },
    
     responsive: true,

"ordering": false,

"dom": 'T<"clear">lfrtip',

"tableTools": {

"sSwfPath": "../apptheme/plugins/datatables/extensions/TableTools/swf/copy_csv_xls_pdf.swf",

"aButtons": [

{

"sExtends": "copy",

"mColumns": [0, 1]

{

"sExtends": "xls",

"mColumns": [0, 1]

{

"sExtends": "pdf",

"mColumns": [0, 1]

]

}

});

</script>

</body>

</html>