query("SELECT productId FROM productFAQ WHERE questionId=" . (int)$qid); $productStr = ","; while ($row = $result->fetch_assoc()) { $productStr .= $row['productId'] . ","; } // Get products $sql = "SELECT id, productName, productPic, productAddtime FROM product WHERE productName LIKE '%" . $conn->real_escape_string($Keyscode) . "%' ORDER BY productAddtime DESC"; $result = $conn->query($sql); $Keys = urlencode($Keys); $Ord = urlencode($Ord); $hrefstr = "?keys=" . $Keys; ?> num_rows > 0) { $pageSize = 7; $totalRows = $result->num_rows; $totalPages = ceil($totalRows / $pageSize); if ($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 = $pageSize * ($Page - 1); $sql .= " LIMIT $offset, $pageSize"; $result = $conn->query($sql); $TempNum = $offset; while ($row = $result->fetch_assoc()) { $TempNum++; $checked = strpos($productStr, "," . $row['id'] . ",") !== false ? ' checked="checked"' : ''; ?>

	序号	产品名称	图片	添加时间
name="chkbox" class="relatedProducts" onChange="relatedProducts(,)" />
Sorry，当前暂无信息
Sorry，没有找到""相关的信息，点击返回
1) { $PageName = "?qid={$qid}&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 "尾页"; } $pageInputJs = "if(event.keyCode==13){location.href='{$PageName}Page='+document.getElementById('Pagego').value}"; echo ""; } ?> 显示 隐藏 删除

close(); ?>