F.23. MS SQL
Function | Returns | Description |
---|---|---|
mssql_connect([string servername [, string username [, string password]]]) | int | Establishes a connection to an MS-SQL server. |
mssql_pconnect([string servername [, string username [, string password]]]) | int | Establishes a persistent connection to an MS-SQL server. |
mssql_close([resource conn_id]) | bool | Closes a connection to an MS-SQL server. |
mssql_select_db(string database_name [, resource conn_id]) | bool | Select an MS-SQL database. |
mssql_fetch_batch(resource result_index) | int | Returns the next batch of records. |
mssql_query(string query [, resource conn_id [, int batch_size]]) | resource | Performs an SQL query on an MS-SQL server database. |
mssql_rows_affected(resource conn_id) | int | Returns the number of records affected by the query. |
mssql_free_result(resource result_index) | bool | Frees an MS-SQL result index. |
mssql_get_last_message(void) | string | Gets the last message from the MS-SQL server. |
mssql_num_rows(resource mssql_result_index) | int | Returns the number of rows fetched in from the result_id specified. |
mssql_num_fields(resource mssql_result_index) | int | Returns the number of fields fetched in from the result_id specified. |
mssql_fetch_row(resource result_id) | array | Returns an array of the current row in the result set specified by result_id. |
mssql_fetch_object(resource result_id [, int result_type]) | object | Returns a psuedo-object of the current row in the result set specified by result_id. |
mssql_fetch_array(resource result_id [, int result_type]) | array | Returns an associative ... |
Get Web Standards Programmer's Reference: HTML, CSS, JavaScript®, Perl, Python®, and PHP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.