PHP Microsoft SQL Server Functions

EditRocket provides the following information on Microsoft SQL Server functions in the PHP source code builder.

bool mssql_bind ( resource $stmt , string $param_name , mixed &$var , int $type [, int $is_output [, int $is_null [, int $maxlen ]]] ) - Binds a parameter to a stored procedure or a remote stored procedure.

bool mssql_close ([ resource $link_identifier ] ) - Closes the link to a MS SQL Server database that's associated with the specified link identifier. If the link identifier isn't specified, the last opened link is assumed.

resource mssql_connect ([ string $servername [, string $username [, string $password [, bool $new_link ]]]] ) - mssql_connect() establishes a connection to a MS SQL server. The servername argument has to be a valid servername that is defined in the 'interfaces' file.

bool mssql_data_seek ( resource $result_identifier , int $row_number ) - mssql_data_seek() moves the internal row pointer of the MS SQL result associated with the specified result identifier to point to the specified row number, first row being number 0.

mixed mssql_execute ( resource $stmt [, bool $skip_results ] ) - Executes a stored procedure on a MS SQL server database

array mssql_fetch_array ( resource $result [, int $result_type ] ) -

array mssql_fetch_assoc ( resource $result_id ) - Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead.

int mssql_fetch_batch ( resource $result ) - Returns the next batch of records

object mssql_fetch_field ( resource $result [, int $field_offset ] ) - mssql_fetch_field() can be used in order to obtain information about fields in a certain query result.

object mssql_fetch_object ( resource $result ) -

array mssql_fetch_row ( resource $result ) - mssql_fetch_row() fetches one row of data from the result associated with the specified result identifier. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.

int mssql_field_length ( resource $result [, int $offset ] ) - Returns the length of field no. offset in result.

string mssql_field_name ( resource $result [, int $offset ] ) - Returns the name of field no. offset in result.

bool mssql_field_seek ( resource $result , int $field_offset ) - Seeks to the specified field offset.

string mssql_field_type ( resource $result [, int $offset ] ) - Returns the type of field no. offset in result.

bool mssql_free_result ( resource $result ) - mssql_free_result() only needs to be called if you are worried about using too much memory while your script is running. All result memory will automatically be freed when the script ends. You may call mssql_free_result() with the result identifier as an argument and the associated result memory will be freed.

bool mssql_free_statement ( resource $stmt ) - mssql_free_statement() only needs to be called if you are worried about using too much memory while your script is running. All statement memory will automatically be freed when the script ends. You may call mssql_free_statement() with the statement identifier as an argument and the associated statement memory will be freed.

string mssql_get_last_message ( void ) -

string mssql_guid_string ( string $binary [, int $short_format ] ) -

resource mssql_init ( string $sp_name [, resource $link_identifier ] ) - Initializes a stored procedure or a remote stored procedure.

void mssql_min_error_severity ( int $severity ) -

void mssql_min_message_severity ( int $severity ) -

bool mssql_next_result ( resource $result_id ) - When sending more than one SQL statement to the server or executing a stored procedure with multiple results, it will cause the server to return multiple result sets. This function will test for additional results available form the server. If an additional result set exists it will free the existing result set and prepare to fetch the rows from the new result set.

int mssql_num_fields ( resource $result ) - mssql_num_fields() returns the number of fields in a result set.

int mssql_num_rows ( resource $result ) - mssql_num_rows() returns the number of rows in a result set.

resource mssql_pconnect ([ string $servername [, string $username [, string $password [, bool $new_link ]]]] ) -

mixed mssql_query ( string $query [, resource $link_identifier [, int $batch_size ]] ) - mssql_query() sends a query to the currently active database on the server that's associated with the specified link identifier.

string mssql_result ( resource $result , int $row , mixed $field ) - mssql_result() returns the contents of one cell from a MS SQL result set.

int mssql_rows_affected ( resource $link_identifier ) -

bool mssql_select_db ( string $database_name [, resource $link_identifier ] ) - mssql_select_db() sets the current active database on the server that's associated with the specified link identifier.