PHP CRUD GENERATOR

PHP CRUD GENERATOR

Customer list

Add new
 
Action customer id first name last name email address active create date last update payment rental
1 MARY SMITH MARY.SMITH@phpcgcustomer.org 1913 Hanoi Way 13 December 2019 1:15 am 12 December 2019 5:0 am

31

Add new payment
payment id amount payment date Action
2 0.99 2005-05-28 10:35:00
3 5.99 2005-06-15 00:54:12
4 0.99 2005-06-15 18:02:53
5 9.99 2005-06-15 21:08:46
6 4.99 2005-06-16 15:18:57
7 4.99 2005-06-18 08:41:48
8 0.99 2005-06-18 13:33:59
9 3.99 2005-06-21 06:24:45
10 5.99 2005-07-08 03:17:05
11 5.99 2005-07-08 07:33:56
12 4.99 2005-07-09 13:24:07
13 4.99 2005-07-09 16:38:01
14 7.99 2005-07-11 10:13:46
15 2.99 2005-07-27 11:31:22
16 4.99 2005-07-28 09:04:45
17 4.99 2005-07-28 16:18:23
18 0.99 2005-07-28 17:33:39
19 0.99 2005-07-28 19:20:07
20 2.99 2005-07-29 03:58:49
21 2.99 2005-07-31 02:42:18
22 4.99 2005-08-01 08:51:04
23 3.99 2005-08-02 15:36:52
24 0.99 2005-08-02 18:01:38
25 4.99 2005-08-17 12:37:54
26 0.99 2005-08-18 03:57:29
27 0.99 2005-08-19 09:55:16
28 2.99 2005-08-19 13:56:54
29 0.99 2005-08-21 23:33:57
30 1.99 2005-08-22 01:27:57
31 2.99 2005-08-22 19:41:37
32 5.99 2005-08-22 20:03:46

1

Add new rental
rental id rental date Action
76 2005-05-25 11:30:37
2 PATRICIA JOHNSON PATRICIA.JOHNSON@phpcgcustomer.org 1121 Loja Avenue 14 February 2006 22:4 pm 15 February 2006 4:57 am

27

Add new payment
payment id amount payment date Action
33 4.99 2005-05-27 00:09:24
34 2.99 2005-06-17 20:54:58
35 2.99 2005-07-10 06:31:24
36 6.99 2005-07-10 12:38:56
37 4.99 2005-07-27 14:30:42
38 5.99 2005-07-27 15:23:02
39 5.99 2005-07-27 18:40:20
40 5.99 2005-07-29 00:12:59
41 2.99 2005-07-29 12:56:59
42 5.99 2005-07-29 17:14:29
43 4.99 2005-07-30 06:06:10
44 10.99 2005-07-30 13:47:43
45 0.99 2005-07-30 14:14:11
46 6.99 2005-07-30 16:21:13
47 6.99 2005-07-30 22:39:53
48 2.99 2005-07-31 21:58:56
49 0.99 2005-08-01 09:45:26
50 0.99 2005-08-02 02:10:56
51 5.99 2005-08-02 07:41:41
52 6.99 2005-08-02 10:43:48
53 2.99 2005-08-02 13:44:53
54 2.99 2005-08-17 03:52:18
55 2.99 2005-08-19 06:26:04
56 4.99 2005-08-21 13:24:32
57 5.99 2005-08-21 22:41:56
58 4.99 2005-08-22 13:53:04
59 4.99 2005-08-23 17:39:35
Add new
3 LINDA WILLIAMS LINDA.WILLIAMS@phpcgcustomer.org 692 Joliet Street 14 February 2006 22:4 pm 15 February 2006 4:57 am

26

Add new payment
payment id amount payment date Action
60 1.99 2005-05-27 17:17:09
61 2.99 2005-05-29 22:43:55
62 8.99 2005-06-16 01:34:05
63 6.99 2005-06-16 15:19:10
64 6.99 2005-06-17 05:15:15
65 2.99 2005-06-19 08:34:53
66 4.99 2005-07-07 10:23:25
67 4.99 2005-07-08 12:47:11
68 5.99 2005-07-27 04:54:42
69 10.99 2005-07-27 20:23:12
70 7.99 2005-07-28 03:59:21
71 6.99 2005-07-28 04:46:30
72 4.99 2005-07-28 11:46:45
73 4.99 2005-07-28 18:17:14
74 2.99 2005-07-29 11:07:04
75 1.99 2005-07-30 13:31:20
76 3.99 2005-07-30 21:45:46
77 2.99 2005-07-31 03:27:58
78 4.99 2005-07-31 11:32:58
79 5.99 2005-08-01 14:19:48
80 4.99 2005-08-18 14:49:55
81 8.99 2005-08-19 22:18:07
82 2.99 2005-08-20 06:14:12
83 8.99 2005-08-21 20:50:48
84 0.99 2005-08-22 09:37:27
85 2.99 2005-08-23 07:10:14
Add new
4 BARBARA JONES BARBARA.JONES@phpcgcustomer.org 1566 Inegl Manor 14 February 2006 22:4 pm 15 February 2006 4:57 am

