prepare($insert_bookings); $sql_insert->execute(); $message = "Details successfully updated."; $status = "success"; header("Location: $redirection_page&id=$edit_id"); } // For Displaying the table if (isset($_GET['pageno'])) { $pageno = $_GET['pageno']; } else { $pageno = 1; } $no_of_records_per_page = 7; $offset = ($pageno - 1) * $no_of_records_per_page; $select_enquiry = "SELECT * FROM $table_name where status = 'Active' order by id desc"; $sql = $dbconn->prepare($select_enquiry); $sql->execute(); $total_rows = $sql->fetchColumn(); $total_pages = ceil($total_rows / $no_of_records_per_page); $select_enquiry = "SELECT * FROM $table_name where status = 'Active' order by id desc LIMIT $offset, $no_of_records_per_page"; $sql = $dbconn->prepare($select_enquiry); $sql->execute(); $wlvd = $sql->fetchAll(PDO::FETCH_OBJ); $select_bookings = "SELECT * FROM `$table_name` WHERE id = '$edit_id'"; $sql1 = $dbconn->prepare($select_bookings); $sql1->execute(); $wlvd1 = $sql1->fetchAll(PDO::FETCH_OBJ); foreach ($wlvd1 as $rows1); ?>

  1. Dashboard
prepare($delete_statement); $sql_insert->execute(); $message = "Details successfully updated."; $status = "success"; header("Location: $redirection_page&id=$delete_id"); } else { ?>
All Records
rowCount() > 0) { foreach ($wlvd as $rows) { $field1 = $rows->id; $field2 = $rows->user_name; $field3 = $rows->user_role; $field4 = $rows->status; ?>
ID Name Role Status Action