====== crossdbsqlclient Plugin ======

---- plugin ----
description: A GUI-Interface in Dokuwiki to execute sql on MySQL and PostgreSQL.
author     : Soft2C.de
email      : info@soft2c.de
type       : Action, Syntax
lastupdate : 2016-07-08
compatible : 2016-06-26 "Elenor Of Tsort",2012-10-13 "Adora Belle",2013-05-10a "Weatherwax",Release 2013-12-08 "Binky",Release 2014-05-05e "Ponder Stibbons",Release 2014-09-29d "Hrun", 2015-08-10 "Detritus"
tags       : mySql-client, mySql-GUI, mySql-Interface, database, tables 

downloadurl: http://www.soft2c.de/pub/crossdbsqlclient.zip
donationurl: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=GN27JNRYKUYTG
----

===== Description =====

This is a very simple SQL-Client for MySQL. Some helper and template buttons are available in plugin. One or more (; separated) SQL can be executed by an database transaction. 

===== Configuration and Settings =====

In Admin-Section is to configurate the plugin. You have to set the database name, user, passwort and the host. Than you can allow some users or some groups (comma separated) to access the database via plugin. 

===== Installation =====

Download the plugin at [[http://www.soft2c.de/pub/crossdbsqlclient.zip|crossdbsqlclient.zip]] and extract the zip file to the plugin folder on your dokuwiki.


===== Examples/Usage =====

Example to activate the plugin on your page:

==== Default-DB via Admin-Configuration page ====
<code>
{{crossdbsqlclient}}
</code>

==== DB via page level url ====

<code>
{{crossdbsqlclient>type|server|database|user|password}}
</code>

  * type can be mysql or postgresql
  * server can be the host with port delimitted by :

e.g.
<code>
{{crossdbsqlclient>postgresql|localhost:54321|testdb|tester|pwd}}
</code>

===== Syntax =====

With the string ''%%{{crossdbsqlclient}}%%'' on the page level you activates the plugin.

Also, the plugin is on page level.


===== Development =====

===== Change Log =====

  * **2016-07-08** Initial release, first version
  * **2016-07-11** Update description

=== ToDo/Wish List ===
===== FAQ =====

===== Discussion =====