22

Add new payment
payment id amount payment date Action
86 4.99 2005-06-15 09:31:28
87 0.99 2005-06-16 08:08:40
88 2.99 2005-06-16 14:01:27
89 0.99 2005-06-16 15:51:52
90 0.99 2005-06-17 14:31:12
91 5.99 2005-06-19 09:39:01
92 2.99 2005-07-28 02:10:10
93 2.99 2005-07-28 04:37:59
94 3.99 2005-07-29 18:44:57
95 5.99 2005-07-30 08:46:09
96 5.99 2005-07-30 18:58:00
97 0.99 2005-08-02 07:09:34
98 2.99 2005-08-02 08:20:31
99 4.99 2005-08-17 00:28:01
100 2.99 2005-08-18 00:14:03
101 8.99 2005-08-18 05:14:44
102 1.99 2005-08-19 02:19:13
103 2.99 2005-08-20 09:32:04
104 6.99 2005-08-20 12:55:40
105 4.99 2005-08-21 04:53:37
106 2.99 2005-08-22 13:58:23
107 1.99 2005-08-23 07:43:00
Add new
5 ELIZABETH BROWN ELIZABETH.BROWN@phpcgcustomer.org 53 Idfu Parkway 14 February 2006 22:4 pm 15 February 2006 4:57 am

38

Add new payment
payment id amount payment date Action
108 0.99 2005-05-29 07:25:16
109 6.99 2005-05-31 11:15:43
110 1.99 2005-05-31 19:46:38
111 3.99 2005-06-15 22:03:14
112 2.99 2005-06-16 08:01:02
113 4.99 2005-06-17 15:56:53
114 2.99 2005-06-19 04:20:13
115 4.99 2005-06-20 18:38:22
116 4.99 2005-07-06 09:11:58
117 2.99 2005-07-08 20:04:43
118 4.99 2005-07-09 01:57:57
119 5.99 2005-07-09 07:13:52
120 1.99 2005-07-09 08:51:42
121 0.99 2005-07-10 11:09:35
122 8.99 2005-07-11 03:17:04
123 3.99 2005-07-12 11:27:35
124 4.99 2005-07-12 12:16:28
125 0.99 2005-07-27 12:37:28
126 0.99 2005-07-28 01:50:29
127 3.99 2005-07-28 08:43:39
128 2.99 2005-07-29 01:11:23
129 1.99 2005-07-30 04:14:28
130 4.99 2005-07-30 23:52:30
131 3.99 2005-07-31 14:00:53
132 4.99 2005-08-01 14:48:45
133 0.99 2005-08-01 15:27:10
134 4.99 2005-08-02 04:56:45
135 4.99 2005-08-02 10:50:06
136 3.99 2005-08-17 16:28:53
137 9.99 2005-08-18 00:10:04
138 2.99 2005-08-19 00:24:08
139 1.99 2005-08-19 09:45:41
140 0.99 2005-08-20 15:16:18
141 6.99 2005-08-20 22:13:59
142 6.99 2005-08-21 11:31:11
143 2.99 2005-08-21 14:02:50
144 0.99 2005-08-22 17:37:02
145 0.99 2006-02-14 15:16:03
Add new
6 JENNIFER DAVIS JENNIFER.DAVIS@phpcgcustomer.org 1795 Santiago de Compostela Way 14 February 2006 22:4 pm 15 February 2006 4:57 am

28

Add new payment
payment id amount payment date Action
146 4.99 2005-05-25 08:43:32
147 2.99 2005-05-28 11:09:14
148 0.99 2005-05-30 11:25:01
149 3.99 2005-06-16 03:41:38
150 2.99 2005-06-16 23:44:13
151 0.99 2005-06-17 09:19:45
152 0.99 2005-06-18 12:03:23
153 0.99 2005-07-06 23:14:21
154 2.99 2005-07-07 14:53:24
155 0.99 2005-07-10 03:03:35
156 5.99 2005-07-11 12:39:01
157 7.99 2005-07-11 15:01:54
158 0.99 2005-07-12 12:18:38
159 2.99 2005-07-27 05:03:44
160 2.99 2005-07-27 06:38:25
161 0.99 2005-07-28 18:47:23
162 2.99 2005-08-01 03:13:39
163 2.99 2005-08-02 05:36:38
164 3.99 2005-08-02 18:55:15
165 6.99 2005-08-17 02:29:41
166 0.99 2005-08-17 08:12:20
167 0.99 2005-08-17 13:39:32
168 2.99 2005-08-18 04:05:29
169 6.99 2005-08-20 00:18:25
170 7.99 2005-08-21 08:22:56
171 4.99 2005-08-21 09:49:28
172 5.99 2005-08-23 02:51:24
173 0.99 2005-08-23 06:41:32

