Learn about DokuWiki
Learn about DokuWiki
Mysql-for-all provides a user friendly interface to generate a mysql query. It is useful for users that do not have visibility into a database structure, do not know mysql syntax, or that want a quick query without having to check syntax or database names.
The software was created to let wiki users generate queries that can be used on wiki plugins that use mysql queries. It is written to run on a webpage outside of the wiki.
The software can be downloaded at mysql-for-all on Github
When providing user generated database information on a wiki some security precautions should be followed. This section provides suggestions of some steps that can be taken. They are not required but are recommended. This section is written towards users of the phpMyAdmin tool.
Create a database for user generated content. See Security section for setup recommendations.
If using the sample data then import the following sql scripts into your database
This will complete the necessary database setup and you can proceed to the section on installing the software. After seeing it work with the sample data, I recommend reading the next section and examining the imported tables to learn how to setup for your data.
If using your own data then you need to perform the following steps
This section is simply the tables referred to in the previous section
|#db_Relation:||this field links to another field||table field|
|#db_NoDisplay||Do not display this field|
|#db_Filter||User can filter on this field|
|#db_Default:||Default value for the Filter||value|
The Relation directive requires two parameters of a table name and a field for the linked field. A field could have multiple Relation directives.
|brief||brief description of the table||Yes|
|description||a full description of the table||No|
|date||latest date of the data in the table||No|
|source||id of the corresponding source record in source table||Yes|
|author||user that submitted the table data to your website||No|
|key||key field of the table||No|
|helper||1=helper table, 0=main table||Yes|
A helper table supports a main table and would not be displayed in the initial list of tables for the user to choose.
|website||Data source website url||No|
|data_date||Date of data||No|
To run the software on a localhost such as XAMPP:
The steps to running the software on your actual website are roughly the same except that you will need to integrate the /mysite/php code onto a webpage of your site. On my site I have integrated it on a page outside the wiki. I felt that was a more standard (ie: easier) integration and since it is not a dokuwiki plugin was not needed to be on the wiki. If your site is only a dokuwiki implementation there is material on running php from the wiki on the dokuwiki website. However I have not done so.