รบกวนดู code delete ให้หน่อยครับ ผมกดปุ่ม delete ที่ทำไว้แล้วแต่ไม่ลบข้อมูลครับ
code media.php
Code
<?php
include('../admin/session.php');
?>
<script type="text/javascript">
function pop_add_cate(){
window.open("p_cate.php","myWindow","status=1,height=50,width=300,resizeable=0");
}
function d_cate(){
window.location.href("d_cate.php");
}
</script>
<!DOCTYPE html>
<html>
<head>
<title>Digital Media Management</title>
<link href="../css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%">
<div align="right" id="media">
<b id="welcome" style="padding-right:20px;">Welcome : <i><?php echo $login_session; ?></i></b>
<b id="logout"><a href="logout.php">Log Out</a></b>
</div>
<div>
<td style="border:1px solid; text-align:center;"><a href="media.php">Media</a></td>
<td style="border:1px solid; text-align:center;"><a href="playlist.php">Playlist</a></td>
<td style="border:1px solid; text-align:center;"><a href="scolling.php">Scolling</a></td>
<td style="border:1px solid; text-align:center;"><a href="layout.php">Layout</a></td>
<td style="border:1px solid; text-align:center;"><a href="schedule.php">Schedule</a></td>
<td style="border:1px solid; text-align:center;"><a href="setting.php">Setting</a></td>
</div>
<tr>
<div>
<td style="border:1px solid; text-align:center; width:16%">
<div style="border:1px dashed">Media Category</div>
<br>
<div align="center">
<input style="background-image:url(img/srvc-document.png); width:44px; height:40px;" type="button" name="add" id="add" onClick="pop_add_cate()"/><br>
</div>
<br>
<?php
$connnection = mysql_connect("localhost","root","digitalmedia");
$DB = mysql_select_db("digitalmedia" , $connnection);
$s_qu = "select * from categorie";
$s_query = mysql_query($s_qu, $connection);
while($objRe = mysql_fetch_array($s_query)){
?>
<div style="border:1px dashed"> <?php echo $objRe['cate_name']; ?>
<input style="float:right; height:20px; background-image:url(img/bin.png);" width="20px" type="button" name="del" id="del"
onClick="d_cate()"/><br>
</div>
<?php
}
mysql_close($connnection);
?>
</div>
</td>
<td colspan="2" style="border:1px solid; text-align:center;">Video & Pivture</td>
<td colspan="3" style="border:1px solid; text-align:center;">Add Media</td>
</div>
</tr>
</table>
code d_cate.php
Code
<?php
$connnection = mysql_connect("localhost","root","digitalmedia");
$DB = mysql_select_db("digitalmedia" , $connnection);
if(isset($_GET['delete_id']))
{
$del = $_GET["id"];
$sql = "DELETE FROM categorie WHERE id='".$del."'";
$query = mysql_query($sql, $connnection);
header("Location:media.php");
}
mysql_close($connnection);
?>
รูปหน้าหลักที่กด delete ครับ
ขอบคุณครับ
Tag : PHP, HTML/CSS, JavaScript
