Collections:
mssql_close() - Disconnecting from a SQL Server
How To Disconnect from a SQL Server using mssql_close()?
✍: Guest
When you call mssql_connect(), it will return an object representing the connection to the SQL Server. This connection object will be used by subsequent MSSQL function calls. When you are done with this connection, you should close it to free up resources by calling the mssql_close() function.
The tutorial script below shows you how to call mssql_connect() and mssql_close() to connect and disconnect to the SQL Server:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); if (!$con) { print("Connection failed with error.\n"); } else { print("The SQL Server connection object is ready.\n"); mssql_close($con); } ?>
If you run this script and get this output: "The SQL Server connection object is ready", your connection to the SQL Server are working.
Note that 'sa' and 'FYIcenter' used in this script are system administrator login name and password. You may use any other login name and password defined on the SQL Server.
⇒ mssql_select_db() - Selecting an Exiting Database
⇐ Commonly Used MSSQL Functions in PHP
⇑ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
2024-04-07, 1377🔥, 0💬
Popular Posts:
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...