|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2008-09-12 10:50 UTC] johannes at schlueters dot de
[2013-02-18 00:35 UTC] pecl-dev at lists dot php dot net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Nov 02 13:00:01 2025 UTC |
Description: ------------ We use this specification(32 bit and 64 bit): - Linux Fedora Core 5(ReSpin3:20060818 ->32 bit) and (Bordeaux:01.122.500.14.021 -> 64 bit) - MySQL 5.0.22 - PHP 5.1.4 - Apache 2.2.2 client browser: IE-6 and Firefox. The error arise while we try to display the store procedure statement result in the web page (calling store procedure use PDO). All php/html code and mysql code work fine at windows machine, but error at FC-5 (We only try at FC-5) Reproduce code: --------------- Store Proc. Statement: CREATE PROCEDURE `pilsdoc`(IN mul INT) BEGIN SET @skip=mul; SET @numrows=15; PREPARE STMT FROM 'select * from wf_supp_docs limit ?,?'; EXECUTE STMT USING @skip, @numrows; END; PHP Statement: <?php $query =sprintf("call pilsdoc(".$hal1.")" ); $stmt1 = $prsh_dprin->query($query); do { $r=1; while($row = $stmt1->fetch()) { $r++; print "<tr valign='top'>"; ?> <td><?php echo($row[0])?></td> <td><?php echo($row[1])?></td> <td><p align="center"> <input name="actEdit" type="submit" id="actEdit" value="Edit"> <input name="actdel" type="submit" id="actdel" value="Hapus"> </p></td> </tr> <?php } ?> Expected result: ---------------- variabel $row[0] & $row[2] return normal characters. Actual result: -------------- variabel $row[0] & $row[1] return strange characters, like machine code for example heart symbol, +, ?, box, etc. the results are different in every browser client and every loaded page.