mssql_bind(3) [php man page]

MSSQL_BIND(3)															     MSSQL_BIND(3)

mssql_bind - Adds a parameter to a stored procedure or a remote stored procedure

SYNOPSIS

       bool mssql_bind (resource  $stmt, string  $param_name, mixed  &$var, int  $type, [bool  $is_output = false], [bool  $is_null = false], [int
       $maxlen = -1])

DESCRIPTION

	Binds a parameter to a stored procedure or a remote stored procedure.

PARAMETERS

	      o $stmt
		- Statement resource, obtained with mssql_init(3).

	      o $param_name
		- The parameter name, as a string.

	      Note

		      You have to include the @ character, like in the T-SQL syntax. See the explanation included in mssql_execute(3).

	      o $var
		- The PHP variable you'll bind the MSSQL parameter to. It is passed by reference, to retrieve OUTPUT and RETVAL values	after  the
		procedure execution.

	      o $type
		- One of: SQLTEXT, SQLVARCHAR, SQLCHAR, SQLINT1, SQLINT2, SQLINT4, SQLBIT, SQLFLT4, SQLFLT8, SQLFLTN.

	      o $is_output
		-  Whether  the value is an OUTPUT parameter or not. If it's an OUTPUT parameter and you don't mention it, it will be treated as a
		normal input parameter and no error will be thrown.

	      o $is_null
		- Whether the parameter is NULL or not. Passing the NULL value as $var will not do the job.

	      o $maxlen
		- Used with char/varchar values. You have to indicate the length of the data so if the parameter is a varchar(50), the	type  must
		be SQLVARCHAR and this value 50.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_bind(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php');

	      // Create a new stored prodecure
	      $stmt = mssql_init('NewUserRecord');

	      // Bind the field names
	      mssql_bind($stmt, '@username',  'Kalle',	SQLVARCHAR,  false,  false,  60);
	      mssql_bind($stmt, '@name',      'Kalle',	SQLVARCHAR,  false,  false,  60);
	      mssql_bind($stmt, '@age',       19,	SQLINT1,     false,  false,   3);

	      // Execute
	      mssql_execute($stmt);

	      // Free statement
	      mssql_free_statement($stmt);
	      ?>

SEE ALSO

       mssql_execute(3), mssql_free_statement(3), mssql_init(3).

PHP Documentation Group 													     MSSQL_BIND(3)

Check Out this Related Man Page

SQLSRV_SEND_STREAM_DATA(3)												SQLSRV_SEND_STREAM_DATA(3)

sqlsrv_send_stream_data - Sends data from parameter streams to the server

SYNOPSIS

       bool sqlsrv_send_stream_data (resource  $stmt)

DESCRIPTION

	Send data from parameter streams to the server. Up to 8 KB of data is sent with each call.

PARAMETERS

	      o $stmt
		- A statement resource returned by sqlsrv_query(3) or sqlsrv_execute(3).

RETURN VALUES

	Returns TRUE if there is more data to send and FALSE if there is not.

EXAMPLES

       Example #1

	      sqlsrv_send_stream_data(3) example

	      <?php
	      $serverName = "serverNamesqlexpress";
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" );
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);
	      if( $conn === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      $sql = "UPDATE Table_1 SET data = ( ?) WHERE id = 100";

	      // Open parameter data as a stream and put it in the $params array.
	      $data = fopen( "data://text/plain,[ Lengthy content here. ]", "r");
	      $params = array( &$data);

	      // Prepare the statement. Use the $options array to turn off the
	      // default behavior, which is to send all stream data at the time of query
	      // execution.
	      $options = array("SendStreamParamsAtExec"=>0);
	      $stmt = sqlsrv_prepare( $conn, $sql, $params, $options);

	      sqlsrv_execute( $stmt);

	      // Send up to 8K of parameter data to the server
	      // with each call to sqlsrv_send_stream_data.
	      $i = 1;
	      while( sqlsrv_send_stream_data( $stmt)) {
		    $i++;
	      }
	      echo "$i calls were made.";
	      ?>

SEE ALSO

       sqlsrv_prepare(3), sqlsrv_query(3).

PHP Documentation Group 												SQLSRV_SEND_STREAM_DATA(3)

Linux and UNIX Man Pages

mssql_bind(3) [php man page]

Check Out this Related Man Page