CRUD Generator

Database panel

Choose a table
Select an action
Options from the paginated list
phpcg_usersMain settings
phpcg_usersField Names Displayed in Admin
phpcg_usersFilters (drop-down lists to filter results)

Use FlySpeed SQL Query to generate and test your queries

Label
Label displayed next to the drop-down list.
Example : "Author"
Value(s)
Fields to be displayed in the drop-down list, separated by "+".
Example : "authors.name + authors.first_name"
Fields
Fields for the query SQL SELECT.
Example : "authors.name, authors.first_name, articles.authors_id"
Fields to be filtered
The field used to filter the query.
Example : "articles.authors_id"
SQL FROM
SQL FROM query.
Example : "articles Left Join authors On articles.authors_id = authors.id"
Type of values
Text or Boolean.

The query cited as an example will be the following :

SELECT DISTINCT authors.name, authors.first_name, articles.authors_id FROM articles INNER JOIN authors ON articles.authors_id = authors.id

When the user has chosen an item from the list :

SELECT DISTINCT authors.name, authors.first_name, articles.authors_id FROM articles INNER JOIN authors ON articles.authors_id = authors.id WHERE articles.authors_id = [posted value]

Use table.field rather than field to avoid ambiguous queries.

Enable ajax loading if your table contains a lot of records.
Filter field
Enable ajax loading if your table contains a lot of records.
Filter field
Enable ajax loading if your table contains a lot of records.
Filter field
phpcg_usersphpcg_users Fields

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : phpcg_users_profiles.profile_name

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/ class="phpfb-addon-before"
[ROOT_URL]/ class="phpfb-addon-before"

Values : None

Options for the deletion form

Fields displayed to user in admin to confirm deletion

 

PHP CRUD Generator - Configuration

PHP CRUD Generator - Compare files

PHP CRUD Generator - Authentication module

The user authentication module is enabled

construct

getTables => Get tables from DB

getTables => generator default table = phpcg_users

getDbColumns

registerColumnsProperties => From JSON : panel/phpcg_users.json