<?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;
}
ibase_prepare
(PHP 5, PHP 7)
ibase_prepare — Prepare a query for later binding of parameter placeholders and execution
Description
ibase_prepare
( string
$query
) : resource
ibase_prepare
( resource
$link_identifier
, string $query
) : resource
ibase_prepare
( resource
$link_identifier
, string $trans
, string $query
) : resourcePrepare a query for later binding of parameter placeholders and execution (via ibase_execute()).
Parameters
-
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.
Return Values
Returns a prepared query handle, or FALSE on error.
add a note
User Contributed Notes 2 notes
Andrew Champ ¶
3 years ago
adamson dot ibus at gmail dot com ¶
7 years ago
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'];
}
