CRUD Generator

Database nlenergiev-kapaz

Current Version is up to date

Choose a table
Select an action
Options from the paginated list
contract_periodMain settings
Cascade delete options
contract_periodField Names Displayed in Admin
contract_periodFilters (drop-down lists to filter results)

Use FlySpeed SQL Query to generate and test your queries

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

The query cited as an example will be the following :

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

When the user has chosen an item from the list :

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

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

contract_periodcontract_period Fields

Values : None

Values : None

Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
If you activate the generation of thumbnails you must create a folder named 'thumbs' inside your upload directory, then 3 folders inside the 'thumbs' directory named 'lg', 'md', 'sm'.

Values : None

Values : None

contract_periodExternal relations


Enabling this relationship allows you to associate one or more supplier with each table record contract_period.

The product table is in this case a pure relational table which connects the supplier to the contract_period table.

The READ LIST will display the records of the table supplier in a nested table.

Depending on your choice, the CREATE and EDIT forms will allow to associate the records of the table supplier to the contract_period added/edited,
OR to add/edit/delete the records of the table supplier.

ONE_TO_MANY Relation

If you enable this relationship, the READ LIST will display for each record in the table contract_period the matching entries of the table %original_table% in a sub-drop-down table.

If you enable the Allow users to add/edit/delete records from the READ LIST option the users will be able to add/edit/delete the records from the table product directly from this subtable.

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


getTables => Get tables from DB

getTables => generator default table = contract_period


registerColumnsProperties => From JSON : nlenergiev-kapaz/contract_period.json