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)