The MySQL records displayed on this page are extracted from the "film" table.
Table film is structured as follows:
Field name
Displayed name
Extra
film_id
film id
[Primary key]
title
title
description
description
release_year
release year
language_id
language
original_language_id
original language
rental_duration
rental duration
rental_rate
rental rate
length
length
replacement_cost
replacement cost
rating
rating
special_features
special features
last_update
last update
Informations about the Mysql query:
The records are ordered by film.film_id ASC
records are displayed on each page
The following query has been sent to the server: SELECT `film`.`film_id`, `film`.`title`, `film`.`description`, `film`.`release_year`, `language`.`name` AS `language_name`, `language`.`name` AS `language_name`, `film`.`rental_duration`, `film`.`rental_rate`, `film`.`length`, `film`.`replacement_cost`, `film`.`rating`, `film`.`special_features`, `film`.`last_update` FROM film LEFT JOIN `language` ON `language`.`language_id` = `film`.`language_id` ORDER BY film.film_id ASC
The film list uses 2 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 film 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.