Title1

Title2

Title3

prev12-8  op_delete()
14. 撈出資料，顯示在前台next
網站程式設計-PHP

13. CRUD程式流程

一、流程圖

二、SQL 語法

  1. 新增 
    
#################################
# 新增資料
#
#################################
function op_insert() {
	global $mysqli;

	#資料過濾
	#http://php.net/manual/en/mysqli.real-escape-string.php
	$_POST['title'] = $mysqli->real_escape_string($_POST['title']);
	$_POST['target'] = intval($_POST['target']);
	$_POST['enable'] = intval($_POST['enable']);
	$_POST['sort'] = intval($_POST['sort']);
	$_POST['url'] = $mysqli->real_escape_string($_POST['url']);
	$_POST['kind'] = $mysqli->real_escape_string($_POST['kind']);

	$sql = "insert into `creative_nav`
          (`title`, `target`, `enable`, `sort`,`url`,`kind`)
          values
          ('{$_POST['title']}', '{$_POST['target']}', '{$_POST['enable']}', '{$_POST['sort']}', '{$_POST['url']}', '{$_POST['kind']}')";

	$mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));

	$sn = $mysqli->insert_id; //傳回insert 指令所產生之流水號

	return $sn;
}

     

  2. 編輯 
    
#################################
# 更新資料
#
#################################
function op_update($sn = "") {
	global $mysqli;
	if (!$sn) {
		redirect_header("index.php", 3000, "更新記錄錯誤！！");
	}

	#資料過濾
	$_POST['sn'] = intval($_POST['sn']);
	$_POST['title'] = $mysqli->real_escape_string($_POST['title']);
	$_POST['target'] = intval($_POST['target']);
	$_POST['enable'] = intval($_POST['enable']);
	$_POST['sort'] = intval($_POST['sort']);
	$_POST['url'] = $mysqli->real_escape_string($_POST['url']);

	$sql = "update `creative_nav` set
          `title`  = '{$_POST['title']}' ,
          `target` = '{$_POST['target']}',
          `enable` = '{$_POST['enable']}',
          `url` = '{$_POST['url']}',
          `sort` = '{$_POST['sort']}'
          where sn='{$_POST['sn']}'";

	$mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));

	return $sn;
}

     

  3. 刪除 
    
#################################
# 刪除資料
#
#################################
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;
}

     

  4. 列表 
    
#################################
# 列表程式
#
#################################
function op_list() {
	global $mysqli, $smarty;

	#取得所有記錄
	$sql = "select *
          from `creative_nav`
          where `kind`='nav_home'
          order by `sort` "; //die($sql);

	$result = $mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));

	$rows = array();
	while ($row = $result->fetch_assoc()) {
		#過濾撈出資料
		$row['sn'] = intval($row['sn']);
		//http://www.w3school.com.cn/php/func_string_htmlspecialchars.asp
		$row['title'] = htmlspecialchars($row['title'], ENT_QUOTES); // 轉換雙引號和單引號
		$row['url'] = htmlspecialchars($row['url'], ENT_QUOTES); // 轉換雙引號和單引號
		$row['sort'] = intval($row['sort']);
		$row['enable'] = intval($row['enable']);
		$row['target'] = intval($row['target']);

		$rows[] = $row;
	}

	$smarty->assign("rows", $rows);
	return;
}

     

  5. 取得單筆記錄 
    
########################################
#取得單筆記錄
########################################
function get_creative_nav($sn = "") {
	global $mysqli;
	if (!$sn) {
		redirect_header("index.php", 3000, "查詢選單資料錯誤！！");
	}

	$sql = "select *
          from `creative_nav`
          where `sn`='{$sn}' and `kind`= 'nav_home'";
	$result = $mysqli->query($sql) or die(printf("Error: %s <br>" . $sql, $mysqli->sqlstate));
	$row = $result->fetch_assoc();

	#過濾撈出資料
	$row['sn'] = intval($row['sn']);
	//http://www.w3school.com.cn/php/func_string_htmlspecialchars.asp
	$row['title'] = htmlspecialchars($row['title'], ENT_QUOTES); // 轉換雙引號和單引號
	$row['url'] = htmlspecialchars($row['url'], ENT_QUOTES); // 轉換雙引號和單引號
	$row['sort'] = intval($row['sort']);
	$row['enable'] = intval($row['enable']);
	$row['target'] = intval($row['target']);

	return $row;
}

     

