sybase_unbuffered_query(3) [php man page]

SYBASE_UNBUFFERED_QUERY(3)												SYBASE_UNBUFFERED_QUERY(3)

sybase_unbuffered_query - Send a Sybase query and do not block

SYNOPSIS

       resource sybase_unbuffered_query (string  $query, resource  $link_identifier, [bool  $store_result])

DESCRIPTION

       sybase_unbuffered_query(3)  sends  a query to the currently active database on the server that's associated with the specified link identi-
       fier. If the link identifier isn't specified, the last opened link is assumed. If no link is open, the function tries to establish  a  link
       as if sybase_connect(3) was called, and use it.

	Unlike	sybase_query(3), sybase_unbuffered_query(3) reads only the first row of the result set. sybase_fetch_array(3) and similar function
       read more rows as needed. sybase_data_seek(3) reads up to the target row. The behavior may produce  better  performance	for  large  result
       sets.

       sybase_num_rows(3)  will  only  return  the  correct number of rows if all result sets have been read. To Sybase, the number of rows is not
       known and is therefore computed by the client implementation.

       Note

	       If you don't read all of the resultsets prior to executing the next query, PHP will raise a warning and cancel all of  the  pending
	      results. To get rid of this, use sybase_free_result(3) which will cancel pending results of an unbuffered query.

PARAMETERS

	      o $query
		-

	      o $link_identifier
		-

	      o $store_result
		-  The	optional  $store_result  can  be FALSE to indicate the resultsets shouldn't be fetched into memory, thus minimizing memory
		usage which is particularly interesting with very large resultsets.

RETURN VALUES

	Returns a positive Sybase result identifier on success, or FALSE on error.

EXAMPLES

       Example #1

	      sybase_unbuffered_query(3) example

	      <?php

	      $dbh = sybase_connect('SYBASE', '', '');
	      $q = sybase_unbuffered_query('select firstname, lastname from huge_table', $dbh, false);
	      sybase_data_seek($q, 10000);
	      $i = 0;

	      while ($row = sybase_fetch_row($q)) {
		  echo $row[0], ' ', $row[1], '<br />';
		  if ($i++ > 40000) {
		      break;
		  }
	      }

	      sybase_free_result($q);
	      sybase_close($dbh);

	      ?>

NOTES

       Note

	      This function is only available when using the CT library interface to Sybase, and not with the DB library.

SEE ALSO

       sybase_query(3).

PHP Documentation Group 												SYBASE_UNBUFFERED_QUERY(3)

INGRES_UNBUFFERED_QUERY(3)						 1						INGRES_UNBUFFERED_QUERY(3)

ingres_unbuffered_query - Send an unbuffered SQL query to Ingres

SYNOPSIS

       mixed ingres_unbuffered_query (resource	$link, string  $query, [array  $params], [string  $types])

DESCRIPTION

       ingres_unbuffered_query(3) sends the given $query to the Ingres server.

	The query becomes part of the currently open transaction. If there is no open transaction, ingres_unbuffered_query(3) opens a new transac-
       tion. To close the transaction, you can call either ingres_commit(3) to commit the changes made to the database	or  ingres_rollback(3)	to
       cancel  these  changes.	When  the  script  ends,  any  open  transaction  is rolled back (by calling ingres_rollback(3)). You can also use
       ingres_autocommit(3) before opening a new transaction to have every SQL query immediately committed. Ingres allows only a single unbuffered
       statement to be active at any one time. The extension will close any active unbuffered statements before executing any SQL. In addition you
       cannot use ingres_result_seek(3) to position the row before fetching.

       Note

	      Related Configurations

	       See also the ingres.describe and ingres.utf8 directives in Runtime Configuration.

PARAMETERS

	      o $link
		- The connection link identifier

	      o $query
		- A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter  in  ingres_query(3)
		for  a	list  of  SQL statements that cannot be executed via ingres_unbuffered_query(3).  Data inside the query should be properly
		escaped.

	      o $params
		- An array of parameter values to be used with the query

	      o $types
		- A string containing a sequence of types for the parameter values passed. See the types parameter in ingres_query(3) for the list
		of type codes.

RETURN VALUES

       ingres_unbuffered_query(3) returns a query result identifier when there are rows to fetch; else it returns FALSE when there are no rows, as
       is the case of an INSERT, UPDATE, or DELETE statement. To see if an error occurred, use ingres_errno(3), ingres_error(3), or ingres_errsql-
       state(3).

EXAMPLES

       Example #1

	      Issue a simple un-buffered select

	      <?php
	      $link = ingres_connect("demodb");

	      $result = ingres_unbuffered_query($link, "select * from user_profile");
	      while ($row = ingres_fetch_row($result)) {
		  echo $row[1];
		  echo $row[2];
	      }
	      ?>

       Example #2

	      Passing query parameters to ingres_unbuffered_query(3)

	      <?php
	      $link = ingres_connect("demodb");

	      $params[] = "Emma";
	      $query = "select * from user_profile where up_first = ?";
	      $result = ingres_unbuffered_query($link, $query, $params);
	      while ($row = ingres_fetch_row($result)) {
		  echo $row[1];
		  echo $row[2];
	      }
	      ?>

       Example #3

	      Inserting a BLOB with parameter types

	      <?php
	      $link = ingres_connect("demodb");

	      //Open a photo
	      $fh = fopen("photo.jpg","r");
	      $blob_data = stream_get_contents($fh);
	      fclose($fh);

	      //Prepare parameters
	      $params[] = $blob_data;
	      $params[] = 1201;

	      //Define parameter types
	      $param_types = "Bi";

	      $query = "update user_profile set up_image = ? where up_id = ?";
	      $result = ingres_unbuffered_query($link, $query , $params, $param_types);

	      if (ingres_errno())
	      {
		  echo ingres_errno() . "-" . ingres_error() . "
";
	      }
	      ?>

SEE ALSO

       ingres_query(3),  ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3), ingres_roll-
       back(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3).

PHP Documentation Group 												INGRES_UNBUFFERED_QUERY(3)