mssql_pconnect
(PHP 3, PHP 4 )
mssql_pconnect -- Open persistent MS SQL connection
Description
int mssql_pconnect ( [string servername [, string username
[, string password]]])
Returns: A positive MS SQL persistent link identifier on
success, or FALSE on error.
mssql_pconnect() acts very much like mssql_connect() with
two major differences.
First, when connecting, the function would first try to
find a (persistent) link that's already open with the same
host, username and password. If one is found, an identifier
for it will be returned instead of opening a new connection.
Second, the connection to the SQL server will not be closed
when the execution of the script ends. Instead, the link
will remain open for future use (mssql_close() will not
close links established by mssql_pconnect()).
This type of links is therefore called 'persistent'.
mssql_query
(PHP 3, PHP 4 )
mssql_query -- Send MS SQL query
Description
resource mssql_query ( string query [, resource link_identifier
[, int batch_size]])
Returns: A positive MS SQL result identifier on success,
or FALSE on error.
mssql_query() sends a query to the currently active database
on the server that's associated with the specified link
identifier. If the link identifier isn't specified, the
last opened link is assumed. If no link is open, the function
tries to establish a link as if mssql_connect() was called,
and use it.
See also mssql_select_db() and mssql_connect().