How to use SQL Server database in PHP programming?

In web development, PHP is widely used to create dynamic websites and web applications. These applications often require access to a database to store and retrieve data. While MySQL is one of the most popular databases, SQL Server is also a common choice. In this article, I will introduce how to use SQL Server database in PHP programming.

First, you need to make sure that SQL Server is installed on your development computer or server and configured. You also need to install the SQL Server PHP extension provided by Microsoft. This extension provides the function of connecting, querying and managing SQL Server databases. You can enable this extension by adding the following entry in your php.ini file:

extension=php_sqlsrv_56_ts.dll
extension=php_pdo_sqlsrv_56_ts.dll

Modify the above php_sqlsrv_56_ts.dll and php_pdo_sqlsrv_56_ts .dll is the file name corresponding to your PHP version and architecture.

Once the extension is installed and enabled, you can start writing PHP code to access the SQL Server database.

Connecting to a SQL Server database

To connect to a SQL Server database, you need to provide the following information:

• The host name or IP address of the database
• Database name
• Login name
• Password

You can use the following PHP code to connect to the SQL Server database:

$serverName = "localhost"; // Your SQL Server host name or IP address
$databaseName = "database_name"; // Database name
$username = "username"; // Login name
$password = "password"; // Password

// Connect to SQL Server database
$connectionInfo = array("Database" => $databaseName, "UID" => $username, " PWD" => $password);
$conn = sqlsrv_connect($serverName, $connectionInfo);

if ($conn) {
echo "Connection successful!";
} else {
echo "Connection failed!";
die(print_r(sqlsrv_errors(), true));
}

In the above code, we use the sqlsrv_connect() function to connect to the SQL Server database. If the connection is successful, we will get a confirmation message, otherwise an error message will be output.

Execute SQL queries

After connecting to the SQL Server database, you can execute any SQL query, such as INSERT, SELECT, UPDATE, and DELETE. SQL queries can be executed using the sqlsrv_query() function.

The following is an example, executing a SELECT query and outputting its results:

$query = "SELECT * FROM customers";
$result = sqlsrv_query ($conn, $query);
if ($result === false) {
die(print_r(sqlsrv_errors(), true));
}

while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
echo $row["customer_name"]."
";
}

In the above code, we use sqlsrv_query() function to execute a SELECT query, and use the sqlsrv_fetch_array() function to obtain the results of a SELECT query. Finally, we use the echo statement to output the results.

Close the connection

After completing the operation on the SQL Server database, you should close the connection. You can use the sqlsrv_close() function to close the connection:

sqlsrv_close($conn);

In the above code, we use the sqlsrv_close() function to close The SQL Server connection created earlier.

Conclusion

By using SQL Server PHP extension, you can easily use SQL Server database in PHP programming. Connecting to the database, querying and closing the connection is easy, allowing you to focus on writing code and web applications.

The above is the detailed content of How to use SQL Server database in PHP programming?. For more information, please follow other related articles on the PHP Chinese website!