Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Binary data not returned when column data or column bound by name #35

Closed
v-mabarw opened this issue Jul 29, 2014 · 3 comments
Closed

Binary data not returned when column data or column bound by name #35

v-mabarw opened this issue Jul 29, 2014 · 3 comments
Assignees
@yitam
Labels
bug CodePlex PDO_SQLSRV resolved
Projects
msphpsql

Comments

@v-mabarw
Copy link
Member

Hi,

When using the PDO php driver (v3) with the adventureworks sample db and
either you add the following code to the sample (pdo_photo.php):

$stmt->execute(array(&$_GET['productId']));

/ _ NEW CODE _ /

$data = array();
$count = $stmt->columnCount();
for ( $i = 0; $i < $count; $i++ )
{
$field_data_array = $stmt->getColumnMeta($i);
$data[$field_data->Name] = $field_data_array;
}

/ _ END NEW CODE _ /

$stmt->bindColumn(1, $image, PDO::PARAM_LOB, 0, PDO::SQLSRV_ENCODING_BINARY);

$stmt->execute(array(&$_GET['productId']));

/ _ CHANGE column index to name, strange column indexes are 1 based _ /

$stmt->bindColumn(1, "LargePhoto", PDO::PARAM_LOB, 0,
PDO::SQLSRV_ENCODING_BINARY);

Then the binary data is mangled and the photo is not displayed.

Yours,

Charles Durrant
Thomson Reuters

Work Item Details

Original CodePlex Issue: Issue 22424
Status: Proposed
Reason Closed: Unassigned
Assigned to: Unassigned
Reported on: Nov 19, 2013 at 2:47 PM
Reported by: charliedurrant
Updated on: Nov 19, 2013 at 2:48 PM
Updated by: charliedurrant
@v-mabarw
Copy link
Member Author

On 2013-11-19 22:48:42 UTC, charliedurrant commented:

Apologies, example 2) should be

$stmt->bindColumn("LargePhoto", $image, PDO::PARAM_LOB, 0, PDO::SQLSRV_ENCODING_BINARY);

@yitam
Copy link
Contributor

yitam commented Jan 6, 2017

I was able to reproduce the problem using the following script:

$conn = new PDO( "sqlsrv:server=$server ; Database = $dbName", $uid, $pwd);
$stmt = $conn->prepare("SELECT LargePhoto FROM [Production].[ProductPhoto] WHERE ProductPhotoID = ?"); 
$param = 70;
$stmt->execute(array($param));  
$stmt->bindColumn(1, $image, PDO::PARAM_LOB, 0, PDO::SQLSRV_ENCODING_BINARY);  
//$stmt->bindColumn('LargePhoto', $image, PDO::PARAM_LOB, 0, PDO::SQLSRV_ENCODING_BINARY);  	// doing this the binary data is messed up and can't be displayed
$stmt->fetch(PDO::FETCH_BOUND);  
echo $image;
$stmt = null;
$conn = null;

@meet-bhagdev
Copy link
Contributor

@charles-durrant-tr does this repro make sense to you?

