| ||||||
 | ||||||
LVI. Microsoft SQL Server functions
The MSSQL extension is available on Win32 systems only. You can use the Sybase extension to connect to MSSQL databases from other platforms.
These functions allow you to access MS SQL Server database. The extension requires the MS SQL Client Tools to be installed on the system where PHP is installed. The Client Tools can be installed from the MS SQL Server CD or by copying ntwdblib.dll from \winnt\system32 on the server to \winnt\system32 on the PHP box. Copying ntwdblib.dll will only provide access. Configuration of the client will require installation of all the tools.
The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini.
- Obsah
- mssql_close — Close MS SQL Server connection
- mssql_connect — Open MS SQL server connection
- mssql_data_seek — Move internal row pointer
- mssql_fetch_array — Fetch row as array
- mssql_fetch_field — Get field information
- mssql_fetch_object — Fetch row as object
- mssql_fetch_row — Get row as enumerated array
- mssql_field_length — Get the length of a field
- mssql_field_name — Get the name of a field
- mssql_field_seek — Set field offset
- mssql_field_type — Get the type of a field
- mssql_free_result — Free result memory
- mssql_get_last_message — Returns the last message from server (over min_message_severity?)
- mssql_min_error_severity — Sets the lower error severity
- mssql_min_message_severity — Sets the lower message severity
- mssql_next_result — Move the internal result pointer to the next result
- mssql_num_fields — Get number of fields in result
- mssql_num_rows — Get number of rows in result
- mssql_pconnect — Open persistent MS SQL connection
- mssql_query — Send MS SQL query
- mssql_result — Get result data
- mssql_select_db — Select MS SQL database
- mssql_bind — Adds a parameter to a stored procedure or a remote stored procedure
- mssql_execute — Executes a stored procedure on a MS-SQL server database
- mssql_fetch_assoc — Returns an associative array of the current row in the result set specified by result_id
- mssql_fetch_batch — Returns the next batch of records
- mssql_guid_string — Converts a 16 byte binary GUID to a string
- mssql_init — Initializes a stored procedure or a remote stored procedure
- mssql_rows_affected — Returns the number of records affected by the query
| ||||||
|