array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'tr', ), 'this' => array ( 0 => 'function.cubrid-execute.php', 1 => 'cubrid_execute', ), 'up' => array ( 0 => 'ref.cubrid.php', 1 => 'CUBRID İşlevleri', ), 'prev' => array ( 0 => 'function.cubrid-error-msg.php', 1 => 'cubrid_error_msg', ), 'next' => array ( 0 => 'function.cubrid-fetch.php', 1 => 'cubrid_fetch', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/cubrid/functions/cubrid-execute.xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); ?>
(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_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, başarısızlık durumunda false
döner.
Sürüm: | Açıklama |
---|---|
8.4.0 |
Add new option CUBRID_EXEC_QUERY_ALL .
|
Örnek 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);
?>
Yukarıdaki örneğin çıktısı:
athlete host_year score unit Phelps Michael 2004 51.25 time