|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2002-04-13 08:44 UTC] thies@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Sun Dec 22 05:01:30 2024 UTC |
I'm not sure this is a bug. Maybe one cannot just "break" out of an "if" or "else" block. I have a html page that accepts a username and password and then calls the code below. <?php if ((!$username) || (!$password)) { header("Location: https://192.168.1.3/easy2chat.html"); exit; } $db=""; $connection = OCILogon($username, $password, $db); if ($connection == false){ $msg = OCIError($connection)."<BR>"; } else do { // Looks like we need the "do..while()" so we can "break;" below! $stmt = "select * from \"Person\""; $cursor = OCIParse($connection, $stmt); if (false == $cursor){ $msg = OCIError($cursor)."<BR>"; OCILogoff($connection); break; } $result = OCIExecute($cursor); if (false == $result) { $msg = OCIError($cursor)."<BR>"; OCILogoff($connection); break; } echo "<table border=1>"; echo " <tr> <td><b>LegalEntityID</b></td> <td><b>Person Name</b></td> <td><b>Person Information</b></td> </tr>"; while (OCIFetchInto ($cursor, $values)){ $leID = $values[0]; $pName = $values[1]; $pInfo = $values[2]; echo " <tr> <td>$leID</td> <td>$pName</td> <td>$pInfo</td> </tr>"; } echo "</table>"; OCILogoff($connection); } while (false); ?> <HTML> <HEAD> <TITLE>Secret Area</TITLE> </HEAD> <BODY> <? echo "$msg"; ?> <form method="POST" action="https://192.168.1.3/easy2chat.html");> <input type="submit" name="logon" value="Back"> </form> </BODY> </HTML> The problem is that if I use a user which doesn't have the "Person" table in its schema the second "break;" (OCIExecute()) causes the following error: Warning: OCIStmtExecute: ORA-00942: table or view does not exist in /home/httpd/html/sec_html/logon.php on line 25 Fatal error: Cannot break/continue 1 levels in /home/httpd/html/sec_html/logon.php on line 29 My configure line was: ./configure --without-mysql --with-oci8 --with-apache=../apache_1.3.20 --enable-track-vars --with-openssl Best regards, Andrei Lenkei