v5:addons:addons_index
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:addons:addons_index [2016/03/19 03:54] – [The xmlrpc library] mnewnham | v5:addons:addons_index [2023/05/12 19:12] (current) – [Paging & Scrolling with ADOdb Pager] move screenshot before code snippet dregad | ||
---|---|---|---|
Line 178: | Line 178: | ||
===== The xmlrpc library ====== | ===== The xmlrpc library ====== | ||
This addon provides an interface between the adodb recordset and the php xmlrpc library. [[v5: | This addon provides an interface between the adodb recordset and the php xmlrpc library. [[v5: | ||
+ | ----------------------------- | ||
===== Paging & Scrolling with ADOdb Pager ===== | ===== Paging & Scrolling with ADOdb Pager ===== | ||
- | The following code creates a very simple recordset | + | <WRAP right box> |
+ | == Requires == | ||
+ | adodb-pager.inc.php | ||
+ | </ | ||
- | <code php> | + | The following |
- | include_once(' | + | |
- | include_once(' | + | {{: |
+ | <WRAP clear/> | ||
- | session_start(); | + | <code php> |
- | $db = NewADOConnection('mysql'); | + | include_once |
- | $db-> | + | include_once ' |
- | $sql = " | + | |
- | $pager = new ADODB_Pager($db,$sql); | + | $db = ADONewConnection(' |
+ | $db-> | ||
- | $pager-> | + | $sql = ' |
+ | $pager = new ADODB_Pager($db, | ||
+ | $pager-> | ||
</ | </ | ||
- | This will create a basic record pager that looks like this: | ||
- | |< << | + | The number of rows to display at one time is controled by the //Render($rows)// method. If you do not pass any value to Render(), |
- | + | ||
- | ^ID^First Name^Last Name^Date Created^ | + | |
- | |36|Alan|Turing|Sat 06, Oct 2001| | + | |
- | |37|Serena|Williams|Sat 06, Oct 2001| | + | |
- | |38|Yat Sun|Sun|Sat 06, Oct 2001| | + | |
- | |39|Wai Hun|See|Sat 06, Oct 2001| | + | |
- | |40|Steven|Oey|Sat 06, Oct 2001| | + | |
- | + | ||
- | Page 8/10 | + | |
- | + | ||
- | The number of rows to display at one time is controled by the Render($rows) method. If you do not pass any value to Render(), | + | |
- | + | ||
- | You can control the column titles by modifying your SQL (supported by most databases): | + | |
+ | You can control the column titles by aliasing them in your SQL (supported by most databases): | ||
<code php> | <code php> | ||
$sql = ' | $sql = ' | ||
Line 223: | Line 216: | ||
</ | </ | ||
- | The above code can be found in the adodb/ | + | The ADODB_Pager code can be adapted by a programmer |
+ | |||
+ | By default, special characters in the displayed data will be escaped to prevent execution of HTML code. If you wish to have them interpreted instead, before calling Render() you can set | ||
+ | <code php> | ||
+ | $pager-> | ||
+ | </ | ||
- | You can also allow display of html by setting $pager->htmlSpecialChars = false. | + | <WRAP important> |
+ | This is a **security risk**, unescaped HTML will leave you vulnerable to Cross-site scripting (XSS) attacks. | ||
+ | Use with caution, and only with trusted data. | ||
+ | </ | ||
- | Some of the code used here was contributed by Iván Oliva and Cornel G.. |
v5/addons/addons_index.1458356097.txt.gz · Last modified: 2017/04/21 11:22 (external edit)