Phpcg users profiles

Add new

  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)
CREATE/DELETE rights on users table cannot be limited - this would be a nonsense

Create your own CRUD Application from your MySQL Database

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

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