real_escape_string($keyscode) . "%'"; break; case "2": $filterStr = "WHERE newEmp LIKE '%" . $conn->real_escape_string($keyscode) . "%'"; break; case "3": $filterStr = "WHERE oldCode LIKE '%" . $conn->real_escape_string($keyscode) . "%'"; break; case "4": $filterStr = "WHERE cs_id IN (SELECT id FROM customer WHERE cs_code LIKE '%" . $conn->real_escape_string($keyscode) . "%')"; break; default: $filterStr = ""; } ?>

搜索条件

query($sql); if ($result && $result->num_rows > 0) { $pageSize = 20; $page = empty($page) ? 1 : $page; $page = $page === 'end' ? ceil($result->num_rows / $pageSize) : $page; $page = !is_numeric($page) || $page < 1 ? 1 : (int)$page; $totalPages = ceil($result->num_rows / $pageSize); $page = $page > $totalPages ? $totalPages : $page; $offset = $pageSize * ($page - 1); // Store all results in array $rows = []; while ($row = $result->fetch_assoc()) { $rows[] = $row; } // Get paginated results $paginatedRows = array_slice($rows, $offset, $pageSize); $tempNum = $offset; foreach ($paginatedRows as $row) { $tempNum++; // Get new customer code $customerResult = $conn->query("SELECT cs_code FROM customer WHERE id = " . $row['cs_id']); $customerCode = ($customerRow = $customerResult->fetch_assoc()) ? $customerRow['cs_code'] : ''; ?>
序号 时间 记录 新编号
认领了 的客户(
当前暂无认领记录
1) { $pageName = "?Keys=" . $keys . ($urlStr ?? '') . "&searcheType=" . $searcheType . "&"; $pagelen = 3; // First page and Previous page if ($page > 1) { echo "首页"; echo "上一页"; } // Calculate page range 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; } } // Page numbers for ($i = $startPage; $i <= $endPage; $i++) { if ($i == $page) { echo "{$i}"; } else { echo "{$i}"; } } // Next page and Last page if ($page < $totalPages) { if ($totalPages - $page > $pagelen) { echo "...{$totalPages}"; } echo "下一页"; echo "尾页"; } } ?>