ID: 36519 Updated by: [EMAIL PROTECTED] Reported By: sanchezvilledah at missouri dot edu Status: Feedback Bug Type: Oracle related Operating System: Red Hat 9.0 PHP Version: 5.1.2 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5.1-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.1-win32-latest.zip Try CVS snapshot first. Previous Comments: ------------------------------------------------------------------------ [2006-02-25 17:15:01] [EMAIL PROTECTED] Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. ------------------------------------------------------------------------ [2006-02-24 22:47:30] sanchezvilledah at missouri dot edu Description: ------------ The script does not process the last records. If I use phpinfo() at the end of the script it finishes, otherwise the script lost the last 3 rows, and I got in error_log file [Fri Feb 24 11:27:49 2006] [notice] child pid. url at http://btest.rnet.missouri.edu/Roots/Roots_Integration/MicroArray_Info6.php Reproduce code: --------------- <? require_once("connection.php"); require_once("Structure3.php"); /*********************/ /* connect to Oracle */ /*********************/ $conn = db_connect(); if (!$conn) return "Can not connect to Oracle."; $FDR_Min = SetFDRMin(); $FDR_Max = SetFDRMax(); $tab_active = "MArray"; PrintHTMLHeader( $tab_active ); DisplaySearchFDR(); # display the box with search options print "<table class=\"sort-table\" id=\"table-1\" border=1, width=\"1250\">"; print "<thead><tr><td title=\"String\">MZ_NAME</td><td title=\"Number\">FOLD CHANGE</td><td title=\"Number\">P_VALUE</td><td title=\"Number\">FDR</td><td title=\"Number\">STD DEV</td><td title=\"String\">EXPERIMENT</td></tr></thead>\n"; $query = CreateFDRQuery($FDR_Min, $FDR_Max); $query = OCIParse($conn, $query); OCIExecute($query); print " <tbody>"; while(OCIFetch($query)) { $GName = OCIResult($query, "MZ_NAME"); $FChange = OCIResult($query, "FOLD_CHANGE"); $PValue = OCIResult($query, "P_VALUE"); $FDR = OCIResult($query, "FDR"); $STD_DEV = OCIResult($query, "STD_DEV"); $Experiment = OCIResult($query, "EXPERIMENT_NAME"); $Exp_ID = SetExperiment($Experiment); $EXPERIMENTURL = "http://bioinf2.rnet.missouri.edu/nologin.phtml?location=experiment_edit.phtml?i_e=".$Exp_ID; $DESCURL = "/Roots/Roots_Integration/MicroArray_Desc.php?Mz_Name=".$GName; print "<tr><td><a target=\"_blank\" href=".$DESCURL.">".$GName."</a></td><td>".$FChange."</td><td>".$PValue."</td><td>".$FDR."</td><td>" .$STD_DEV."</td><td><a target=\"_blank\" href=".$EXPERIMENTURL.">".$Experiment."</a></td></tr>\n"; # print "<tr><td><a href=\"MicroArray_Desc.php\" onclick="MM_openBRWindow(\'.$DESCURL.">".$GName','','width=500,height=400\')."</a></td><td>".$FChange."</td><td>".$PValue."</td><td>".$FDR."</td><td>" .$STD_DEV."</td><td><a target=\"_blank\" href=".$EXPERIMENTURL.">".$Experiment."</a></td></tr>\n"; } print "</tbody>"; print "</table>"; print "<script type=\"text/javascript\">"; print "var st1 = new SortableTable(document.getElementById(\"table-1\"), [\"String\", \"Number\", \"Number\", \"Number\", \"Number\", \"String\"])"; print "</script>\n"; OCIFreeStatement($query); $query = CreateFDRQuery($FDR_Min, $FDR_Max); $query = OCIParse($conn, $query); OCIExecute($query); OCILogoff($conn); print phpinfo(32); # if this line is commented the last rows are not processed ?> </BODY> </HTML> Expected result: ---------------- I expect that the script process all the Fetched records and print them. Actual result: -------------- If I include other sql query and print the results to the screen it works, however the last rows for the second query are not processed. It might be something with the buffer. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36519&edit=1
