Example #1
0
$result = mysqli_query($conn, $sql);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "<tr>";
        echo "<td>" . $row['ID'] . "</td>";
        echo "<th>" . $row['TieuDe'] . "</th>";
        echo "<td>" . $row['NoiDung'] . "</td>";
        echo "<td>" . $row['TenDN'] . "</td>";
        echo "<td>" . $row['KiemDuyet'] . "</td>";
        echo "<td>" . $row['NgayBinhLuan'] . "</td>";
        echo "<td>\n\t\t\t\t\t\t\t<a href='BinhLuan_Doc.php?ID=" . $row['ID'] . "'><input type='button' value='Xem' class='btn btn-default'/></a>\n\t\t\t\t\t\t\t<a href='BinhLuan_Sua.php?ID=" . $row['ID'] . "'><input type='button' value='Sửa' class='btn btn-success'/></a>\n\t\t\t\t\t\t\t<a href='BinhLuan_Xoa.php?ID=" . $row['ID'] . "'> <input type='button' value='Xóa' class='btn btn-danger'/> </a>";
        echo "</td>";
        echo "</tr>";
    }
}
ConnectDB::disconnect();
?>
		</table>
         <?php 
//bắt đầu phân trang
$page_cr = $start / $row_per_page + 1;
//echo "<h4><span class='bg-primary'>". $page_cr."</span></h4>";
for ($i = 1; $i <= $page; $i++) {
    if ($page_cr != $i) {
        echo "<a href='QLBinhLuan.php?start=" . $row_per_page * ($i - 1) . "'><button type='button' class='btn btn-success'>" . $i . "</button></a>";
    } else {
        echo "<button type='button' class='btn btn-warning'>" . $i . "</button>";
    }
}
?>
    </div>