CUBRID 関数
PHP Manual

cubrid_execute

(PECL CUBRID >= 8.3.0)

cubrid_executeExecute a prepared SQL statement

説明

resource cubrid_execute ( resource $conn_identifier , string $sql [, int $option ] )
bool cubrid_execute ( resource $request_identifier [, int $option ] )

The cubrid_execute() function is used to execute the given SQL statement. It executes the query by using conn_identifier and SQL, and then returns the request identifier created. It is used for simple execution of query, where the parameter binding is not needed. In addition, the cubrid_execute() function is used to execute the prepared statement by means of cubrid_prepare() and cubrid_bind(). At this time, you need to specify arguments of request_identifier and option.

The option is used to determine whether to get OID after query execution and whether to execute the query in synchronous or asynchronous mode. CUBRID_INCLUDE_OID and CUBRID_ASYNC (or CUBRID_EXEC_QUERY_ALL if you want to execute multiple SQL statements) can be specified by using a bitwise OR operator. If not specified, neither of them isselected. If the flag CUBRID_EXEC_QUERY_ALL is set, a synchronous mode (sync_mode) is used to retrieve query results, and in such cases the following rules are applied:

If the first argument is request_identifier to execute the cubrid_prepare() function, you can specify an option, CUBRID_ASYNC only.

パラメータ

conn_identifier

Connection identifier.

sql

SQL to be executed.

option

Query execution option CUBRID_INCLUDE_OID, CUBRID_ASYNC, CUBRID_EXEC_QUERY_ALL.

request_identifier

cubrid_prepare() identifier.

返り値

Request identifier, when process is successful and first param is conn_identifier; TRUE, when process is successful and first argument is request_identifier.

FALSE, when process is unsuccessful.

変更履歴

バージョン 説明
8.4.0 Add new option CUBRID_EXEC_QUERY_ALL.

例1 cubrid_execute() example

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

$result cubrid_execute($conn"SELECT code FROM event WHERE name='100m Butterfly' and gender='M'"CUBRID_ASYNC);
$row cubrid_fetch_array($resultCUBRID_ASSOC);
$event_code $row["code"];

cubrid_close_request($result);

$history_req cubrid_prepare($conn"SELECT * FROM history WHERE event_code=?");
cubrid_bind($history_req1$event_code"number");
cubrid_execute($history_req);

printf("%-20s %-9s %-10s %-5s\n""athlete""host_year""score""unit");
while (
$row cubrid_fetch_array($history_reqCUBRID_ASSOC)) {
    
printf("%-20s %-9s %-10s %-5s\n"
        
$row["athlete"], $row["host_year"], $row["score"], $row["unit"]);
}

cubrid_close_request($history_req);

cubrid_disconnect($conn);
?>

上の例の出力は以下となります。

athlete              host_year score      unit 
Phelps Michael       2004      51.25      time 

参考


CUBRID 関数
PHP Manual

レンタルサーバー