prepare($sqlTotal);
$stmt_count->execute();
$total = $stmt_count->rowCount();
/*$Qtotal = mysqli_query($db,"SELECT * FROM std_paper"); //คิวรี่ คำสั่ง
$total = mysqli_num_rows($Qtotal); // หาจำนวน record*/
$Per_Page = 5; //per page
if (!isset($_GET["Page"])) {
$Page = $pageNumber;
} else {
$Page = $pageNumber;
}
$Prev_Page = $Page - 1;
$Next_Page = $Page + 1;
$Page_Start = (($Per_Page * $Page) - $Per_Page);
if ($total <= $Per_Page) {
$Num_Pages = 1;
} else if (($total % $Per_Page) == 0) {
$Num_Pages = ($total / $Per_Page);
} else {
$Num_Pages = ($total / $Per_Page) + 1;
$Num_Pages = (int)$Num_Pages;
}
$Query = $pdo->prepare("SELECT * FROM std_paper ORDER BY paper_upload_date DESC LIMIT $Page_Start,$Per_Page");
$Query->execute();
$totalp = $Query->rowCount();
$j = 1;
?>
Back";
}
for($i=1;$i<=$Num_Pages;$i++)
{
if($i!=$Page)
{
echo "$i";
}
else
{
echo "$i";
}
}
if ($Page!=$Num_Pages)
{
echo "Next";
}*/
?>
