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

include("../link/databaseconnection.php");
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="glyphicon glyphicon-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'];
$nemail1=$_POST['nemail1'];
$oldpas=$_POST['oldpas'];
$newpas=$_POST['newpas'];

//echo $message;
$sell="select *from admin_login where email='$oemail' and password='$oldpas'";

$res=mysqli_query($conn,$sell);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$mob=$row['mobile'];
if($row)
{
	$up="update admin_login set email='$nemail1',password='$newpas'";
	if($res1=mysqli_query($conn,$up))
	{
		$username="AwadheshYadav";
$password="AwadheshYadav";
$senderid="SHIVBI";
$message="SHIVBI Email and Password Change Email-"." ".$nemail1.' '.'Password-'." ".$newpas;
$msg=urlencode($message);

$to=$mob;

$api="http://sms.jupitersms.com/api/sendmsg.php?user=brkweb&pass=india&sender=$senderid&phone=$to&text=$msg&priority=ndnd&stype=normal";

$result=file_get_contents($api);
if($result)
{
	$ins="insert into message (message,count) value('$message','1')";
	echo "<script>alert('Change');window.location.href='../admin/student_details.php'</script>";
}
else
{
	echo"sms not send";
}
		//====
	}
	else
	{
		echo"not update";
	}
	
	
}

	else
	{
		echo "<script>alert('Email Or Password Invailid');window.location.href='../admin/student_details.php'</script>";
	}
	break;
}
?>