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.
- Table of Contents
- 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
|
