Help/SqlResultPlugin
The SqlResult plugin displays results of arbitrary SQL select statements in table form.
The database definition, the DSN, must be defined in the local file config/SqlResult.ini
A simple textfile with alias = dsn lines.
Optional template file to format the result and handle some logic.
Template vars: %%where%%, %%sortby%%, %%limit%%
Usage
<<SqlResult parameters SELECT statement >>
Arguments
Argument |
Description |
Default value |
---|---|---|
alias |
DSN database specification |
false |
ordered |
if to display as <ol> list: single col only without template |
false |
template |
use a custom <theme>/template.tmpl |
false |
where |
custom filter for the query |
false |
sortby |
for paging |
false (no paging) |
limit |
for paging |
0,50 (only the first 50) |
Examples
<<SqlResult alias=mysql SELECT 'mysql password for string "xx":', PASSWORD('xx') >> <<SqlResult alias=videos template=videos SELECT rating,title,date FROM video ORDER BY rating DESC LIMIT 5 >> <<SqlResult alias=imdb template=imdbmovies where||="Davies, Jeremy%" SELECT m.title, m.date, n.name, c.role FROM movies as m, names as n, jobs as j, characters as c WHERE n.name LIKE "%%where%%" AND m.title_id = c.title_id AND n.name_id = c.name_id AND c.job_id = j.job_id AND j.description = 'Actor' ORDER BY m.date DESC >>