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(); } //print_r($guidaSubTypeID_1); // ดึงข้อมูลทั้งหมดเพื่อนับจำนวนหน้า $total_sql = "SELECT COUNT(*) FROM guide WHERE guidaSubTypeID = 1"; $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)) { $Aid = $rows['Aid']; $title = $rows['title']; $Atitle = $rows['Atitle']; $coverImg = $rows['coverImg']; $subTitle = $rows['subTitle']; $view = $rows['view']; ?>

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(); } //print_r($guidaSubTypeID_1); // ดึงข้อมูลทั้งหมดเพื่อนับจำนวนหน้า $total_sql = "SELECT COUNT(*) FROM guide WHERE guidaSubTypeID = 2"; $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)) { $Aid = $rows['Aid']; $title = $rows['title']; $Atitle = $rows['Atitle']; $coverImg = $rows['coverImg']; $subTitle = $rows['subTitle']; $view = $rows['view']; ?>

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(); } //print_r($guidaSubTypeID_1); // ดึงข้อมูลทั้งหมดเพื่อนับจำนวนหน้า $total_sql = "SELECT COUNT(*) FROM guide WHERE guidaSubTypeID = 3"; $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)) { $Aid = $rows['Aid']; $title = $rows['title']; $Atitle = $rows['Atitle']; $coverImg = $rows['coverImg']; $subTitle = $rows['subTitle']; $view = $rows['view']; ?>