(PHP 5, PHP 7)
ibase_prepare — Prepare a query for later binding of parameter placeholders and execution
$query
)$link_identifier
, string $query
)$link_identifier
, string $trans
, string $query
)Prepare a query for later binding of parameter placeholders and execution (via ibase_execute()).
queryAn InterBase query.
link_identifierAn InterBase link identifier returned from ibase_connect(). If omitted, the last opened link is assumed.
transAn 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'];
}