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_GET_FIELD(3) SQLSRV_GET_FIELD(3) sqlsrv_get_field - Gets field data from the currently selected row SYNOPSIS
mixed sqlsrv_get_field (resource $stmt, int $fieldIndex, [int $getAsType]) DESCRIPTION
Gets field data from the currently selected row. Fields must be accessed in order. Field indices start at 0. PARAMETERS
o $stmt - A statement resource returned by sqlsrv_query(3) or sqlsrv_execute(3). o $fieldIndex - The index of the field to be retrieved. Field indices start at 0. Fields must be accessed in order. i.e. If you access field index 1, then field index 0 will not be available. o $getAsType - The PHP data type for the returned field data. If this parameter is not set, the field data will be returned as its default PHP data type. For information about default PHP data types, see Default PHP Data Types in the Microsoft SQLSRV documentation. RETURN VALUES
Returns data from the specified field on success. Returns FALSE otherwise. EXAMPLES
Example #1 sqlsrv_get_field(3) example The following example demonstrates how to retrieve a row with sqlsrv_fetch(3) and get the row fields with sqlsrv_get_field(3). <?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 = "SELECT Name, Comment FROM Table_1 WHERE ReviewID=1"; $stmt = sqlsrv_query( $conn, $sql); if( $stmt === false ) { die( print_r( sqlsrv_errors(), true)); } // Make the first (and in this case, only) row of the result set available for reading. if( sqlsrv_fetch( $stmt ) === false) { die( print_r( sqlsrv_errors(), true)); } // Get the row fields. Field indeces start at 0 and must be retrieved in order. // Retrieving row fields by name is not supported by sqlsrv_get_field. $name = sqlsrv_get_field( $stmt, 0); echo "$name: "; $comment = sqlsrv_get_field( $stmt, 1); echo $comment; ?> SEE ALSO
sqlsrv_fetch(3), sqlsrv_fetch_array(3), sqlsrv_fetch_object(3). PHP Documentation Group SQLSRV_GET_FIELD(3)