Cannot backup a database and retrieve multiple results in one statement

In our application, we need to be able to backup a database from PHP and also retrieve data from SELECTs in the same statement. Actually, we run all this code in a Stored Procedure in SQL Server 20...

Id #22419 | Release: None | Updated: Dec 11, 2012 at 2:29 PM by MaxiWheat | Created: Dec 10, 2012 at 5:56 PM by MaxiWheat

Problem with sqlsrv_next_result/lastinsertid after insert on table with trigger

Hi, i have a table with an insert trigger defined. I made an insert on this table and want to get the inserted id. So i made this: $sql = 'INSERT INTO "content" ("parent", "name", "content", "crea...

Id #22418 | Release: None | Updated: Dec 6, 2012 at 7:45 AM by lordlamer | Created: Nov 30, 2012 at 8:57 AM by lordlamer

PHP sqlsrv 3.0.1 Driver: sqlsrv_field_metadata returns column name as char*, so unicode column names can't be fetched correctly

Customer uses unicode column names: CREATE TABLE Greek ( [γεια σας κόσμο] nvarchar NOT NULL, [привет мир] nvarchar NOT NULL, [こんにちは世界] nvarchar NOT NULL ); calling sqlsrv_field_metadata c...

Id #22417 | Release: None | Updated: Sep 25, 2012 at 8:17 PM by WRead | Created: Sep 25, 2012 at 8:17 PM by WRead

PDOStatement execute error

I am using PHP 5.4 (zend 5.6), IIS 7.5, and SQLSRV-PHP driver on my development machine. I tried inserting some data into SQL2008R2 database using the new driver but to my surprise every time i ru...

Id #22416 | Release: None | Updated: May 21, 2012 at 3:01 PM by jguerin | Created: May 17, 2012 at 2:33 PM by quaspam

Warning in ReflectionExtension::export('sqlsrv')

PHP 5.3.5 - windows 7 - VC6 ts <code> ReflectionExtension::export('sqlsrv'); </code> Warning: ReflectionExtension::__toString(): Internal error: Cannot find extension function SQLSRV_PHPTYPE_STREA...

Id #20138 | Release: None | Updated: Mar 4, 2011 at 2:54 PM by stealth35 | Created: Mar 4, 2011 at 12:13 PM by stealth35

Add required header to config.w32

Hi. Adding the line ... CHECK_HEADER_ADD_INCLUDE('sqlncli.h', 'CFLAGS_SQLSRV_ODBC'); to config.w32 would be useful for new builds.

Id #19302 | Release: None | Updated: Dec 14, 2010 at 4:57 PM by RQuadling | Created: Dec 14, 2010 at 4:57 PM by RQuadling

Mistake in help: Data protocol in PHP expects urlencoded data.

PHP has a feature to open the stream from string passed through RFC 2397 data: protocol. The SQLSRV help describes this feature to send the data as a stream to the MS-SQL server. However, data pas...

Id #19139 | Release: None | Updated: Nov 18, 2010 at 11:45 AM by michalkocarek | Created: Nov 18, 2010 at 11:44 AM by michalkocarek

Using reflection on the extension or the functions in the extension result in invalid parameter names.

The parameter names to all the functions in the extension (V1.1.428.1) are quoted ... [2010/04/30 12:17:20] [C:] [] >c:\php5\php.exe -n -d extension_dir=c:\php5\ext -d extension="php_sqlsrv_53_nts...

Id #17486 | Release: None | Updated: Jul 17, 2010 at 8:44 PM by AshayC | Created: Apr 30, 2010 at 11:21 AM by RQuadling

Objects and resources (streams) cause web server crash after sqlsrv_prepare()

/* This sample code will crash your web server. It won't crash when $myDate is initialised to a DateTime object before calling sqlsrv_prepare(). / $conn = sqlsrv_connect(........); sqlsrv_free_stm...

Id #17336 | Release: None | Updated: Jul 13, 2010 at 9:04 PM by icosahedron | Created: Apr 21, 2010 at 3:03 PM by robertjohnson

php --re sqlsrv returns warnings.

Hi. Using the official PHP V5.3.2 and php_sqlsrv_53_nts_vc9.dll results in some warnings when using --ri. Even tried removing the ini file (-n) ... php -n -d extension_dir=c:\php5\ext -d extensi...

Id #16926 | Release: None | Updated: Jul 19, 2010 at 11:19 AM by RQuadling | Created: Mar 23, 2010 at 3:05 PM by RQuadling