DokuWiki

It's better when it's simple

User Tools

Site Tools


plugin:sqlquery

SQL Query Plugin

Compatible with DokuWiki

Elenor Of Tsort, Frusterick Manners, Greebo

plugin Processing query to MySQL databases and display results as a table.

Last updated on
2019-05-03
Provides
Syntax
Repository
Source

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

Tagged with database, mysql, query, sql

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

Discussion, feature requests and bug reports

plugin/sqlquery.txt · Last modified: 2019-05-03 17:30 by George Pirogov

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki