Add_Drop.php

<!--for delete Record -->
<?php
	$msg="";
	$opr="";
	if(isset($_GET['opr']))
	$opr=$_GET['opr'];
	
if(isset($_GET['rs_id']))
	$id=$_GET['rs_id'];

if(isset($_GET['usr_id']))
	$iid=$_GET['usr_id'];

if(isset($_GET['third_id']))
	$iiid=$_GET['third_id'];


if(isset($_GET['accepted']))
{
    if($_GET['accepted'] == 1){
        echo "Accpeted!";
        $acc_sql=mysqli_query($con,"UPDATE student_reg_forms SET status = 'A' WHERE roll_number='$id'and year = '$iid' and semester = '$iiid'");
        if($acc_sql)
            $msg="<div style='background-color: white;padding: 20px;border: 1px solid black;margin-bottom: 25px;''>"
                    . "<span class='p_font'>"
                    . "1 Record Updated... !"
                    . "</span>"
                    . "</div>";
        
        else
            $msg="Could not Update :".mysqli_error($con);
    }
    else{
        $del_sql=mysqli_query($con,"DELETE FROM student_reg_forms WHERE roll_number='$id'and year = '$iid' and semester = '$iiid' and status = 'n'");
        if($del_sql)
            $msg="<div style='background-color: white;padding: 20px;border: 1px solid black;margin-bottom: 25px;''>"
                    . "<span class='p_font'>"
                    . "1 Record Deleted... !"
                    . "</span>"
                    . "</div>";
        
        else
            $msg="Could not Delete :".mysqli_error($con);
    }
}   
	echo $msg;
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/style_view.css" />
</head>

<body>
<div class="btn_pos">
        <form method="post">
            <input type="text" name="searchtxt" class="input_box_pos form-control" placeholder="Search name.." />
            <div class="btn_pos_search">
            <input type="submit" class="btn btn-primary btn-large" name="btnsearch" value="Search"/>&nbsp;&nbsp;
            </div>
        </form>
    </div><br><br>
            
            
<div class="table_margin">
<table class="table table-bordered">
        <thead>
            <tr>
            <th style="text-align: center;">S No.</th>
 	        <th style="text-align: center;">Roll Number</th>
            <th style="text-align: center;">Courses</th>
            <th style="text-align: center;">Credits</th>
            <th style="text-align: center;" colspan="2">Operation</th>
        </tr>
        
        <?php
	$key="";
	if(isset($_POST['searchtxt']))
		$key=$_POST['searchtxt'];
	
	if($key !="")
		$sql_sel=mysqli_query($con,"SELECT roll_number,GROUP_CONCAT(course_id),SUM(credits),year,semester FROM student_reg_forms WHERE roll_number  like '%$key%' and status = 'FS' GROUP BY roll_number,year,semester");
	else
		 $sql_sel=mysqli_query($con,"SELECT roll_number,GROUP_CONCAT(course_id),SUM(credits),year,semester FROM student_reg_forms WHERE status = 'FS' GROUP BY roll_number,year,semester");
	
		
    $i=0;
    while($row=mysqli_fetch_array($sql_sel)){
    $i++;
    ?>
      <tr>
            <td><?php echo $i;?></td>
	        <td><?php echo $row['roll_number'];?></td>
            <td><?php echo $row['GROUP_CONCAT(course_id)'];?></td>
            <td><?php echo $row['SUM(credits)'];?></td>	
            <td><a href="?tag=add_drop&usr_id=<?php echo $row['year'];?>&rs_id=<?php echo $row['roll_number'];?>&third_id=<?php echo $row['semester'];?>&accepted=1" title="Accept"><button> Approve </button></a><a href="?tag=add_drop&usr_id=<?php echo $row['year'];?>&rs_id=<?php echo $row['roll_number'];?>&third_id=<?php echo $row['semester'];?>&accepted=2" title="Reject"><button > Reject </button></a></td>
             
        </tr>
    <?php	
    }
	// ----- for search studnens------	
		
	
    ?>
    </table>
</form>
</div>
</body>
</html>


<!--
<td>
        	<a href="?tag=student_entry"><input type="button" title="Add new student" name="butAdd" value="Add New" id="button-search" /></a>
        </td>
        <td>
        	<input type="text" name="searchtxt" title="Enter name for search " class="search" autocomplete="off"/>
        </td>
        <td style="float:right">
        	<input type="submit" name="btnsearch" value="Search" id="button-search" title="Search Student" />
        </td>
-->