phpcg users profiles

Edit

  1. Set the Read, Update, Create/Delete rights of the table you want to restrict to "Restricted" in the drodown list
  2. In the Constraint Query field, enter the WHERE query to use to limit the user's rights

Example:

WHERE your_table.phpcg_users_ID = CURRENT_USER_ID


CURRENT_USER_ID will be automatically replaced with the ID of the connected user.


Your table MUST have direct or indirect relationship with phpcg_users. For example:

  • your_table.phpcg_users_ID => phpcg_users.ID (direct relationship)
  • your_table.t2_ID => t2.ID
    t2.phpcg_users_ID => phpcg_users.ID (indirect relationship)
actor
address
category
city
country
customer
film
film_actor
film_category
inventory
language
payment
rental
staff
store
phpcg_users
CREATE/DELETE rights on users table cannot be limited - this would be a nonsense
phpcg_users_profiles

Create your own CRUD Application from your MySQL Database

This Bootstrap 4 Dashboard has been entirely designed with PHP CRUD Generator.

The current page lists the records of the 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.