cubrid_prepare

(PECL CUBRID >= 8.3.0)

cubrid_prepare — Prepare a SQL statement for execution

说明

cubrid_prepare ( resource $conn_identifier , string $prepare_stmt [, int $option = 0 ] ) : resource

The cubrid_prepare() function is a sort of API which represents SQL statements compiled previously to a given connection handle. This pre-compiled SQL statement will be included in the cubrid_prepare().

Accordingly, you can use this statement effectively to execute several times repeatedly or to process long data. Only a single statement can be used and a parameter may put a question mark (?) to appropriate area in the SQL statement. Add a parameter when you bind a value in the VALUES clause of INSERT statement or in the WHERE clause. Note that it is allowed to bind a value to a MARK(?) by using the cubrid_bind() function only.

参数

conn_identifier

Connection identifier.

prepare_stmt

Prepare query.

option

OID return option CUBRID_INCLUDE_OID.

返回值

Request identifier, if process is successful;

FALSE, if process is unsuccessful.

范例

Example #1 cubrid_prepare() example

<?php
$conn = cubrid_connect("localhost", 33000, "demodb");

$sql = <<<EOD
SELECT g.event_code, e.name 
FROM game g 
JOIN event e ON g.event_code=e.code 
WHERE host_year = ? AND event_code NOT IN (SELECT event_code FROM game WHERE host_year=?) GROUP BY event_code;
EOD;

$req = cubrid_prepare($conn, $sql);

cubrid_bind($req, 1, 2004);
cubrid_bind($req, 2, 2000);
cubrid_execute($req);

$row_num = cubrid_num_rows($req);
printf("There are %d event that exits in 2004 olympic but not in 2000. For example:\n\n", $row_num);

printf("%-15s %s\n", "Event_code", "Event_name");
printf("----------------------------\n");

$row = cubrid_fetch_assoc($req);
printf("%-15d %s\n", $row["event_code"], $row["name"]);
$row = cubrid_fetch_assoc($req);
printf("%-15d %s\n", $row["event_code"], $row["name"]);

cubrid_disconnect($conn);
?>

以上例程会输出：

There are 27 event that exits in 2004 olympic but not in 2000. For example:

Event_code      Event_name
----------------------------
20063           +91kg
20070           64kg

参见

相关文章
php cubrid mysql 兼容性函数 return the number of rows affected by the last sql statementphp cubrid 函数 execute a prepared sql statementphp cubrid 函数 prepare a sql statement for executionphp cubrid mysql 兼容性函数 escape special characters in a string for use in an sql statementphp ibm db2 函数 binds a php variable to an sql statement parameterphp ibm db2 函数 executes a prepared sql statementphp ibm db2 函数 returns a string containing the sqlstate returned by an sql statementphp ibm db2 函数 returns a string containing the last sql statement error messagephp dbx 函数 escape a string so it can safely be used in an sql statementphp firebird/interbase 函数 prepare a query for later binding of parameter placeholders and executionphp informix 函数 prepare an sql statement for executionphp maxdb 函数 prepare an sql statement for executionphp maxdb 函数 prepare an sql statement for executionphp odbc 函数 prepare and execute an sql statementphp sqlite 函数 returns the number of rows that were changed by the most recent sql statementphp sqlsrv 函数 executes a statement prepared with sqlsrv preparephp mysqli stmt prepare an sql statement for executionphp mysqlnduhpreparedstatement prepare an sql statement for executionphp sdo das relational 函数 executes an sql query passed as a prepared statement with a list of values to substitute for placeholders and return the results as a normalised data graphphp sqlite3 prepares an sql statement for execution
关注编程学问公众号