PHP CRUD Generator - Database dalaz_sistema

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]