ID: 12401
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Bogus
Bug Type: OCI8 related
Operating System: Linux Server 2.2.14-6.1.1
PHP Version: 4.0.6
New Comment:
i'm sure you found this out in the meantime
Previous Comments:
------------------------------------------------------------------------
[2001-07-26 10:10:30] [EMAIL PROTECTED]
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
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=12401&edit=1
