statement_type.phpt

来自「PHP v6.0 For Linux 运行环境：Win9X/ WinME/ Wi」· PHPT 代码 · 共 47 行

--TEST--
oci_statement_type()
--SKIPIF--
<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
--FILE--
<?php

require dirname(__FILE__)."/connect.inc";

if (!empty($dbase)) {
	var_dump($c = oci_connect($user, $password, $dbase));
}
else {
	var_dump($c = oci_connect($user, $password));
}

$sqls = Array(
	"SELECT * FROM table",
	"DELETE FROM table WHERE id = 1",
	"INSERT INTO table VALUES(1)",
	"UPDATE table SET id = 1",
	"DROP TABLE table",
	"CREATE TABLE table (id NUMBER)",
	"WRONG SYNTAX",
	""
);

foreach ($sqls as $sql) {
	$s = oci_parse($c, $sql);
	var_dump(oci_statement_type($s));
}

echo "Done\n";

?>
--EXPECTF--
resource(%d) of type (oci8 connection)
string(6) "SELECT"
string(6) "DELETE"
string(6) "INSERT"
string(6) "UPDATE"
string(4) "DROP"
string(6) "CREATE"
string(7) "UNKNOWN"
string(7) "UNKNOWN"
Done