prepare("SELECT * FROM qudao WHERE id = ?"); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { $stmt = $conn->prepare("UPDATE qudao SET ch_name = ? WHERE id = ?"); $stmt->bind_param("si", $ch_name, $id); $stmt->execute(); } $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); header("Location: ?keys=$keys&Ord=$ord&Page=$page"); exit; } else { $stmt = $conn->prepare("INSERT INTO qudao (ch_name) VALUES (?)"); $stmt->bind_param("s", $ch_name); $stmt->execute(); header("Location: ?"); exit; } } if ($act == 'postchk') { $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); $page = $_GET['Page'] ?? ''; if (isset($_POST['chkbox']) && is_array($_POST['chkbox'])) { $ids = array_map('intval', $_POST['chkbox']); $idList = implode(',', $ids); if (!empty($idList)) { $stmt = $conn->prepare("DELETE FROM qudao WHERE id IN ($idList)"); $stmt->execute(); } } header("Location: ?Keys=$keys&Ord=$ord&Page=$page"); exit; } // Now we can start HTML output ?> 管理区域
prepare("SELECT * FROM qudao WHERE id = ?"); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); if ($row = $result->fetch_assoc()) { $ch_name = textUncode($row['ch_name']); } else { $isEdit = false; } } $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); $hrefstr = "?keys=$keys&Ord=$ord&Page=$page"; ?>
来源
prepare($sql); $searchTerm = "%$keyscode%"; $stmt->bind_param("s", $searchTerm); $stmt->execute(); $result = $stmt->get_result(); $keys = urlencode($keys); $ord = urlencode($ord); $hrefstr = "?keys=$keys"; ?>
num_rows > 0) { $pageSize = 10; $totalRecords = $result->num_rows; $totalPages = ceil($totalRecords / $pageSize); if (empty($page)) $page = 1; if ($page == 'end') $page = $totalPages; if (!is_numeric($page) || $page < 1) $page = 1; $page = (int)$page; if ($page > $totalPages) $page = $totalPages; $offset = ($page - 1) * $pageSize; $sql .= " LIMIT ?, ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("sii", $searchTerm, $offset, $pageSize); $stmt->execute(); $result = $stmt->get_result(); $tempNum = $pageSize * ($page - 1); while ($row = $result->fetch_assoc()) { $tempNum++; ?>
序号 渠道来源 操作
修改
Sorry，当前暂无信息
Sorry，没有找到""相关的信息，点击返回
1) { $pageName = "?Keys=$keys&Ord=$ord&"; $pageLen = 3; if ($page > 1) { echo "首页"; echo "上一页"; } if ($pageLen * 2 + 1 >= $totalPages) { $startPage = 1; $endPage = $totalPages; } else { if ($page <= $pageLen + 1) { $startPage = 1; $endPage = $pageLen * 2 + 1; } else { $startPage = $page - $pageLen; $endPage = $page + $pageLen; } if ($page + $pageLen > $totalPages) { $startPage = $totalPages - $pageLen * 2; $endPage = $totalPages; } } for ($i = $startPage; $i <= $endPage; $i++) { if ($i == $page) { echo "$i"; } else { echo "$i"; } } if ($page < $totalPages) { if ($totalPages - $page > $pageLen) { echo "...$totalPages"; } echo "下一页"; echo "尾页"; } echo ""; } ?>