xref: /PHP-7.1/ext/oci8/tests/define3.phpt (revision 113213f0)
1--TEST--
2Test oci_define_by_name() LOB descriptor
3--SKIPIF--
4<?php
5$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
6require(dirname(__FILE__).'/skipif.inc');
7?>
8--FILE--
9<?php
10
11require(dirname(__FILE__)."/connect.inc");
12
13$stmtarray = array(
14	"drop table phpdefblobtable",
15	"create table phpdefblobtable (id number(10), fileimage blob)"
16);
17
18oci8_test_sql_execute($c, $stmtarray);
19
20// Load data
21$stmt = oci_parse ($c, "insert into phpdefblobtable (id, fileimage) values (:id, empty_blob()) returning fileimage into :fileimage");
22$fileimage = oci_new_descriptor($c,OCI_D_LOB);
23oci_bind_by_name($stmt,":id",$id);
24oci_bind_by_name($stmt,":fileimage",$fileimage,-1,OCI_B_BLOB);
25$id = 1;
26oci_execute($stmt, OCI_DEFAULT);
27$fileimage->savefile(dirname(__FILE__)."/test.gif");
28$data = $fileimage->load();
29var_dump(md5($data));  // original md5
30oci_commit($c);
31
32// New row with different data
33$id = 2;
34$data = strrev($data);
35var_dump(md5($data));
36oci_execute($stmt, OCI_DEFAULT);
37$fileimage->save($data);
38oci_commit($c);
39
40echo "Test 1\n";
41$stmt = oci_parse($c, "SELECT fileimage FROM phpdefblobtable");
42var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $f));
43oci_execute($stmt);
44
45while (oci_fetch($stmt)) {
46   var_dump($f);
47   echo "file md5:" . md5($f->load()) . "\n";
48}
49
50echo "Test 2\n";
51$stmt = oci_parse($c, "SELECT fileimage FROM phpdefblobtable");
52var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $outdata, SQLT_STR));
53oci_execute($stmt);
54
55while (oci_fetch($stmt)) {
56   echo "file md5:" . md5($outdata) . "\n";
57}
58
59echo "Test 3\n";
60$stmt = oci_parse($c, "SELECT fileimage FROM phpdefblobtable");
61var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $outdata, SQLT_BIN));
62oci_execute($stmt);
63
64while (oci_fetch($stmt)) {
65   echo "file md5:" . md5($outdata) . "\n";
66}
67
68echo "Test 4\n";
69$fid = oci_new_descriptor($c,OCI_D_LOB);
70$stmt = oci_parse($c, "SELECT fileimage FROM phpdefblobtable");
71var_dump(oci_define_by_name($stmt, 'FILEIMAGE', $fid));
72oci_execute($stmt);
73
74while (oci_fetch($stmt)) {
75   echo "file md5:" . md5($fid->load()) . "\n";
76}
77
78$stmtarray = array(
79	"drop table phpdefblobtable"
80);
81
82oci8_test_sql_execute($c, $stmtarray);
83
84echo "Done\n";
85
86?>
87--EXPECTF--
88string(32) "614fcbba1effb7caa27ef0ef25c27fcf"
89string(32) "06d4f219d946c74d748d43932cd9dcb2"
90Test 1
91bool(true)
92object(OCI-Lob)#%d (1) {
93  ["descriptor"]=>
94  resource(%d) of type (oci8 descriptor)
95}
96file md5:614fcbba1effb7caa27ef0ef25c27fcf
97object(OCI-Lob)#%d (1) {
98  ["descriptor"]=>
99  resource(%d) of type (oci8 descriptor)
100}
101file md5:06d4f219d946c74d748d43932cd9dcb2
102Test 2
103bool(true)
104
105Warning: oci_fetch(): ORA-00932: %s on line %d
106Test 3
107bool(true)
108file md5:614fcbba1effb7caa27ef0ef25c27fcf
109file md5:06d4f219d946c74d748d43932cd9dcb2
110Test 4
111bool(true)
112file md5:614fcbba1effb7caa27ef0ef25c27fcf
113file md5:06d4f219d946c74d748d43932cd9dcb2
114Done
115