@yitam yitam self-assigned this Feb 10, 2017
@yitam yitam added the bug label Feb 10, 2017
@yitam yitam moved this from Backlog to Staged in msphpsql Feb 10, 2017
@yitam yitam moved this from Staged to Testing in msphpsql Feb 10, 2017
@yitam yitam moved this from Testing to In Progress in msphpsql Feb 10, 2017
@yitam yitam mentioned this issue Feb 10, 2017
Merged
@yitam yitam moved this from In Progress to Need Review in msphpsql Feb 10, 2017
v-dareck added a commit that referenced this issue Feb 14, 2017
@v-dareck
Merge pull request #286 from yitam/GH35
c6157b0 
Fix issue #35
@yitam yitam moved this from Need Review to Completed in msphpsql Feb 14, 2017
@yitam yitam added the resolved label Feb 14, 2017
ulvii pushed a commit that referenced this issue Mar 14, 2017
@ulvii
Updated master branch with 4.1.7-preview release (#325)
531b574 
* fixed Github #182, empty bound output parameters

* Fixing the issue with buffered result sets, when connection option is set to utf8. See issue #192

* removing new lines

* Replcaing SQLSRV_ENCODING ( CP_UTF8) with SQLSRV_ENCODING_UTF8

* Replcaing SQLSRV_ENCODING ( CP_UTF8) with SQLSRV_ENCODING_UTF8

* fixed tab and spacing

* updated the code structure

* deleted pdo_sqlsrv obsolete folder

* Updated pdo driver source code path

* added pdo shared folder

* updated sqlsrv and pdo_sqlsrv config.w32 to get the dir name dynamically

* deleted shared folder inside pdo

* Initial AppVeyor CI test build.

* Remove AppVeyor whitelist for testing.

* Fix source file path.

* Update pdo_util.cpp

* changed tab to spaces

* fixed indentations

* fixed indentations

* moved templates to driver folder

* Enable build matrix for different SQL Server versions.

* fixed the limit for row count

* fix #173, #138 on Windows code

* fixed indentations

* revert core_results to 365220a

* Readme and Change updates for Windows release.

* Fix table rendering.

* Readme and Change updates for Windows release.

* Update change log.

* Readme and Change updates for Windows release.

* Remove Linux section.

* merged Linux to CPP files

* merged Linux to php_sqlsrv.h

* Merged Linux and Windows PDO_SQLSRV code

* merged core_conn from linux to Windows

* modified based on reviews

* updated to version 4.1.5

* fixed indentations

* updated the date to Jan 19

* updated core_init

* Small ifdef fix

* Spacing fixes

* Commented code removed

* fixed preprocessor directives

* merged core_stmt from Linux

* merged conversion functions in core_sqlsrv and core_util

* config.m4

* Capitalised win32

* Commented code removed

* merged core_sqlsrv.h

* merged core_stream

* merged core_results

* added Linux specific files

* added Linux specific files

* removed windows header

* removed header files included in core_sqlv from xplat

* Issue 228. Don't allow 0 for sqlsrv ClientBufferMaxKBSize.

Add new tests for sqlsrv and pdo.

* Issue 37. sqlsrv_has_rows does not fetch if already true.

Change sqlsrv_has_rows to not scroll if already true
when using forward only cursor.

* gaurded strsafe header

* Update pdo_dbh.cpp

* Update pdo_stmt.cpp

* Update pdo_init.cpp

* Update pdo_parser.cpp

* Remove comment line from test.

* Update test comments.

* Add Description section to phpt test.

* fixed included headers order

* fixed indentations and spacing

* fixed indentations on core_results

* fixed indentations on rowCount

* fixed indentations in updated code

* fixed indentations

* fixed indentations

* bumped version to windows version

* made the ifdef consitent

* fixed L166 indentations

* bumped version to 4.1

* bumped up the version to 4.1

* bumped up the version to 4.1

* updated to version 4.1

* updated version to 4.1

* Added config.m4

* Added build directory

* fixed closing } dropped indentations

* fixed core_conn

* renamed header files with the same name as windows headers

* renamed <intsafe> in xplat.h to xplat_intsafe

* safeguard get_col_meta

* edited included headers

* fixed invalid user pass issue in core_conn

* added TravisCI to merged-code branch

* updated renamed header

* removed comments

* updated travis docker with latest from linux branch

* applied peer review comments

* added packagize.sh

* fixed get_processor_arch comparisons

* removed unused sqlsrv_zend_hash_add

* Update srv_075_database_wide_string.phpt

* Update srv_075_database.phpt

* Update srv_074_database.phpt

* Update srv_074_database_wide_string.phpt

* Update srv_073_database.phpt

* Merge remaining PHP-7.0-Linux changes into merged codebase.

* Change $sample calculation to avoid conversion to float.

