odbc_execute(3) [php man page]

ODBC_EXECUTE(3) 							 1							   ODBC_EXECUTE(3)

odbc_execute - Execute a prepared statement

SYNOPSIS

       bool odbc_execute (resource  $result_id, [array	$parameters_array])

DESCRIPTION

	Executes a statement prepared with odbc_prepare(3).

PARAMETERS

	      o $result_id
		- The result id resource, from odbc_prepare(3).

	      o $parameters_array
		-  Parameters  in $parameter_array will be substituted for placeholders in the prepared statement in order. Elements of this array
		will be converted to strings by calling this function.	Any parameters in $parameter_array which start and end with single  quotes
		will  be  taken as the name of a file to read and send to the database server as the data for the appropriate placeholder.  If you
		wish to store a string which actually begins and ends with single quotes, you must add a space or other non-single-quote character
		to  the  beginning  or	end  of the parameter, which will prevent the parameter from being taken as a file name. If this is not an
		option, then you must use another mechanism to store the string, such as executing the query directly with odbc_exec(3)).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      odbc_execute(3) and odbc_prepare(3) example

	       In the following code, $success will only be TRUE if all three parameters to myproc are IN parameters:

	      <?php
	      $a = 1;
	      $b = 2;
	      $c = 3;
	      $stmt    = odbc_prepare($conn, 'CALL myproc(?,?,?)');
	      $success = odbc_execute($stmt, array($a, $b, $c));
	      ?>

	If you need to call a stored procedure using INOUT or OUT parameters, the recommended workaround is to use a  native  extension  for  your
       database (for example, mssql for MS SQL Server, or oci8 for Oracle).

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 4.2.0	|						    |
       |	|						    |
       |	|  File  reading  is  now  subject to safe mode and |
       |	| open-basedir restrictions in $parameters_array.   |
       |	|						    |
       +--------+---------------------------------------------------+
SEE ALSO

       odbc_prepare(3).

PHP Documentation Group 													   ODBC_EXECUTE(3)

PDOSTATEMENT.BINDPARAM(3)						 1						 PDOSTATEMENT.BINDPARAM(3)

PDOStatement::bindParam - Binds a parameter to the specified variable name

SYNOPSIS

       public  bool  PDOStatement::bindParam  (mixed   $parameter,  mixed   &$variable, [int  $data_type = PDO::PARAM_STR], [int  $length], [mixed
       $driver_options])

DESCRIPTION

	Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was used to  prepare  the	statement.
       Unlike  PDOStatement.bindValue(3), the variable is bound as a reference and will only be evaluated at the time that PDOStatement.execute(3)
       is called.

	Most parameters are input parameters, that is, parameters that are used in a read-only fashion to build up the query. Some drivers support
       the  invocation of stored procedures that return data as output parameters, and some also as input/output parameters that both send in data
       and are updated to receive it.

PARAMETERS

	      o $parameter
		- Parameter identifier. For a prepared statement using named placeholders, this will be a parameter name of the form $:name. For a
		prepared statement using question mark placeholders, this will be the 1-indexed position of the parameter.

	      o $variable
		- Name of the PHP variable to bind to the SQL statement parameter.

	      o $data_type
		- Explicit data type for the parameter using the PDO::PARAM_* constants. To return an INOUT parameter from a stored procedure, use
		the bitwise OR operator to set the PDO::PARAM_INPUT_OUTPUT bits for the $data_type parameter.

	      o $length
		- Length of the data type. To indicate that a parameter is an OUT parameter from a stored procedure, you must explicitly  set  the
		length.

	      o $driver_options
		-

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Execute a prepared statement with named placeholders

	      <?php
	      /* Execute a prepared statement by binding PHP variables */
	      $calories = 150;
	      $colour = 'red';
	      $sth = $dbh->prepare('SELECT name, colour, calories
		  FROM fruit
		  WHERE calories < :calories AND colour = :colour');
	      $sth->bindParam(':calories', $calories, PDO::PARAM_INT);
	      $sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);
	      $sth->execute();
	      ?>

       Example #2

	      Execute a prepared statement with question mark placeholders

	      <?php
	      /* Execute a prepared statement by binding PHP variables */
	      $calories = 150;
	      $colour = 'red';
	      $sth = $dbh->prepare('SELECT name, colour, calories
		  FROM fruit
		  WHERE calories < ? AND colour = ?');
	      $sth->bindParam(1, $calories, PDO::PARAM_INT);
	      $sth->bindParam(2, $colour, PDO::PARAM_STR, 12);
	      $sth->execute();
	      ?>

       Example #3

	      Call a stored procedure with an INOUT parameter

	      <?php
	      /* Call a stored procedure with an INOUT parameter */
	      $colour = 'red';
	      $sth = $dbh->prepare('CALL puree_fruit(?)');
	      $sth->bindParam(1, $colour, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 12);
	      $sth->execute();
	      print("After pureeing fruit, the colour is: $colour");
	      ?>

SEE ALSO

       PDO.prepare(3), PDOStatement.execute(3), PDOStatement.bindValue(3).

PHP Documentation Group 												 PDOSTATEMENT.BINDPARAM(3)