PHP Notice: Undefined variable: objResult

Question

I have a problem executing this code.
It shows this error every time:

Notice: Undefined variable: objResult in C:\wamp\www\delete.php on line 26

Also the same on line 27,28,29 and 30.

This is the table I am working on:

SQL> desc etudiant;
Nom                                       NULL ?   Type
----------------------------------------- --------  ----------------------------
NUM                                       NOT NULL NUMBER
NOM                                                VARCHAR2(15)
PRENOM                                             VARCHAR2(15)
DATE_NAISSENCE                                     DATE
ADRESSE                                            VARCHAR2(30)

delete.php sample

<html>  
<head>  
<title>DELETE ROW</title>  
</head>  
<body>  
<?  
$objConnect = oci_connect("alaa94", "red1", "orcl");   
$strSQL = "SELECT * FROM etudiant";  
$objParse = oci_parse ($objConnect, $strSQL);  
oci_execute ($objParse,OCI_DEFAULT);  
?>  
<table width="600" border="1">  
<tr>  
<th width="91"> <div align="center">Num </div></th>  
<th width="98"> <div align="center">Nom </div></th>  
<th width="198"> <div align="center">Prenom </div></th>  
<th width="97"> <div align="center">Date_naiss </div></th>  
<th width="59"> <div align="center">adresse </div></th>  
</tr>  
<?  
while($objResult = oci_fetch_array($objParse,OCI_BOTH))  
{  
?> 

<tr>  
<td><div align="center"><?=$objResult["num"];?></div></td>  
<td><?=$objResult["nom"];?></td>  
<td><?=$objResult["prenom"];?></td>  
<td><div align="center"><?=$objResult["date_naissence"];?></div></td>  
<td align="right"><?=$objResult["adresse"];?></td>  

<td align="center"><a href="delete2.php?numID=<?=$objResult["num"];?>">Delete</a></td>  
Confirm Delete  
<td align="center"><a href="JavaScript:if(confirm('Confirm Delete?')==true){window.location='delete2.php?numID=<?=$objResult["num"];?>';}">Delete</a></td>  

</tr>  
<?  
}  
?>  
</table>  
<?  
oci_close($objConnect);  
?>  
</body>  
</html>

And this is delete2.php sample

<html>  
<head>  
<title>DELETE ROW</title>  
</head>  
<body>  
<?  
$objConnect = oci_connect("alaa94", "red1", "orcl");  
$strSQL = "DELETE FROM etudiant ";  
$strSQL .="WHERE num = '".$_GET["numID"]."' ";  
$objParse = oci_parse($objConnect, $strSQL);  
$objExecute = oci_execute($objParse, OCI_DEFAULT);  
if($objExecute)  
{  
oci_commit($objConnect); //*** Commit Transaction ***//  
echo "Record Deleted.";  
}  
else  
{  
oci_rollback($objConnect); //*** RollBack Transaction ***//  
$e = oci_error($objParse);  
echo "Error Delete [".$e['message']."]";  
}  
oci_close($objConnect);  
?>  
</body>  
</html>

Possible duplicate of [PHP: "Notice: Undefined variable" and "Notice: Undefined index"](http://stackoverflow.com/questions/4261133/php-notice-undefined-variable-and-notice-undefined-index) — Qirel, Dec 11 '15 at 17:17
Not familiar with OCI but looks like you are open to SQL injections with this code.. — chris85, Dec 11 '15 at 17:20
possibly you are not getting the data from your database and $objResult["anyvalue"] doesn't contain any value so you are getting this error — Sugumar Venkatesan, Dec 11 '15 at 17:44
Stick a `print_r($objResult);` at the beginning of your `while` loop to see what's actually in there. — Darwin von Corax, Dec 11 '15 at 17:58
Is anything showing up in your server's `error.log`? Also, comment out all the table code and just call `print_r()` *instead of* generating the table. — Darwin von Corax, Dec 11 '15 at 21:34
Could it have something to do with the shorthand you're using to echo the stuff? what if you use a regular echo.. — I wrestled a bear once., Dec 11 '15 at 21:34

PHP Notice: Undefined variable: objResult

0 Answers0