<?php
$flag=$_REQUEST['flag'];

include("../link/databaseconnection.php");
if(!$flag)
			{
				header("location:http://gcschool.co.in");
			}
switch($flag)
{
	case 1:
$message=$_POST['data'];
//echo $message;
$ins="insert into news(message) value('$message')";
if($res=mysqli_query($conn,$ins))
{
	echo "Submit";
	
}

	else
	{
		echo "Submit not";
	}
	break;
	
	case 2:
	
	?>
	

	<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
        buttons: []
    });
	
});
</script>


	<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
        <thead>
            <tr>
                <th>Sr.</th><th>Message</th><th>Delete</th>
            </tr>
        </thead>
<tfoot>
            <tr>
                <th>Sr.</th><th>Message</th><th>Delete</th>
            </tr>
        </tfoot>
<tbody>		
  <?php
  $sel="select * from  news order by id desc";
	$res=mysqli_query($conn,$sel);
	$s=1;
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		
		?>
		 
	<tr class="text-center">
	<td><?php echo $s;?></td><td><?php echo $row['message'];?></td>
	
	
	
	<td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="fa fa-trash"></span></a></td>
	</tr>
	<?php
	$s++;
	}
	?>
	 </tbody>
    </table>
	
	</div>
	
	
	<?php
	break;
	
	
	case 3:
	$id=$_POST['rowid'];
	
	$del="delete from news where id='$id'";
	if(mysqli_query($conn,$del))
	{
		echo"deleted Successfully";
		
	}
	else
	{
		echo"Not Deleted";
	}
	break;
	
	
	case 4:
$oemail=$_POST['email1'];

$pass=$_POST['pass'];

//echo $message;

	
	

	break;
}
?>