Delete Function Problem...

Question

kira4 0 Light Poster

14 Years Ago

Don't know why my coding appear this error:
"Notice : Undefined index: PK in c:\easyphp1-8\www\associationdeleteprocess.php on line 24"
But I still can delete my database. Who can help me to solve this problem?

This is my "AssociationDeleteProcess.php" coding:

<html>
<head>
<title>Index</title>
</head>

<body background="E-Filing%20Management%20System%20Picture/Snow.gif">

<p align="center">
<img border="0" src="E-Filing%20Management%20System%20Picture/logo-RR-gif.gif" width="957" height="245"></p>
<p align="center"><span lang="zh-cn">&nbsp;</span></p>
<p align="center"><span lang="zh-cn"><img border="0" src="E-Filing%20Management%20System%20Picture/Association.gif" width="491" height="74"></span></p>
<p align="center"><span lang="zh-cn">&nbsp;</span></p>

<form method="post" action="AssociationDeleteProcess.php">

<?php
	$connection = mysql_connect("localhost", "root", "")   
		or die("<font color='#FFFFFF'>Could not connect to MySQL </font>" .mysql_error());

	$selection = mysql_select_db("efiling")   
		or die("<font color='#FFFFFF'>Unable to select database.</font>" .mysql_error());
		
	$submit = $_POST["submit"];
	$PK = $_POST["PK"];
	
	if($submit=="Search")
	{
    		if(isset($_POST["PK"]))
    		{ 
    			$PK = $_POST["PK"];
	  		$sql = "SELECT * from association where PriKey ='$PK'";
	   		$result = mysql_query($sql) 
	  			or die("<font color='#FFFFFF'>SQL select statement failed</font>");
	  
	  		if($row=mysql_fetch_array($result))
       	    		{  
            			echo "<p align='center'><font size='5' face='Arial Rounded MT Bold'><font color='#FFFFFF'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Index &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  : &nbsp;&nbsp;$row[ID] </font></font></p>";
       	        		echo "<p align='center'><font size='5' face='Arial Rounded MT Bold'><font color='#FFFFFF'>Association Name &nbsp;&nbsp; : &nbsp;&nbsp;$row[AssociationName]</font></font></p><br>";
       	        		echo "<input type='hidden' name='PK' value='$row[PriKey]'>";
                		echo "<p align='center'><input type ='submit' name='submit' value='Delete'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";	
                		echo "<input type ='submit' name='submit' value='Back'></p>";	
            		}
            
	 		else 
	 		{ 
	 			echo "<font size='5' face='Arial Rounded MT Bold'><font color='#FFFFFF'><p align='center'>No record found</p></font></font><br><br>"; 
	 			echo "<p align='center'><input type ='submit' name='submit' value='Back'></p>";	
	 		}
     		}  
	}
	
	if($submit=="Delete")
	{	
		$PK = $_POST["PK"];
    		$sql= "DELETE FROM association WHERE PriKey = '$PK'";
    		$result = mysql_query($sql);
    		echo "<hr><h2><font color='#FFFFFF'><p align='center'>Record Deleted</p></hr></h2><br>";
    		echo "<p align='center'><input type ='submit' name='submit' value='Back'></p>";
 	}   
	
	if($submit=="Back")
	{	
		print "<script language ='javascript'>window.location.href='Association.php'</script>";
 	}
?>


<p align="center"></p>
<p align="center"></p>
<p align="center"></p>
<p align="center"></p>
<p align="center"></p>

</body>
</html>

This is the previous page "AssociationDelete.php" coding:

<html>
<head>
<title>Index</title>
</head>

<body background="E-Filing%20Management%20System%20Picture/Snow.gif">
<p align="center">
<img border="0" src="E-Filing%20Management%20System%20Picture/logo-RR-gif.gif" width="957" height="245"></p>
<p align="center"><span lang="zh-cn">&nbsp;</span></p>
<p align="center"><span lang="zh-cn"><img border="0" src="E-Filing%20Management%20System%20Picture/Association.gif" width="491" height="74"></span></p>
<p align="center"><span lang="zh-cn">&nbsp;</span></p>
<form method="POST" action="AssociationDeleteProcess.php"> 



<p align="center"><font size='3' face='Arial Rounded MT Bold'><font color='#FFFFFF'>Enter Primary Key to Delete :&nbsp;&nbsp;<input type="text" name="PK" size="6">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" name="submit" value="Search" > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="submit" value="Back" > </font></font></p>



</form> 
<p align="center"></p>
<p align="center"></p>
<p align="center"></p>
<p align="center"></p>
<p align="center"></p>

</body>
</html>

php

4 Contributors
5 Replies
100 Views
2 Days Discussion Span
Latest Post 14 Years Ago Latest Post by kira4

All 5 Replies

diafol

14 Years Ago

$submit = $_POST["submit"];
	$PK = $_POST["PK"];

If $_POST does not exist, you'll get an error. You've correctly used 'isset' elsewhere in your code, but not the first instance.

network18 15 Practically a Master Poster

14 Years Ago

one more thing, apart from above -
$PK = $_POST["PK"];
you doing this thing twice which is not needed actually, just delete the line24 and it should work.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster · Answer 1 · 2009-10-30T06:45:03+00:00

You may want to note that for assigning a possibly undefined variable or array index/key the following is the correct method.

$PK = (isset($_POST['PK']))?$_POST['PK']:'';

The above is what line 24 should be.

network18 15 Practically a Master Poster · Answer 2 · 2009-10-30T11:29:34+00:00

yes, that's always better, but here its not the case.
The guy is doing assigning that variable inside the if(isset($_POST["PK"]))
so actually no need to do isset() again when assigning the value to some other variable, it will be always set inside this loop.
From his code Lines28 -30 here -

if(isset($_POST["PK"]))
    		{ 
    			$PK = $_POST["PK"];

kira4 0 Light Poster · Answer 3 · 2009-10-30T17:45:25+00:00

yes, that's always better, but here its not the case.
The guy is doing assigning that variable inside the if(isset($_POST["PK"]))
so actually no need to do isset() again when assigning the value to some other variable, it will be always set inside this loop.
From his code Lines28 -30 here -
if(isset($_POST["PK"]))
    		{ 
    			$PK = $_POST["PK"];

Thanks...
I just notice that. :)

Delete Function Problem...

Recommended Answers Collapse Answers

All 5 Replies

Recommended Answers