efd8a0caeba8da2c57a2538ddb6934da28c2cbae
[Packages/TYPO3.CMS.git] / typo3 / sysext / adodb / adodb / drivers / adodb-ibase.inc.php
1 <?php
2 /*
3 V4.93 10 Oct 2006 (c) 2000-2006 John Lim (jlim#natsoft.com.my). All rights reserved.
4 Released under both BSD license and Lesser GPL library license.
5 Whenever there is any discrepancy between the two licenses,
6 the BSD license will take precedence.
7
8 Latest version is available at http://adodb.sourceforge.net
9
10 Interbase data driver. Requires interbase client. Works on Windows and Unix.
11
12 3 Jan 2002 -- suggestions by Hans-Peter Oeri <kampfcaspar75@oeri.ch>
13 changed transaction handling and added experimental blob stuff
14
15 Docs to interbase at the website
16 http://www.synectics.co.za/php3/tutorial/IB_PHP3_API.html
17
18 To use gen_id(), see
19 http://www.volny.cz/iprenosil/interbase/ip_ib_code.htm#_code_creategen
20
21 $rs = $conn->Execute('select gen_id(adodb,1) from rdb$database');
22 $id = $rs->fields[0];
23 $conn->Execute("insert into table (id, col1,...) values ($id, $val1,...)");
24 */
25
26 // security - hide paths
27 if (!defined('ADODB_DIR')) die();
28
29 class ADODB_ibase extends ADOConnection {
30 var $databaseType = "ibase";
31 var $dataProvider = "ibase";
32 var $replaceQuote = "''"; // string to use to replace quotes
33 var $ibase_datefmt = '%Y-%m-%d'; // For hours,mins,secs change to '%Y-%m-%d %H:%M:%S';
34 var $fmtDate = "'Y-m-d'";
35 var $ibase_timestampfmt = "%Y-%m-%d %H:%M:%S";
36 var $ibase_timefmt = "%H:%M:%S";
37 var $fmtTimeStamp = "'Y-m-d, H:i:s'";
38 var $concat_operator='||';
39 var $_transactionID;
40 var $metaTablesSQL = "select rdb\$relation_name from rdb\$relations where rdb\$relation_name not like 'RDB\$%'";
41 //OPN STUFF start
42 var $metaColumnsSQL = "select a.rdb\$field_name, a.rdb\$null_flag, a.rdb\$default_source, b.rdb\$field_length, b.rdb\$field_scale, b.rdb\$field_sub_type, b.rdb\$field_precision, b.rdb\$field_type from rdb\$relation_fields a, rdb\$fields b where a.rdb\$field_source = b.rdb\$field_name and a.rdb\$relation_name = '%s' order by a.rdb\$field_position asc";
43 //OPN STUFF end
44 var $ibasetrans;
45 var $hasGenID = true;
46 var $_bindInputArray = true;
47 var $buffers = 0;
48 var $dialect = 1;
49 var $sysDate = "cast('TODAY' as timestamp)";
50 var $sysTimeStamp = "CURRENT_TIMESTAMP"; //"cast('NOW' as timestamp)";
51 var $ansiOuter = true;
52 var $hasAffectedRows = false;
53 var $poorAffectedRows = true;
54 var $blobEncodeType = 'C';
55 var $role = false;
56
57 function ADODB_ibase()
58 {
59 if (defined('IBASE_DEFAULT')) $this->ibasetrans = IBASE_DEFAULT;
60 }
61
62
63 // returns true or false
64 function _connect($argHostname, $argUsername, $argPassword, $argDatabasename,$persist=false)
65 {
66 if (!function_exists('ibase_pconnect')) return null;
67 if ($argDatabasename) $argHostname .= ':'.$argDatabasename;
68 $fn = ($persist) ? 'ibase_pconnect':'ibase_connect';
69 if ($this->role)
70 $this->_connectionID = $fn($argHostname,$argUsername,$argPassword,
71 $this->charSet,$this->buffers,$this->dialect,$this->role);
72 else
73 $this->_connectionID = $fn($argHostname,$argUsername,$argPassword,
74 $this->charSet,$this->buffers,$this->dialect);
75
76 if ($this->dialect != 1) { // http://www.ibphoenix.com/ibp_60_del_id_ds.html
77 $this->replaceQuote = "''";
78 }
79 if ($this->_connectionID === false) {
80 $this->_handleerror();
81 return false;
82 }
83
84 // PHP5 change.
85 if (function_exists('ibase_timefmt')) {
86 ibase_timefmt($this->ibase_datefmt,IBASE_DATE );
87 if ($this->dialect == 1) ibase_timefmt($this->ibase_datefmt,IBASE_TIMESTAMP );
88 else ibase_timefmt($this->ibase_timestampfmt,IBASE_TIMESTAMP );
89 ibase_timefmt($this->ibase_timefmt,IBASE_TIME );
90
91 } else {
92 ini_set("ibase.timestampformat", $this->ibase_timestampfmt);
93 ini_set("ibase.dateformat", $this->ibase_datefmt);
94 ini_set("ibase.timeformat", $this->ibase_timefmt);
95 }
96 return true;
97 }
98 // returns true or false
99 function _pconnect($argHostname, $argUsername, $argPassword, $argDatabasename)
100 {
101 return $this->_connect($argHostname, $argUsername, $argPassword, $argDatabasename,true);
102 }
103
104
105 function MetaPrimaryKeys($table,$owner_notused=false,$internalKey=false)
106 {
107 if ($internalKey) return array('RDB$DB_KEY');
108
109 $table = strtoupper($table);
110
111 $sql = 'SELECT S.RDB$FIELD_NAME AFIELDNAME
112 FROM RDB$INDICES I JOIN RDB$INDEX_SEGMENTS S ON I.RDB$INDEX_NAME=S.RDB$INDEX_NAME
113 WHERE I.RDB$RELATION_NAME=\''.$table.'\' and I.RDB$INDEX_NAME like \'RDB$PRIMARY%\'
114 ORDER BY I.RDB$INDEX_NAME,S.RDB$FIELD_POSITION';
115
116 $a = $this->GetCol($sql,false,true);
117 if ($a && sizeof($a)>0) return $a;
118 return false;
119 }
120
121 function ServerInfo()
122 {
123 $arr['dialect'] = $this->dialect;
124 switch($arr['dialect']) {
125 case '':
126 case '1': $s = 'Interbase 5.5 or earlier'; break;
127 case '2': $s = 'Interbase 5.6'; break;
128 default:
129 case '3': $s = 'Interbase 6.0'; break;
130 }
131 $arr['version'] = ADOConnection::_findvers($s);
132 $arr['description'] = $s;
133 return $arr;
134 }
135
136 function BeginTrans()
137 {
138 if ($this->transOff) return true;
139 $this->transCnt += 1;
140 $this->autoCommit = false;
141 $this->_transactionID = $this->_connectionID;//ibase_trans($this->ibasetrans, $this->_connectionID);
142 return $this->_transactionID;
143 }
144
145 function CommitTrans($ok=true)
146 {
147 if (!$ok) return $this->RollbackTrans();
148 if ($this->transOff) return true;
149 if ($this->transCnt) $this->transCnt -= 1;
150 $ret = false;
151 $this->autoCommit = true;
152 if ($this->_transactionID) {
153 //print ' commit ';
154 $ret = ibase_commit($this->_transactionID);
155 }
156 $this->_transactionID = false;
157 return $ret;
158 }
159
160 // there are some compat problems with ADODB_COUNTRECS=false and $this->_logsql currently.
161 // it appears that ibase extension cannot support multiple concurrent queryid's
162 function &_Execute($sql,$inputarr=false)
163 {
164 global $ADODB_COUNTRECS;
165
166 if ($this->_logsql) {
167 $savecrecs = $ADODB_COUNTRECS;
168 $ADODB_COUNTRECS = true; // force countrecs
169 $ret =& ADOConnection::_Execute($sql,$inputarr);
170 $ADODB_COUNTRECS = $savecrecs;
171 } else {
172 $ret =& ADOConnection::_Execute($sql,$inputarr);
173 }
174 return $ret;
175 }
176
177 function RollbackTrans()
178 {
179 if ($this->transOff) return true;
180 if ($this->transCnt) $this->transCnt -= 1;
181 $ret = false;
182 $this->autoCommit = true;
183 if ($this->_transactionID)
184 $ret = ibase_rollback($this->_transactionID);
185 $this->_transactionID = false;
186
187 return $ret;
188 }
189
190 function &MetaIndexes ($table, $primary = FALSE, $owner=false)
191 {
192 // save old fetch mode
193 global $ADODB_FETCH_MODE;
194 $false = false;
195 $save = $ADODB_FETCH_MODE;
196 $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
197 if ($this->fetchMode !== FALSE) {
198 $savem = $this->SetFetchMode(FALSE);
199 }
200 $table = strtoupper($table);
201 $sql = "SELECT * FROM RDB\$INDICES WHERE RDB\$RELATION_NAME = '".$table."'";
202 if (!$primary) {
203 $sql .= " AND RDB\$INDEX_NAME NOT LIKE 'RDB\$%'";
204 } else {
205 $sql .= " AND RDB\$INDEX_NAME NOT LIKE 'RDB\$FOREIGN%'";
206 }
207 // get index details
208 $rs = $this->Execute($sql);
209 if (!is_object($rs)) {
210 // restore fetchmode
211 if (isset($savem)) {
212 $this->SetFetchMode($savem);
213 }
214 $ADODB_FETCH_MODE = $save;
215 return $false;
216 }
217
218 $indexes = array();
219 while ($row = $rs->FetchRow()) {
220 $index = $row[0];
221 if (!isset($indexes[$index])) {
222 if (is_null($row[3])) {$row[3] = 0;}
223 $indexes[$index] = array(
224 'unique' => ($row[3] == 1),
225 'columns' => array()
226 );
227 }
228 $sql = "SELECT * FROM RDB\$INDEX_SEGMENTS WHERE RDB\$INDEX_NAME = '".$index."' ORDER BY RDB\$FIELD_POSITION ASC";
229 $rs1 = $this->Execute($sql);
230 while ($row1 = $rs1->FetchRow()) {
231 $indexes[$index]['columns'][$row1[2]] = $row1[1];
232 }
233 }
234 // restore fetchmode
235 if (isset($savem)) {
236 $this->SetFetchMode($savem);
237 }
238 $ADODB_FETCH_MODE = $save;
239
240 return $indexes;
241 }
242
243
244 // See http://community.borland.com/article/0,1410,25844,00.html
245 function RowLock($tables,$where,$col)
246 {
247 if ($this->autoCommit) $this->BeginTrans();
248 $this->Execute("UPDATE $table SET $col=$col WHERE $where "); // is this correct - jlim?
249 return 1;
250 }
251
252
253 function CreateSequence($seqname,$startID=1)
254 {
255 $ok = $this->Execute(("INSERT INTO RDB\$GENERATORS (RDB\$GENERATOR_NAME) VALUES (UPPER('$seqname'))" ));
256 if (!$ok) return false;
257 return $this->Execute("SET GENERATOR $seqname TO ".($startID-1).';');
258 }
259
260 function DropSequence($seqname)
261 {
262 $seqname = strtoupper($seqname);
263 $this->Execute("delete from RDB\$GENERATORS where RDB\$GENERATOR_NAME='$seqname'");
264 }
265
266 function GenID($seqname='adodbseq',$startID=1)
267 {
268 $getnext = ("SELECT Gen_ID($seqname,1) FROM RDB\$DATABASE");
269 $rs = @$this->Execute($getnext);
270 if (!$rs) {
271 $this->Execute(("INSERT INTO RDB\$GENERATORS (RDB\$GENERATOR_NAME) VALUES (UPPER('$seqname'))" ));
272 $this->Execute("SET GENERATOR $seqname TO ".($startID-1).';');
273 $rs = $this->Execute($getnext);
274 }
275 if ($rs && !$rs->EOF) $this->genID = (integer) reset($rs->fields);
276 else $this->genID = 0; // false
277
278 if ($rs) $rs->Close();
279
280 return $this->genID;
281 }
282
283 function SelectDB($dbName)
284 {
285 return false;
286 }
287
288 function _handleerror()
289 {
290 $this->_errorMsg = ibase_errmsg();
291 }
292
293 function ErrorNo()
294 {
295 if (preg_match('/error code = ([\-0-9]*)/i', $this->_errorMsg,$arr)) return (integer) $arr[1];
296 else return 0;
297 }
298
299 function ErrorMsg()
300 {
301 return $this->_errorMsg;
302 }
303
304 function Prepare($sql)
305 {
306 $stmt = ibase_prepare($this->_connectionID,$sql);
307 if (!$stmt) return false;
308 return array($sql,$stmt);
309 }
310
311 // returns query ID if successful, otherwise false
312 // there have been reports of problems with nested queries - the code is probably not re-entrant?
313 function _query($sql,$iarr=false)
314 {
315
316 if (!$this->autoCommit && $this->_transactionID) {
317 $conn = $this->_transactionID;
318 $docommit = false;
319 } else {
320 $conn = $this->_connectionID;
321 $docommit = true;
322 }
323 if (is_array($sql)) {
324 $fn = 'ibase_execute';
325 $sql = $sql[1];
326 if (is_array($iarr)) {
327 if (ADODB_PHPVER >= 0x4050) { // actually 4.0.4
328 if ( !isset($iarr[0]) ) $iarr[0] = ''; // PHP5 compat hack
329 $fnarr =& array_merge( array($sql) , $iarr);
330 $ret = call_user_func_array($fn,$fnarr);
331 } else {
332 switch(sizeof($iarr)) {
333 case 1: $ret = $fn($sql,$iarr[0]); break;
334 case 2: $ret = $fn($sql,$iarr[0],$iarr[1]); break;
335 case 3: $ret = $fn($sql,$iarr[0],$iarr[1],$iarr[2]); break;
336 case 4: $ret = $fn($sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3]); break;
337 case 5: $ret = $fn($sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3],$iarr[4]); break;
338 case 6: $ret = $fn($sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3],$iarr[4],$iarr[5]); break;
339 case 7: $ret = $fn($sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3],$iarr[4],$iarr[5],$iarr[6]); break;
340 default: ADOConnection::outp( "Too many parameters to ibase query $sql");
341 case 8: $ret = $fn($sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3],$iarr[4],$iarr[5],$iarr[6],$iarr[7]); break;
342 }
343 }
344 } else $ret = $fn($sql);
345 } else {
346 $fn = 'ibase_query';
347
348 if (is_array($iarr)) {
349 if (ADODB_PHPVER >= 0x4050) { // actually 4.0.4
350 if (sizeof($iarr) == 0) $iarr[0] = ''; // PHP5 compat hack
351 $fnarr =& array_merge( array($conn,$sql) , $iarr);
352 $ret = call_user_func_array($fn,$fnarr);
353 } else {
354 switch(sizeof($iarr)) {
355 case 1: $ret = $fn($conn,$sql,$iarr[0]); break;
356 case 2: $ret = $fn($conn,$sql,$iarr[0],$iarr[1]); break;
357 case 3: $ret = $fn($conn,$sql,$iarr[0],$iarr[1],$iarr[2]); break;
358 case 4: $ret = $fn($conn,$sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3]); break;
359 case 5: $ret = $fn($conn,$sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3],$iarr[4]); break;
360 case 6: $ret = $fn($conn,$sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3],$iarr[4],$iarr[5]); break;
361 case 7: $ret = $fn($conn,$sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3],$iarr[4],$iarr[5],$iarr[6]); break;
362 default: ADOConnection::outp( "Too many parameters to ibase query $sql");
363 case 8: $ret = $fn($conn,$sql,$iarr[0],$iarr[1],$iarr[2],$iarr[3],$iarr[4],$iarr[5],$iarr[6],$iarr[7]); break;
364 }
365 }
366 } else $ret = $fn($conn,$sql);
367 }
368 if ($docommit && $ret === true) ibase_commit($this->_connectionID);
369
370 $this->_handleerror();
371 return $ret;
372 }
373
374 // returns true or false
375 function _close()
376 {
377 if (!$this->autoCommit) @ibase_rollback($this->_connectionID);
378 return @ibase_close($this->_connectionID);
379 }
380
381 //OPN STUFF start
382 function _ConvertFieldType(&$fld, $ftype, $flen, $fscale, $fsubtype, $fprecision, $dialect3)
383 {
384 $fscale = abs($fscale);
385 $fld->max_length = $flen;
386 $fld->scale = null;
387 switch($ftype){
388 case 7:
389 case 8:
390 if ($dialect3) {
391 switch($fsubtype){
392 case 0:
393 $fld->type = ($ftype == 7 ? 'smallint' : 'integer');
394 break;
395 case 1:
396 $fld->type = 'numeric';
397 $fld->max_length = $fprecision;
398 $fld->scale = $fscale;
399 break;
400 case 2:
401 $fld->type = 'decimal';
402 $fld->max_length = $fprecision;
403 $fld->scale = $fscale;
404 break;
405 } // switch
406 } else {
407 if ($fscale !=0) {
408 $fld->type = 'decimal';
409 $fld->scale = $fscale;
410 $fld->max_length = ($ftype == 7 ? 4 : 9);
411 } else {
412 $fld->type = ($ftype == 7 ? 'smallint' : 'integer');
413 }
414 }
415 break;
416 case 16:
417 if ($dialect3) {
418 switch($fsubtype){
419 case 0:
420 $fld->type = 'decimal';
421 $fld->max_length = 18;
422 $fld->scale = 0;
423 break;
424 case 1:
425 $fld->type = 'numeric';
426 $fld->max_length = $fprecision;
427 $fld->scale = $fscale;
428 break;
429 case 2:
430 $fld->type = 'decimal';
431 $fld->max_length = $fprecision;
432 $fld->scale = $fscale;
433 break;
434 } // switch
435 }
436 break;
437 case 10:
438 $fld->type = 'float';
439 break;
440 case 14:
441 $fld->type = 'char';
442 break;
443 case 27:
444 if ($fscale !=0) {
445 $fld->type = 'decimal';
446 $fld->max_length = 15;
447 $fld->scale = 5;
448 } else {
449 $fld->type = 'double';
450 }
451 break;
452 case 35:
453 if ($dialect3) {
454 $fld->type = 'timestamp';
455 } else {
456 $fld->type = 'date';
457 }
458 break;
459 case 12:
460 $fld->type = 'date';
461 break;
462 case 13:
463 $fld->type = 'time';
464 break;
465 case 37:
466 $fld->type = 'varchar';
467 break;
468 case 40:
469 $fld->type = 'cstring';
470 break;
471 case 261:
472 $fld->type = 'blob';
473 $fld->max_length = -1;
474 break;
475 } // switch
476 }
477 //OPN STUFF end
478 // returns array of ADOFieldObjects for current table
479 function &MetaColumns($table)
480 {
481 global $ADODB_FETCH_MODE;
482
483 $save = $ADODB_FETCH_MODE;
484 $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
485
486 $rs = $this->Execute(sprintf($this->metaColumnsSQL,strtoupper($table)));
487
488 $ADODB_FETCH_MODE = $save;
489 $false = false;
490 if ($rs === false) {
491 return $false;
492 }
493
494 $retarr = array();
495 //OPN STUFF start
496 $dialect3 = ($this->dialect==3 ? true : false);
497 //OPN STUFF end
498 while (!$rs->EOF) { //print_r($rs->fields);
499 $fld = new ADOFieldObject();
500 $fld->name = trim($rs->fields[0]);
501 //OPN STUFF start
502 $this->_ConvertFieldType($fld, $rs->fields[7], $rs->fields[3], $rs->fields[4], $rs->fields[5], $rs->fields[6], $dialect3);
503 if (isset($rs->fields[1]) && $rs->fields[1]) {
504 $fld->not_null = true;
505 }
506 if (isset($rs->fields[2])) {
507
508 $fld->has_default = true;
509 $d = substr($rs->fields[2],strlen('default '));
510 switch ($fld->type)
511 {
512 case 'smallint':
513 case 'integer': $fld->default_value = (int) $d; break;
514 case 'char':
515 case 'blob':
516 case 'text':
517 case 'varchar': $fld->default_value = (string) substr($d,1,strlen($d)-2); break;
518 case 'double':
519 case 'float': $fld->default_value = (float) $d; break;
520 default: $fld->default_value = $d; break;
521 }
522 // case 35:$tt = 'TIMESTAMP'; break;
523 }
524 if ((isset($rs->fields[5])) && ($fld->type == 'blob')) {
525 $fld->sub_type = $rs->fields[5];
526 } else {
527 $fld->sub_type = null;
528 }
529 //OPN STUFF end
530 if ($ADODB_FETCH_MODE == ADODB_FETCH_NUM) $retarr[] = $fld;
531 else $retarr[strtoupper($fld->name)] = $fld;
532
533 $rs->MoveNext();
534 }
535 $rs->Close();
536 if ( empty($retarr)) return $false;
537 else return $retarr;
538 }
539
540 function BlobEncode( $blob )
541 {
542 $blobid = ibase_blob_create( $this->_connectionID);
543 ibase_blob_add( $blobid, $blob );
544 return ibase_blob_close( $blobid );
545 }
546
547 // since we auto-decode all blob's since 2.42,
548 // BlobDecode should not do any transforms
549 function BlobDecode($blob)
550 {
551 return $blob;
552 }
553
554
555
556
557 // old blobdecode function
558 // still used to auto-decode all blob's
559 function _BlobDecode_old( $blob )
560 {
561 $blobid = ibase_blob_open($this->_connectionID, $blob );
562 $realblob = ibase_blob_get( $blobid,$this->maxblobsize); // 2nd param is max size of blob -- Kevin Boillet <kevinboillet@yahoo.fr>
563 while($string = ibase_blob_get($blobid, 8192)){
564 $realblob .= $string;
565 }
566 ibase_blob_close( $blobid );
567
568 return( $realblob );
569 }
570
571 function _BlobDecode( $blob )
572 {
573 if (ADODB_PHPVER >= 0x5000) {
574 $blob_data = ibase_blob_info($this->_connectionID, $blob );
575 $blobid = ibase_blob_open($this->_connectionID, $blob );
576 } else {
577
578 $blob_data = ibase_blob_info( $blob );
579 $blobid = ibase_blob_open( $blob );
580 }
581
582 if( $blob_data[0] > $this->maxblobsize ) {
583
584 $realblob = ibase_blob_get($blobid, $this->maxblobsize);
585
586 while($string = ibase_blob_get($blobid, 8192)){
587 $realblob .= $string;
588 }
589 } else {
590 $realblob = ibase_blob_get($blobid, $blob_data[0]);
591 }
592
593 ibase_blob_close( $blobid );
594 return( $realblob );
595 }
596
597 function UpdateBlobFile($table,$column,$path,$where,$blobtype='BLOB')
598 {
599 $fd = fopen($path,'rb');
600 if ($fd === false) return false;
601 $blob_id = ibase_blob_create($this->_connectionID);
602
603 /* fill with data */
604
605 while ($val = fread($fd,32768)){
606 ibase_blob_add($blob_id, $val);
607 }
608
609 /* close and get $blob_id_str for inserting into table */
610 $blob_id_str = ibase_blob_close($blob_id);
611
612 fclose($fd);
613 return $this->Execute("UPDATE $table SET $column=(?) WHERE $where",array($blob_id_str)) != false;
614 }
615
616 /*
617 Insert a null into the blob field of the table first.
618 Then use UpdateBlob to store the blob.
619
620 Usage:
621
622 $conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)');
623 $conn->UpdateBlob('blobtable','blobcol',$blob,'id=1');
624 */
625 function UpdateBlob($table,$column,$val,$where,$blobtype='BLOB')
626 {
627 $blob_id = ibase_blob_create($this->_connectionID);
628
629 // ibase_blob_add($blob_id, $val);
630
631 // replacement that solves the problem by which only the first modulus 64K /
632 // of $val are stored at the blob field ////////////////////////////////////
633 // Thx Abel Berenstein aberenstein#afip.gov.ar
634 $len = strlen($val);
635 $chunk_size = 32768;
636 $tail_size = $len % $chunk_size;
637 $n_chunks = ($len - $tail_size) / $chunk_size;
638
639 for ($n = 0; $n < $n_chunks; $n++) {
640 $start = $n * $chunk_size;
641 $data = substr($val, $start, $chunk_size);
642 ibase_blob_add($blob_id, $data);
643 }
644
645 if ($tail_size) {
646 $start = $n_chunks * $chunk_size;
647 $data = substr($val, $start, $tail_size);
648 ibase_blob_add($blob_id, $data);
649 }
650 // end replacement /////////////////////////////////////////////////////////
651
652 $blob_id_str = ibase_blob_close($blob_id);
653
654 return $this->Execute("UPDATE $table SET $column=(?) WHERE $where",array($blob_id_str)) != false;
655
656 }
657
658
659 function OldUpdateBlob($table,$column,$val,$where,$blobtype='BLOB')
660 {
661 $blob_id = ibase_blob_create($this->_connectionID);
662 ibase_blob_add($blob_id, $val);
663 $blob_id_str = ibase_blob_close($blob_id);
664 return $this->Execute("UPDATE $table SET $column=(?) WHERE $where",array($blob_id_str)) != false;
665 }
666
667 // Format date column in sql string given an input format that understands Y M D
668 // Only since Interbase 6.0 - uses EXTRACT
669 // problem - does not zero-fill the day and month yet
670 function SQLDate($fmt, $col=false)
671 {
672 if (!$col) $col = $this->sysDate;
673 $s = '';
674
675 $len = strlen($fmt);
676 for ($i=0; $i < $len; $i++) {
677 if ($s) $s .= '||';
678 $ch = $fmt[$i];
679 switch($ch) {
680 case 'Y':
681 case 'y':
682 $s .= "extract(year from $col)";
683 break;
684 case 'M':
685 case 'm':
686 $s .= "extract(month from $col)";
687 break;
688 case 'Q':
689 case 'q':
690 $s .= "cast(((extract(month from $col)+2) / 3) as integer)";
691 break;
692 case 'D':
693 case 'd':
694 $s .= "(extract(day from $col))";
695 break;
696 case 'H':
697 case 'h':
698 $s .= "(extract(hour from $col))";
699 break;
700 case 'I':
701 case 'i':
702 $s .= "(extract(minute from $col))";
703 break;
704 case 'S':
705 case 's':
706 $s .= "CAST((extract(second from $col)) AS INTEGER)";
707 break;
708
709 default:
710 if ($ch == '\\') {
711 $i++;
712 $ch = substr($fmt,$i,1);
713 }
714 $s .= $this->qstr($ch);
715 break;
716 }
717 }
718 return $s;
719 }
720 }
721
722 /*--------------------------------------------------------------------------------------
723 Class Name: Recordset
724 --------------------------------------------------------------------------------------*/
725
726 class ADORecordset_ibase extends ADORecordSet
727 {
728
729 var $databaseType = "ibase";
730 var $bind=false;
731 var $_cacheType;
732
733 function ADORecordset_ibase($id,$mode=false)
734 {
735 global $ADODB_FETCH_MODE;
736
737 $this->fetchMode = ($mode === false) ? $ADODB_FETCH_MODE : $mode;
738 $this->ADORecordSet($id);
739 }
740
741 /* Returns: an object containing field information.
742 Get column information in the Recordset object. fetchField() can be used in order to obtain information about
743 fields in a certain query result. If the field offset isn't specified, the next field that wasn't yet retrieved by
744 fetchField() is retrieved. */
745
746 function &FetchField($fieldOffset = -1)
747 {
748 $fld = new ADOFieldObject;
749 $ibf = ibase_field_info($this->_queryID,$fieldOffset);
750 switch (ADODB_ASSOC_CASE) {
751 case 2: // the default
752 $fld->name = ($ibf['alias']);
753 if (empty($fld->name)) $fld->name = ($ibf['name']);
754 break;
755 case 0:
756 $fld->name = strtoupper($ibf['alias']);
757 if (empty($fld->name)) $fld->name = strtoupper($ibf['name']);
758 break;
759 case 1:
760 $fld->name = strtolower($ibf['alias']);
761 if (empty($fld->name)) $fld->name = strtolower($ibf['name']);
762 break;
763 }
764
765 $fld->type = $ibf['type'];
766 $fld->max_length = $ibf['length'];
767
768 /* This needs to be populated from the metadata */
769 $fld->not_null = false;
770 $fld->has_default = false;
771 $fld->default_value = 'null';
772 return $fld;
773 }
774
775 function _initrs()
776 {
777 $this->_numOfRows = -1;
778 $this->_numOfFields = @ibase_num_fields($this->_queryID);
779
780 // cache types for blob decode check
781 for ($i=0, $max = $this->_numOfFields; $i < $max; $i++) {
782 $f1 = $this->FetchField($i);
783 $this->_cacheType[] = $f1->type;
784 }
785 }
786
787 function _seek($row)
788 {
789 return false;
790 }
791
792 function _fetch()
793 {
794 $f = @ibase_fetch_row($this->_queryID);
795 if ($f === false) {
796 $this->fields = false;
797 return false;
798 }
799 // OPN stuff start - optimized
800 // fix missing nulls and decode blobs automatically
801
802 global $ADODB_ANSI_PADDING_OFF;
803 //$ADODB_ANSI_PADDING_OFF=1;
804 $rtrim = !empty($ADODB_ANSI_PADDING_OFF);
805
806 for ($i=0, $max = $this->_numOfFields; $i < $max; $i++) {
807 if ($this->_cacheType[$i]=="BLOB") {
808 if (isset($f[$i])) {
809 $f[$i] = $this->connection->_BlobDecode($f[$i]);
810 } else {
811 $f[$i] = null;
812 }
813 } else {
814 if (!isset($f[$i])) {
815 $f[$i] = null;
816 } else if ($rtrim && is_string($f[$i])) {
817 $f[$i] = rtrim($f[$i]);
818 }
819 }
820 }
821 // OPN stuff end
822
823 $this->fields = $f;
824 if ($this->fetchMode == ADODB_FETCH_ASSOC) {
825 $this->fields = &$this->GetRowAssoc(ADODB_ASSOC_CASE);
826 } else if ($this->fetchMode == ADODB_FETCH_BOTH) {
827 $this->fields =& array_merge($this->fields,$this->GetRowAssoc(ADODB_ASSOC_CASE));
828 }
829 return true;
830 }
831
832 /* Use associative array to get fields array */
833 function Fields($colname)
834 {
835 if ($this->fetchMode & ADODB_FETCH_ASSOC) return $this->fields[$colname];
836 if (!$this->bind) {
837 $this->bind = array();
838 for ($i=0; $i < $this->_numOfFields; $i++) {
839 $o = $this->FetchField($i);
840 $this->bind[strtoupper($o->name)] = $i;
841 }
842 }
843
844 return $this->fields[$this->bind[strtoupper($colname)]];
845
846 }
847
848
849 function _close()
850 {
851 return @ibase_free_result($this->_queryID);
852 }
853
854 function MetaType($t,$len=-1,$fieldobj=false)
855 {
856 if (is_object($t)) {
857 $fieldobj = $t;
858 $t = $fieldobj->type;
859 $len = $fieldobj->max_length;
860 }
861 switch (strtoupper($t)) {
862 case 'CHAR':
863 return 'C';
864
865 case 'TEXT':
866 case 'VARCHAR':
867 case 'VARYING':
868 if ($len <= $this->blobSize) return 'C';
869 return 'X';
870 case 'BLOB':
871 return 'B';
872
873 case 'TIMESTAMP':
874 case 'DATE': return 'D';
875 case 'TIME': return 'T';
876 //case 'T': return 'T';
877
878 //case 'L': return 'L';
879 case 'INT':
880 case 'SHORT':
881 case 'INTEGER': return 'I';
882 default: return 'N';
883 }
884 }
885
886 }
887 ?>