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['que_id'];

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

header("location:questions.php");

}

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

$que_id=$_GET['que_id'];

$conn->exec("Update question set approve='1' where que_id='$que_id'");

header("location:questions.php");

}

<!DOCTYPE html>

<html>

<head>

<title>Questions</title>

<?php  cssfile();?>

</head>

<?php headermenu();?>

<h3 class="box-title">Questions</h3>

</div>

</div>

<?php
           /*$db=$conn->prepare("select * from question a inner join student_reg b on a.stu_id=b.stu_id where a.check_status='0' order by datetime DESC");*/
           $db=$conn->prepare("select * from question a inner join student_reg b on a.stu_id=b.stu_id order by datetime DESC");

$db->execute();$results=$db->fetchall();

foreach($results as $rows){?>

<li>

<?php echo $rows['text'];?>

</div>

<?php if($rows['approve']=='0'){?><a href='questions.php?action=approve&que_id=<?php echo $rows['que_id'];?>' onclick="return confirm('Are you sure you want to Approve?')" class="btn btn-warning btn-xs">Approve?</a><?php }else{echo"<label class='label bg-green'><i class='fa fa-check'></i> Approved</label>";}?>&nbsp;&nbsp;

<a href='questions.php?action=delete&que_id=<?php echo $rows['que_id'];?>' onclick="return confirm('Are you sure you want to delete?')" class="btn btn-danger btn-xs">Delete</a>&nbsp;&nbsp;

<a href="answer.php?topic_id=<?php echo $rows['topic_id'];?>&queid=<?php echo $rows['que_id'];?>#answer" class="btn btn-primary btn-xs">Read more & Answer</a>

</div>

</li>

<?php }?>

</ul>

</section>

</div></div>

<?php footer();?>

</div>

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

</body>

</html>