Diff: Help/SqlResultPlugin
Note: You are viewing an old revision of this page. View the current version.
Differences between version 5 and previous revision of Help/SqlResultPlugin.
Other diffs: Previous Major Revision, Previous Author
Newer page: | version 5 | Last edited on 9 September 2007 0:16 | by harold | Revert |
Older page: | version 4 | Last edited on 22 May 2014 3:01 | by harold | Revert |
@@ -1,86 +1,27 @@
-The **~SqlResult** [[Help:WikiPlugin|plugin]] displays results of arbitrary SQL select statements in table form.
+_short description_
-The database definition, the DSN, must be defined in the local file ##config/
SqlResult.ini##
+! Usage
+<verbatim>
+ <?plugin
SqlResult ?>
+</verbatim>
-A simple textfile with alias = dsn lines.
+! Arguments
-Optional template file
to format the result and handle some logic
.
+page _(default: current pagename)_:
+ The page
to execute upon
.
-Template vars: %%where%%, %%sortby%%, %%limit%%
+! Example
-== Usage ==
-{{{
-<<
SqlResult parameters
-SELECT statement
->>
-}}}
+<verbatim>
+<?plugin
SqlResult ?>
+</verbatim
>
-== Arguments ==
+<?plugin SqlResult ?>
-{| class="bordered"
-|-
-
! 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)
-|}
+! Author
+PhpWiki
:ReiniUrban
-== Examples ==
+! See Also
-{{{
-<<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
->>
-}}}
-
-== Author ==
-* [[Help:Reini Urban|Reini Urban]]
-
-== See Also ==
-
-<noinclude>
----
-[[
PhpWikiDocumentation]] [[CategoryWikiPlugin]]
-</noinclude>
+PhpWikiDocumentation Help:WikiPlugin
version 5
short description
Usage
<?plugin SqlResult ?>
Arguments
- page (default: current pagename)
- The page to execute upon.
Example
<?plugin SqlResult ?>Plugin SqlResult failed. No DSN alias for SqlResult.ini specified