1

Add new rental
rental id rental date Action
57 2005-05-25 08:43:32
7 MARIA MILLER MARIA.MILLER@phpcgcustomer.org 900 Santiago de Compostela Parkway 14 February 2006 22:4 pm 15 February 2006 4:57 am

27

Add new payment
payment id amount payment date Action
174 5.99 2005-05-25 06:04:08
175 0.99 2005-05-25 19:30:46
176 2.99 2005-05-29 09:27:00
177 4.99 2005-05-30 21:07:15
178 5.99 2005-05-31 08:44:29
179 0.99 2005-06-16 21:06:00
180 2.99 2005-06-18 05:03:36
181 0.99 2005-06-19 14:00:26
182 4.99 2005-06-20 01:50:56
183 0.99 2005-06-20 10:11:53
184 5.99 2005-07-06 07:09:17
185 2.99 2005-07-07 13:22:20
186 5.99 2005-07-08 16:16:04
187 4.99 2005-07-08 18:47:38
188 8.99 2005-07-09 21:52:05
189 7.99 2005-07-10 21:35:12
190 1.99 2005-07-11 10:36:28
191 2.99 2005-07-11 17:30:58
192 3.99 2005-07-12 15:17:42
193 5.99 2005-07-29 07:02:55
194 7.99 2005-07-31 04:30:03
195 6.99 2005-08-01 04:57:04
196 5.99 2005-08-01 08:19:53
197 4.99 2005-08-01 11:39:26
198 4.99 2005-08-01 15:52:00
199 3.99 2005-08-02 04:40:54
200 7.99 2005-08-17 00:51:32

2

Add new rental
rental id rental date Action
46 2005-05-25 06:04:08
117 2005-05-25 19:30:46
8 SUSAN WILSON SUSAN.WILSON@phpcgcustomer.org 478 Joliet Way 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
9 MARGARET MOORE MARGARET.MOORE@phpcgcustomer.org 613 Korolev Drive 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
10 DOROTHY TAYLOR DOROTHY.TAYLOR@phpcgcustomer.org 1531 Sal Drive 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
11 LISA ANDERSON LISA.ANDERSON@phpcgcustomer.org 1542 Tarlac Parkway 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
12 NANCY THOMAS NANCY.THOMAS@phpcgcustomer.org 808 Bhopal Manor 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
13 KAREN JACKSON KAREN.JACKSON@phpcgcustomer.org 270 Amroha Parkway 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
14 BETTY WHITE BETTY.WHITE@phpcgcustomer.org 770 Bydgoszcz Avenue 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new

1

Add new rental
rental id rental date Action
151 2005-05-26 00:37:28
15 HELEN HARRIS HELEN.HARRIS@phpcgcustomer.org 419 Iligan Lane 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
16 SANDRA MARTIN SANDRA.MARTIN@phpcgcustomer.org 360 Toulouse Parkway 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
17 DONNA THOMPSON DONNA.THOMPSON@phpcgcustomer.org 270 Toulon Boulevard 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
19 RUTH MARTINEZ RUTH.MARTINEZ@phpcgcustomer.org 1417 Lancaster Avenue 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new

3

Add new rental
rental id rental date Action
18 2005-05-25 01:10:47
110 2005-05-25 18:43:49
179 2005-05-26 04:26:06
21 MICHELLE CLARK MICHELLE.CLARK@phpcgcustomer.org 262 A Corua (La Corua) Parkway 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new
22 LAURA RODRIGUEZ LAURA.RODRIGUEZ@phpcgcustomer.org 28 Charlotte Amalie Street 14 February 2006 22:4 pm 15 February 2006 4:57 am
Add new
Add new

Results 1 to 20 of 249

About the current Customer data list

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
email email
address_id address
active active
create_date create date
last_update last update

Informations about the Mysql query:

  • The records are ordered by customer.customer_id ASC
  • records are displayed on each page
  • The following query has been sent to the server:
    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.customer_id ASC

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