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)

SERIALIZE(3)								 1							      SERIALIZE(3)

serialize - Generates a storable representation of a value

SYNOPSIS

       string serialize (mixed	$value)

DESCRIPTION

	Generates a storable representation of a value.

	This is useful for storing or passing PHP values around without losing their type and structure.

	To make the serialized string into a PHP value again, use unserialize(3).

PARAMETERS

	      o $value
		- The value to be serialized. serialize(3) handles all types, except the resource-type. You can even serialize(3) arrays that con-
		tain references to itself. Circular references inside the array/object you are serializing will also be stored. Any  other  refer-
		ence  will be lost.  When serializing objects, PHP will attempt to call the member function __sleep() prior to serialization. This
		is to allow the object to do any last minute clean-up, etc. prior to being serialized. Likewise, when the object is restored using
		unserialize(3) the __wakeup() member function is called.

	      Note

		      Object's	private  members  have	the class name prepended to the member name; protected members have a '*' prepended to the
		     member name. These prepended values have null bytes on either side.

RETURN VALUES

	Returns a string containing a byte-stream representation of $value that can be stored anywhere.

	Note that this is a binary string which may include null bytes, and needs to be stored and handled as such. For example, serialize(3) out-
       put should generally be stored in a BLOB field in a database, rather than a CHAR or TEXT field.

EXAMPLES

       Example #1

	      serialize(3) example

	      <?php
	      // $session_data contains a multi-dimensional array with session
	      // information for the current user.  We use serialize() to store
	      // it in a database at the end of the request.

	      $conn = odbc_connect("webdb", "php", "chicken");
	      $stmt = odbc_prepare($conn,
		    "UPDATE sessions SET data = ? WHERE id = ?");
	      $sqldata = array (serialize($session_data), $_SERVER['PHP_AUTH_USER']);
	      if (!odbc_execute($stmt, $sqldata)) {
		  $stmt = odbc_prepare($conn,
		   "INSERT INTO sessions (id, data) VALUES(?, ?)");
		  if (!odbc_execute($stmt, $sqldata)) {
		      /* Something went wrong.. */
		  }
	      }
	      ?>

NOTES

       Note

	       Note that many built-in PHP objects cannot be serialized. However, those with this ability either implement the Serializable inter-
	      face or the magic __sleep() and __wakeup() methods. If an internal class does not fulfill any of those requirements, it cannot reli-
	      ably be serialized.

	       There  are  some  historical exceptions to the above rule, where some internal objects could be serialized without implementing the
	      interface or exposing the methods. Notably, the ArrayObject prior to PHP 5.2.0.

       Warning

	       When serialize(3) serializes objects, the leading backslash is not included in the class name of  namespaced  classes  for  maximum
	      compatibility.

SEE ALSO

       unserialize(3), var_export(3), json_encode(3), Serializing Objects, __sleep(), __wakeup().

PHP Documentation Group 													      SERIALIZE(3)