Accessing SQL Server Databases with PHP
Read the whitepaper here - http://msdn.microsoft.com/en-us/library/cc793139(SQL.90).aspx
extension=php_sqlsrv.dll
The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, connection pooling, and error handling. This paper discusses how to use several of these features by closely examining parts of the Example Application in the SQL Server 2005 Driver for PHP product documentation in MSDN. This paper assumes that the reader is familiar with programming in PHP, that the reader has a computer that meets the System Requirements listed for using the driver, and that the AdventureWorks example database is installed from CodePlex.
serverName = "(local)"; $connectionOptions = array("Database"=>"AdventureWorks"); /* Connect using Windows Authentication. */ $conn = sqlsrv_connect( $serverName, $connectionOptions); if( $conn === false ) { die( FormatErrors( sqlsrv_errors() ) ); }
Related posts:
Leave a Reply
You must be logged in to post a comment.