Action Id Profile name Read actor Update actor Create/Delete actor Constraint query actor Read address Update address Create/Delete address Constraint query address Read category Update category Create/Delete category Constraint query category Read city Update city Create/Delete city Constraint query city Read country Update country Create/Delete country Constraint query country Read customer Update customer Create/Delete customer Constraint query customer Read film Update film Create/Delete film Constraint query film Read film actor Update film actor Create/Delete film actor Constraint query film actor Read film category Update film category Create/Delete film category Constraint query film category Read inventory Update inventory Create/Delete inventory Constraint query inventory Read language Update language Create/Delete language Constraint query language Read payment Update payment Create/Delete payment Constraint query payment Read rental Update rental Create/Delete rental Constraint query rental Read staff Update staff Create/Delete staff Constraint query staff Read store Update store Create/Delete store Constraint query store Read phpcg users Update phpcg users Create/Delete phpcg users Constraint query phpcg users Read phpcg users profiles Update phpcg users profiles Create/Delete phpcg users profiles Constraint query phpcg users profiles
Restricted superadmin Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Results 1 to 1 of 1

About the current Phpcg_users_profiles data list

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

Table phpcg_users_profiles is structured as follows:

Field name Displayed name Extra
id Id
profile_name Profile name
r_actor Read actor
u_actor Update actor
cd_actor Create/Delete actor
cq_actor Constraint query actor
r_address Read address
u_address Update address
cd_address Create/Delete address
cq_address Constraint query address
r_category Read category
u_category Update category
cd_category Create/Delete category
cq_category Constraint query category
r_city Read city
u_city Update city
cd_city Create/Delete city
cq_city Constraint query city
r_country Read country
u_country Update country
cd_country Create/Delete country
cq_country Constraint query country
r_customer Read customer
u_customer Update customer
cd_customer Create/Delete customer
cq_customer Constraint query customer
r_film Read film
u_film Update film
cd_film Create/Delete film
cq_film Constraint query film
r_film_actor Read film actor
u_film_actor Update film actor
cd_film_actor Create/Delete film actor
cq_film_actor Constraint query film actor
r_film_category Read film category
u_film_category Update film category
cd_film_category Create/Delete film category
cq_film_category Constraint query film category
r_inventory Read inventory
u_inventory Update inventory
cd_inventory Create/Delete inventory
cq_inventory Constraint query inventory
r_language Read language
u_language Update language
cd_language Create/Delete language
cq_language Constraint query language
r_payment Read payment
u_payment Update payment
cd_payment Create/Delete payment
cq_payment Constraint query payment
r_rental Read rental
u_rental Update rental
cd_rental Create/Delete rental
cq_rental Constraint query rental
r_staff Read staff
u_staff Update staff
cd_staff Create/Delete staff
cq_staff Constraint query staff
r_store Read store
u_store Update store
cd_store Create/Delete store
cq_store Constraint query store
r_phpcg_users Read phpcg users
u_phpcg_users Update phpcg users
cd_phpcg_users Create/Delete phpcg users
cq_phpcg_users Constraint query phpcg users
r_phpcg_users_profiles Read phpcg users profiles
u_phpcg_users_profiles Update phpcg users profiles
cd_phpcg_users_profiles Create/Delete phpcg users profiles
cq_phpcg_users_profiles Constraint query phpcg users profiles

Informations about the Mysql query:

  • The records are ordered by phpcg_users_profiles.id ASC
  • records are displayed on each page

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

Customise the theme and navigation bars