php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #8165 Database output is only one char per column
Submitted: 2000-12-08 07:39 UTC Modified: 2001-02-18 06:28 UTC
From: sven dot voigt at lhsystems dot com Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.3pl1 OS: SuSE Linux 6.3/Kernel 2.2.13
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
47 + 13 = ?
Subscribe to this entry?

 
 [2000-12-08 07:39 UTC] sven dot voigt at lhsystems dot com
We're using an Oracle 8051 with Apache 1.3.12. The following code fragment runs faultless on PHP3.0.15, but produces one character output per column only on PHP4.0.3pl1:

while (OCIFetch($Stmt)) {
   echo "  <TR>\n    ";
   for ($Column=1; $Column < $NumCols; $Column++) {
      $spalte_wert=trim(OCIResult($Stmt,$Column));
      $spalte_typ=OCIColumnType($Stmt,$Column);
      if($spalte_wert=="")
         $spalte_wert="&nbsp;";
      if($spalte_typ=="NUMBER")
         $spalte_ausrichtung="RIGHT";
      else
         $spalte_ausrichtung="LEFT";
      echo ('<TD ALIGN="'.$spalte_ausrichtung.'">');
      echo "$spalte_wert";
      echo "</TD>";
   }
   echo "\n  </TR>\n";
}

The docs don't state any special treatment due to PHP4, so the code should be running on PHP3 and on PHP4. Or am I wrong? To me it looks like a bug.

For further infos please mail to stated email address above. Ciao!

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-07 19:51 UTC] sniper@php.net
Does this happen with PHP 4.0.4 ?

--Jani
 [2001-01-09 11:50 UTC] cynic@php.net
user feedback:
When I recompiled Apache with PHP 4.0.4 the problem seemed to have vanished. 
Now a colleague reported that this happened again. An Apache restart did help. So far, I couldn't figure out what the *real* problem was... As soon as I know, I'll report it to bugs.php.net

 [2001-02-18 06:28 UTC] thies@php.net
i'm sure your problem will dissapear once you set all 
oracle related env-vars *before* you start apache.

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Apr 19 03:01:27 2024 UTC