region.php

<?php
include("sqlcon.php");
if(isset($_POST[add]))
{
	$region = mysqli_real_escape_string($con,$_POST[region]);
	$q = mysqli_query($con, "select * from tblregion where LOWER(location)=LOWER(".$_POST[region].")");
	if(mysqli_num_rows($q) >0 )
	{
		echo "<script>alert(Region alredy exist!!!);</script>";
	}
	else
	{
	$qry = "insert into tblregion(location) values (".$region.")";
	if(mysqli_query($con, $qry))
	{ 
		echo "<script>alert(success!!!);</script>";
	}
	}
}
if(isset($_GET[id]))
{
	$rs = mysqli_query($con, "delete from tblregion where locid=".$_GET[id]);
	if($rs)
	{
		echo "<script>alert(Record Deleted!!!);window.location=region.php;</script>";
	}
}
/* ### */  ?>


<?php
include("header.php")
/* ### */  ?>

 
<div class="container">
	<div class="page">
   <h3>Alumni Regions</h3>
 
<div class="bs-example" data-example-id="simple-horizontal-form">
    <form class="form-horizontal" action="" method="post">
      <div class="form-group">
        <label for="inputEmail3" class="col-sm-2 control-label">Region</label>
        <div class="col-sm-6">
          <input type="text" class="form-control" id="region" name="region" placeholder="Region" required>
        </div>
      </div> 
      <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
          <input type="submit" class="btn btn-default" name="add" value="ADD">
		       <input type="submit" class="btn btn-default" name="cancel" value="CANCEL">
        </div>
      </div>
    </form>
  </div>	
 <div class="bs-example" data-example-id="contextual-table" style="border: 1px solid #eee">
    <table class="table" id="dataTables-example">
  <tr>
    <th>#</th>
    <th>Region</th>
    <th>Action</th>
  </tr>
  <?php
  $res = mysqli_query($con, "Select * from tblregion");
  $c = 1;
  while($row = mysqli_fetch_array($res))
  {
	  echo "<tr>
    <td>".$c++."</td>
    <td>".$row[1]."</td>
    <td><a href=region.php?id=$row[0] onclick=return val()>Delete</a></td>
  </tr>";
  }
  /* ### */  ?>
  
</table>
</div>
</div>
</div>


<?php
include("footer.php");
/* ### */  ?>
<link rel="stylesheet" type="text/css" href="DataTables-1.10.12/extensions/Buttons/css/buttons.dataTables.css">
 	<link rel="stylesheet" type="text/css" href="DataTables-1.10.12/media/css/jquery.dataTables.css">
<script type="text/javascript" language="javascript" src="DataTables-1.10.12/media/js/jquery.dataTables.js">
	</script>
	<script type="text/javascript" language="javascript" src="DataTables-1.10.12/extensions/Buttons/js/dataTables.buttons.js">
	</script>
	<script type="text/javascript" language="javascript" src="Stuk-jszip-6d2b991/dist/jszip.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="pdfmake-master/build/pdfmake.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="pdfmake-master/build/vfs_fonts.js">
	</script>
	<script type="text/javascript" language="javascript" src="DataTables-1.10.12/extensions/Buttons/js/buttons.html5.js">
	</script>
	<script type="text/javascript" language="javascript" src="DataTables-1.10.12/examples/resources/syntax/shCore.js">
	</script>
	<script type="text/javascript" language="javascript" src="DataTables-1.10.12/examples/resources/demo.js">
	</script>
    <script>
        $(document).ready(function () {
            $(#dataTables-example).dataTable({
		dom: Bfrtip,
        lengthMenu: [
            [ 10, 25, 50, -1 ],
            [ 10 rows, 25 rows, 50 rows, Show all ]
        ],
        buttons: [
            pageLength,
			pdfHtml5
        ]
	} );
        });
    </script>
	<script>
	 function val()
	 {
		var flag=confirm("Do you want to delete the record");
		if(!flag)
		return false;
		else
		return true;
	 }
	</script>