ibase_blob_import(3) [php man page]

IBASE_BLOB_IMPORT(3)							 1						      IBASE_BLOB_IMPORT(3)

ibase_blob_import - Create blob, copy file in it, and close it

SYNOPSIS

       string ibase_blob_import (resource  $link_identifier, resource  $file_handle)

DESCRIPTION

       string ibase_blob_import (resource  $file_handle)

	This function creates a BLOB, reads an entire file into it, closes it and returns the assigned BLOB id.

PARAMETERS

	      o $link_identifier
		- An InterBase link identifier. If omitted, the last opened link is assumed.

	      o $file_handle
		- The file handle is a handle returned by fopen(3).

RETURN VALUES

	Returns the BLOB id on success, or FALSE on error.

EXAMPLES

       Example #1

	      ibase_blob_import(3) example

	      <?php
	      $dbh = ibase_connect($host, $username, $password);
	      $filename = '/tmp/bar';

	      $fd = fopen($filename, 'r');
	      if ($fd) {

		  $blob = ibase_blob_import($dbh, $fd);
		  fclose($fd);

		  if (!is_string($blob)) {
		      // import failed
		  } else {
		      $query = "INSERT INTO foo (name, data) VALUES ('$filename', ?)";
		      $prepared = ibase_prepare($dbh, $query);
		      if (!ibase_execute($prepared, $blob)) {
			  // record insertion failed
		      }
		  }
	      } else {
		  // unable to open the data file
	      }
	      ?>

SEE ALSO

       ibase_blob_add(3), ibase_blob_cancel(3), ibase_blob_close(3), ibase_blob_create(3).

PHP Documentation Group 												      IBASE_BLOB_IMPORT(3)

IBASE_EXECUTE(3)							 1							  IBASE_EXECUTE(3)

ibase_execute - Execute a previously prepared query

SYNOPSIS

       resource ibase_execute (resource  $query, [mixed  $bind_arg], [mixed  $...])

DESCRIPTION

	Execute a query prepared by ibase_prepare(3).

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

PARAMETERS

	      o $query
		- An InterBase query prepared by ibase_prepare(3).

	      o $bind_arg
		-

	      o $...
		-

RETURN VALUES

	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.

       Note

	       This  function  returns	the  number of rows affected by the query (if > 0 and applicable to the statement type). A query that suc-
	      ceeded, but did not affect any rows (e.g. an UPDATE of a non-existent record) will return TRUE.

EXAMPLES

       Example #1

	      ibase_execute(3) 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 = ?");

	      foreach ($updates as $baz => $bar) {
		  ibase_execute($query, $bar, $baz);
	      }

	      ?>

SEE ALSO

       ibase_query(3).

PHP Documentation Group 													  IBASE_EXECUTE(3)