The real release 0.46 :-)
[awl.git] / docs / api / awl / Browser / Browser.html
blobb7180abb46ff549925fcdddb5da876c2c1e0dcce
1 <?xml version="1.0" encoding="iso-8859-1"?>
2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3 <html xmlns="http://www.w3.org/1999/xhtml">
4 <head>
5 <!-- template designed by Marco Von Ballmoos -->
6 <title>Docs For Class Browser</title>
7 <link rel="stylesheet" href="../../media/stylesheet.css" />
8 <script src="../../media/lib/classTree.js"></script>
9 <script language="javascript" type="text/javascript">
10 var imgPlus = new Image();
11 var imgMinus = new Image();
12 imgPlus.src = "../../media/images/plus.png";
13 imgMinus.src = "../../media/images/minus.png";
15 function showNode(Node){
16 switch(navigator.family){
17 case 'nn4':
18 // Nav 4.x code fork...
19 var oTable = document.layers["span" + Node];
20 var oImg = document.layers["img" + Node];
21 break;
22 case 'ie4':
23 // IE 4/5 code fork...
24 var oTable = document.all["span" + Node];
25 var oImg = document.all["img" + Node];
26 break;
27 case 'gecko':
28 // Standards Compliant code fork...
29 var oTable = document.getElementById("span" + Node);
30 var oImg = document.getElementById("img" + Node);
31 break;
33 oImg.src = imgMinus.src;
34 oTable.style.display = "block";
37 function hideNode(Node){
38 switch(navigator.family){
39 case 'nn4':
40 // Nav 4.x code fork...
41 var oTable = document.layers["span" + Node];
42 var oImg = document.layers["img" + Node];
43 break;
44 case 'ie4':
45 // IE 4/5 code fork...
46 var oTable = document.all["span" + Node];
47 var oImg = document.all["img" + Node];
48 break;
49 case 'gecko':
50 // Standards Compliant code fork...
51 var oTable = document.getElementById("span" + Node);
52 var oImg = document.getElementById("img" + Node);
53 break;
55 oImg.src = imgPlus.src;
56 oTable.style.display = "none";
59 function nodeIsVisible(Node){
60 switch(navigator.family){
61 case 'nn4':
62 // Nav 4.x code fork...
63 var oTable = document.layers["span" + Node];
64 break;
65 case 'ie4':
66 // IE 4/5 code fork...
67 var oTable = document.all["span" + Node];
68 break;
69 case 'gecko':
70 // Standards Compliant code fork...
71 var oTable = document.getElementById("span" + Node);
72 break;
74 return (oTable && oTable.style.display == "block");
77 function toggleNodeVisibility(Node){
78 if (nodeIsVisible(Node)){
79 hideNode(Node);
80 }else{
81 showNode(Node);
84 </script>
85 </head>
86 <body>
87 <div class="page-body">
88 <h2 class="class-name"><img src="../../media/images/Class_logo.png"
89 alt=" Class"
90 title=" Class"
91 style="vertical-align: middle"> Browser</h2>
93 <a name="sec-description"></a>
94 <div class="info-box">
95 <div class="info-box-title">Description</div>
96 <div class="nav-bar">
97 <span class="disabled">Description</span> |
98 <a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
99 | <a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
101 </div>
102 <div class="info-box-body">
103 <!-- ========== Info from phpDoc block ========= -->
104 <p class="short-description">Start a new Browser, add columns, set a join and Render it to create a basic list of records in a table.</p>
105 <p class="description"><p>You can, of course, get a lot fancier with setting ordering, where clauses totalled columns and so forth.</p></p>
106 <p class="notes">
107 Located in <a class="field" href="_classBrowser.php.html">/classBrowser.php</a> (line <span class="field">174</span>)
108 </p>
111 <pre></pre>
113 </div>
114 </div>
118 <a name="sec-var-summary"></a>
119 <div class="info-box">
120 <div class="info-box-title">Variable Summary</span></div>
121 <div class="nav-bar">
122 <a href="#sec-description">Description</a> |
123 <span class="disabled">Vars</span> (<a href="#sec-vars">details</a>)
125 <a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
127 </div>
128 <div class="info-box-body">
129 <div class="var-summary">
130 <div class="var-title">
131 <img src="../../media/images/Variable.png" alt=" " />
132 <span class="var-type">mixed</span>
133 <a href="#$BeginRow" title="details" class="var-name">$BeginRow</a>
134 </div>
135 <div class="var-title">
136 <img src="../../media/images/Variable.png" alt=" " />
137 <span class="var-type">mixed</span>
138 <a href="#$BeginRowArgs" title="details" class="var-name">$BeginRowArgs</a>
139 </div>
140 <div class="var-title">
141 <img src="../../media/images/Variable.png" alt=" " />
142 <span class="var-type">mixed</span>
143 <a href="#$CloseRow" title="details" class="var-name">$CloseRow</a>
144 </div>
145 <div class="var-title">
146 <img src="../../media/images/Variable.png" alt=" " />
147 <span class="var-type">mixed</span>
148 <a href="#$Columns" title="details" class="var-name">$Columns</a>
149 </div>
150 <div class="var-title">
151 <img src="../../media/images/Variable.png" alt=" " />
152 <span class="var-type">mixed</span>
153 <a href="#$Distinct" title="details" class="var-name">$Distinct</a>
154 </div>
155 <div class="var-title">
156 <img src="../../media/images/Variable.png" alt=" " />
157 <span class="var-type">mixed</span>
158 <a href="#$DivClose" title="details" class="var-name">$DivClose</a>
159 </div>
160 <div class="var-title">
161 <img src="../../media/images/Variable.png" alt=" " />
162 <span class="var-type">mixed</span>
163 <a href="#$DivOpen" title="details" class="var-name">$DivOpen</a>
164 </div>
165 <div class="var-title">
166 <img src="../../media/images/Variable.png" alt=" " />
167 <span class="var-type">mixed</span>
168 <a href="#$ExtraRows" title="details" class="var-name">$ExtraRows</a>
169 </div>
170 <div class="var-title">
171 <img src="../../media/images/Variable.png" alt=" " />
172 <span class="var-type">mixed</span>
173 <a href="#$FieldNames" title="details" class="var-name">$FieldNames</a>
174 </div>
175 <div class="var-title">
176 <img src="../../media/images/Variable.png" alt=" " />
177 <span class="var-type">mixed</span>
178 <a href="#$ForcedOrder" title="details" class="var-name">$ForcedOrder</a>
179 </div>
180 <div class="var-title">
181 <img src="../../media/images/Variable.png" alt=" " />
182 <span class="var-type">mixed</span>
183 <a href="#$Grouping" title="details" class="var-name">$Grouping</a>
184 </div>
185 <div class="var-title">
186 <img src="../../media/images/Variable.png" alt=" " />
187 <span class="var-type">mixed</span>
188 <a href="#$HiddenColumns" title="details" class="var-name">$HiddenColumns</a>
189 </div>
190 <div class="var-title">
191 <img src="../../media/images/Variable.png" alt=" " />
192 <span class="var-type">mixed</span>
193 <a href="#$Joins" title="details" class="var-name">$Joins</a>
194 </div>
195 <div class="var-title">
196 <img src="../../media/images/Variable.png" alt=" " />
197 <span class="var-type">mixed</span>
198 <a href="#$Limit" title="details" class="var-name">$Limit</a>
199 </div>
200 <div class="var-title">
201 <img src="../../media/images/Variable.png" alt=" " />
202 <span class="var-type">mixed</span>
203 <a href="#$match_column" title="details" class="var-name">$match_column</a>
204 </div>
205 <div class="var-title">
206 <img src="../../media/images/Variable.png" alt=" " />
207 <span class="var-type">mixed</span>
208 <a href="#$match_function" title="details" class="var-name">$match_function</a>
209 </div>
210 <div class="var-title">
211 <img src="../../media/images/Variable.png" alt=" " />
212 <span class="var-type">mixed</span>
213 <a href="#$match_value" title="details" class="var-name">$match_value</a>
214 </div>
215 <div class="var-title">
216 <img src="../../media/images/Variable.png" alt=" " />
217 <span class="var-type">mixed</span>
218 <a href="#$Offset" title="details" class="var-name">$Offset</a>
219 </div>
220 <div class="var-title">
221 <img src="../../media/images/Variable.png" alt=" " />
222 <span class="var-type">mixed</span>
223 <a href="#$Order" title="details" class="var-name">$Order</a>
224 </div>
225 <div class="var-title">
226 <img src="../../media/images/Variable.png" alt=" " />
227 <span class="var-type">mixed</span>
228 <a href="#$OrderBrowserKey" title="details" class="var-name">$OrderBrowserKey</a>
229 </div>
230 <div class="var-title">
231 <img src="../../media/images/Variable.png" alt=" " />
232 <span class="var-type">mixed</span>
233 <a href="#$OrderDirection" title="details" class="var-name">$OrderDirection</a>
234 </div>
235 <div class="var-title">
236 <img src="../../media/images/Variable.png" alt=" " />
237 <span class="var-type">mixed</span>
238 <a href="#$OrderField" title="details" class="var-name">$OrderField</a>
239 </div>
240 <div class="var-title">
241 <img src="../../media/images/Variable.png" alt=" " />
242 <span class="var-type">mixed</span>
243 <a href="#$Query" title="details" class="var-name">$Query</a>
244 </div>
245 <div class="var-title">
246 <img src="../../media/images/Variable.png" alt=" " />
247 <span class="var-type">mixed</span>
248 <a href="#$SubTitle" title="details" class="var-name">$SubTitle</a>
249 </div>
250 <div class="var-title">
251 <img src="../../media/images/Variable.png" alt=" " />
252 <span class="var-type">mixed</span>
253 <a href="#$Title" title="details" class="var-name">$Title</a>
254 </div>
255 <div class="var-title">
256 <img src="../../media/images/Variable.png" alt=" " />
257 <span class="var-type">mixed</span>
258 <a href="#$TotalFuncs" title="details" class="var-name">$TotalFuncs</a>
259 </div>
260 <div class="var-title">
261 <img src="../../media/images/Variable.png" alt=" " />
262 <span class="var-type">mixed</span>
263 <a href="#$Totals" title="details" class="var-name">$Totals</a>
264 </div>
265 <div class="var-title">
266 <img src="../../media/images/Variable.png" alt=" " />
267 <span class="var-type">mixed</span>
268 <a href="#$Union" title="details" class="var-name">$Union</a>
269 </div>
270 <div class="var-title">
271 <img src="../../media/images/Variable.png" alt=" " />
272 <span class="var-type">mixed</span>
273 <a href="#$Where" title="details" class="var-name">$Where</a>
274 </div>
275 </div>
276 </div>
277 </div>
279 <a name="sec-method-summary"></a>
280 <div class="info-box">
281 <div class="info-box-title">Method Summary</span></div>
282 <div class="nav-bar">
283 <a href="#sec-description">Description</a> |
284 <a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
287 <span class="disabled">Methods</span> (<a href="#sec-methods">details</a>)
288 </div>
289 <div class="info-box-body">
290 <div class="method-summary">
292 <div class="method-definition">
293 <img src="../../media/images/Constructor.png" alt=" "/>
294 <span class="method-result">Browser</span>
295 <a href="#Browser" title="details" class="method-name">Browser</a>
296 ([<span class="var-type">string</span>&nbsp;<span class="var-name">$title</span> = <span class="var-default">&quot;&quot;</span>])
297 </div>
299 <div class="method-definition">
300 <img src="../../media/images/Method.png" alt=" "/>
301 <span class="method-result">void</span>
302 <a href="#AddColumn" title="details" class="method-name">AddColumn</a>
303 (<span class="var-type">string</span>&nbsp;<span class="var-name">$field</span>, [<span class="var-type">string</span>&nbsp;<span class="var-name">$header</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$align</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$format</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$sql</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$class</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$datatype</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$hook</span> = <span class="var-default">null</span>])
304 </div>
306 <div class="method-definition">
307 <img src="../../media/images/Method.png" alt=" "/>
308 <span class="method-result">void</span>
309 <a href="#AddGrouping" title="details" class="method-name">AddGrouping</a>
310 (<span class="var-type"></span>&nbsp;<span class="var-name">$field</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$browser_array_key</span> = <span class="var-default">0</span>])
311 </div>
313 <div class="method-definition">
314 <img src="../../media/images/Method.png" alt=" "/>
315 <span class="method-result">void</span>
316 <a href="#AddHidden" title="details" class="method-name">AddHidden</a>
317 (<span class="var-type">string</span>&nbsp;<span class="var-name">$field</span>, [<span class="var-type">string</span>&nbsp;<span class="var-name">$sql</span> = <span class="var-default">&quot;&quot;</span>])
318 </div>
320 <div class="method-definition">
321 <img src="../../media/images/Method.png" alt=" "/>
322 <span class="method-result">void</span>
323 <a href="#AddOrder" title="details" class="method-name">AddOrder</a>
324 (<span class="var-type">string</span>&nbsp;<span class="var-name">$field</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$direction</span>, [<span class="var-type">string</span>&nbsp;<span class="var-name">$browser_array_key</span> = <span class="var-default">0</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$secondary</span> = <span class="var-default">0</span>])
325 </div>
327 <div class="method-definition">
328 <img src="../../media/images/Method.png" alt=" "/>
329 <span class="method-result">void</span>
330 <a href="#AddRow" title="details" class="method-name">AddRow</a>
331 (<span class="var-type"></span>&nbsp;<span class="var-name">$column_values</span>)
332 </div>
334 <div class="method-definition">
335 <img src="../../media/images/Method.png" alt=" "/>
336 <span class="method-result">void</span>
337 <a href="#AddTotal" title="details" class="method-name">AddTotal</a>
338 (<span class="var-type">string</span>&nbsp;<span class="var-name">$column_name</span>, [<span class="var-type">string</span>&nbsp;<span class="var-name">$total_function</span> = <span class="var-default">false</span>])
339 </div>
341 <div class="method-definition">
342 <img src="../../media/images/Method.png" alt=" "/>
343 <span class="method-result">void</span>
344 <a href="#AndWhere" title="details" class="method-name">AndWhere</a>
345 (<span class="var-type">string</span>&nbsp;<span class="var-name">$more_where</span>)
346 </div>
348 <div class="method-definition">
349 <img src="../../media/images/Method.png" alt=" "/>
350 <span class="method-result">boolean</span>
351 <a href="#DoQuery" title="details" class="method-name">DoQuery</a>
353 </div>
355 <div class="method-definition">
356 <img src="../../media/images/Method.png" alt=" "/>
357 <span class="method-result">void</span>
358 <a href="#ForceOrder" title="details" class="method-name">ForceOrder</a>
359 (<span class="var-type">string</span>&nbsp;<span class="var-name">$field</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$direction</span>)
360 </div>
362 <div class="method-definition">
363 <img src="../../media/images/Method.png" alt=" "/>
364 <span class="method-result">void</span>
365 <a href="#GetTotal" title="details" class="method-name">GetTotal</a>
366 (<span class="var-type">string</span>&nbsp;<span class="var-name">$column_name</span>)
367 </div>
369 <div class="method-definition">
370 <img src="../../media/images/Method.png" alt=" "/>
371 <span class="method-result">void</span>
372 <a href="#MatchedRow" title="details" class="method-name">MatchedRow</a>
373 (<span class="var-type">string</span>&nbsp;<span class="var-name">$column</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$value</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$function</span>)
374 </div>
376 <div class="method-definition">
377 <img src="../../media/images/Method.png" alt=" "/>
378 <span class="method-result">void</span>
379 <a href="#MoreWhere" title="details" class="method-name">MoreWhere</a>
380 (<span class="var-type">string</span>&nbsp;<span class="var-name">$operator</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$more_where</span>)
381 </div>
383 <div class="method-definition">
384 <img src="../../media/images/Method.png" alt=" "/>
385 <span class="method-result">void</span>
386 <a href="#OrWhere" title="details" class="method-name">OrWhere</a>
387 (<span class="var-type">string</span>&nbsp;<span class="var-name">$more_where</span>)
388 </div>
390 <div class="method-definition">
391 <img src="../../media/images/Method.png" alt=" "/>
392 <span class="method-result">string</span>
393 <a href="#Render" title="details" class="method-name">Render</a>
394 ([<span class="var-type">string</span>&nbsp;<span class="var-name">$title_tag</span> = <span class="var-default">null</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$subtitle_tag</span> = <span class="var-default">null</span>])
395 </div>
397 <div class="method-definition">
398 <img src="../../media/images/Method.png" alt=" "/>
399 <span class="method-result">void</span>
400 <a href="#RowFormat" title="details" class="method-name">RowFormat</a>
401 (<span class="var-type">string</span>&nbsp;<span class="var-name">$beginrow</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$closerow</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$rowargs</span>)
402 </div>
404 <div class="method-definition">
405 <img src="../../media/images/Method.png" alt=" "/>
406 <span class="method-result">void</span>
407 <a href="#SetDistinct" title="details" class="method-name">SetDistinct</a>
408 (<span class="var-type">string</span>&nbsp;<span class="var-name">$distinct</span>)
409 </div>
411 <div class="method-definition">
412 <img src="../../media/images/Method.png" alt=" "/>
413 <span class="method-result">void</span>
414 <a href="#SetDiv" title="details" class="method-name">SetDiv</a>
415 (<span class="var-type">string</span>&nbsp;<span class="var-name">$open_div</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$close_div</span>)
416 </div>
418 <div class="method-definition">
419 <img src="../../media/images/Method.png" alt=" "/>
420 <span class="method-result">void</span>
421 <a href="#SetJoins" title="details" class="method-name">SetJoins</a>
422 (<span class="var-type">string</span>&nbsp;<span class="var-name">$join_list</span>)
423 </div>
425 <div class="method-definition">
426 <img src="../../media/images/Method.png" alt=" "/>
427 <span class="method-result">void</span>
428 <a href="#SetLimit" title="details" class="method-name">SetLimit</a>
429 (<span class="var-type">int</span>&nbsp;<span class="var-name">$limit_n</span>)
430 </div>
432 <div class="method-definition">
433 <img src="../../media/images/Method.png" alt=" "/>
434 <span class="method-result">void</span>
435 <a href="#SetOffset" title="details" class="method-name">SetOffset</a>
436 (<span class="var-type">int</span>&nbsp;<span class="var-name">$offset_n</span>)
437 </div>
439 <div class="method-definition">
440 <img src="../../media/images/Method.png" alt=" "/>
441 <span class="method-result">void</span>
442 <a href="#SetOrdering" title="details" class="method-name">SetOrdering</a>
443 ([<span class="var-type"></span>&nbsp;<span class="var-name">$default_fld</span> = <span class="var-default">null</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$default_dir</span> = <span class="var-default">'A'</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$browser_array_key</span> = <span class="var-default">0</span>])
444 </div>
446 <div class="method-definition">
447 <img src="../../media/images/Method.png" alt=" "/>
448 <span class="method-result">void</span>
449 <a href="#SetSubTitle" title="details" class="method-name">SetSubTitle</a>
450 (<span class="var-type">string</span>&nbsp;<span class="var-name">$sub_title</span>)
451 </div>
453 <div class="method-definition">
454 <img src="../../media/images/Method.png" alt=" "/>
455 <span class="method-result">void</span>
456 <a href="#SetTitle" title="details" class="method-name">SetTitle</a>
457 (<span class="var-type">string</span>&nbsp;<span class="var-name">$new_title</span>)
458 </div>
460 <div class="method-definition">
461 <img src="../../media/images/Method.png" alt=" "/>
462 <span class="method-result">void</span>
463 <a href="#SetTranslatable" title="details" class="method-name">SetTranslatable</a>
464 (<span class="var-type">array</span>&nbsp;<span class="var-name">$column_list</span>)
465 </div>
467 <div class="method-definition">
468 <img src="../../media/images/Method.png" alt=" "/>
469 <span class="method-result">void</span>
470 <a href="#SetUnion" title="details" class="method-name">SetUnion</a>
471 (<span class="var-type">string</span>&nbsp;<span class="var-name">$union_select</span>)
472 </div>
474 <div class="method-definition">
475 <img src="../../media/images/Method.png" alt=" "/>
476 <span class="method-result">void</span>
477 <a href="#SetWhere" title="details" class="method-name">SetWhere</a>
478 (<span class="var-type">string</span>&nbsp;<span class="var-name">$where_clause</span>)
479 </div>
481 <div class="method-definition">
482 <img src="../../media/images/Method.png" alt=" "/>
483 <span class="method-result">string</span>
484 <a href="#Title" title="details" class="method-name">Title</a>
485 ([<span class="var-type">string</span>&nbsp;<span class="var-name">$new_title</span> = <span class="var-default">null</span>])
486 </div>
488 <div class="method-definition">
489 <img src="../../media/images/Method.png" alt=" "/>
490 <span class="method-result">void</span>
491 <a href="#ValueReplacement" title="details" class="method-name">ValueReplacement</a>
492 (<span class="var-type">array</span>&nbsp;<span class="var-name">$matches</span>)
493 </div>
494 </div>
495 </div>
496 </div>
498 <a name="sec-vars"></a>
499 <div class="info-box">
500 <div class="info-box-title">Variables</div>
501 <div class="nav-bar">
502 <a href="#sec-description">Description</a> |
503 <a href="#sec-var-summary">Vars</a> (<span class="disabled">details</span>)
507 <a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
509 </div>
510 <div class="info-box-body">
512 <a name="var$BeginRow" id="$BeginRow"><!-- --></A>
513 <div class="evenrow">
515 <div class="var-header">
516 <img src="../../media/images/Variable.png" />
517 <span class="var-title">
518 <span class="var-type">mixed</span>
519 <span class="var-name">$BeginRow</span>
520 (line <span class="line-number">194</span>)
521 </span>
522 </div>
524 <!-- ========== Info from phpDoc block ========= -->
530 </div>
531 <a name="var$BeginRowArgs" id="$BeginRowArgs"><!-- --></A>
532 <div class="oddrow">
534 <div class="var-header">
535 <img src="../../media/images/Variable.png" />
536 <span class="var-title">
537 <span class="var-type">mixed</span>
538 <span class="var-name">$BeginRowArgs</span>
539 (line <span class="line-number">196</span>)
540 </span>
541 </div>
543 <!-- ========== Info from phpDoc block ========= -->
549 </div>
550 <a name="var$CloseRow" id="$CloseRow"><!-- --></A>
551 <div class="evenrow">
553 <div class="var-header">
554 <img src="../../media/images/Variable.png" />
555 <span class="var-title">
556 <span class="var-type">mixed</span>
557 <span class="var-name">$CloseRow</span>
558 (line <span class="line-number">195</span>)
559 </span>
560 </div>
562 <!-- ========== Info from phpDoc block ========= -->
568 </div>
569 <a name="var$Columns" id="$Columns"><!-- --></A>
570 <div class="oddrow">
572 <div class="var-header">
573 <img src="../../media/images/Variable.png" />
574 <span class="var-title">
575 <span class="var-type">mixed</span>
576 <span class="var-name">$Columns</span>
577 (line <span class="line-number">179</span>)
578 </span>
579 </div>
581 <!-- ========== Info from phpDoc block ========= -->
587 </div>
588 <a name="var$Distinct" id="$Distinct"><!-- --></A>
589 <div class="evenrow">
591 <div class="var-header">
592 <img src="../../media/images/Variable.png" />
593 <span class="var-title">
594 <span class="var-type">mixed</span>
595 <span class="var-name">$Distinct</span>
596 (line <span class="line-number">183</span>)
597 </span>
598 </div>
600 <!-- ========== Info from phpDoc block ========= -->
606 </div>
607 <a name="var$DivClose" id="$DivClose"><!-- --></A>
608 <div class="oddrow">
610 <div class="var-header">
611 <img src="../../media/images/Variable.png" />
612 <span class="var-title">
613 <span class="var-type">mixed</span>
614 <span class="var-name">$DivClose</span>
615 (line <span class="line-number">204</span>)
616 </span>
617 </div>
619 <!-- ========== Info from phpDoc block ========= -->
625 </div>
626 <a name="var$DivOpen" id="$DivOpen"><!-- --></A>
627 <div class="evenrow">
629 <div class="var-header">
630 <img src="../../media/images/Variable.png" />
631 <span class="var-title">
632 <span class="var-type">mixed</span>
633 <span class="var-name">$DivOpen</span>
634 (line <span class="line-number">203</span>)
635 </span>
636 </div>
638 <!-- ========== Info from phpDoc block ========= -->
644 </div>
645 <a name="var$ExtraRows" id="$ExtraRows"><!-- --></A>
646 <div class="oddrow">
648 <div class="var-header">
649 <img src="../../media/images/Variable.png" />
650 <span class="var-title">
651 <span class="var-type">mixed</span>
652 <span class="var-name">$ExtraRows</span>
653 (line <span class="line-number">199</span>)
654 </span>
655 </div>
657 <!-- ========== Info from phpDoc block ========= -->
663 </div>
664 <a name="var$FieldNames" id="$FieldNames"><!-- --></A>
665 <div class="evenrow">
667 <div class="var-header">
668 <img src="../../media/images/Variable.png" />
669 <span class="var-title">
670 <span class="var-type">mixed</span>
671 <span class="var-name">$FieldNames</span>
672 (line <span class="line-number">178</span>)
673 </span>
674 </div>
676 <!-- ========== Info from phpDoc block ========= -->
682 </div>
683 <a name="var$ForcedOrder" id="$ForcedOrder"><!-- --></A>
684 <div class="oddrow">
686 <div class="var-header">
687 <img src="../../media/images/Variable.png" />
688 <span class="var-title">
689 <span class="var-type">mixed</span>
690 <span class="var-name">$ForcedOrder</span>
691 (line <span class="line-number">189</span>)
692 </span>
693 </div>
695 <!-- ========== Info from phpDoc block ========= -->
701 </div>
702 <a name="var$Grouping" id="$Grouping"><!-- --></A>
703 <div class="evenrow">
705 <div class="var-header">
706 <img src="../../media/images/Variable.png" />
707 <span class="var-title">
708 <span class="var-type">mixed</span>
709 <span class="var-name">$Grouping</span>
710 (line <span class="line-number">190</span>)
711 </span>
712 </div>
714 <!-- ========== Info from phpDoc block ========= -->
720 </div>
721 <a name="var$HiddenColumns" id="$HiddenColumns"><!-- --></A>
722 <div class="oddrow">
724 <div class="var-header">
725 <img src="../../media/images/Variable.png" />
726 <span class="var-title">
727 <span class="var-type">mixed</span>
728 <span class="var-name">$HiddenColumns</span>
729 (line <span class="line-number">180</span>)
730 </span>
731 </div>
733 <!-- ========== Info from phpDoc block ========= -->
739 </div>
740 <a name="var$Joins" id="$Joins"><!-- --></A>
741 <div class="evenrow">
743 <div class="var-header">
744 <img src="../../media/images/Variable.png" />
745 <span class="var-title">
746 <span class="var-type">mixed</span>
747 <span class="var-name">$Joins</span>
748 (line <span class="line-number">181</span>)
749 </span>
750 </div>
752 <!-- ========== Info from phpDoc block ========= -->
758 </div>
759 <a name="var$Limit" id="$Limit"><!-- --></A>
760 <div class="oddrow">
762 <div class="var-header">
763 <img src="../../media/images/Variable.png" />
764 <span class="var-title">
765 <span class="var-type">mixed</span>
766 <span class="var-name">$Limit</span>
767 (line <span class="line-number">191</span>)
768 </span>
769 </div>
771 <!-- ========== Info from phpDoc block ========= -->
777 </div>
778 <a name="var$match_column" id="$match_column"><!-- --></A>
779 <div class="evenrow">
781 <div class="var-header">
782 <img src="../../media/images/Variable.png" />
783 <span class="var-title">
784 <span class="var-type">mixed</span>
785 <span class="var-name">$match_column</span>
786 (line <span class="line-number">200</span>)
787 </span>
788 </div>
790 <!-- ========== Info from phpDoc block ========= -->
796 </div>
797 <a name="var$match_function" id="$match_function"><!-- --></A>
798 <div class="oddrow">
800 <div class="var-header">
801 <img src="../../media/images/Variable.png" />
802 <span class="var-title">
803 <span class="var-type">mixed</span>
804 <span class="var-name">$match_function</span>
805 (line <span class="line-number">202</span>)
806 </span>
807 </div>
809 <!-- ========== Info from phpDoc block ========= -->
815 </div>
816 <a name="var$match_value" id="$match_value"><!-- --></A>
817 <div class="evenrow">
819 <div class="var-header">
820 <img src="../../media/images/Variable.png" />
821 <span class="var-title">
822 <span class="var-type">mixed</span>
823 <span class="var-name">$match_value</span>
824 (line <span class="line-number">201</span>)
825 </span>
826 </div>
828 <!-- ========== Info from phpDoc block ========= -->
834 </div>
835 <a name="var$Offset" id="$Offset"><!-- --></A>
836 <div class="oddrow">
838 <div class="var-header">
839 <img src="../../media/images/Variable.png" />
840 <span class="var-title">
841 <span class="var-type">mixed</span>
842 <span class="var-name">$Offset</span>
843 (line <span class="line-number">192</span>)
844 </span>
845 </div>
847 <!-- ========== Info from phpDoc block ========= -->
853 </div>
854 <a name="var$Order" id="$Order"><!-- --></A>
855 <div class="evenrow">
857 <div class="var-header">
858 <img src="../../media/images/Variable.png" />
859 <span class="var-title">
860 <span class="var-type">mixed</span>
861 <span class="var-name">$Order</span>
862 (line <span class="line-number">185</span>)
863 </span>
864 </div>
866 <!-- ========== Info from phpDoc block ========= -->
872 </div>
873 <a name="var$OrderBrowserKey" id="$OrderBrowserKey"><!-- --></A>
874 <div class="oddrow">
876 <div class="var-header">
877 <img src="../../media/images/Variable.png" />
878 <span class="var-title">
879 <span class="var-type">mixed</span>
880 <span class="var-name">$OrderBrowserKey</span>
881 (line <span class="line-number">188</span>)
882 </span>
883 </div>
885 <!-- ========== Info from phpDoc block ========= -->
891 </div>
892 <a name="var$OrderDirection" id="$OrderDirection"><!-- --></A>
893 <div class="evenrow">
895 <div class="var-header">
896 <img src="../../media/images/Variable.png" />
897 <span class="var-title">
898 <span class="var-type">mixed</span>
899 <span class="var-name">$OrderDirection</span>
900 (line <span class="line-number">187</span>)
901 </span>
902 </div>
904 <!-- ========== Info from phpDoc block ========= -->
910 </div>
911 <a name="var$OrderField" id="$OrderField"><!-- --></A>
912 <div class="oddrow">
914 <div class="var-header">
915 <img src="../../media/images/Variable.png" />
916 <span class="var-title">
917 <span class="var-type">mixed</span>
918 <span class="var-name">$OrderField</span>
919 (line <span class="line-number">186</span>)
920 </span>
921 </div>
923 <!-- ========== Info from phpDoc block ========= -->
929 </div>
930 <a name="var$Query" id="$Query"><!-- --></A>
931 <div class="evenrow">
933 <div class="var-header">
934 <img src="../../media/images/Variable.png" />
935 <span class="var-title">
936 <span class="var-type">mixed</span>
937 <span class="var-name">$Query</span>
938 (line <span class="line-number">193</span>)
939 </span>
940 </div>
942 <!-- ========== Info from phpDoc block ========= -->
948 </div>
949 <a name="var$SubTitle" id="$SubTitle"><!-- --></A>
950 <div class="oddrow">
952 <div class="var-header">
953 <img src="../../media/images/Variable.png" />
954 <span class="var-title">
955 <span class="var-type">mixed</span>
956 <span class="var-name">$SubTitle</span>
957 (line <span class="line-number">177</span>)
958 </span>
959 </div>
961 <!-- ========== Info from phpDoc block ========= -->
967 </div>
968 <a name="var$Title" id="$Title"><!-- --></A>
969 <div class="evenrow">
971 <div class="var-header">
972 <img src="../../media/images/Variable.png" />
973 <span class="var-title">
974 <span class="var-type">mixed</span>
975 <span class="var-name">$Title</span>
976 (line <span class="line-number">176</span>)
977 </span>
978 </div>
980 <!-- ========== Info from phpDoc block ========= -->
986 </div>
987 <a name="var$TotalFuncs" id="$TotalFuncs"><!-- --></A>
988 <div class="oddrow">
990 <div class="var-header">
991 <img src="../../media/images/Variable.png" />
992 <span class="var-title">
993 <span class="var-type">mixed</span>
994 <span class="var-name">$TotalFuncs</span>
995 (line <span class="line-number">198</span>)
996 </span>
997 </div>
999 <!-- ========== Info from phpDoc block ========= -->
1005 </div>
1006 <a name="var$Totals" id="$Totals"><!-- --></A>
1007 <div class="evenrow">
1009 <div class="var-header">
1010 <img src="../../media/images/Variable.png" />
1011 <span class="var-title">
1012 <span class="var-type">mixed</span>
1013 <span class="var-name">$Totals</span>
1014 (line <span class="line-number">197</span>)
1015 </span>
1016 </div>
1018 <!-- ========== Info from phpDoc block ========= -->
1024 </div>
1025 <a name="var$Union" id="$Union"><!-- --></A>
1026 <div class="oddrow">
1028 <div class="var-header">
1029 <img src="../../media/images/Variable.png" />
1030 <span class="var-title">
1031 <span class="var-type">mixed</span>
1032 <span class="var-name">$Union</span>
1033 (line <span class="line-number">184</span>)
1034 </span>
1035 </div>
1037 <!-- ========== Info from phpDoc block ========= -->
1043 </div>
1044 <a name="var$Where" id="$Where"><!-- --></A>
1045 <div class="evenrow">
1047 <div class="var-header">
1048 <img src="../../media/images/Variable.png" />
1049 <span class="var-title">
1050 <span class="var-type">mixed</span>
1051 <span class="var-name">$Where</span>
1052 (line <span class="line-number">182</span>)
1053 </span>
1054 </div>
1056 <!-- ========== Info from phpDoc block ========= -->
1062 </div>
1064 </div>
1065 </div>
1067 <a name="sec-methods"></a>
1068 <div class="info-box">
1069 <div class="info-box-title">Methods</div>
1070 <div class="nav-bar">
1071 <a href="#sec-description">Description</a> |
1072 <a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
1073 <a href="#sec-method-summary">Methods</a> (<span class="disabled">details</span>)
1075 </div>
1076 <div class="info-box-body">
1077 <A NAME='method_detail'></A>
1078 <a name="methodBrowser" id="Browser"><!-- --></a>
1079 <div class="oddrow">
1081 <div class="method-header">
1082 <img src="../../media/images/Constructor.png" />
1083 <span class="method-title">Constructor Browser</span> (line <span class="line-number">211</span>)
1084 </div>
1086 <!-- ========== Info from phpDoc block ========= -->
1087 <p class="short-description">The Browser class constructor</p>
1089 <div class="method-signature">
1090 <span class="method-result">Browser</span>
1091 <span class="method-name">
1092 Browser
1093 </span>
1094 ([<span class="var-type">string</span>&nbsp;<span class="var-name">$title</span> = <span class="var-default">&quot;&quot;</span>])
1095 </div>
1097 <ul class="parameters">
1098 <li>
1099 <span class="var-type">string</span>
1100 <span class="var-name">$title</span><span class="var-description">: A title for the browser (optional).</span> </li>
1101 </ul>
1104 </div>
1105 <a name="methodAddColumn" id="AddColumn"><!-- --></a>
1106 <div class="evenrow">
1108 <div class="method-header">
1109 <img src="../../media/images/Method.png" />
1110 <span class="method-title">AddColumn</span> (line <span class="line-number">257</span>)
1111 </div>
1113 <!-- ========== Info from phpDoc block ========= -->
1114 <p class="short-description">Add a column to the Browser.</p>
1115 <p class="description"><p>This constructs a new BrowserColumn, appending it to the array of columns in this Browser.</p><p>Note that if the $format parameter starts with '&lt;td&gt;' the format will replace the column format, otherwise it will be used within '&lt;td&gt;...&lt;/td&gt;' tags.</p></p>
1116 <ul class="tags">
1117 <li><span class="field">see:</span> <a href="../../awl/Browser/BrowserColumn.html">BrowserColumn</a></li>
1118 </ul>
1120 <div class="method-signature">
1121 <span class="method-result">void</span>
1122 <span class="method-name">
1123 AddColumn
1124 </span>
1125 (<span class="var-type">string</span>&nbsp;<span class="var-name">$field</span>, [<span class="var-type">string</span>&nbsp;<span class="var-name">$header</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$align</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$format</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$sql</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$class</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$datatype</span> = <span class="var-default">&quot;&quot;</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$hook</span> = <span class="var-default">null</span>])
1126 </div>
1128 <ul class="parameters">
1129 <li>
1130 <span class="var-type">string</span>
1131 <span class="var-name">$field</span><span class="var-description">: The name of the field.</span> </li>
1132 <li>
1133 <span class="var-type">string</span>
1134 <span class="var-name">$header</span><span class="var-description">: A column header for the field.</span> </li>
1135 <li>
1136 <span class="var-type">string</span>
1137 <span class="var-name">$align</span><span class="var-description">: An alignment for column values.</span> </li>
1138 <li>
1139 <span class="var-type">string</span>
1140 <span class="var-name">$format</span><span class="var-description">: A sprintf format for displaying column values.</span> </li>
1141 <li>
1142 <span class="var-type">string</span>
1143 <span class="var-name">$sql</span><span class="var-description">: An SQL fragment for calculating the value.</span> </li>
1144 <li>
1145 <span class="var-type">string</span>
1146 <span class="var-name">$class</span><span class="var-description">: A CSS class to apply to the cells of this column.</span> </li>
1147 <li>
1148 <span class="var-type">string</span>
1149 <span class="var-name">$hook</span><span class="var-description">: <p>The name of a global function which will preprocess the column value</p><p>The hook function should be defined as follows: function hookfunction( $column_value, $column_name, $database_row ) { ... return $value; }</p></span> </li>
1150 <li>
1151 <span class="var-type"></span>
1152 <span class="var-name">$datatype</span> </li>
1153 </ul>
1156 </div>
1157 <a name="methodAddGrouping" id="AddGrouping"><!-- --></a>
1158 <div class="oddrow">
1160 <div class="method-header">
1161 <img src="../../media/images/Method.png" />
1162 <span class="method-title">AddGrouping</span> (line <span class="line-number">446</span>)
1163 </div>
1165 <!-- ========== Info from phpDoc block ========= -->
1167 <div class="method-signature">
1168 <span class="method-result">void</span>
1169 <span class="method-name">
1170 AddGrouping
1171 </span>
1172 (<span class="var-type"></span>&nbsp;<span class="var-name">$field</span>, [<span class="var-type"></span>&nbsp;<span class="var-name">$browser_array_key</span> = <span class="var-default">0</span>])
1173 </div>
1175 <ul class="parameters">
1176 <li>
1177 <span class="var-type"></span>
1178 <span class="var-name">$field</span> </li>
1179 <li>
1180 <span class="var-type"></span>
1181 <span class="var-name">$browser_array_key</span> </li>
1182 </ul>
1185 </div>
1186 <a name="methodAddHidden" id="AddHidden"><!-- --></a>
1187 <div class="evenrow">
1189 <div class="method-header">
1190 <img src="../../media/images/Method.png" />
1191 <span class="method-title">AddHidden</span> (line <span class="line-number">272</span>)
1192 </div>
1194 <!-- ========== Info from phpDoc block ========= -->
1195 <p class="short-description">Add a hidden column - one that is present in the SQL result, but for which there is no column displayed.</p>
1196 <p class="description"><p>This can be useful for including a value in (e.g.) clickable links or title attributes which is not actually displayed as a visible column.</p></p>
1198 <div class="method-signature">
1199 <span class="method-result">void</span>
1200 <span class="method-name">
1201 AddHidden
1202 </span>
1203 (<span class="var-type">string</span>&nbsp;<span class="var-name">$field</span>, [<span class="var-type">string</span>&nbsp;<span class="var-name">$sql</span> = <span class="var-default">&quot;&quot;</span>])
1204 </div>
1206 <ul class="parameters">
1207 <li>
1208 <span class="var-type">string</span>
1209 <span class="var-name">$field</span><span class="var-description">: The name of the field.</span> </li>
1210 <li>
1211 <span class="var-type">string</span>
1212 <span class="var-name">$sql</span><span class="var-description">: An SQL fragment to calculate the field, if it is calculated.</span> </li>
1213 </ul>
1216 </div>
1217 <a name="methodAddOrder" id="AddOrder"><!-- --></a>
1218 <div class="oddrow">
1220 <div class="method-header">
1221 <img src="../../media/images/Method.png" />
1222 <span class="method-title">AddOrder</span> (line <span class="line-number">471</span>)
1223 </div>
1225 <!-- ========== Info from phpDoc block ========= -->
1226 <p class="short-description">Add an ordering to the browser widget.</p>
1227 <p class="description"><p>The ordering can be overridden by GET parameters which will be rendered into the column headers so that a user can click on the column headers to control the actual order.</p></p>
1229 <div class="method-signature">
1230 <span class="method-result">void</span>
1231 <span class="method-name">
1232 AddOrder
1233 </span>
1234 (<span class="var-type">string</span>&nbsp;<span class="var-name">$field</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$direction</span>, [<span class="var-type">string</span>&nbsp;<span class="var-name">$browser_array_key</span> = <span class="var-default">0</span>], [<span class="var-type">string</span>&nbsp;<span class="var-name">$secondary</span> = <span class="var-default">0</span>])
1235 </div>
1237 <ul class="parameters">
1238 <li>
1239 <span class="var-type">string</span>
1240 <span class="var-name">$field</span><span class="var-description">: The name of the field to be ordered by.</span> </li>
1241 <li>
1242 <span class="var-type">string</span>
1243 <span class="var-name">$direction</span><span class="var-description">: A for Ascending, otherwise it will be descending order.</span> </li>
1244 <li>
1245 <span class="var-type">string</span>
1246 <span class="var-name">$browser_array_key</span><span class="var-description">: Use this to distinguish between multiple browser widgets on the same page. Leave it empty if you only have a single browser instance.</span> </li>
1247 <li>
1248 <span class="var-type">string</span>
1249 <span class="var-name">$secondary</span><span class="var-description">: Use this to indicate a default secondary order which shouldn't interfere with the default primary order.</span> </li>
1250 </ul>
1253 </div>
1254 <a name="methodAddRow" id="AddRow"><!-- --></a>
1255 <div class="evenrow">
1257 <div class="method-header">
1258 <img src="../../media/images/Method.png" />
1259 <span class="method-title">AddRow</span> (line <span class="line-number">644</span>)
1260 </div>
1262 <!-- ========== Info from phpDoc block ========= -->
1263 <p class="short-description">Add an extra arbitrary row onto the end of the browser.</p>
1264 <ul class="tags">
1265 <li><span class="field">var:</span> Contains an array of named fields, hopefully matching the column names.</li>
1266 </ul>
1268 <div class="method-signature">
1269 <span class="method-result">void</span>
1270 <span class="method-name">
1271 AddRow
1272 </span>
1273 (<span class="var-type"></span>&nbsp;<span class="var-name">$column_values</span>)
1274 </div>
1276 <ul class="parameters">
1277 <li>
1278 <span class="var-type"></span>
1279 <span class="var-name">$column_values</span> </li>
1280 </ul>
1283 </div>
1284 <a name="methodAddTotal" id="AddTotal"><!-- --></a>
1285 <div class="oddrow">
1287 <div class="method-header">
1288 <img src="../../media/images/Method.png" />
1289 <span class="method-title">AddTotal</span> (line <span class="line-number">554</span>)
1290 </div>
1292 <!-- ========== Info from phpDoc block ========= -->
1293 <p class="short-description">Mark a column as something to be totalled. You can also specify the name of a function which may modify the value before the actual totalling.</p>
1294 <p class="description"><p>The callback function will be called with each row, with the first argument being the entire record object and the second argument being only the column being totalled. The callback should return a number, to be added to the total.</p></p>
1296 <div class="method-signature">
1297 <span class="method-result">void</span>
1298 <span class="method-name">
1299 AddTotal
1300 </span>
1301 (<span class="var-type">string</span>&nbsp;<span class="var-name">$column_name</span>, [<span class="var-type">string</span>&nbsp;<span class="var-name">$total_function</span> = <span class="var-default">false</span>])
1302 </div>
1304 <ul class="parameters">
1305 <li>
1306 <span class="var-type">string</span>
1307 <span class="var-name">$column_name</span><span class="var-description">: The name of the column to be totalled.</span> </li>
1308 <li>
1309 <span class="var-type">string</span>
1310 <span class="var-name">$total_function</span><span class="var-description">: The name of the callback function.</span> </li>
1311 </ul>
1314 </div>
1315 <a name="methodAndWhere" id="AndWhere"><!-- --></a>
1316 <div class="evenrow">
1318 <div class="method-header">
1319 <img src="../../media/images/Method.png" />
1320 <span class="method-title">AndWhere</span> (line <span class="line-number">433</span>)
1321 </div>
1323 <!-- ========== Info from phpDoc block ========= -->
1324 <p class="short-description">Add an OR ... to the SQL Where clause</p>
1326 <div class="method-signature">
1327 <span class="method-result">void</span>
1328 <span class="method-name">
1329 AndWhere
1330 </span>
1331 (<span class="var-type">string</span>&nbsp;<span class="var-name">$more_where</span>)
1332 </div>
1334 <ul class="parameters">
1335 <li>
1336 <span class="var-type">string</span>
1337 <span class="var-name">$more_where</span><span class="var-description">: The extra part of the where clause</span> </li>
1338 </ul>
1341 </div>
1342 <a name="methodDoQuery" id="DoQuery"><!-- --></a>
1343 <div class="oddrow">
1345 <div class="method-header">
1346 <img src="../../media/images/Method.png" />
1347 <span class="method-title">DoQuery</span> (line <span class="line-number">615</span>)
1348 </div>
1350 <!-- ========== Info from phpDoc block ========= -->
1351 <p class="short-description">This method is used to build and execute the database query.</p>
1352 <p class="description"><p>You need not call this method, since Browser::Render() will call it for you if you have not done so at that point.</p></p>
1353 <ul class="tags">
1354 <li><span class="field">return:</span> The success / fail status of the AwlQuery::Exec()</li>
1355 </ul>
1357 <div class="method-signature">
1358 <span class="method-result">boolean</span>
1359 <span class="method-name">
1360 DoQuery
1361 </span>
1363 </div>
1367 </div>
1368 <a name="methodForceOrder" id="ForceOrder"><!-- --></a>
1369 <div class="evenrow">
1371 <div class="method-header">
1372 <img src="../../media/images/Method.png" />
1373 <span class="method-title">ForceOrder</span> (line <span class="line-number">505</span>)
1374 </div>
1376 <!-- ========== Info from phpDoc block ========= -->
1377 <p class="short-description">Force a particular ordering onto the browser widget.</p>
1379 <div class="method-signature">
1380 <span class="method-result">void</span>
1381 <span class="method-name">
1382 ForceOrder
1383 </span>
1384 (<span class="var-type">string</span>&nbsp;<span class="var-name">$field</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$direction</span>)
1385 </div>
1387 <ul class="parameters">
1388 <li>
1389 <span class="var-type">string</span>
1390 <span class="var-name">$field</span><span class="var-description">: The name of the field to be ordered by.</span> </li>
1391 <li>
1392 <span class="var-type">string</span>
1393 <span class="var-name">$direction</span><span class="var-description">: A for Ascending, otherwise it will be descending order.</span> </li>
1394 </ul>
1397 </div>
1398 <a name="methodGetTotal" id="GetTotal"><!-- --></a>
1399 <div class="oddrow">
1401 <div class="method-header">
1402 <img src="../../media/images/Method.png" />
1403 <span class="method-title">GetTotal</span> (line <span class="line-number">567</span>)
1404 </div>
1406 <!-- ========== Info from phpDoc block ========= -->
1407 <p class="short-description">Retrieve the total from a totalled column</p>
1409 <div class="method-signature">
1410 <span class="method-result">void</span>
1411 <span class="method-name">
1412 GetTotal
1413 </span>
1414 (<span class="var-type">string</span>&nbsp;<span class="var-name">$column_name</span>)
1415 </div>
1417 <ul class="parameters">
1418 <li>
1419 <span class="var-type">string</span>
1420 <span class="var-name">$column_name</span><span class="var-description">: The name of the column to be totalled.</span> </li>
1421 </ul>
1424 </div>
1425 <a name="methodMatchedRow" id="MatchedRow"><!-- --></a>
1426 <div class="evenrow">
1428 <div class="method-header">
1429 <img src="../../media/images/Method.png" />
1430 <span class="method-title">MatchedRow</span> (line <span class="line-number">657</span>)
1431 </div>
1433 <!-- ========== Info from phpDoc block ========= -->
1434 <p class="short-description">Replace a row where $column = $value with an extra arbitrary row, returned from calling $function</p>
1436 <div class="method-signature">
1437 <span class="method-result">void</span>
1438 <span class="method-name">
1439 MatchedRow
1440 </span>
1441 (<span class="var-type">string</span>&nbsp;<span class="var-name">$column</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$value</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$function</span>)
1442 </div>
1444 <ul class="parameters">
1445 <li>
1446 <span class="var-type">string</span>
1447 <span class="var-name">$column</span><span class="var-description">: The name of a column to match</span> </li>
1448 <li>
1449 <span class="var-type">string</span>
1450 <span class="var-name">$value</span><span class="var-description">: The value to match in the column</span> </li>
1451 <li>
1452 <span class="var-type">string</span>
1453 <span class="var-name">$function</span><span class="var-description">: The name of the function to call for the matched row</span> </li>
1454 </ul>
1457 </div>
1458 <a name="methodMoreWhere" id="MoreWhere"><!-- --></a>
1459 <div class="oddrow">
1461 <div class="method-header">
1462 <img src="../../media/images/Method.png" />
1463 <span class="method-title">MoreWhere</span> (line <span class="line-number">420</span>)
1464 </div>
1466 <!-- ========== Info from phpDoc block ========= -->
1467 <p class="short-description">Add an [operator] ... to the SQL Where clause</p>
1468 <p class="description"><p>You will generally want to call OrWhere or AndWhere rather than this function, but hey: who am I to tell you how to code!</p></p>
1470 <div class="method-signature">
1471 <span class="method-result">void</span>
1472 <span class="method-name">
1473 MoreWhere
1474 </span>
1475 (<span class="var-type">string</span>&nbsp;<span class="var-name">$operator</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$more_where</span>)
1476 </div>
1478 <ul class="parameters">
1479 <li>
1480 <span class="var-type">string</span>
1481 <span class="var-name">$operator</span><span class="var-description">: The operator to combine with previous where clause parts.</span> </li>
1482 <li>
1483 <span class="var-type">string</span>
1484 <span class="var-name">$more_where</span><span class="var-description">: The extra part of the where clause</span> </li>
1485 </ul>
1488 </div>
1489 <a name="methodOrWhere" id="OrWhere"><!-- --></a>
1490 <div class="evenrow">
1492 <div class="method-header">
1493 <img src="../../media/images/Method.png" />
1494 <span class="method-title">OrWhere</span> (line <span class="line-number">442</span>)
1495 </div>
1497 <!-- ========== Info from phpDoc block ========= -->
1498 <p class="short-description">Add an OR ... to the SQL Where clause</p>
1500 <div class="method-signature">
1501 <span class="method-result">void</span>
1502 <span class="method-name">
1503 OrWhere
1504 </span>
1505 (<span class="var-type">string</span>&nbsp;<span class="var-name">$more_where</span>)
1506 </div>
1508 <ul class="parameters">
1509 <li>
1510 <span class="var-type">string</span>
1511 <span class="var-name">$more_where</span><span class="var-description">: The extra part of the where clause</span> </li>
1512 </ul>
1515 </div>
1516 <a name="methodRender" id="Render"><!-- --></a>
1517 <div class="oddrow">
1519 <div class="method-header">
1520 <img src="../../media/images/Method.png" />
1521 <span class="method-title">Render</span> (line <span class="line-number">702</span>)
1522 </div>
1524 <!-- ========== Info from phpDoc block ========= -->
1525 <p class="short-description">This method is used to render the browser as HTML. If the query has not yet been executed then this will call DoQuery to do so.</p>
1526 <p class="description"><p>The browser (including the title) will be displayed in a div with id=&quot;browser&quot; so that you can style '#browser tr.header', '#browser tr.totals' and so forth.</p></p>
1527 <ul class="tags">
1528 <li><span class="field">return:</span> The rendered HTML fragment to display to the user.</li>
1529 </ul>
1531 <div class="method-signature">
1532 <span class="method-result">string</span>
1533 <span class="method-name">
1534 Render
1535 </span>
1536 ([<span class="var-type">string</span>&nbsp;<span class="var-name">$title_tag</span> = <span class="var-default">null</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$subtitle_tag</span> = <span class="var-default">null</span>])
1537 </div>
1539 <ul class="parameters">
1540 <li>
1541 <span class="var-type">string</span>
1542 <span class="var-name">$title_tag</span><span class="var-description">: The tag to use around the browser title (default 'h1')</span> </li>
1543 <li>
1544 <span class="var-type"></span>
1545 <span class="var-name">$subtitle_tag</span> </li>
1546 </ul>
1549 </div>
1550 <a name="methodRowFormat" id="RowFormat"><!-- --></a>
1551 <div class="evenrow">
1553 <div class="method-header">
1554 <img src="../../media/images/Method.png" />
1555 <span class="method-title">RowFormat</span> (line <span class="line-number">594</span>)
1556 </div>
1558 <!-- ========== Info from phpDoc block ========= -->
1559 <p class="short-description">Set the format for an output row.</p>
1560 <p class="description"><p>The row format is set as an sprintf format string for the start of the row, and a plain text string for the close of the row. Subsequent arguments are interpreted as names of fields, the values of which will be sprintf'd into the beginrow string for each row.</p><p>Some special field names exist beginning with the '#' character which have 'magic' functionality, including '#even' which will insert '0' for even rows and '1' for odd rows, allowing a nice colour alternation if the beginrow format refers to it like: 'class=&quot;r%d&quot;' so that even rows will become 'class=&quot;r0&quot;' and odd rows will be 'class=&quot;r1&quot;'.</p><p>At present only '#even' exists, although other magic values may be defined in future.</p></p>
1562 <div class="method-signature">
1563 <span class="method-result">void</span>
1564 <span class="method-name">
1565 RowFormat
1566 </span>
1567 (<span class="var-type">string</span>&nbsp;<span class="var-name">$beginrow</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$closerow</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$rowargs</span>)
1568 </div>
1570 <ul class="parameters">
1571 <li>
1572 <span class="var-type">string</span>
1573 <span class="var-name">$beginrow</span><span class="var-description">: The new printf format for the start of the row.</span> </li>
1574 <li>
1575 <span class="var-type">string</span>
1576 <span class="var-name">$closerow</span><span class="var-description">: The new string for the close of the row.</span> </li>
1577 <li>
1578 <span class="var-type">string</span>
1579 <span class="var-name">$rowargs</span><span class="var-description">: ... The row arguments which will be sprintf'd into the $beginrow format for each row</span> </li>
1580 </ul>
1583 </div>
1584 <a name="methodSetDistinct" id="SetDistinct"><!-- --></a>
1585 <div class="oddrow">
1587 <div class="method-header">
1588 <img src="../../media/images/Method.png" />
1589 <span class="method-title">SetDistinct</span> (line <span class="line-number">385</span>)
1590 </div>
1592 <!-- ========== Info from phpDoc block ========= -->
1593 <p class="short-description">Set the SQL DISTINCT clause to a specific value.</p>
1594 <p class="description"><p>The whole clause (except the keyword) needs to be supplied</p></p>
1596 <div class="method-signature">
1597 <span class="method-result">void</span>
1598 <span class="method-name">
1599 SetDistinct
1600 </span>
1601 (<span class="var-type">string</span>&nbsp;<span class="var-name">$distinct</span>)
1602 </div>
1604 <ul class="parameters">
1605 <li>
1606 <span class="var-type">string</span>
1607 <span class="var-name">$distinct</span><span class="var-description">: The whole clause, after 'DISTINCT'</span> </li>
1608 </ul>
1611 </div>
1612 <a name="methodSetDiv" id="SetDiv"><!-- --></a>
1613 <div class="evenrow">
1615 <div class="method-header">
1616 <img src="../../media/images/Method.png" />
1617 <span class="method-title">SetDiv</span> (line <span class="line-number">336</span>)
1618 </div>
1620 <!-- ========== Info from phpDoc block ========= -->
1621 <p class="short-description">Set a div for wrapping the browse.</p>
1623 <div class="method-signature">
1624 <span class="method-result">void</span>
1625 <span class="method-name">
1626 SetDiv
1627 </span>
1628 (<span class="var-type">string</span>&nbsp;<span class="var-name">$open_div</span>, <span class="var-type">string</span>&nbsp;<span class="var-name">$close_div</span>)
1629 </div>
1631 <ul class="parameters">
1632 <li>
1633 <span class="var-type">string</span>
1634 <span class="var-name">$open_div</span><span class="var-description">: The HTML to open the div</span> </li>
1635 <li>
1636 <span class="var-type">string</span>
1637 <span class="var-name">$close_div</span><span class="var-description">: The HTML to open the div</span> </li>
1638 </ul>
1641 </div>
1642 <a name="methodSetJoins" id="SetJoins"><!-- --></a>
1643 <div class="oddrow">
1645 <div class="method-header">
1646 <img src="../../media/images/Method.png" />
1647 <span class="method-title">SetJoins</span> (line <span class="line-number">350</span>)
1648 </div>
1650 <!-- ========== Info from phpDoc block ========= -->
1651 <p class="short-description">Set the tables and joins for the SQL.</p>
1652 <p class="description"><p>For a single table this should just contain the name of that table, but for multiple tables it should be the full content of the SQL 'FROM ...' clause (excluding the actual 'FROM' keyword).</p></p>
1654 <div class="method-signature">
1655 <span class="method-result">void</span>
1656 <span class="method-name">
1657 SetJoins
1658 </span>
1659 (<span class="var-type">string</span>&nbsp;<span class="var-name">$join_list</span>)
1660 </div>
1662 <ul class="parameters">
1663 <li>
1664 <span class="var-type">string</span>
1665 <span class="var-name">$join_list</span> </li>
1666 </ul>
1669 </div>
1670 <a name="methodSetLimit" id="SetLimit"><!-- --></a>
1671 <div class="evenrow">
1673 <div class="method-header">
1674 <img src="../../media/images/Method.png" />
1675 <span class="method-title">SetLimit</span> (line <span class="line-number">396</span>)
1676 </div>
1678 <!-- ========== Info from phpDoc block ========= -->
1679 <p class="short-description">Set the SQL LIMIT clause to a specific value.</p>
1680 <p class="description"><p>Only the limit number should be supplied.</p></p>
1682 <div class="method-signature">
1683 <span class="method-result">void</span>
1684 <span class="method-name">
1685 SetLimit
1686 </span>
1687 (<span class="var-type">int</span>&nbsp;<span class="var-name">$limit_n</span>)
1688 </div>
1690 <ul class="parameters">
1691 <li>
1692 <span class="var-type">int</span>
1693 <span class="var-name">$limit_n</span><span class="var-description">: A number of rows to limit the SQL selection to</span> </li>
1694 </ul>
1697 </div>
1698 <a name="methodSetOffset" id="SetOffset"><!-- --></a>
1699 <div class="oddrow">
1701 <div class="method-header">
1702 <img src="../../media/images/Method.png" />
1703 <span class="method-title">SetOffset</span> (line <span class="line-number">407</span>)
1704 </div>
1706 <!-- ========== Info from phpDoc block ========= -->
1707 <p class="short-description">Set the SQL OFFSET clause to a specific value.</p>
1708 <p class="description"><p>Only the offset number</p></p>
1710 <div class="method-signature">
1711 <span class="method-result">void</span>
1712 <span class="method-name">
1713 SetOffset
1714 </span>
1715 (<span class="var-type">int</span>&nbsp;<span class="var-name">$offset_n</span>)
1716 </div>
1718 <ul class="parameters">
1719 <li>
1720 <span class="var-type">int</span>
1721 <span class="var-name">$offset_n</span><span class="var-description">: A number of rows to offset the SQL selection to, based from the start of the results.</span> </li>
1722 </ul>
1725 </div>
1726 <a name="methodSetOrdering" id="SetOrdering"><!-- --></a>
1727 <div class="evenrow">
1729 <div class="method-header">
1730 <img src="../../media/images/Method.png" />
1731 <span class="method-title">SetOrdering</span> (line <span class="line-number">532</span>)
1732 </div>
1734 <!-- ========== Info from phpDoc block ========= -->
1735 <p class="short-description">Set up the ordering for the browser. Generally you should call this with the first parameter set as a field to order by default. Call with the second parameter set to 'D' or 'DESCEND' if you want to reverse the default order.</p>
1737 <div class="method-signature">
1738 <span class="method-result">void</span>
1739 <span class="method-name">
1740 SetOrdering
1741 </span>
1742 ([<span class="var-type"></span>&nbsp;<span class="var-name">$default_fld</span> = <span class="var-default">null</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$default_dir</span> = <span class="var-default">'A'</span>], [<span class="var-type"></span>&nbsp;<span class="var-name">$browser_array_key</span> = <span class="var-default">0</span>])
1743 </div>
1745 <ul class="parameters">
1746 <li>
1747 <span class="var-type"></span>
1748 <span class="var-name">$default_fld</span> </li>
1749 <li>
1750 <span class="var-type"></span>
1751 <span class="var-name">$default_dir</span> </li>
1752 <li>
1753 <span class="var-type"></span>
1754 <span class="var-name">$browser_array_key</span> </li>
1755 </ul>
1758 </div>
1759 <a name="methodSetSubTitle" id="SetSubTitle"><!-- --></a>
1760 <div class="oddrow">
1762 <div class="method-header">
1763 <img src="../../media/images/Method.png" />
1764 <span class="method-title">SetSubTitle</span> (line <span class="line-number">326</span>)
1765 </div>
1767 <!-- ========== Info from phpDoc block ========= -->
1768 <p class="short-description">Set a Sub Title for the browse.</p>
1770 <div class="method-signature">
1771 <span class="method-result">void</span>
1772 <span class="method-name">
1773 SetSubTitle
1774 </span>
1775 (<span class="var-type">string</span>&nbsp;<span class="var-name">$sub_title</span>)
1776 </div>
1778 <ul class="parameters">
1779 <li>
1780 <span class="var-type">string</span>
1781 <span class="var-name">$sub_title</span><span class="var-description">: The sub title string</span> </li>
1782 </ul>
1785 </div>
1786 <a name="methodSetTitle" id="SetTitle"><!-- --></a>
1787 <div class="evenrow">
1789 <div class="method-header">
1790 <img src="../../media/images/Method.png" />
1791 <span class="method-title">SetTitle</span> (line <span class="line-number">286</span>)
1792 </div>
1794 <!-- ========== Info from phpDoc block ========= -->
1795 <p class="short-description">Set the Title for the browse.</p>
1796 <p class="description"><p>This can also be set in the constructor but if you create a template Browser and then clone it in a loop you may want to assign a different Title for each instance.</p></p>
1798 <div class="method-signature">
1799 <span class="method-result">void</span>
1800 <span class="method-name">
1801 SetTitle
1802 </span>
1803 (<span class="var-type">string</span>&nbsp;<span class="var-name">$new_title</span>)
1804 </div>
1806 <ul class="parameters">
1807 <li>
1808 <span class="var-type">string</span>
1809 <span class="var-name">$new_title</span><span class="var-description">: The new title for the browser</span> </li>
1810 </ul>
1813 </div>
1814 <a name="methodSetTranslatable" id="SetTranslatable"><!-- --></a>
1815 <div class="oddrow">
1817 <div class="method-header">
1818 <img src="../../media/images/Method.png" />
1819 <span class="method-title">SetTranslatable</span> (line <span class="line-number">308</span>)
1820 </div>
1822 <!-- ========== Info from phpDoc block ========= -->
1823 <p class="short-description">Set the named columns to be translatable</p>
1825 <div class="method-signature">
1826 <span class="method-result">void</span>
1827 <span class="method-name">
1828 SetTranslatable
1829 </span>
1830 (<span class="var-type">array</span>&nbsp;<span class="var-name">$column_list</span>)
1831 </div>
1833 <ul class="parameters">
1834 <li>
1835 <span class="var-type">array</span>
1836 <span class="var-name">$column_list</span><span class="var-description">: The list of columns which are translatable</span> </li>
1837 </ul>
1840 </div>
1841 <a name="methodSetUnion" id="SetUnion"><!-- --></a>
1842 <div class="evenrow">
1844 <div class="method-header">
1845 <img src="../../media/images/Method.png" />
1846 <span class="method-title">SetUnion</span> (line <span class="line-number">363</span>)
1847 </div>
1849 <!-- ========== Info from phpDoc block ========= -->
1850 <p class="short-description">Set a Union SQL statement.</p>
1851 <p class="description"><p>In rare cases this might be useful. It's currently a fairly simple hack which requires you to put an entire valid (&amp; matching) UNION subclause (although without the UNION keyword).</p></p>
1853 <div class="method-signature">
1854 <span class="method-result">void</span>
1855 <span class="method-name">
1856 SetUnion
1857 </span>
1858 (<span class="var-type">string</span>&nbsp;<span class="var-name">$union_select</span>)
1859 </div>
1861 <ul class="parameters">
1862 <li>
1863 <span class="var-type">string</span>
1864 <span class="var-name">$union_select</span> </li>
1865 </ul>
1868 </div>
1869 <a name="methodSetWhere" id="SetWhere"><!-- --></a>
1870 <div class="oddrow">
1872 <div class="method-header">
1873 <img src="../../media/images/Method.png" />
1874 <span class="method-title">SetWhere</span> (line <span class="line-number">374</span>)
1875 </div>
1877 <!-- ========== Info from phpDoc block ========= -->
1878 <p class="short-description">Set the SQL Where clause to a specific value.</p>
1879 <p class="description"><p>The WHERE keyword should not be included.</p></p>
1881 <div class="method-signature">
1882 <span class="method-result">void</span>
1883 <span class="method-name">
1884 SetWhere
1885 </span>
1886 (<span class="var-type">string</span>&nbsp;<span class="var-name">$where_clause</span>)
1887 </div>
1889 <ul class="parameters">
1890 <li>
1891 <span class="var-type">string</span>
1892 <span class="var-name">$where_clause</span><span class="var-description">: A valide SQL WHERE ... clause.</span> </li>
1893 </ul>
1896 </div>
1897 <a name="methodTitle" id="Title"><!-- --></a>
1898 <div class="evenrow">
1900 <div class="method-header">
1901 <img src="../../media/images/Method.png" />
1902 <span class="method-title">Title</span> (line <span class="line-number">297</span>)
1903 </div>
1905 <!-- ========== Info from phpDoc block ========= -->
1906 <p class="short-description">Accessor for the Title for the browse, which could set the title also.</p>
1907 <ul class="tags">
1908 <li><span class="field">return:</span> The current title for the browser</li>
1909 </ul>
1911 <div class="method-signature">
1912 <span class="method-result">string</span>
1913 <span class="method-name">
1914 Title
1915 </span>
1916 ([<span class="var-type">string</span>&nbsp;<span class="var-name">$new_title</span> = <span class="var-default">null</span>])
1917 </div>
1919 <ul class="parameters">
1920 <li>
1921 <span class="var-type">string</span>
1922 <span class="var-name">$new_title</span><span class="var-description">: The new title for the browser</span> </li>
1923 </ul>
1926 </div>
1927 <a name="methodValueReplacement" id="ValueReplacement"><!-- --></a>
1928 <div class="oddrow">
1930 <div class="method-header">
1931 <img src="../../media/images/Method.png" />
1932 <span class="method-title">ValueReplacement</span> (line <span class="line-number">673</span>)
1933 </div>
1935 <!-- ========== Info from phpDoc block ========= -->
1936 <p class="short-description">Return values from the current row for replacing into a template.</p>
1937 <p class="description"><p>This is used to return values from the current row, so they can be inserted into a row template. It is used as a callback function for preg_replace_callback.</p></p>
1939 <div class="method-signature">
1940 <span class="method-result">void</span>
1941 <span class="method-name">
1942 ValueReplacement
1943 </span>
1944 (<span class="var-type">array</span>&nbsp;<span class="var-name">$matches</span>)
1945 </div>
1947 <ul class="parameters">
1948 <li>
1949 <span class="var-type">array</span>
1950 <span class="var-name">$matches</span><span class="var-description">: of string $matches An array containing a field name as offset 1</span> </li>
1951 </ul>
1954 </div>
1956 </div>
1957 </div>
1960 <p class="notes" id="credit">
1961 Documentation generated on Tue, 28 Dec 2010 02:01:35 +1300 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.3</a>
1962 </p>
1963 </div></body>
1964 </html>