網站程式設計-PHP
程式:op_delete()
#################################
# 刪除資料
#
#################################
function op_delete($sn = "") {
global $mysqli;
if (!$sn) {
redirect_header("index.php", 3000, "刪除記錄錯誤!!");
}
#檢查
$sql = "delete
from `creative_nav`
where `sn`='{$sn}'"; //die($sql);
$mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));
return;
}
樣板:
op_list
sweet-alert套件:https://lipis.github.io/bootstrap-sweetalert/
下載:https://github.com/lipis/bootstrap-sweetalert/tree/master/dist
<link rel="stylesheet" href="<{$smarty.const.WEB_URL}>/class/sweetalert/sweetalert.css" type="text/css"> <script src="<{$smarty.const.WEB_URL}>/class/sweetalert/sweetalert.min.js" type="text/javascript"></script> <script type="text/javascript"> function op_delete_js(sn){ //警告視窗 swal({ title: '確定要刪除此資料?', text: '相關資料通通都將會被移除!', type: 'warning', showCancelButton: 1, confirmButtonColor: '#DD6B55', confirmButtonText: '確定刪除!', closeOnConfirm: false , allowOutsideClick: true }, function(){//確定 location.href="?op=op_delete&sn="+sn; }); } </script>