Delete selected records? ( Records)
The MySQL records displayed on this page are extracted from the "customer" table.
Table customer is structured as follows:
| Field name | Displayed name | Extra |
|---|---|---|
| customer_id | customer id | [Primary key] |
| store_id | store | |
| first_name | first name | |
| last_name | last name | |
| address_id | address | |
| active | active | |
| create_date | create date | |
| last_update | last update |
SELECT `customer`.`customer_id`, `store`.`store_id` AS `store_store_id`, `customer`.`first_name`, `customer`.`last_name`, `customer`.`email`, `address`.`address` AS `address_address`, `customer`.`active`, `customer`.`create_date`, `customer`.`last_update` FROM customer LEFT JOIN `address` ON `address`.`address_id` = `customer`.`address_id` LEFT JOIN `store` ON `store`.`store_id` = `customer`.`store_id` ORDER BY customer.last_name ASC
The customer list uses 2 external relational table(s).
The records of the external relational table(s) are displayed in nested table(s).
This Bootstrap 4 Dashboard has been entirely designed with PHP CRUD Generator.
The current admin page lists the records of the customer table.
PHP CRUD Generator allows to build this type of PHP admin dashboard in a very simple way and without programming.
The CRUD application analyzes your SQL database and extracts all its components: tables, relationships, fields, primary and secondary keys, field and data types, ...
The CRUD system is able to generate an admin dashboard such as this one from any MySQL database, no matter how complex it is.
PHP CRUD Generator is available at a very low price here on Codecanyon.
1 license = 1 project, no recurring payments, 6 months of support included, a professional web application, no known bugs, ... and tons of work saved.