Current Version is up to date

PHP CRUD Generator - Database phpcg

Tools
Organize Admin Navbar
phpcg Relations
Table Column Referenced table Referenced column
address city_id city city_id
city country_id country country_id
customer address_id address address_id
customer store_id store store_id
film language_id language language_id
film original_language_id language language_id
film_actor actor_id actor actor_id
film_actor film_id film film_id
film_category category_id category category_id
film_category film_id film film_id
inventory film_id film film_id
inventory store_id store store_id
payment customer_id customer customer_id
payment rental_id rental rental_id
payment staff_id staff staff_id
rental customer_id customer customer_id
rental inventory_id inventory inventory_id
rental staff_id staff staff_id
staff address_id address address_id
staff store_id store store_id
store address_id address address_id
store manager_staff_id staff staff_id
users profiles_ID users_profiles ID
Table

All CRUD operations are disabled in this demo.

Select an action
Build Read List
Build Create / Update Forms
Build Delete Form
Options from the paginated list
Main settings
actor

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"
Column number
Index of the filtered column in the paged list
Used to color the filtered column. The index starts at number 1.
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.

Filter field
Filter field
actor

Values : None

Values : None

[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/

Values : None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM
External relations
MANY_TO_MANY Relation

Enabling this relationship allows you to associate one or more film with each table record actor.

The film_actor table is in this case a pure relational table which connects the film to the actor table.

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

The CREATE and EDIT forms will allow to associate the records of the table film to the actor added/edited.

ONE_TO_MANY Relation

If you enable this relationship, the READ LIST will display for each record in the table actor 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 film_actor directly from this subtable.

Choose the field types and options for Create | Update
actor

Auto-increment fields values are automatically generated in CREATE forms
Validation is automatic and cannot be changed

[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/
Leave blank if no limitation
Leave blank if no limitation
Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM
No html
required($message = null)
integer($message = null)
min($limit, $include = TRUE, $message = null)
max($limit, $include = TRUE, $message = null)
[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/
Leave blank if no limitation
Leave blank if no limitation
Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM
No html
required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/
Leave blank if no limitation
Leave blank if no limitation
Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM
No html
required($message = null)
maxLength($length, $message = null)
[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/
Leave blank if no limitation
Leave blank if no limitation
Hide the field and set the value to the current date (no|yes)

None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM
No html
required($message = null)
date($message = null)
External relations
Single record list options
Main settings
actor
actor

Values : None

Values : None

[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/

Values : None

[ROOT_PATH]/
[ROOT_URL]/
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
[ROOT_PATH]/
[ROOT_URL]/

Values : None

Rule Description Result
d Date of the month 1 – 31
dd Date of the month with a leading zero 01 – 31
ddd Day of the week in short form Sun – Sat
dddd Day of the week in full form Sunday – Saturday
m Month of the year 1 – 12
mm Month of the year with a leading zero 01 – 12
mmm Month name in short form Jan – Dec
mmmm Month name in full form January – December
yy Year in short form * 00 – 99
yyyy Year in full form 2000 – 2999
Rule Description Result
h Hour in 12-hour format 1 – 12
hh Hour in 12-hour format with a leading zero 01 – 12
H Hour in 24-hour format 0 – 23
HH Hour in 24-hour format with a leading zero 00 – 23
i Minutes 00 – 59
a Day time period a.m. / p.m.
A Day time period in uppercase AM / PM
External relations
MANY_TO_MANY Relation

Enabling this relationship allows you to associate one or more film with each table record actor.

The film_actor table is in this case a pure relational table which connects the film to the actor table.

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

The CREATE and EDIT forms will allow to associate the records of the table film to the actor added/edited.

ONE_TO_MANY Relation

If you enable this relationship, the READ LIST will display for each record in the table actor 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 film_actor directly from this subtable.

Options for the deletion form

Fields displayed to user in admin to confirm deletion