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">
5 <!-- template designed by Marco Von Ballmoos -->
6 <title>Docs For Class AwlQuery
</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){
18 // Nav
4.x code fork...
19 var oTable = document.layers[
"span" + Node];
20 var oImg = document.layers[
"img" + Node];
23 // IE
4/
5 code fork...
24 var oTable = document.all[
"span" + Node];
25 var oImg = document.all[
"img" + Node];
28 // Standards Compliant code fork...
29 var oTable = document.getElementById(
"span" + Node);
30 var oImg = document.getElementById(
"img" + Node);
33 oImg.src = imgMinus.src;
34 oTable.style.display =
"block";
37 function hideNode(Node){
38 switch(navigator.family){
40 // Nav
4.x code fork...
41 var oTable = document.layers[
"span" + Node];
42 var oImg = document.layers[
"img" + Node];
45 // IE
4/
5 code fork...
46 var oTable = document.all[
"span" + Node];
47 var oImg = document.all[
"img" + Node];
50 // Standards Compliant code fork...
51 var oTable = document.getElementById(
"span" + Node);
52 var oImg = document.getElementById(
"img" + Node);
55 oImg.src = imgPlus.src;
56 oTable.style.display =
"none";
59 function nodeIsVisible(Node){
60 switch(navigator.family){
62 // Nav
4.x code fork...
63 var oTable = document.layers[
"span" + Node];
66 // IE
4/
5 code fork...
67 var oTable = document.all[
"span" + Node];
70 // Standards Compliant code fork...
71 var oTable = document.getElementById(
"span" + Node);
74 return (oTable && oTable.style.display ==
"block");
77 function toggleNodeVisibility(Node){
78 if (nodeIsVisible(Node)){
87 <div class=
"page-body">
88 <h2 class=
"class-name"><img src=
"../../media/images/Class_logo.png"
91 style=
"vertical-align: middle"> AwlQuery
</h2>
93 <a name=
"sec-description"></a>
94 <div class=
"info-box">
95 <div class=
"info-box-title">Description
</div>
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>)
102 <div class=
"info-box-body">
103 <!-- ========== Info from phpDoc block ========= -->
104 <p class=
"short-description">The AwlQuery Class.
</p>
105 <p class=
"description"><p>This class builds and executes SQL Queries and traverses the set of results returned from the query.
</p><p><strong>Example usage
</strong> <div class=
"src-code"><ol><li><div class=
"src-line"> <span class=
"src-var">$sql
</span>=
<span class=
"src-str">"SELECT
*
FROM
mytable
WHERE
mytype
=
?
"</span><span class=
"src-sym">;
</span></div></li>
106 <li><div class=
"src-line"> <span class=
"src-var">$qry
</span>=
<span class=
"src-key">new
</span><span class=
"src-id"><a href=
"../../awl/AwlDatabase/AwlQuery.html">AwlQuery
</a></span><span class=
"src-sym">(
</span><span class=
"src-var">$sql
</span><span class=
"src-sym">,
</span><span class=
"src-var">$myunsanitisedtype
</span><span class=
"src-sym">)
</span><span class=
"src-sym">;
</span></div></li>
107 <li><div class=
"src-line"> <span class=
"src-key">if
</span><span class=
"src-sym">(
</span><span class=
"src-var">$qry
</span><span class=
"src-sym">-
></span><a href=
"../../awl/AwlDatabase/AwlQuery.html#methodExec">Exec
</a><span class=
"src-sym">(
</span><span class=
"src-str">"typeselect
"</span><span class=
"src-sym">,
</span>__line__
<span class=
"src-sym">,
</span>__file__
<span class=
"src-sym">)
</span></div></li>
108 <li><div class=
"src-line"> && <span class=
"src-var">$qry
</span><span class=
"src-sym">-
></span><a href=
"../../awl/AwlDatabase/AwlQuery.html#methodrows">rows
</a> > <span class=
"src-num">0 </span><span class=
"src-sym">)
</span></div></li>
109 <li><div class=
"src-line"> <span class=
"src-sym">{
</span></div></li>
110 <li><div class=
"src-line"> <span class=
"src-key">while
</span><span class=
"src-sym">(
</span><span class=
"src-var">$row
</span>=
<span class=
"src-var">$qry
</span><span class=
"src-sym">-
></span><a href=
"../../awl/AwlDatabase/AwlQuery.html#methodFetch">Fetch
</a><span class=
"src-sym">(
</span><span class=
"src-sym">)
)
</span><span class=
"src-sym">{
</span></div></li>
111 <li><div class=
"src-line"> <span class=
"src-id">do_something_with
</span><span class=
"src-sym">(
</span><span class=
"src-var">$row
</span><span class=
"src-sym">)
</span><span class=
"src-sym">;
</span></div></li>
112 <li><div class=
"src-line"> <span class=
"src-sym">}
</span></div></li>
113 <li><div class=
"src-line"> <span class=
"src-sym">}
</span></div></li>
116 Located in
<a class=
"field" href=
"_AwlQuery.php.html">/AwlQuery.php
</a> (line
<span class=
"field">117</span>)
127 <a name=
"sec-var-summary"></a>
128 <div class=
"info-box">
129 <div class=
"info-box-title">Variable Summary
</span></div>
130 <div class=
"nav-bar">
131 <a href=
"#sec-description">Description
</a> |
132 <span class=
"disabled">Vars
</span> (
<a href=
"#sec-vars">details
</a>)
134 <a href=
"#sec-method-summary">Methods
</a> (
<a href=
"#sec-methods">details
</a>)
137 <div class=
"info-box-body">
138 <div class=
"var-summary">
139 <div class=
"var-title">
140 <img src=
"../../media/images/Variable.png" alt=
" " />
141 <span class=
"var-type">array
</span>
142 <a href=
"#$bound_parameters" title=
"details" class=
"var-name">$bound_parameters
</a>
144 <div class=
"var-title">
145 <img src=
"../../media/images/Variable.png" alt=
" " />
146 <span class=
"var-type">string
</span>
147 <a href=
"#$bound_querystring" title=
"details" class=
"var-name">$bound_querystring
</a>
149 <div class=
"var-title">
150 <img src=
"../../media/images/Variable.png" alt=
" " />
151 <span class=
"var-type">resource
</span>
152 <a href=
"#$connection" title=
"details" class=
"var-name">$connection
</a>
154 <div class=
"var-title">
155 <img src=
"../../media/images/Variable.png" alt=
" " />
156 <span class=
"var-type">string
</span>
157 <a href=
"#$error_info" title=
"details" class=
"var-name">$error_info
</a>
159 <div class=
"var-title">
160 <img src=
"../../media/images/Variable.png" alt=
" " />
161 <span class=
"var-type">string
</span>
162 <a href=
"#$execution_time" title=
"details" class=
"var-name">$execution_time
</a>
164 <div class=
"var-title">
165 <img src=
"../../media/images/Variable.png" alt=
" " />
166 <span class=
"var-type">string
</span>
167 <a href=
"#$location" title=
"details" class=
"var-name">$location
</a>
169 <div class=
"var-title">
170 <img src=
"../../media/images/Variable.png" alt=
" " />
171 <span class=
"var-type">string
</span>
172 <a href=
"#$querystring" title=
"details" class=
"var-name">$querystring
</a>
174 <div class=
"var-title">
175 <img src=
"../../media/images/Variable.png" alt=
" " />
176 <span class=
"var-type">double
</span>
177 <a href=
"#$query_time_warning" title=
"details" class=
"var-name">$query_time_warning
</a>
179 <div class=
"var-title">
180 <img src=
"../../media/images/Variable.png" alt=
" " />
181 <span class=
"var-type">resource
</span>
182 <a href=
"#$result" title=
"details" class=
"var-name">$result
</a>
184 <div class=
"var-title">
185 <img src=
"../../media/images/Variable.png" alt=
" " />
186 <span class=
"var-type">int
</span>
187 <a href=
"#$rownum" title=
"details" class=
"var-name">$rownum
</a>
189 <div class=
"var-title">
190 <img src=
"../../media/images/Variable.png" alt=
" " />
191 <span class=
"var-type">int
</span>
192 <a href=
"#$rows" title=
"details" class=
"var-name">$rows
</a>
194 <div class=
"var-title">
195 <img src=
"../../media/images/Variable.png" alt=
" " />
196 <span class=
"var-type">string
</span>
197 <a href=
"#$sth" title=
"details" class=
"var-name">$sth
</a>
203 <a name=
"sec-method-summary"></a>
204 <div class=
"info-box">
205 <div class=
"info-box-title">Method Summary
</span></div>
206 <div class=
"nav-bar">
207 <a href=
"#sec-description">Description
</a> |
208 <a href=
"#sec-var-summary">Vars
</a> (
<a href=
"#sec-vars">details
</a>)
211 <span class=
"disabled">Methods
</span> (
<a href=
"#sec-methods">details
</a>)
213 <div class=
"info-box-body">
214 <div class=
"method-summary">
216 <div class=
"method-definition">
217 <img src=
"../../media/images/Constructor.png" alt=
" "/>
218 <span class=
"method-result">The
</span>
219 <a href=
"#__construct" title=
"details" class=
"method-name">__construct
</a>
220 (
<span class=
"var-type">string
</span> <span class=
"var-name">0</span>,
<span class=
"var-type">mixed
</span> <span class=
"var-name">1</span>)
223 <div class=
"method-definition">
224 <img src=
"../../media/images/Method.png" alt=
" "/>
225 <span class=
"method-result">void
</span>
226 <a href=
"#Begin" title=
"details" class=
"method-name">Begin
</a>
230 <div class=
"method-definition">
231 <img src=
"../../media/images/Method.png" alt=
" "/>
232 <span class=
"method-result">void
</span>
233 <a href=
"#Bind" title=
"details" class=
"method-name">Bind
</a>
234 (
<span class=
"var-type">mixed
</span> <span class=
"var-name">$args
</span>)
237 <div class=
"method-definition">
238 <img src=
"../../media/images/Method.png" alt=
" "/>
239 <span class=
"method-result">void
</span>
240 <a href=
"#Commit" title=
"details" class=
"method-name">Commit
</a>
244 <div class=
"method-definition">
245 <img src=
"../../media/images/Method.png" alt=
" "/>
246 <span class=
"method-result">boolean
</span>
247 <a href=
"#Exec" title=
"details" class=
"method-name">Exec
</a>
248 ([
<span class=
"var-type">string
</span> <span class=
"var-name">$location
</span> =
<span class=
"var-default">null
</span>], [
<span class=
"var-type">int
</span> <span class=
"var-name">$line
</span> =
<span class=
"var-default">null
</span>], [
<span class=
"var-type">string
</span> <span class=
"var-name">$file
</span> =
<span class=
"var-default">null
</span>])
251 <div class=
"method-definition">
252 <img src=
"../../media/images/Method.png" alt=
" "/>
253 <span class=
"method-result">void
</span>
254 <a href=
"#Execute" title=
"details" class=
"method-name">Execute
</a>
258 <div class=
"method-definition">
259 <img src=
"../../media/images/Method.png" alt=
" "/>
260 <span class=
"method-result">mixed
</span>
261 <a href=
"#Fetch" title=
"details" class=
"method-name">Fetch
</a>
262 ([
<span class=
"var-type">boolean
</span> <span class=
"var-name">$as_array
</span> =
<span class=
"var-default">false
</span>])
265 <div class=
"method-definition">
266 <img src=
"../../media/images/Method.png" alt=
" "/>
267 <span class=
"method-result">void
</span>
268 <a href=
"#Parameters" title=
"details" class=
"method-name">Parameters
</a>
272 <div class=
"method-definition">
273 <img src=
"../../media/images/Method.png" alt=
" "/>
274 <span class=
"method-result">void
</span>
275 <a href=
"#Prepare" title=
"details" class=
"method-name">Prepare
</a>
279 <div class=
"method-definition">
280 <img src=
"../../media/images/Method.png" alt=
" "/>
281 <span class=
"method-result">boolean
</span>
282 <a href=
"#QDo" title=
"details" class=
"method-name">QDo
</a>
283 (
<span class=
"var-type">string
</span> <span class=
"var-name">0</span>,
<span class=
"var-type">mixed
</span> <span class=
"var-name">1</span>)
286 <div class=
"method-definition">
287 <img src=
"../../media/images/Method.png" alt=
" "/>
288 <span class=
"method-result">void
</span>
289 <a href=
"#QueryString" title=
"details" class=
"method-name">QueryString
</a>
293 <div class=
"method-definition">
294 <img src=
"../../media/images/Method.png" alt=
" "/>
295 <span class=
"method-result">string
</span>
296 <a href=
"#quote" title=
"details" class=
"method-name">quote
</a>
297 ([
<span class=
"var-type">mixed
</span> <span class=
"var-name">$str
</span> =
<span class=
"var-default">null
</span>])
300 <div class=
"method-definition">
301 <img src=
"../../media/images/Method.png" alt=
" "/>
302 <span class=
"method-result">void
</span>
303 <a href=
"#Rollback" title=
"details" class=
"method-name">Rollback
</a>
307 <div class=
"method-definition">
308 <img src=
"../../media/images/Method.png" alt=
" "/>
309 <span class=
"method-result">void
</span>
310 <a href=
"#rows" title=
"details" class=
"method-name">rows
</a>
314 <div class=
"method-definition">
315 <img src=
"../../media/images/Method.png" alt=
" "/>
316 <span class=
"method-result">void
</span>
317 <a href=
"#SetConnection" title=
"details" class=
"method-name">SetConnection
</a>
318 (
<span class=
"var-type">resource
</span> <span class=
"var-name">$new_connection
</span>, [
<span class=
"var-type"></span> <span class=
"var-name">$options
</span> =
<span class=
"var-default">null
</span>])
321 <div class=
"method-definition">
322 <img src=
"../../media/images/Method.png" alt=
" "/>
323 <span class=
"method-result">void
</span>
324 <a href=
"#SetSql" title=
"details" class=
"method-name">SetSql
</a>
325 (
<span class=
"var-type">string
</span> <span class=
"var-name">$sql
</span>)
328 <div class=
"method-definition">
329 <img src=
"../../media/images/Method.png" alt=
" "/>
330 <span class=
"method-result">void
</span>
331 <a href=
"#TransactionState" title=
"details" class=
"method-name">TransactionState
</a>
335 <div class=
"method-definition">
336 <img src=
"../../media/images/Method.png" alt=
" "/>
337 <span class=
"method-result">void
</span>
338 <a href=
"#_log_query" title=
"details" class=
"method-name">_log_query
</a>
339 (
<span class=
"var-type">string
</span> <span class=
"var-name">$locn
</span>,
<span class=
"var-type">string
</span> <span class=
"var-name">$tag
</span>,
<span class=
"var-type">string
</span> <span class=
"var-name">$string
</span>, [
<span class=
"var-type">int
</span> <span class=
"var-name">$line
</span> =
<span class=
"var-default">0</span>], [
<span class=
"var-type">string
</span> <span class=
"var-name">$file
</span> =
<span class=
"var-default">""</span>])
345 <a name=
"sec-vars"></a>
346 <div class=
"info-box">
347 <div class=
"info-box-title">Variables
</div>
348 <div class=
"nav-bar">
349 <a href=
"#sec-description">Description
</a> |
350 <a href=
"#sec-var-summary">Vars
</a> (
<span class=
"disabled">details
</span>)
354 <a href=
"#sec-method-summary">Methods
</a> (
<a href=
"#sec-methods">details
</a>)
357 <div class=
"info-box-body">
359 <a name=
"var$bound_parameters" id=
"$bound_parameters"><!-- --></A>
362 <div class=
"var-header">
363 <img src=
"../../media/images/Variable.png" />
364 <span class=
"var-title">
365 <span class=
"var-type">array
</span>
366 <span class=
"var-name">$bound_parameters
</span>
367 (line
<span class=
"line-number">144</span>)
371 <!-- ========== Info from phpDoc block ========= -->
372 <p class=
"short-description">The current array of bound parameters
</p>
374 <li><span class=
"field">access:
</span> protected
</li>
382 <a name=
"var$bound_querystring" id=
"$bound_querystring"><!-- --></A>
383 <div class=
"evenrow">
385 <div class=
"var-header">
386 <img src=
"../../media/images/Variable.png" />
387 <span class=
"var-title">
388 <span class=
"var-type">string
</span>
389 <span class=
"var-name">$bound_querystring
</span>
390 (line
<span class=
"line-number">138</span>)
394 <!-- ========== Info from phpDoc block ========= -->
395 <p class=
"short-description">The actual query string, after we've replaced parameters in it
</p>
397 <li><span class=
"field">access:
</span> protected
</li>
405 <a name=
"var$connection" id=
"$connection"><!-- --></A>
408 <div class=
"var-header">
409 <img src=
"../../media/images/Variable.png" />
410 <span class=
"var-title">
411 <span class=
"var-type">resource
</span>
412 <span class=
"var-name">$connection
</span>
413 (line
<span class=
"line-number">126</span>)
417 <!-- ========== Info from phpDoc block ========= -->
418 <p class=
"short-description">Our database connection, normally copied from a global one
</p>
420 <li><span class=
"field">access:
</span> protected
</li>
428 <a name=
"var$error_info" id=
"$error_info"><!-- --></A>
429 <div class=
"evenrow">
431 <div class=
"var-header">
432 <img src=
"../../media/images/Variable.png" />
433 <span class=
"var-title">
434 <span class=
"var-type">string
</span>
435 <span class=
"var-name">$error_info
</span>
436 (line
<span class=
"line-number">174</span>)
440 <!-- ========== Info from phpDoc block ========= -->
441 <p class=
"short-description">The Database error information, if the query fails.
</p>
443 <li><span class=
"field">access:
</span> protected
</li>
451 <a name=
"var$execution_time" id=
"$execution_time"><!-- --></A>
454 <div class=
"var-header">
455 <img src=
"../../media/images/Variable.png" />
456 <span class=
"var-title">
457 <span class=
"var-type">string
</span>
458 <span class=
"var-name">$execution_time
</span>
459 (line
<span class=
"line-number">181</span>)
463 <!-- ========== Info from phpDoc block ========= -->
464 <p class=
"short-description">Stores the query execution time - used to deal with long queries.
</p>
465 <p class=
"description"><p>should be read-only
</p></p>
467 <li><span class=
"field">access:
</span> protected
</li>
475 <a name=
"var$location" id=
"$location"><!-- --></A>
476 <div class=
"evenrow">
478 <div class=
"var-header">
479 <img src=
"../../media/images/Variable.png" />
480 <span class=
"var-title">
481 <span class=
"var-type">string
</span>
482 <span class=
"var-name">$location
</span>
483 (line
<span class=
"line-number">193</span>)
487 <!-- ========== Info from phpDoc block ========= -->
488 <p class=
"short-description">Where we called this query from so we can find it in our code! Debugging may also be selectively enabled for a $location.
</p>
490 <li><span class=
"field">access:
</span> public
</li>
498 <a name=
"var$querystring" id=
"$querystring"><!-- --></A>
501 <div class=
"var-header">
502 <img src=
"../../media/images/Variable.png" />
503 <span class=
"var-title">
504 <span class=
"var-type">string
</span>
505 <span class=
"var-name">$querystring
</span>
506 (line
<span class=
"line-number">132</span>)
510 <!-- ========== Info from phpDoc block ========= -->
511 <p class=
"short-description">The original query string
</p>
513 <li><span class=
"field">access:
</span> protected
</li>
521 <a name=
"var$query_time_warning" id=
"$query_time_warning"><!-- --></A>
522 <div class=
"evenrow">
524 <div class=
"var-header">
525 <img src=
"../../media/images/Variable.png" />
526 <span class=
"var-title">
527 <span class=
"var-type">double
</span>
528 <span class=
"var-name">$query_time_warning
</span>
529 =
<span class=
"var-default"> 0.3</span> (line
<span class=
"line-number">202</span>)
533 <!-- ========== Info from phpDoc block ========= -->
534 <p class=
"short-description">How long the query should take before a warning is issued.
</p>
535 <p class=
"description"><p>This is writable, but a method to set it might be a better interface. The default is
0.3 seconds.
</p></p>
537 <li><span class=
"field">access:
</span> public
</li>
545 <a name=
"var$result" id=
"$result"><!-- --></A>
548 <div class=
"var-header">
549 <img src=
"../../media/images/Variable.png" />
550 <span class=
"var-title">
551 <span class=
"var-type">resource
</span>
552 <span class=
"var-name">$result
</span>
553 (line
<span class=
"line-number">156</span>)
557 <!-- ========== Info from phpDoc block ========= -->
558 <p class=
"short-description">Result of the last execution
</p>
560 <li><span class=
"field">access:
</span> protected
</li>
568 <a name=
"var$rownum" id=
"$rownum"><!-- --></A>
569 <div class=
"evenrow">
571 <div class=
"var-header">
572 <img src=
"../../media/images/Variable.png" />
573 <span class=
"var-title">
574 <span class=
"var-type">int
</span>
575 <span class=
"var-name">$rownum
</span>
576 =
<span class=
"var-default"> null
</span> (line
<span class=
"line-number">162</span>)
580 <!-- ========== Info from phpDoc block ========= -->
581 <p class=
"short-description">number of current row - use accessor to get/set
</p>
583 <li><span class=
"field">access:
</span> protected
</li>
591 <a name=
"var$rows" id=
"$rows"><!-- --></A>
594 <div class=
"var-header">
595 <img src=
"../../media/images/Variable.png" />
596 <span class=
"var-title">
597 <span class=
"var-type">int
</span>
598 <span class=
"var-name">$rows
</span>
599 (line
<span class=
"line-number">168</span>)
603 <!-- ========== Info from phpDoc block ========= -->
604 <p class=
"short-description">number of rows from pg_numrows - use accessor to get value
</p>
606 <li><span class=
"field">access:
</span> protected
</li>
614 <a name=
"var$sth" id=
"$sth"><!-- --></A>
615 <div class=
"evenrow">
617 <div class=
"var-header">
618 <img src=
"../../media/images/Variable.png" />
619 <span class=
"var-title">
620 <span class=
"var-type">string
</span>
621 <span class=
"var-name">$sth
</span>
622 (line
<span class=
"line-number">150</span>)
626 <!-- ========== Info from phpDoc block ========= -->
627 <p class=
"short-description">The PDO statement handle, or null if we don't have one yet.
</p>
629 <li><span class=
"field">access:
</span> protected
</li>
641 <a name=
"sec-methods"></a>
642 <div class=
"info-box">
643 <div class=
"info-box-title">Methods
</div>
644 <div class=
"nav-bar">
645 <a href=
"#sec-description">Description
</a> |
646 <a href=
"#sec-var-summary">Vars
</a> (
<a href=
"#sec-vars">details
</a>)
647 <a href=
"#sec-method-summary">Methods
</a> (
<span class=
"disabled">details
</span>)
650 <div class=
"info-box-body">
651 <A NAME='method_detail'
></A>
652 <a name=
"method__construct" id=
"__construct"><!-- --></a>
655 <div class=
"method-header">
656 <img src=
"../../media/images/Constructor.png" />
657 <span class=
"method-title">Constructor __construct
</span> (line
<span class=
"line-number">212</span>)
660 <!-- ========== Info from phpDoc block ========= -->
661 <p class=
"short-description">Constructor
</p>
663 <li><span class=
"field">return:
</span> AwlQuery object
</li>
666 <div class=
"method-signature">
667 <span class=
"method-result">The
</span>
668 <span class=
"method-name">
671 (
<span class=
"var-type">string
</span> <span class=
"var-name">0</span>,
<span class=
"var-type">mixed
</span> <span class=
"var-name">1</span>)
674 <ul class=
"parameters">
676 <span class=
"var-type">string
</span>
677 <span class=
"var-name">0</span><span class=
"var-description">: The query string in PDO syntax with replacable '?' characters or bindable parameters.
</span> </li>
679 <span class=
"var-type">mixed
</span>
680 <span class=
"var-name">1</span><span class=
"var-description">: The values to replace into the SQL string.
</span> </li>
685 <a name=
"methodBegin" id=
"Begin"><!-- --></a>
686 <div class=
"evenrow">
688 <div class=
"method-header">
689 <img src=
"../../media/images/Method.png" />
690 <span class=
"method-title">Begin
</span> (line
<span class=
"line-number">451</span>)
693 <!-- ========== Info from phpDoc block ========= -->
694 <p class=
"short-description">Wrap the parent DB class Begin() so we can $qry-
>Begin() sometime before we $qry-
>Exec()
</p>
696 <li><span class=
"field">access:
</span> public
</li>
699 <div class=
"method-signature">
700 <span class=
"method-result">void
</span>
701 <span class=
"method-name">
710 <a name=
"methodBind" id=
"Bind"><!-- --></a>
713 <div class=
"method-header">
714 <img src=
"../../media/images/Method.png" />
715 <span class=
"method-title">Bind
</span> (line
<span class=
"line-number">323</span>)
718 <!-- ========== Info from phpDoc block ========= -->
719 <p class=
"short-description">Bind some parameters. This can be called in three ways:
</p>
720 <p class=
"description"><p>1) As Bind(':key','value), when using named parameters
2) As Bind('value'), when using ? placeholders
3) As Bind(array()), to overwrite the existing bound parameters. The array may be ':name' =
> 'value' pairs or ordinal values, depending on whether the SQL is using ':name' or '?' style placeholders.
</p></p>
722 <div class=
"method-signature">
723 <span class=
"method-result">void
</span>
724 <span class=
"method-name">
727 (
<span class=
"var-type">mixed
</span> <span class=
"var-name">$args
</span>)
730 <ul class=
"parameters">
732 <span class=
"var-type">mixed
</span>
733 <span class=
"var-name">$args
</span><span class=
"var-description">: See details above.
</span> </li>
738 <a name=
"methodCommit" id=
"Commit"><!-- --></a>
739 <div class=
"evenrow">
741 <div class=
"method-header">
742 <img src=
"../../media/images/Method.png" />
743 <span class=
"method-title">Commit
</span> (line
<span class=
"line-number">464</span>)
746 <!-- ========== Info from phpDoc block ========= -->
747 <p class=
"short-description">Wrap the parent DB class Commit() so we can $qry-
>Commit() sometime after we $qry-
>Exec()
</p>
749 <li><span class=
"field">access:
</span> public
</li>
752 <div class=
"method-signature">
753 <span class=
"method-result">void
</span>
754 <span class=
"method-name">
763 <a name=
"methodExec" id=
"Exec"><!-- --></a>
766 <div class=
"method-header">
767 <img src=
"../../media/images/Method.png" />
768 <span class=
"method-title">Exec
</span> (line
<span class=
"line-number">540</span>)
771 <!-- ========== Info from phpDoc block ========= -->
772 <p class=
"short-description">Execute the query, logging any debugging.
</p>
773 <p class=
"description"><p><strong>Example
</strong> So that you can nicely enable/disable the queries for a particular class, you could use some of PHPs magic constants in your call.
<div class=
"src-code"><ol><li><div class=
"src-line"> <span class=
"src-var">$qry
</span><span class=
"src-sym">-
></span><a href=
"../../awl/AwlDatabase/AwlQuery.html#methodExec">Exec
</a><span class=
"src-sym">(
</span>__CLASS__
<span class=
"src-sym">,
</span>__LINE__
<span class=
"src-sym">,
</span>__FILE__
<span class=
"src-sym">)
</span><span class=
"src-sym">;
</span></div></li>
776 <li><span class=
"field">return:
</span> Success (true) or Failure (false)
</li>
779 <div class=
"method-signature">
780 <span class=
"method-result">boolean
</span>
781 <span class=
"method-name">
784 ([
<span class=
"var-type">string
</span> <span class=
"var-name">$location
</span> =
<span class=
"var-default">null
</span>], [
<span class=
"var-type">int
</span> <span class=
"var-name">$line
</span> =
<span class=
"var-default">null
</span>], [
<span class=
"var-type">string
</span> <span class=
"var-name">$file
</span> =
<span class=
"var-default">null
</span>])
787 <ul class=
"parameters">
789 <span class=
"var-type">string
</span>
790 <span class=
"var-name">$location
</span><span class=
"var-description">: The name of the location for enabling debugging or just to help our children find the source of a problem.
</span> </li>
792 <span class=
"var-type">int
</span>
793 <span class=
"var-name">$line
</span><span class=
"var-description">: The line number where Exec was called
</span> </li>
795 <span class=
"var-type">string
</span>
796 <span class=
"var-name">$file
</span><span class=
"var-description">: The file where Exec was called
</span> </li>
801 <a name=
"methodExecute" id=
"Execute"><!-- --></a>
802 <div class=
"evenrow">
804 <div class=
"method-header">
805 <img src=
"../../media/images/Method.png" />
806 <span class=
"method-title">Execute
</span> (line
<span class=
"line-number">367</span>)
809 <!-- ========== Info from phpDoc block ========= -->
810 <p class=
"short-description">Tell the database to execute the query
</p>
812 <div class=
"method-signature">
813 <span class=
"method-result">void
</span>
814 <span class=
"method-name">
823 <a name=
"methodFetch" id=
"Fetch"><!-- --></a>
826 <div class=
"method-header">
827 <img src=
"../../media/images/Method.png" />
828 <span class=
"method-title">Fetch
</span> (line
<span class=
"line-number">604</span>)
831 <!-- ========== Info from phpDoc block ========= -->
832 <p class=
"short-description">Fetch the next row from the query results
</p>
834 <li><span class=
"field">return:
</span> query row
</li>
837 <div class=
"method-signature">
838 <span class=
"method-result">mixed
</span>
839 <span class=
"method-name">
842 ([
<span class=
"var-type">boolean
</span> <span class=
"var-name">$as_array
</span> =
<span class=
"var-default">false
</span>])
845 <ul class=
"parameters">
847 <span class=
"var-type">boolean
</span>
848 <span class=
"var-name">$as_array
</span><span class=
"var-description">: True if thing to be returned is array
</span> </li>
853 <a name=
"methodParameters" id=
"Parameters"><!-- --></a>
854 <div class=
"evenrow">
856 <div class=
"method-header">
857 <img src=
"../../media/images/Method.png" />
858 <span class=
"method-title">Parameters
</span> (line
<span class=
"line-number">421</span>)
861 <!-- ========== Info from phpDoc block ========= -->
862 <p class=
"short-description">Return the parameters we are planning to substitute into the query string
</p>
864 <div class=
"method-signature">
865 <span class=
"method-result">void
</span>
866 <span class=
"method-name">
875 <a name=
"methodPrepare" id=
"Prepare"><!-- --></a>
878 <div class=
"method-header">
879 <img src=
"../../media/images/Method.png" />
880 <span class=
"method-title">Prepare
</span> (line
<span class=
"line-number">344</span>)
883 <!-- ========== Info from phpDoc block ========= -->
884 <p class=
"short-description">Tell the database to prepare the query that we will execute
</p>
886 <div class=
"method-signature">
887 <span class=
"method-result">void
</span>
888 <span class=
"method-name">
897 <a name=
"methodQDo" id=
"QDo"><!-- --></a>
898 <div class=
"evenrow">
900 <div class=
"method-header">
901 <img src=
"../../media/images/Method.png" />
902 <span class=
"method-title">QDo
</span> (line
<span class=
"line-number">507</span>)
905 <!-- ========== Info from phpDoc block ========= -->
906 <p class=
"short-description">Simple QDo() class which will re-use this query for whatever was passed in, and execute it returning the result of the Exec() call. We can't call it Do() since that's a reserved word...
</p>
908 <li><span class=
"field">return:
</span> Success (true) or Failure (false)
</li>
909 <li><span class=
"field">access:
</span> public
</li>
912 <div class=
"method-signature">
913 <span class=
"method-result">boolean
</span>
914 <span class=
"method-name">
917 (
<span class=
"var-type">string
</span> <span class=
"var-name">0</span>,
<span class=
"var-type">mixed
</span> <span class=
"var-name">1</span>)
920 <ul class=
"parameters">
922 <span class=
"var-type">string
</span>
923 <span class=
"var-name">0</span><span class=
"var-description">: The query string in PDO syntax with replacable '?' characters or bindable parameters.
</span> </li>
925 <span class=
"var-type">mixed
</span>
926 <span class=
"var-name">1</span><span class=
"var-description">: The values to replace into the SQL string.
</span> </li>
931 <a name=
"methodQueryString" id=
"QueryString"><!-- --></a>
934 <div class=
"method-header">
935 <img src=
"../../media/images/Method.png" />
936 <span class=
"method-title">QueryString
</span> (line
<span class=
"line-number">413</span>)
939 <!-- ========== Info from phpDoc block ========= -->
940 <p class=
"short-description">Return the query string we are planning to execute
</p>
942 <div class=
"method-signature">
943 <span class=
"method-result">void
</span>
944 <span class=
"method-name">
953 <a name=
"methodquote" id=
"quote"><!-- --></a>
954 <div class=
"evenrow">
956 <div class=
"method-header">
957 <img src=
"../../media/images/Method.png" />
958 <span class=
"method-title">quote
</span> (line
<span class=
"line-number">304</span>)
961 <!-- ========== Info from phpDoc block ========= -->
962 <p class=
"short-description">Quote the given string so it can be safely used within string delimiters in a query. To be avoided, in general.
</p>
964 <li><span class=
"field">return:
</span> NULL, TRUE, FALSE, a plain number, or the original string quoted and with ' and \ characters escaped
</li>
967 <div class=
"method-signature">
968 <span class=
"method-result">string
</span>
969 <span class=
"method-name">
972 ([
<span class=
"var-type">mixed
</span> <span class=
"var-name">$str
</span> =
<span class=
"var-default">null
</span>])
975 <ul class=
"parameters">
977 <span class=
"var-type">mixed
</span>
978 <span class=
"var-name">$str
</span><span class=
"var-description">: Data to be converted to a string suitable for including as a value in SQL.
</span> </li>
983 <a name=
"methodRollback" id=
"Rollback"><!-- --></a>
986 <div class=
"method-header">
987 <img src=
"../../media/images/Method.png" />
988 <span class=
"method-title">Rollback
</span> (line
<span class=
"line-number">475</span>)
991 <!-- ========== Info from phpDoc block ========= -->
992 <p class=
"short-description">Wrap the parent DB class Rollback() so we can $qry-
>Rollback() sometime after we $qry-
>Exec()
</p>
994 <li><span class=
"field">access:
</span> public
</li>
997 <div class=
"method-signature">
998 <span class=
"method-result">void
</span>
999 <span class=
"method-name">
1008 <a name=
"methodrows" id=
"rows"><!-- --></a>
1009 <div class=
"evenrow">
1011 <div class=
"method-header">
1012 <img src=
"../../media/images/Method.png" />
1013 <span class=
"method-title">rows
</span> (line
<span class=
"line-number">429</span>)
1016 <!-- ========== Info from phpDoc block ========= -->
1017 <p class=
"short-description">Return the count of rows retrieved/affected
</p>
1019 <div class=
"method-signature">
1020 <span class=
"method-result">void
</span>
1021 <span class=
"method-name">
1030 <a name=
"methodSetConnection" id=
"SetConnection"><!-- --></a>
1031 <div class=
"oddrow">
1033 <div class=
"method-header">
1034 <img src=
"../../media/images/Method.png" />
1035 <span class=
"method-title">SetConnection
</span> (line
<span class=
"line-number">241</span>)
1038 <!-- ========== Info from phpDoc block ========= -->
1039 <p class=
"short-description">Use a different database connection for this query
</p>
1041 <div class=
"method-signature">
1042 <span class=
"method-result">void
</span>
1043 <span class=
"method-name">
1046 (
<span class=
"var-type">resource
</span> <span class=
"var-name">$new_connection
</span>, [
<span class=
"var-type"></span> <span class=
"var-name">$options
</span> =
<span class=
"var-default">null
</span>])
1049 <ul class=
"parameters">
1051 <span class=
"var-type">resource
</span>
1052 <span class=
"var-name">$new_connection
</span><span class=
"var-description">: The database connection to use.
</span> </li>
1054 <span class=
"var-type"></span>
1055 <span class=
"var-name">$options
</span> </li>
1060 <a name=
"methodSetSql" id=
"SetSql"><!-- --></a>
1061 <div class=
"evenrow">
1063 <div class=
"method-header">
1064 <img src=
"../../media/images/Method.png" />
1065 <span class=
"method-title">SetSql
</span> (line
<span class=
"line-number">487</span>)
1068 <!-- ========== Info from phpDoc block ========= -->
1069 <p class=
"short-description">Simple SetSql() class which will reset the object with the querystring from the first argument.
</p>
1071 <li><span class=
"field">access:
</span> public
</li>
1074 <div class=
"method-signature">
1075 <span class=
"method-result">void
</span>
1076 <span class=
"method-name">
1079 (
<span class=
"var-type">string
</span> <span class=
"var-name">$sql
</span>)
1082 <ul class=
"parameters">
1084 <span class=
"var-type">string
</span>
1085 <span class=
"var-name">$sql
</span><span class=
"var-description">: The query string in PDO syntax with replacable '?' characters or bindable parameters.
</span> </li>
1090 <a name=
"methodTransactionState" id=
"TransactionState"><!-- --></a>
1091 <div class=
"oddrow">
1093 <div class=
"method-header">
1094 <img src=
"../../media/images/Method.png" />
1095 <span class=
"method-title">TransactionState
</span> (line
<span class=
"line-number">438</span>)
1098 <!-- ========== Info from phpDoc block ========= -->
1099 <p class=
"short-description">Returns the current state of a transaction, indicating if we have begun a transaction, whether the transaction has failed, or if we are not in a transaction.
</p>
1101 <div class=
"method-signature">
1102 <span class=
"method-result">void
</span>
1103 <span class=
"method-name">
1112 <a name=
"method_log_query" id=
"_log_query"><!-- --></a>
1113 <div class=
"evenrow">
1115 <div class=
"method-header">
1116 <img src=
"../../media/images/Method.png" />
1117 <span class=
"method-title">_log_query
</span> (line
<span class=
"line-number">282</span>)
1120 <!-- ========== Info from phpDoc block ========= -->
1121 <p class=
"short-description">Log query, optionally with file and line location of the caller.
</p>
1122 <p class=
"description"><p>This function should not really be used outside of AwlQuery. For a more useful generic logging interface consider calling dbg_error_log(...);
</p></p>
1124 <div class=
"method-signature">
1125 <span class=
"method-result">void
</span>
1126 <span class=
"method-name">
1129 (
<span class=
"var-type">string
</span> <span class=
"var-name">$locn
</span>,
<span class=
"var-type">string
</span> <span class=
"var-name">$tag
</span>,
<span class=
"var-type">string
</span> <span class=
"var-name">$string
</span>, [
<span class=
"var-type">int
</span> <span class=
"var-name">$line
</span> =
<span class=
"var-default">0</span>], [
<span class=
"var-type">string
</span> <span class=
"var-name">$file
</span> =
<span class=
"var-default">""</span>])
1132 <ul class=
"parameters">
1134 <span class=
"var-type">string
</span>
1135 <span class=
"var-name">$locn
</span><span class=
"var-description">: A string identifying the calling location.
</span> </li>
1137 <span class=
"var-type">string
</span>
1138 <span class=
"var-name">$tag
</span><span class=
"var-description">: A tag string, e.g. identifying the type of event.
</span> </li>
1140 <span class=
"var-type">string
</span>
1141 <span class=
"var-name">$string
</span><span class=
"var-description">: The information to be logged.
</span> </li>
1143 <span class=
"var-type">int
</span>
1144 <span class=
"var-name">$line
</span><span class=
"var-description">: The line number where the logged event occurred.
</span> </li>
1146 <span class=
"var-type">string
</span>
1147 <span class=
"var-name">$file
</span><span class=
"var-description">: The file name where the logged event occurred.
</span> </li>
1157 <p class=
"notes" id=
"credit">
1158 Documentation generated on Mon,
20 Sep
2010 12:
52:
17 +
1200 by
<a href=
"http://www.phpdoc.org" target=
"_blank">phpDocumentor
1.4.3</a>