Share via

SQL Server Driver for PHP 1.1 Community Technology Preview is now available

  • Article

Today we are excited to announce that the Community Technology Preview (CTP) of the Microsoft® SQL Server Driver for PHP 1.1. This version of the driver provides new capabilities for building PHP applications and support for SQL Azure as well as support for PHP version 5.3, enabling developers to build PHP applications with relational capabilities using SQL Azure Database. Details of the SQL Azure Database CTP is available in a blogpost here.

 SQL Server Driver for PHP 1.1 CTP will include:

· Support for SQL Azure

· Support for PHP version 5.3

· Support for UTF-8

· Support for Scrollable results, row countMigration to SQL Server 2008 Native Client framework that provides for performance enhancements.

You can download the CTP of the SQL Server Driver for PHP 1.1 here.

The SQL Connectivity PHP team would welcome your feedback on this release.  

Thanks,

Raghu Ram

Principal Group Program Manager

SQL Connectivity

Comments

  • Anonymous
    August 18, 2009
    I'm very impatient to try this! But I'm not yet able to... PHP 5.3 is compiled with vc8, and this is compiled with vc 6 or 9, neither of which seems to be compatible. Is it possible to get this compiled with vc8? Alternatively I'll try to get PHP 5.3 compiled with vc9 (or 6). The good news is that Zend's Community Server 4.0.5 has PHP 5.3 and the 1.0.0 version of this driver, recompiled  to work with PHP 5.3 (at least for the basics). I'm very much looking forward to the included Unicode support... you wouldn't believe the amount of code it has required for me to work around that in a generic manner! Thanks, --Travis

  • Anonymous
    August 18, 2009
    PHP 5.3 is compiled with vc6 and vc9 http://windows.php.net/download/, I do not know of any official supported releases that is compiled with vc8.

  • Anonymous
    August 19, 2009
    I just installed the driver and it works fine so far. Thanks for the new sqlsrv_num_rows. In fact, I just ported my php_mssql.dll based DB layer to php_sqlsrv.dll in about an hour. There is a small problem: The documentation states that we can use the following constants SQLSRV_FETCH_NEXT SQLSRV_FETCH_PRIOR SQLSRV_FETCH_FIRST SQLSRV_FETCH_LAST SQLSRV_FETCH_ABSOLUTE SQLSRV_FETCH_RELATIVE But the code example uses another constant: SQLSRV_SCROLL_LAST If I use any of the SQLSRV_FETCH_* constants, PHP reports them as unavailable. However, SQLSRV_SCROLL works fine.

  • Anonymous
    August 19, 2009
    The documentation is a bit misleading and needs corrections. The prefix for the new constants is indeed SQLSRV_SCROLL_.  These constants are mapped internally to the appropriate ODBC constants prefixed by SQL_FETCH_ . For example, the driver registers with PHP the string “SQLSRV_SCROLL_NEXT” as a mapping for the integer value represented by ODBC constant SQL_FETCH_NEXT.  Subsequently, only “SQLSRV_SCROLL_NEXT” can be used in a PHP script. Serban Iliescu SQL Connectivity Team

  • Anonymous
    August 20, 2009
    Thanks so much for this release. A lack of support from SQL Server for UTF-8 has been a barrier for us for a while, so to get that AND 5.3 support is a dream come true!

  • Anonymous
    August 20, 2009
    Great to see active progress on this! So now that UTF-8, scrollable resultset, and rowcount have been tackled ( http://blogs.msdn.com/sqlphp/archive/2009/02/18/Working-on-version-1.1-of-the-SQL-Server-Driver-for-PHP.aspx#9576520 ) , does this mean *nix support is next? :) Really looking forward to have an updated, native driver for SQL Server in -PHP- (not just Windows PHP!)