育將電腦工作室 - 線上書籍

12-3 更新記錄

12-5 mysqli next

網站程式設計-PHP
==========

一、流程

```
<pre class="brush:as3;">

#刪除記錄
  case "op_delete":
    op_delete($sn);
    redirect_header("index.php",3000,"刪除記錄成功！！");
    exit;
  break;
```

二、函數

```
<pre class="brush:as3;">

###############################################################################
#  刪除資料
###############################################################################
function op_delete($sn="")
{
  global $mysqli;
  if(!$sn)redirect_header("index.php",3000,"刪除記錄錯誤！！");

#檢查
  $sql = "delete
          from `show_kind`
          where `sn`='{$sn}'";//die($sql);
  $mysqli->query($sql) or die(printf("Error: %s <br>".$sql, $mysqli->sqlstate));

return;
}
```

三、樣板(列表的樣板)

```
<pre class="brush:as3;">
{literal}   
  <link rel="stylesheet" href="../class/sweet-alert/sweet-alert.css" type="text/css" />  
  <script src="../class/sweet-alert/sweet-alert.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='nav_m.php?op=op_delete&sn=' + sn;
      });
    }            
  </script>
{/literal}
```

```
<pre class="brush:as3;">

<button onclick="javascript:op_delete_js({$row.sn});" type="button" class="btn btn-danger">刪除</button>
```

Title1

Title2

Title3

Title1

Title2

Title3

MarkDown