search

FirebirdSQL / php-firebird

Firebird PHP driver
Other
66 stars 15 forks source link

Boolean support #2

Closed MartinKoeditz closed 3 years ago

MartinKoeditz commented 3 years ago

Test from Emil Totev:

<?php
ibase_connect('localhost:employee','sysdba','masterkey');
$res = ibase_query("select 1, 'true', 'false' from rdb\$database");
$rec = ibase_fetch_assoc($res);
var_dump($rec);

$res = ibase_query("select 1, true, 'false' from rdb\$database");
$rec = ibase_fetch_assoc($res);
var_dump($rec);

And the result is

array(3) {
  ["CONSTANT"]=>
  int(1)
  ["CONSTANT_01"]=>
  string(4) "true"
  ["CONSTANT_02"]=>
  string(5) "false"
}
PHP Warning:  ibase_fetch_assoc(): Incorrect values within SQLDA structure empty pointer to data at SQLVAR index 1  in D:\tmp\test.php on line 9

Warning: ibase_fetch_assoc(): Incorrect values within SQLDA structure empty pointer to data at SQLVAR index 1  in D:\tmp\test.php on line 9
bool(false)

PHP 7.3.16 (cli) (built: Mar 17 2020 13:33:00) ( ZTS MSVC15 (Visual C++ 2017) x64 )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.16, Copyright (c) 1998-2018 Zend Technologies
MartinKoeditz commented 3 years ago

Precompiled beta versions are available at [https://firebirdsql.org/en/php-driver/]. Please give some feedback.

MartinKoeditz commented 3 years ago

No problems were reported. So this issue will be closed.