Action staff id first name last name address picture email store active username password last update
1 Mike Hillyer 23 Workhaven Lane - Mike.Hillyer@phpcgstaff.com 1 Mike 8cb2237d0679ca88db6464eac60da96345513964 15 February 2006 3:57 am
2 Jon Stephens 1411 Lillydale Drive - Jon.Stephens@phpcgstaff.com 2 Jon 15 February 2006 3:57 am

About the current Staff data list

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

Table staff is structured as follows:

Field name Displayed name Extra
staff_id staff id [Primary key]
first_name first name
last_name last name
address_id address
picture picture
email email
store_id store
active active
username username
password password
last_update last update

Informations about the Mysql query:

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

The staff list doesn't use any external relational table.


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 staff 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.