1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 9:25 pm Apr 28, 2026

Forum Moderators: coopster

Message Too Old, No Replies

Delete Function Problem.

         

kira4

4:50 pm on Oct 28, 2009 (gmt 0)

10+ Year Member



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>

TheMadScientist

1:50 am on Oct 29, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



I think it's usually when the POST value is not set... check first, or suppress / turn off the error_reporting:

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

OR

error_reporting(0);

StoutFiles

1:56 am on Oct 29, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I think the bigger problem is lack of CSS.

TheMadScientist

2:00 am on Oct 29, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



How can CSS possibly effect PHP? The page might not look right without CSS, but it should not have anything to do with PHP parsing.

I'm fairly certain the Notice is from what I stated previously...
[google.com...]

kira4

11:45 am on Oct 30, 2009 (gmt 0)

10+ Year Member



Thanks! The problem was solved. :)
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

  1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 9:25 pm Apr 28, 2026