©
本文档使用 PHP中文网手册 发布
(PECL CUBRID >= 8.3.0)
cubrid_execute — Execute a prepared SQL statement
$conn_identifier
, string $sql
[, int $option
] )$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. |
Example #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