************************************* require("dbconfig.php"); if (isset($_GET['page_no']) && $_GET['page_no']!="") { $page_no = $_GET['page_no']; } else { $page_no = 1; } $total_records_per_page = 3; $offset = ($page_no-1) * $total_records_per_page; $previous_page = $page_no - 1; $next_page = $page_no + 1; $adjacent = "2"; $result_count = mysqli_query($conn,"SELECT COUNT(*) As total_records FROM tbldoctorstatus"); $total_records = mysqli_fetch_array($result_count); $total_records = $total_records['total_records']; $total_no_of_pages = ceil($total_records / $total_records_per_page); $second_last = $total_no_of_pages - 1; // total pages minus 1 $result = mysqli_query( $conn, "SELECT * FROM tbldoctorstatus LIMIT $offset, $total_records_per_page"); //$sql ="SELECT * FROM tbldoctorstatus WHERE status_present LIMIT $offset, $total_records_per_page"; // $result = mysqli_query($sql, $conn); while($row = mysqli_fetch_array($result)) { echo " ".$row['id']." ".$row['firstname']." ".$row['picture_path']." ".$row['email']." ".$row['status_present']." "; } mysqli_close($conn);