ibase_query(3) [php man page]

IBASE_QUERY(3)								 1							    IBASE_QUERY(3)

ibase_query - Execute a query on an InterBase database

SYNOPSIS

       resource ibase_query ([resource	$link_identifier], string  $query, [int  $bind_args])

DESCRIPTION

	Performs a query on an InterBase database.

PARAMETERS

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

	      o $query
		- An InterBase query.

	      o $bind_args
		-

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

	       In PHP 5.0.0 and up, this function will return the number of rows affected by the query for INSERT, UPDATE and  DELETE  statements.
	      In  order  to  retain  backward compatibility, it will return TRUE for these statements if the query succeeded without affecting any
	      rows.

ERRORS
/EXCEPTIONS
	If you get some error like "arithmetic exception, numeric overflow, or string truncation. Cannot transliterate character between character
       sets"  (this  occurs  when you try use some character with accents) when using this and after ibase_query(3) you must set the character set
       (i.e. ISO8859_1 or your current character set).

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.3.1	|						    |
       |	|						    |
       |	|  On success the  function  now  returns  TRUE  if |
       |	| there  were no affected rows, where it previously |
       |	| returned 0  (a zero followed by an empty space).  |
       |	|						    |
       +--------+---------------------------------------------------+
EXAMPLES

       Example #1

	      ibase_query(3) example

	      <?php

	      $host = 'localhost:/path/to/your.gdb';

	      $dbh = ibase_connect($host, $username, $password);
	      $stmt = 'SELECT * FROM tblname';

	      $sth = ibase_query($dbh, $stmt) or die(ibase_errmsg());

	      ?>

SEE ALSO

       ibase_errmsg(3), ibase_fetch_row(3), ibase_fetch_object(3), ibase_free_result(3).

PHP Documentation Group 													    IBASE_QUERY(3)

MYSQLI_STMT_AFFECTED_ROWS(3)						 1					      MYSQLI_STMT_AFFECTED_ROWS(3)

mysqli_stmt::$affected_rows - Returns the total number of rows changed, deleted, or inserted by the last executed statement

       Object oriented style

SYNOPSIS

       int$mysqli_stmt->affected_rows ()

DESCRIPTION

       Procedural style
       int mysqli_stmt_affected_rows (mysqli_stmt  $stmt)

	Returns the number of rows affected by INSERT, UPDATE, or DELETE query.

	This  function	only  works  with  queries  which  update  a  table.  In  order  to  get  the  number  of  rows  from  a SELECT query, use
       mysqli_stmt_num_rows(3) instead.

PARAMETERS

	      o $
		stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).

RETURN VALUES

	An integer greater than zero indicates the number of rows affected or retrieved. Zero indicates that  no  records  where  updated  for	an
       UPDATE/DELETE  statement, no rows matched the WHERE clause in the query or that no query has yet been executed. -1 indicates that the query
       has returned an error. NULL indicates an invalid argument was supplied to the function.

       Note

	       If the number of affected rows is greater than maximal PHP int value, the number of affected rows will  be  returned  as  a  string
	      value.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      /* create temp table */
	      $mysqli->query("CREATE TEMPORARY TABLE myCountry LIKE Country");

	      $query = "INSERT INTO myCountry SELECT * FROM Country WHERE Code LIKE ?";

	      /* prepare statement */
	      if ($stmt = $mysqli->prepare($query)) {

		  /* Bind variable for placeholder */
		  $code = 'A%';
		  $stmt->bind_param("s", $code);

		  /* execute statement */
		  $stmt->execute();

		  printf("rows inserted: %d
", $stmt->affected_rows);

		  /* close statement */
		  $stmt->close();
	      }

	      /* close connection */
	      $mysqli->close();
	      ?>

       Example #2

	      Procedural style

	      <?php
	      $link = mysqli_connect("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      /* create temp table */
	      mysqli_query($link, "CREATE TEMPORARY TABLE myCountry LIKE Country");

	      $query = "INSERT INTO myCountry SELECT * FROM Country WHERE Code LIKE ?";

	      /* prepare statement */
	      if ($stmt = mysqli_prepare($link, $query)) {

		  /* Bind variable for placeholder */
		  $code = 'A%';
		  mysqli_stmt_bind_param($stmt, "s", $code);

		  /* execute statement */
		  mysqli_stmt_execute($stmt);

		  printf("rows inserted: %d
", mysqli_stmt_affected_rows($stmt));

		  /* close statement */
		  mysqli_stmt_close($stmt);
	      }

	      /* close connection */
	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      rows inserted: 17

SEE ALSO

       mysqli_stmt_num_rows(3), mysqli_prepare(3).

PHP Documentation Group 											      MYSQLI_STMT_AFFECTED_ROWS(3)