三、樣板

  1. theme.html 
            <{if $WEB.file_name =="index.php"}>
          <{include file="tpl/admin_index.html"}>
        <{/if}>

     

  2. tpl/admin_index.html 列表 
    <{if $op == "op_list"}>
  <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>
  <div class="panel panel-default">
    <div class="panel-heading">選單管理 - 列表</div>
    <!-- /.panel-heading -->
    <div class="panel-body">
      <div class="table-responsive">
        <table class="table table-striped table-bordered table-hover">
          <thead>
            <tr class="active">   
              <th class="col-md-3 text-center">標題</th>
              <th class="col-md-3 text-center">網址</th>
              <th class="col-md-1 text-center">外連</th>
              <th class="col-md-1 text-center">狀態</th>
              <th class="col-md-1 text-center"><a href="?op=op_form" class="btn btn-xs btn-primary">新增</a></th>
            </tr>
          </thead>
          <tbody>
            <{foreach from=$rows item=row}>
              <tr>
                <td class="text-center"><{$row.title}></td>
                <td><{$row.url}></td>
                <td class="text-center">
                  <{if $row.target == 1}>
                    <img src="<{$smarty.const.WEB_URL}>/images/yes.gif">
                  <{else}>
                    <img src="<{$smarty.const.WEB_URL}>/images/no.gif">
                  <{/if}>
                </td>
                <td class="text-center">
                  <{if $row.enable == 1}>
                    <img src="<{$smarty.const.WEB_URL}>/images/yes.gif">
                  <{else}>
                    <img src="<{$smarty.const.WEB_URL}>/images/no.gif">
                  <{/if}> 
                </td>
                <td class="text-center">                    
                  <a href="?op=op_form&sn=<{$row.sn}>" class="btn btn-xs btn-success">
                    編輯
                  </a>
                  <a href="javascript:op_delete_js(<{$row.sn}>);" class="btn btn-xs btn-danger">
                    刪除
                  </a>
                </td>
              </tr> 
            <{/foreach}>
                              
          </tbody>
        </table>
      </div>
      <!-- /.table-responsive --> 
    </div>
    <!-- /.panel-body -->
  </div>
<{/if}>

     

  3. admin/admin_index.html 表單 
    
<{if $op == "op_form"}>
  <div class="panel panel-primary">
    <div class="panel-heading"><h3 class="panel-title">選單管理 - <{$row.form_title}></h3></div>
    <div class="panel-body">
      <form role="form" action="index.php" method="post" id="myForm">        
        <div class="row">
          <div class="col-md-6">
            <div class="form-group">
              <label>標題</label>
              <input type="text" name="title" id="title" class="form-control" value="<{$row.title}>" placeholder="標題" >
            </div>
          </div>
          <div class="col-md-6">
            <div class="form-group">
              <label>網址</label>
              <input type="text" name="url" id="url" class="form-control" value="<{$row.url}>" placeholder="網址">
            </div>
          </div>
          <div class="col-md-1">
            <div class="form-group">
              <label>排序</label>
              <input type="text" name="sort" id="sort" class="form-control" value="<{$row.sort}>">
            </div>
          </div>
          <div class="col-md-2">            
            <div class="form-group">
              <label style="display:block;">外連狀態</label>
              <input type="radio" name="target" id="target_1" value="1" <{if $row.target == 1}>checked<{/if}>>
              <label for="target_1">外連</label>&nbsp;&nbsp;
              <input type="radio" name="target" id="target_0" value="0" <{if $row.target == 0}>checked<{/if}>>
              <label for="target_0">本站</label>
            </div>
          </div>
          <div class="col-md-2">            
            <div class="form-group">
              <label style="display:block;">啟用狀態</label>
              <input type="radio" name="enable" id="enable_1" value="1" <{if $row.enable == 1}>checked<{/if}>>
              <label for="enable_1">啟用</label>&nbsp;&nbsp;
              <input type="radio" name="enable" id="enable_0" value="0" <{if $row.enable == 0}>checked<{/if}>>
              <label for="enable_0">停用</label>
            </div>
          </div>
        </div>
        <hr>
        <div class="text-center">
          <input type="hidden" name="op" value="<{$row.op}>">
          <input type="hidden" name="sn" value="<{$row.sn}>">
          <input type="hidden" name="kind" value="<{$row.kind}>">

          <button type="submit" class="btn btn-primary">送出</button>
          <button type="reset" class="btn btn-danger">重設</button>
          <button type="button" class="btn btn-warning" onclick="location.href='<{$smarty.session.op_list}>'">返回</button>
        </div>
      </form>
    </div>
  </div>
<{/if}>

     


  4.  

 

prev12-8  op_delete()
14. 撈出資料，顯示在前台next

友善列印 & 下載 PDF 匯出 MarkDown 格式