What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.

ibase_prepare
Prev	XXIX. Interbase Functions	Next

ibase_prepare

Name

ibase_prepare — Prepare a query for execution

Synopsis

resource ibase_prepare([link], query); resource link (optional): Connection or transaction handle string query: Query to be prepared

Returns

Query handle, FALSE on error

Description

Prepares a query for later execution with ibase_execute() . Optional parameter link can be a connection handle from either ibase_connect() or ibase_pconnect() , in which case the query executes in the context of the default transaction on the specified connection, or a specific transaction opened with ibase_trans() . Defaults to default transaction on last opened connection.

Since preparing a query for execution is quite an expensive operation, it pays off to prepare it only once and then execute the prepared query several times supplying it with variables to bind into parameter placeholders, if possible. This is a very effective technique when the query runs for example inside a loop and only some of its parameters change by each iteration.

Note

Available in PHP 3 since 3.0.6, PHP 4

Example

Example 548. Preparing a query

$db = ibase_connect('/opt/interbase/examples/employee.gdb') or die("Couldn't connect to database!");
// We are going to raise the minimum salary for several job categories.
// Since this is going to be a very expensive operation, let's at least
// save some processor cycles by preparing the query beforehand...
$rs = ibase_prepare($db, 'update job set min_salary = min_salary + 30 where job_code = ?');

Prev	Home	Next
ibase_pconnect	Up	ibase_query

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at http://www.opencontent.org/openpub/). The authors of this book have elected not to choose any options under the OPL. This online book was obtained from http://www.fooassociates.com/phpfer/ and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.