(PECL CUBRID >= 8.3.0)
cubrid_execute — Execute a prepared SQL statement
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_identifierConnection identifier.
sqlSQL to be executed.
optionQuery execution option CUBRID_INCLUDE_OID, CUBRID_ASYNC, CUBRID_EXEC_QUERY_ALL.
request_identifiercubrid_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 を返します.
| バージョン | 説明 |
|---|---|
| 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($result, CUBRID_ASSOC);
$event_code = $row["code"];
cubrid_close_request($result);
$history_req = cubrid_prepare($conn, "SELECT * FROM history WHERE event_code=?");
cubrid_bind($history_req, 1, $event_code, "number");
cubrid_execute($history_req);
printf("%-20s %-9s %-10s %-5s\n", "athlete", "host_year", "score", "unit");
while ($row = cubrid_fetch_array($history_req, CUBRID_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