setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $result = $conn->prepare($sql); $result->bindValue(':limit', $limit, PDO::PARAM_INT); $result->bindValue(':offset', $offset, PDO::PARAM_INT); try { $result->execute(); } catch (PDOException $e) { echo "Error: " . $e->getMessage(); } $total_sql = "SELECT COUNT(*) FROM guida_QA WHERE title IS NOT NULL AND answer IS NOT NULL"; $total_result = $conn->prepare($total_sql); $total_result->execute(); $total_rows = $total_result->fetchColumn(); $total_pages = ceil($total_rows / $limit); ?>

Smart Q&A

คำถามที่พบบ่อย

fetch(PDO::FETCH_ASSOC)) { $Gtitle = htmlspecialchars($rows['title']); $Ganswer = htmlspecialchars($rows['answer']); ?>