PHP ?? ?? ?? ???? ?? ??
? ? ??? ?? ?? ? ??? ???????. ??? ?? ????? ?? ??? ?? ???????. ?? ??? ?? ? ???? ?????!
?? new_delete.php? ?????. ?? ?? ?? ?? ????? ?? ??? ?? ? ??? ??? ???? ?? ID? ???? ??? ???? ???. ???? ??? JS? ?????.
<a class='button border-red' href='javascript:;' onclick='return del(<?php echo $val['id']?>)'> <span class='icon-trash-o'></span> 刪除</a>
?? ?? ?? ?? ??? ??? JS ??? ?????.
//單個刪除
function del(id){
if(confirm("您確定要刪除嗎?")){
document.location.href = "new_delete.php?id=" + id ;
}
}?? ?? new_delete.php ???? ID? ?? ??? ???? ???? ???? ?????!
?? ??? ?? ? ?? ??? ??????? ???? ????.
<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2016/9/2
* Time: 15:44
*/
// 連接mysql數(shù)據(jù)庫
$link = mysqli_connect('localhost', 'root', 'root');
if (!$link) {
echo "connect mysql error!";
exit();
}
// 選中數(shù)據(jù)庫 my_db為數(shù)據(jù)庫的名字
$db_selected = mysqli_select_db($link, 'news');
if (!$db_selected) {
echo "<br>selected db error!";
exit();
}?? ??? ID ???? ??? ?? ID? ?? ???? ???? SQL ?? ???? ????.
$id = $_GET['id'];
if( !is_numeric($id) ){
echo "ERROR!";
exit;
}
$sql = "delete from new where id = $id";
$result = mysqli_query($link, $sql);??? ??? ??? ????. ???? ?????:
if($result){
echo "刪除成功！";
// 直接跳轉(zhuǎn)進入簡歷列表
header("Location: new_list.php");
} else {
echo "刪除失敗！";
}?? ???? ???? ? ?? ??? ?? ?????!
