   #PHP Manual InterBase functions ibase_errmsg ibase_fetch_assoc

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                 ibase_execute

   (PHP 3>= 3.0.6, PHP 4 )
   ibase_execute -- Execute a previously prepared query

Description

   resource ibase_execute ( resource query [, int bind_args])

   Execute a query prepared by ibase_prepare(). If the query raises an
   error, returns FALSE. If it is successful and there is a (possibly
   empty) result set (such as with a SELECT query), returns a result
   identifier. If the query was successful and there were no results,
   returns TRUE.

   This is a lot more effective than using ibase_query() if you are
   repeating a same kind of query several times with only some parameters
   changing.

   Example 1. ibase_execute() example
   <?php

       $dbh = ibase_connect($host, $username, $password);
       $updates = array(
           1 => 'Eric',
           5 => 'Filip',
           7 => 'Larry'
       );
       $query = ibase_prepare($dbh, "UPDATE FOO SET BAR = ? WHERE BAZ =
   ?");
       while (list($baz, $bar) = each($updates)) {
           ibase_execute($query, $bar, $baz);
       }
   ?>

     Note: In PHP 5.0.0 and up, this function returns the number of rows
     affected by the query (if > 0 and applicable to the statement
     type). A query that succeeded, but did not affect any rows (e.g. an
     UPDATE of a non-existent record) will return TRUE.

   See also ibase_query().
   ______________________________________________________________________

   Prev         Home              Next
   ibase_errmsg  Up  ibase_fetch_assoc
