DokuWiki

It's better when it's simple

User Tools

Site Tools

Trace: • autopasswd • bootstrap3
plugin:sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
plugin:sql [2020-02-27 19:34] – Aleksandrplugin:sql [2024-02-01 18:54] (current) – 2a01:190:5:1001:af4e:b82e:cc0a:bede
Line 6: Line 6:
 email      : slim.amamou@gmail.com email      : slim.amamou@gmail.com
 type       : syntax type       : syntax
-lastupdate : 2019-04-25+lastupdate : 2023-06-14
 compatible :  compatible : 
 depends    :  depends    : 
Line 15: Line 15:
 downloadurl: https://github.com/ALIXSYS/plugin-sql/archive/master.zip downloadurl: https://github.com/ALIXSYS/plugin-sql/archive/master.zip
 sourcerepo:  https://github.com/ALIXSYS/plugin-sql sourcerepo:  https://github.com/ALIXSYS/plugin-sql
-bugtracker:  https://github.com/lupo49/plugin-sql/issues+bugtracker:  https://github.com/ALIXSYS/plugin-sql/issues
 ---- ----
 +__The file //plugin.info.txt// is not up to date! And //issues// are not enabled in the repository! Please fix this!__
  
 ===== Installation ===== ===== Installation =====
Line 161: Line 162:
  
 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://en.wikipedia.org/wiki/PHP_Extension_Community_Library|PECL]] and [[http://en.wikipedia.org/wiki/PHP_Extension_Community_Library#External_links|PEAR]].+  * PHP Extensions: [[wp>PHP_Extension_Community_Library|PECL]] and [[wp>PHP_Extension_Community_Library#External_links|PEAR]].
   * 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 ''go-pear.bat'' in ''C:\php''.   * PEAR is installed in command prompt((DOS-window)) with ''go-pear.bat'' in ''C:\php''.
Line 243: Line 244:
 \\ You'll probably need some more logic in the code to determine if the page has any SQL syntax.  The best way to handle that is most likely to utilize the page's [[metadata]] - have your syntax plugin write some metadata concerning the page and its SQL use or its caching requirement and then have the action plugin check the metadata before deciding whether or not to send additional headers. --- //[[chris@jalakai.co.uk|Christopher Smith]] 2006-05-22 11:30// \\ You'll probably need some more logic in the code to determine if the page has any SQL syntax.  The best way to handle that is most likely to utilize the page's [[metadata]] - have your syntax plugin write some metadata concerning the page and its SQL use or its caching requirement and then have the action plugin check the metadata before deciding whether or not to send additional headers. --- //[[chris@jalakai.co.uk|Christopher Smith]] 2006-05-22 11:30//
  
-> I found the problem in [[http://dev.splitbrain.org/reference/dokuwiki/inc/parserutils.php.source.html#l26|p_cached_xhtml()]]. it is trying to get cached instructions unconditionally (ignoring ''$info['cache']''). for me it's a bug : it does not make sense to use cached instructions when it's explicitly asked to not use cache at all. what do you think? (BTW [[http://dev.splitbrain.org/reference/dokuwiki/inc/parserutils.php.source.html#l65|p_cached_instructions()]] is called with ''$info'' as it's third argument when it is declared with only two arguments) --- //[[slim.amamou@gmail.com|Slim Amamou]] 2006-05-23 01:12//+> I found the problem in [[xref>p_cached_xhtml()]]. it is trying to get cached instructions unconditionally (ignoring ''$info['cache']''). for me it's a bug : it does not make sense to use cached instructions when it's explicitly asked to not use cache at all. what do you think? (BTW [[xref>p_cached_instructions()]] is called with ''$info'' as it's third argument when it is declared with only two arguments) --- //[[slim.amamou@gmail.com|Slim Amamou]] 2006-05-23 01:12//
 >> Not a bug. Instructions should be cacheable. ''$info['cache']'' is a renderer value and doesn't exist in the handler. If you need to do something every time the page is required, do it in the render function and standardize the instruction generated by the handle function.  In your case, you might create the SQL statements in the handle() function and then use them to retrieve the data and format it for output in the render() function. --- //[[chris@jalakai.co.uk|Christopher Smith]] 2006-05-23 01:31// >> Not a bug. Instructions should be cacheable. ''$info['cache']'' is a renderer value and doesn't exist in the handler. If you need to do something every time the page is required, do it in the render function and standardize the instruction generated by the handle function.  In your case, you might create the SQL statements in the handle() function and then use them to retrieve the data and format it for output in the render() function. --- //[[chris@jalakai.co.uk|Christopher Smith]] 2006-05-23 01:31//
 >>> Thanks Christopher for your help, the problem is now corrected.  --- //[[slim.amamou@gmail.com|Slim Amamou]] 2006-05-27 00:21// >>> Thanks Christopher for your help, the problem is now corrected.  --- //[[slim.amamou@gmail.com|Slim Amamou]] 2006-05-27 00:21//
plugin/sql.1582828459.txt.gz · Last modified: 2020-02-27 19:34 by Aleksandr
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

Global DokuWiki Links