mssql_init(3) [php man page]

MSSQL_INIT(3)															     MSSQL_INIT(3)

mssql_init - Initializes a stored procedure or a remote stored procedure

SYNOPSIS

       resource mssql_init (string  $sp_name, [resource  $link_identifier])

DESCRIPTION

	Initializes a stored procedure or a remote stored procedure.

PARAMETERS

	      o $sp_name
		- Stored procedure name, like ownew.sp_name or otherdb.owner.sp_name.

	      o $link_identifier
		- A MS SQL link identifier, returned by mssql_connect(3).

RETURN VALUES

	Returns a resource identifier "statement", used in subsequent calls to mssql_bind(3) and mssql_execute(3), or FALSE on errors.

EXAMPLES

       Example #1

	      mssql_init(3) example

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

	      // Create a new statement
	      $stmt = mssql_init('StatementTest', $link);

	      // Bind values here

	      // Once values are binded we execute our statement
	      // using mssql_execute:
	      mssql_execute($stmt);

	      // And we can free it like so:
	      mssql_free_statement($stmt);
	      ?>

SEE ALSO

       mssql_bind(3), mssql_execute(3), mssql_free_statement(3).

PHP Documentation Group 													     MSSQL_INIT(3)

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)