Binds a parameter to a stored procedure or a remote stored procedure.
Statement resource, obtained with mssql_init().
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().
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.
One of: SQLTEXT
, SQLVARCHAR
, SQLCHAR
, SQLINT1
, SQLINT2
, SQLINT4
, SQLBIT
, SQLFLT4
, SQLFLT8
, SQLFLTN
.
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.
Whether the parameter is NULL
or not. Passing the NULL
value as var
will not do the job.
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.
Returns TRUE
on success or FALSE
on failure.
<?php // Connect to MSSQL and select the database mssql_connect('KALLESPC\SQLEXPRESS', '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); ?>
Please login to continue.