ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
Common.php
Go to the documentation of this file.
1<?php
2// +----------------------------------------------------------------------+
3// | PHP versions 4 and 5 |
4// +----------------------------------------------------------------------+
5// | Copyright (c) 1998-2006 Manuel Lemos, Tomas V.V.Cox, |
6// | Stig. S. Bakken, Lukas Smith |
7// | All rights reserved. |
8// +----------------------------------------------------------------------+
9// | MDB2 is a merge of PEAR DB and Metabases that provides a unified DB |
10// | API as well as database abstraction for PHP applications. |
11// | This LICENSE is in the BSD license style. |
12// | |
13// | Redistribution and use in source and binary forms, with or without |
14// | modification, are permitted provided that the following conditions |
15// | are met: |
16// | |
17// | Redistributions of source code must retain the above copyright |
18// | notice, this list of conditions and the following disclaimer. |
19// | |
20// | Redistributions in binary form must reproduce the above copyright |
21// | notice, this list of conditions and the following disclaimer in the |
22// | documentation and/or other materials provided with the distribution. |
23// | |
24// | Neither the name of Manuel Lemos, Tomas V.V.Cox, Stig. S. Bakken, |
25// | Lukas Smith nor the names of his contributors may be used to endorse |
26// | or promote products derived from this software without specific prior|
27// | written permission. |
28// | |
29// | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
30// | "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
31// | LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS |
32// | FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE |
33// | REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, |
34// | INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |
35// | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS|
36// | OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED |
37// | AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT |
38// | LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY|
39// | WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
40// | POSSIBILITY OF SUCH DAMAGE. |
41// +----------------------------------------------------------------------+
42// | Author: Lukas Smith <smith@pooteeweet.org> |
43// +----------------------------------------------------------------------+
44//
45// $Id: Common.php,v 1.17 2007/01/12 11:29:12 quipo Exp $
46//
47
62{
63 // {{{ executeStoredProc()
64
77 function &executeStoredProc($name, $params = null, $types = null, $result_class = true, $result_wrap_class = false)
78 {
79 $db =& $this->getDBInstance();
80 if (PEAR::isError($db)) {
81 return $db;
82 }
83
84 $error =& $db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
85 'method not implemented', __FUNCTION__);
86 return $error;
87 }
88
89 // }}}
90 // {{{ functionTable()
91
98 function functionTable()
99 {
100 return '';
101 }
102
103 // }}}
104 // {{{ now()
105
116 function now($type = 'timestamp')
117 {
118 switch ($type) {
119 case 'time':
120 return 'CURRENT_TIME';
121 case 'date':
122 return 'CURRENT_DATE';
123 case 'timestamp':
124 default:
125 return 'CURRENT_TIMESTAMP';
126 }
127 }
128
129 // }}}
130 // {{{ substring()
131
138 function substring($value, $position = 1, $length = null)
139 {
140 if (!is_null($length)) {
141 return "SUBSTRING($value FROM $position FOR $length)";
142 }
143 return "SUBSTRING($value FROM $position)";
144 }
145
146 // }}}
147 // {{{ concat()
148
158 function concat($value1, $value2)
159 {
160 $args = func_get_args();
161 return "(".implode(' || ', $args).")";
162 }
163
164 // }}}
165 // {{{ random()
166
173 function random()
174 {
175 return 'RAND()';
176 }
177
178 // }}}
179 // {{{ lower()
180
188 function lower($expression)
189 {
190 return "LOWER($expression)";
191 }
192
193 // }}}
194 // {{{ upper()
195
203 function upper($expression)
204 {
205 return "UPPER($expression)";
206 }
207
208 // }}}
209 // {{{ guid()
210
217 function guid()
218 {
219 $db =& $this->getDBInstance();
220 if (PEAR::isError($db)) {
221 return $db;
222 }
223
224 $error =& $db->raiseError(MDB2_ERROR_UNSUPPORTED, null, null,
225 'method not implemented', __FUNCTION__);
226 return $error;
227 }
228
229 // }}}
230}
231?>
const MDB2_ERROR_UNSUPPORTED
Definition: MDB2.php:73
upper($expression)
return string to call a function to upper the case of an expression
Definition: Common.php:203
concat($value1, $value2)
Returns string to concatenate two or more string parameters.
Definition: Common.php:158
guid()
Returns global unique identifier.
Definition: Common.php:217
lower($expression)
return string to call a function to lower the case of an expression
Definition: Common.php:188
random()
return string to call a function to get random value inside an SQL statement
Definition: Common.php:173
& executeStoredProc($name, $params=null, $types=null, $result_class=true, $result_wrap_class=false)
Execute a stored procedure and return any results.
Definition: Common.php:77
functionTable()
return string for internal table used when calling only a function
Definition: Common.php:98
substring($value, $position=1, $length=null)
return string to call a function to get a substring inside an SQL statement
Definition: Common.php:138
now($type='timestamp')
Return string to call a variable with the current timestamp inside an SQL statement There are three s...
Definition: Common.php:116
& getDBInstance()
Get the instance of MDB2 associated with the module instance.
Definition: MDB2.php:4206
isError($data, $code=null)
Tell whether a value is a PEAR error.
Definition: PEAR.php:279
$params
Definition: example_049.php:96