ibase_prepare

(PHP 5, PHP 7)

ibase_prepare — Prepare a query for later binding of parameter placeholders and execution

Description

resource ibase_prepare ( string $query )

resource ibase_prepare ( resource $link_identifier , string $query )

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

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

Parameters

query: An InterBase query.

Return Values

Returns a prepared query handle, or FALSE on error.

User Contributed Notes

Andrew Champ

3 months ago


<?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;
}

adamson dot ibus at gmail dot com

3 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'];
}