|
Последние активные темы форума |
|
ibase_execute
(PHP 3>= 3.0.6, PHP 4 , PHP 5) ibase_execute -- Execute a previously prepared query
Descriptionresource ibase_execute ( resource query [, mixed bind_arg [, mixed ...]] ) Execute a query prepared by ibase_prepare(). If
the query raises an error, returns FALSE. If it is successful and
there is a (possibly empty) result set (such as with a SELECT query),
returns a result identifier. If the query was successful and there were
no results, returns TRUE.
This is a lot more effective than using ibase_query()
if you are repeating a same kind of query several times with only
some parameters changing.
Пример 1. ibase_execute() example
<?php
$dbh
=
ibase_connect
(
$host
,
$username
,
$password
);
$updates
= array(
1
=>
'Eric'
,
5
=>
'Filip'
,
7
=>
'Larry'
);
$query
=
ibase_prepare
(
$dbh
,
"UPDATE FOO SET BAR = ? WHERE BAZ = ?"
);
while (list(
$baz
,
$bar
) =
each
(
$updates
)) {
ibase_execute
(
$query
,
$bar
,
$baz
);
}
?>
|
|
Замечание:
In PHP 5.0.0 and up, this function returns the number of rows affected by
the query (if > 0 and applicable to the statement type). A query that succeeded,
but did not affect any rows (e.g. an UPDATE of a non-existent record) will return
TRUE.
Смотрите также ibase_query().
|