Table of Contents
SQL Query Plugin
Compatible with DokuWiki
Elenor Of Tsort, Frusterick Manners, Greebo
Processing query to MySQL databases and display results as a table.
This extension has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues.
Similar to sqljson
Description
Do you want to display data from your MySQL database in DokuWiki? No problem! This simple plugin processing query to MySQL database and displaying results as a table. You also may use it with DataTables Plugin for more usability such as – sorting, searching and etc.
Please donate if you like it.
Syntax
Basic syntax:
<sql>query string</sql>
query string– SQL query to perform against the database.
Examples
Perform a simple query to display all records from the table “table”:
<sql>select * from table;</sql>
Using together with DataTables Plugin:
<datatables> <sql>select * from table;</sql> </datatables>
Configuration and Settings
The plugin can be configured via the Configuration Manager
| Option | Description | Default value |
|---|---|---|
| Host | DNS name or IP address of MySQL server | localhost |
| DB | MySQL database name | (empty) |
| user | MySQL user name | (empty) |
| password | MySQL password | (empty) |
Change Log
- 2019-05-03
- Successfully tested with “Frusterick Manners” and “Greebo” latest releases.
- 2016-11-25
- Initial release