ibase_prepare()

(PHP 5, PHP 7)

Prepare a query for later binding of parameter placeholders and execution

说明

ibase_prepare(string $query): resource

ibase_prepare(resource $link_identifier,string $query): resource

ibase_prepare(resource $link_identifier,string $trans,string $query): resource

Prepare a query for later binding of parameter placeholders and execution(via ibase_execute()).

参数

$query

An InterBase query.

$link_identifier

An InterBase link identifier returned from ibase_connect(). If omitted, the last opened link is assumed.

$trans

An InterBase transaction handle the query should be associated with. If omitted, the default transaction of the connection is assumed.

返回值

Returns a prepared query handle, or FALSE on error.

<?php
/**
 * EDIT TO ABOVE: The above mentions "ibase_fetch_object". 
 * In that case if should be using the object operator.
 * Example below.
 */
$query = "SELECT * FROM EMPLOYEES";
$p_sql = ibase_prepare($query);
$result = ibase_execute($p_sql);
while($row = ibase_fetch_object($result)){
echo $row->FIRSTNAME;
}

ex.
<?php
$query = "SELECT * FROM EMPLOYEES";
$p_sql = ibase_prepare($query);
$result = ibase_execute($p_sql);
while($row = ibase_fetch_object($result)){
echo $row['FIRSTNAME'];
}