plugin:sql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
plugin:sql [2011-08-18 20:26] – [Discussion] 72.37.171.68 | plugin:sql [2023-08-13 15:58] – Klap-in | ||
---|---|---|---|
Line 6: | Line 6: | ||
email : slim.amamou@gmail.com | email : slim.amamou@gmail.com | ||
type : syntax | type : syntax | ||
- | lastupdate : 2007-05-07 | + | lastupdate : 2023-06-14 |
compatible : | compatible : | ||
depends | depends | ||
Line 13: | Line 13: | ||
tags : database search mysql sqlite | tags : database search mysql sqlite | ||
- | downloadurl: | + | downloadurl: |
- | sourcerepo: | + | sourcerepo: |
- | bugtracker: | + | bugtracker: |
---- | ---- | ||
===== Installation ===== | ===== Installation ===== | ||
- | ^ Download | [[http:// | + | ^ Download |
+ | ^ Repository | [[https:// | ||
Use this address to install this plugin by using the plugin manager. | Use this address to install this plugin by using the plugin manager. | ||
Line 26: | Line 27: | ||
==== Requirements ==== | ==== Requirements ==== | ||
- | * [[http:// | + | * <del>[[http:// |
- | * On Debian Etch (4.0) hosts install the packages: '' | + | * php-pdo |
Line 72: | Line 73: | ||
==== Changelog ==== | ==== Changelog ==== | ||
- | {{rss>http:// | + | {{rss>https:// |
(Old) | (Old) | ||
Line 90: | Line 91: | ||
* < | * < | ||
* make it trait multiple queries as a transaction. | * make it trait multiple queries as a transaction. | ||
- | * refactor to use [[http:// | + | * <del>refactor to use [[http:// |
* < | * < | ||
+ | * Set the db name, user name and password in the plugin configuration page not the wiki page to remove this information from public view, eg in config set comma separated triplets : mydb1: | ||
===== Known Bugs ===== | ===== Known Bugs ===== | ||
Line 126: | Line 128: | ||
</ | </ | ||
- | **You have to install the [[http:// | + | <del>You have to install the [[http:// |
+ | </ | ||
+ | |||
+ | This is not an issue anymore since today --- [[user> | ||
==== Can I use it for Oracle-Queries? | ==== Can I use it for Oracle-Queries? | ||
Line 156: | Line 161: | ||
My DokuWiki platform is Windows 2003 + IIS + PHP 5.2.4. To get the connection to MS SQL Server you need these: | My DokuWiki platform is Windows 2003 + IIS + PHP 5.2.4. To get the connection to MS SQL Server you need these: | ||
- | * PHP Extensions: [[http:// | + | * PHP Extensions: [[wp>PHP_Extension_Community_Library|PECL]] and [[wp>PHP_Extension_Community_Library# |
* Im sorry I cannot describe the PECL-installation here. I installed it simultaneously with PHP. | * Im sorry I cannot describe the PECL-installation here. I installed it simultaneously with PHP. | ||
* PEAR is installed in command prompt((DOS-window)) with '' | * PEAR is installed in command prompt((DOS-window)) with '' | ||
Line 163: | Line 168: | ||
* Check installed PEAR components with: '' | * Check installed PEAR components with: '' | ||
* See here for more: [[http:// | * See here for more: [[http:// | ||
+ | * Alternatively you can use this [[https:// | ||
* Edit PHP.ini to match this: | * Edit PHP.ini to match this: | ||
< | < | ||
Line 221: | Line 227: | ||
* plugin should use this method to register its handlers with the dokuwiki' | * plugin should use this method to register its handlers with the dokuwiki' | ||
*/ | */ | ||
- | function register(&$controller) { | + | function register(Doku_Event_Handler |
$controller-> | $controller-> | ||
} | } | ||
Line 237: | Line 243: | ||
\\ You'll probably need some more logic in the code to determine if the page has any SQL syntax. | \\ You'll probably need some more logic in the code to determine if the page has any SQL syntax. | ||
- | > I found the problem in [[http:// | + | > I found the problem in [[xref>p_cached_xhtml()]]. it is trying to get cached instructions unconditionally (ignoring '' |
>> Not a bug. Instructions should be cacheable. '' | >> Not a bug. Instructions should be cacheable. '' | ||
>>> | >>> | ||
Line 256: | Line 262: | ||
When I view the source of the page (the HTML source, not the wiki source) I see every cell has a new paragraph inside of it. This causes a lot of extra whitespace that I don't want (the cells get too big and I have to scroll, lines wrap...). | When I view the source of the page (the HTML source, not the wiki source) I see every cell has a new paragraph inside of it. This causes a lot of extra whitespace that I don't want (the cells get too big and I have to scroll, lines wrap...). | ||
- | |||
plugin/sql.txt · Last modified: 2024-02-01 18:54 by 2a01:190:5:1001:af4e:b82e:cc0a:bede