Untitled

<?php

include_once '../dbconnect.php';


$res = $con->query("SELECT * FROM main_menu");
$sql_query=mysqli_query($res);


if(isset($_GET['delete_id'])) {
 $sql_query="DELETE FROM main_menu WHERE m_menu_id=".$_GET['m_menu_id'];
 mysqli_query($sql_query);

 header("Location: delete_menu.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP Delete Data With Javascript Confirmation - By Cleartuts</title>
<link rel="stylesheet" href="style.css" type="text/css" />
<script type="text/javascript">
function delete_id(id)
{
 if(confirm('Sure To Remove This Record ?'))
 {
  window.location.href='delete_menu.php?delete_id='+id;
 }
}
</script>
</head>
<body>
<center>

<div id="header">
 <div id="content">
    <label>PHP Delete Data With Javascript Confirmation</label>
    </div>
</div>
<div id="body">
 <div id="content">


<table class="table" align="center" border="1" cellspacing="1" cellpadding="2">
        <thead>
            <th>Title</th>
            <th>Permalink</th>
        </thead>

        <?php
            $res=$con->query("SELECT * FROM main_menu");
             while($row=$res->fetch_array()) { ?>

         <tr>
           <td><?php echo $row['m_menu_id']; ?></td>
           <td><?php echo $row['m_menu_name']; ?></td>
           <td align="center"><a href="javascript:delete_id(<?php echo $row['m_menu_id']; ?>)"><img src="delete.png" alt="Delete" /></a></td>
         </tr>

        <?php
         }
        ?>

</table>

    </div>
</div>

</center>
</body>
</html>