Tag: sql
11 results
Reports
Nathan Pitman (Nine Four Ltd)
ExpressionEngine 1.x, ExpressionEngine 2
An ExpressionEngine 1.x and 2.x module which allows for the export of SQL query based reports through a friendly control panel interface. The module can also perform post processing on queries prior to export in CSV format.
- No Reviews.
- Rating - 5.001 Vote
- 0 Favs
- Fieldtype
- tags: multi-select menu, country select, multiselect, custom drop down, dropdown, drop-down, menu, ajax, sql
- Plugin
- tags: channel entries, query, sql
Channel Query
Exp:resso
ExpressionEngine 2
This plugin lets you display channel entries using a custom SQL query. It brings you the benefits of combining the {exp:query} tag with the {exp:channel:entries} tag, without having to worry about GROUP_CONCAT or parse order.
- 1 Review
- Rating - 4.502 Votes
- 4 Favs
- Plugin
- tags: secure, escape, encode, query module, query string, html injection, sql, html, output, variable, escaping
Escape
EpicVoyage
ExpressionEngine 2
Provides variable escaping for SQL or HTML output
- No Reviews.
- Rating - 0.00No Votes
- 1 Fave
- Module
- tags: entry_id, sql, query, pagination, entry_ids, ab, entry, ids, pipe, separated, delimited, mysql, return
AB Entry IDs
Bjorn Borresen
ExpressionEngine 2
Run SQL and get the results returned as a |-separated list of entry_ids which you can use as a parameter in another tag (ie. the {exp:channel:entries} tag).
- No Reviews.
- Rating - 0.00No Votes
- 3 Favs
- Fieldtype
- tags: datasource, custom, select, database, dropdown, matrix, matrix celltype, matrix compatible, sql, dropdown fieldtype, table, pull, value, label, column
SP Table Select
Jamie Rumbelow
ExpressionEngine 2
SP Table Select from Sparkplugs allows you to setup a dropdown that pulls its values and labels from arbitrary columns in an arbitrary database table. It fully supports Matrix and for greater customisability, custom SQL queries.
- 2 Reviews
- Rating - 3.002 Votes
- 7 Favs
- Plugin
- tags: activerecord, db, sql, mysql, query, data, database, codeigniter, code, ignitre, active, record, pattern
Active Record
Rob Sanchez
ExpressionEngine 2
Use the CodeIgniter Active Record pattern in an ExpressionEngine plugin.
- 2 Reviews
- Rating - 5.0010 Votes
- 46 Favs
Select Entries
Adam Khan
ExpressionEngine 1.x, ExpressionEngine 2
This plugin has been wrapped into the External Entries plugin and has been discontinued.
- 1 Review
- Rating - 3.001 Vote
- 0 Favs
- Plugin
- tags: row, add, sql, insert, integration, integrate, export, mysql, database, within, templates
Insert Entries
Adam Khan
ExpressionEngine 1.x, ExpressionEngine 2
This plugin has been wrapped into the External Entries plugin and discontinued.
- No Reviews.
- Rating - No Votes
- 2 Favs