関数・クラス解説

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.

サンプル

例1 cubrid_prepare() example
 

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

$sql = <<
 
上の例の出力は以下となります。
 
There are 27 event that exits in 2004 olympic but not in 2000. For example:

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

参考