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); while ($rows = $result->fetch(PDO::FETCH_ASSOC)) { $Qid = $rows['id']; $Gtitle = $rows['title']; $Ganswer = $rows['answer']; ?>