PHP CRUD GENERATOR version 1.28 is available
Just click & relax, the updater is safe, it won't break anything
Need help?
Use FlySpeed SQL Query to generate and test your queries
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.
table.field
field
Values : None
Comma separated list. Example: doc, docx, xls, xlsx, pdf, txt
d
dd
ddd
dddd
m
mm
mmm
mmmm
yy
yyyy
h
hh
H
HH
i
a
A
Auto-increment fields values are automatically generated in CREATE formsValidation is automatic and cannot be changed
Leave blank if no limitation
Hide the field and set the value to the current date (no|yes)
None
No html
Fields displayed to user in admin to confirm deletion