本文为不熟悉SQL Server的Web开发者提供指南，介绍如何将SQL Server数据库与PHP网站结合使用。内容涵盖环境搭建、连接数据库、数据存取及使用PDO等。
Intended audience: Web developers who are not familiar with SQL Server, yet want to learn how to use a SQL Server database with their PHP web sites.
The links below are external links and provide information and guidance on creating dynamic web pages using PHP, SQL Server and IIS as part of web site development. This information assumes that you are already familiar with PHP development. If you are not familiar with PHP and are looking for information or additional programming resources for this language, visit http://www.php.net/.
Setting up your environment
- Getting Started with PHP on Windows (initial setup, including manual setup)
- Getting Started with PHP on Windows with SQL Server Express (initial setup and basic usage)
- Getting Started with the SQL Server Driver for PHP
- SQL Server Driver for PHP: Understanding Windows Authentication
Connecting to SQL Server from PHP
- Connecting to the SQL Server
- How to: Connect Using Windows Authentication
- How to: Connect Using SQL Server Authentication
Storing and Retrieving Data
- Execute a query using sqlsrv_query
- Execute a prepared statement using sqlsrv_execute
- How to: Perform Parameterized Queries
- How to: Perform Transactions
- Retrieving data
- Retrieve data as an array
- Retrieve data as a PHP object
- Retrieve a row of data
- Retrieve a field from the current row
- Storing images/using FILESTREAM
PHP Data Object (PDO) Support
- Retrieving a row of data
- Retrieve all rows as an array
- Retrieve one column from a row
- Retrieve a row as a PHP object
Other Languages
This article is also available in the following languages:
- Portuguese: Como Utilizar PHP do SQL Server (pt-BR)
- Japanese: PHP で SQL Server を利用するには (ja-JP)
- Spanish: Cómo usar PHP con SQL Server (es-ES)
=======================
Read the latest version of this Wiki article here, including lists of articles about Improving Performance and Security Concerns.
扫一扫
1992
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
