Action store id manager staff address last update staff
1 Hillyer Mike 47 Mytest Drive 15 February 2006 4:57 am

1

first name last name email
Mike Hillyer Mike.Hillyer@phpcgstaff.com
2 Stephens Jon 28 MySQL Boulevard 15 February 2006 4:57 am

1

first name last name email
Jon Stephens Jon.Stephens@phpcgstaff.com

About the current Store data list

The MySQL records displayed on this page are extracted from the "store" table.

Table store is structured as follows:

Field name Displayed name Extra
store_id store id [Primary key]
manager_staff_id manager staff
address_id address
last_update last update

Informations about the Mysql query:

  • The records are ordered by store.store_id ASC
  • records are displayed on each page
  • The following query has been sent to the server:
    SELECT `store`.`store_id`, `staff`.`last_name` AS `staff_last_name`, `staff`.`first_name` AS `staff_first_name`, `address`.`address` AS `address_address`, `store`.`last_update` FROM store LEFT JOIN `address` ON `address`.`address_id` = `store`.`address_id` LEFT JOIN `staff` ON `staff`.`staff_id` = `store`.`manager_staff_id` ORDER BY store.store_id ASC

The store list uses 1 external relational table(s).

The records of the external relational table(s) are displayed in nested table(s).


Create your own CRUD Application from your MySQL Database

This Bootstrap 4 Dashboard has been entirely designed with PHP CRUD Generator.

The current admin page lists the records of the store 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.