Action payment id customer staff rental amount payment date
174 MARIA MILLER Jon Stephens 2005-05-25 06:04:08 5.99 25 May 2005 6:4 am
146 JENNIFER DAVIS Jon Stephens 2005-05-25 08:43:32 4.99 25 May 2005 8:43 am
175 MARIA MILLER Jon Stephens 2005-05-25 19:30:46 0.99 25 May 2005 19:30 pm
33 PATRICIA JOHNSON Mike Hillyer 4.99 27 May 2005 0:9 am
60 LINDA WILLIAMS Mike Hillyer 1.99 27 May 2005 17:17 pm
2 MARY SMITH Mike Hillyer 2005-05-25 06:04:08 0.99 28 May 2005 10:35 am
147 JENNIFER DAVIS Mike Hillyer 2.99 28 May 2005 11:9 am
108 ELIZABETH BROWN Mike Hillyer 0.99 29 May 2005 7:25 am
176 MARIA MILLER Jon Stephens 2.99 29 May 2005 9:27 am
61 LINDA WILLIAMS Mike Hillyer 2.99 29 May 2005 22:43 pm
148 JENNIFER DAVIS Jon Stephens 0.99 30 May 2005 11:25 am
177 MARIA MILLER Mike Hillyer 4.99 30 May 2005 21:7 pm
178 MARIA MILLER Mike Hillyer 5.99 31 May 2005 8:44 am
109 ELIZABETH BROWN Mike Hillyer 6.99 31 May 2005 11:15 am
110 ELIZABETH BROWN Mike Hillyer 1.99 31 May 2005 19:46 pm
3 MARY SMITH Mike Hillyer 5.99 15 June 2005 0:54 am
86 BARBARA JONES Mike Hillyer 4.99 15 June 2005 9:31 am
4 MARY SMITH Jon Stephens 0.99 15 June 2005 18:2 pm
5 MARY SMITH Jon Stephens 9.99 15 June 2005 21:8 pm
111 ELIZABETH BROWN Mike Hillyer 3.99 15 June 2005 22:3 pm

About the current Payment data list

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

Table payment is structured as follows:

Field name Displayed name Extra
payment_id payment id [Primary key]
customer_id customer
staff_id staff
rental_id rental
amount amount
payment_date payment date
last_update last update

Informations about the Mysql query:

  • The records are ordered by payment.payment_date ASC
  • records are displayed on each page
  • The following query has been sent to the server:
    SELECT `payment`.`payment_id`, `customer`.`first_name` AS `customer_first_name`, `customer`.`last_name` AS `customer_last_name`, `staff`.`first_name` AS `staff_first_name`, `staff`.`last_name` AS `staff_last_name`, `rental`.`rental_date` AS `rental_rental_date`, `payment`.`amount`, `payment`.`payment_date`, `payment`.`last_update` FROM payment LEFT JOIN `customer` ON `customer`.`customer_id` = `payment`.`customer_id` LEFT JOIN `rental` ON `rental`.`rental_id` = `payment`.`rental_id` LEFT JOIN `staff` ON `staff`.`staff_id` = `payment`.`staff_id` ORDER BY payment.payment_date ASC

The payment 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 payment 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.