query($sql); if ($rs->rowCount() == 0) { $sql = "Insert Into qudao(ch_name) values('" . $ch_name . "')"; } else { $sql = "Update qudao Set ch_name='" . $ch_name . "' Where id=" . $id; } $conn->query($sql); $page = $_GET['Page'] ?? ''; $keys = urlencode($_GET['Keys'] ?? ''); $ord = urlencode($_GET['Ord'] ?? ''); header("Location: ?keys=" . $keys . "&Ord=" . $ord . "&Page=" . $page); exit; } else { $sql = "Insert Into qudao(ch_name) values('" . $ch_name . "')"; $conn->query($sql); header("Location: ?"); exit; } } if ($act == "add" || $act == "edit") { $id = $_GET['id'] ?? ''; $isedit = false; $ch_name = ''; if ($id != "" && is_numeric($id)) { $isedit = true; $sql = "Select * From qudao Where id=" . $id; $rs = $conn->query($sql); if ($row = $rs->fetch()) { $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; ?>
来源
query($sqlStr); } header("Location: ?Keys=" . $keys . "&Ord=" . $ord . "&Page=" . $page); exit; } $keys = $_GET['Keys'] ?? ''; $keyscode = textEncode($keys); $ord = $_GET['Ord'] ?? ''; $page = $_GET['Page'] ?? ''; $ordStr = ""; if ($ord != "") { $ordStr = $ord . ","; } $sql = "Select * From qudao Where ch_name like '%" . $keyscode . "%' Order By id Desc"; $rs = $conn->query($sql); $keys = urlencode($keys); $ord = urlencode($ord); $hrefstr = "?keys=" . $keys; ?>
rowCount() > 0) { $records_per_page = 10; if ($page == "") $page = 1; if ($page == "end") $page = ceil($rs->rowCount() / $records_per_page); if (!is_numeric($page) || $page < 1) $page = 1; $page = (int)$page; if ($page > ceil($rs->rowCount() / $records_per_page)) { $page = ceil($rs->rowCount() / $records_per_page); } $start = ($page - 1) * $records_per_page; $tempNum = $start; $count = 0; while ($row = $rs->fetch()) { $count++; if ($count > $start && $count <= $start + $records_per_page) { $tempNum++; ?>
序号 渠道来源 操作
修改
Sorry,当前暂无信息
Sorry,没有找到""相关的信息,点击返回
rowCount() > 0) { $total_pages = ceil($rs->rowCount() / $records_per_page); if ($total_pages > 1) { $pageName = "?Keys=" . $keys . "&Ord=" . $ord . "&"; $pagelen = 3; if ($page > 1) { echo "首页"; echo "上一页"; } if ($pagelen * 2 + 1 >= $total_pages) { $startPage = 1; $endPage = $total_pages; } else { if ($page <= $pagelen + 1) { $startPage = 1; $endPage = $pagelen * 2 + 1; } else { $startPage = $page - $pagelen; $endPage = $page + $pagelen; } if ($page + $pagelen > $total_pages) { $startPage = $total_pages - $pagelen * 2; $endPage = $total_pages; } } for ($i = $startPage; $i <= $endPage; $i++) { if ($i == $page) { echo "$i"; } else { echo "$i"; } } if ($page < $total_pages) { if ($total_pages - $page > $pagelen) { echo "...$total_pages"; } echo "下一页"; echo "尾页"; } echo ""; } } ?>