* Change FORMAT SQL to CAST as SQL 2008 does not support FORMAT.

* modified ifdef __linux__

* Update srv_037_transaction_rollback.phpt

* Tab/indentation fixes.

* replace __linux__ with _WIN32 define.

* Update Readme and Changelog for merged code.

* Add re2c and gcc to readme steps.

* Update version.h

* removed inconsistent code calling convert_string_from_utf16

* corrected comment

* Change branch links to dev in README

* Test: Bind values with PDO::PARAM_BOOL

* Update pdo_023.phpt

* Update README.md

Add unixODBC 2.3.1 limitation for connection pooling with PDO.

* define SQL_GUID for PECL

* check if constant defined first

* In closeCursor check if statement has been executed before moving to next result.

* Change tab to spaces.

* Fix for issue 223

* added a test

* Modified the test 

to make it more robust

* Fix error message in close cursor. Change prepare to query in test.

* Fix and tests for issue #69

* fix formatting

* Fix issue #35

* add a simple test case with an input file

* simplified the test without image input

* Fix clang compile errors.

* Update README.md

* Add check for SQL_NO_TOTAL for SQLBindParameter out parameter.

* Update PHPT comment.

* Update PHPT comment and script.

* calculate field size instead of using column size and fixed the parameter encoding

* Remove uchar.h usage from buffered results.

* fix PHP7.1 debug abort error

* Add buffered sqlsrv test.

* use static cast for SQLSRV_ENCODING

* Update phpt comment.

* fixed issue #270

* test fetch binary

* added autonomous setup to test

* caps description

* Modify string_to_number utf8 conversion.

* Added survey

* fixed indentation and typo

* fixed indentations

* Changed db to tempdb and random table name

* fixed string quotes and free stmt

* fixed comment

* Change errno check to ERROR_SUCCESS

* Fix baseline for #297 changes.

* batch 1

* batch 2

* Fix memory leaks in buffered resultsets.

* batch 3

* modified tests based on review

* Added SELinux note for RedHat

* Issue #308

* Fix spacing

* Use a simpler way

* String release first

* String release first

* Modified based on review

* Modified note

* added a sqlsrv test, a variant

* Update srv_308_empty_output_param.phpt

* Update README.md

* appveyor.yml now outputs details of failing tests

* updated versioning to semantic versioning #282

* Update README.md

* changed locale for mac

* added client info tests

* added versioning notes

* updated precedence order example

* added 4.1.7 to changedlog

* updated PECL package version

* Update CHANGELOG.md

* Update CHANGELOG.md

* Update CHANGELOG.md

* part 1 with utf8 data

* MAC OS X announcement

* part 2 testing diff API

* part 3 testing rowCount

* part 4 fetching various types

* part 5 new sqlsrv tests

* removed redundant tests

* fixed some tests

* modified a failing test

* one more test

* Mac instructions (#319)

* Initial Mac instructions

* Add pecl install for mac

* Changing instructions for loading the drivers

* Updating apache install intructions for MAC

* Adding Mac related notes

* Minor cleanup

* appveyor.yml now outputs details of failing tests

* updated versioning to semantic versioning #282

* Update README.md

* changed locale for mac

* added client info tests

* added versioning notes

* updated precedence order example

* added 4.1.7 to changedlog

* updated PECL package version

* Update CHANGELOG.md

* Update CHANGELOG.md

* Update CHANGELOG.md

* MAC OS X announcement

* Updating Mac Apache Instructions. Also removing the step of manually adding drivers to the ini file.

* Adding php7.1-xml installation

* Apache config for Mac

* Fixing Apache config

* Update PECL instructions

* Fixed headers formatting
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yitam yitam

Labels
bug CodePlex PDO_SQLSRV resolved
Projects
msphpsql
Completed
Milestone
No milestone
Development

No branches or pull requests
4 participants
@v-mabarw @meet-bhagdev @Hadis-Knj @yitam