????JFIF??x?x????'
Server IP : 79.136.114.73 / Your IP : 18.216.45.133 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/oci8/tests/ |
Upload File : |
--TEST-- Test ROWID bind --SKIPIF-- <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> --FILE-- <?php require(dirname(__FILE__)."/connect.inc"); function do_query($c) { $s = oci_parse($c, 'select address from rid_tab order by id'); $id = 1; oci_execute($s, OCI_DEFAULT); while ($row = oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)) { var_dump($row); } } $stmtarray = array( "drop table rid_tab", "create table rid_tab (id number, address varchar2(40))", "insert into rid_tab (id, address) values (1, 'original text #1')", "insert into rid_tab (id, address) values (2, 'original text #2')" ); oci8_test_sql_execute($c, $stmtarray); echo "Initial Data\n"; do_query($c); $s = oci_parse($c, 'select rowid, address from rid_tab where id = :l_bv for update'); $id = 1; oci_bind_by_name($s, ':l_bv', $id); oci_execute($s, OCI_DEFAULT); $row = oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS); $rid = $row['ROWID']; $addr = $row['ADDRESS']; $addr = 'Some new text'; // Save changes $s = oci_parse($c,'update rid_tab set address = :a_bv where rowid = :r_bv'); oci_bind_by_name($s, ':r_bv', $rid, -1, OCI_B_ROWID); oci_bind_by_name($s, ':a_bv', $addr); oci_execute($s); echo "Verify Change\n"; do_query($c); // Cleanup $stmtarray = array( "drop table rid_tab" ); oci8_test_sql_execute($c, $stmtarray); echo "Done\n"; ?> --EXPECT-- Initial Data array(1) { ["ADDRESS"]=> string(16) "original text #1" } array(1) { ["ADDRESS"]=> string(16) "original text #2" } Verify Change array(1) { ["ADDRESS"]=> string(13) "Some new text" } array(1) { ["ADDRESS"]=> string(16) "original text #2" } Done