Ad:

PHP Discussion Thread
Unsolved
Views: 1187

May 7th, 2009

Deleting Entry From MySQL Table

Expand Post »

Hey all this is a pretty simple question, basically I connect to a mysql database, and iterate a list of names like this:

PHP Syntax (Toggle Plain Text)
$result = mysql_query("SELECT * FROM Students");
 
echo "<table border=\"1\">";
 
while($row = mysql_fetch_array($result))
  {
  print "
    <tr>
         <td>
  " 
  . $row['Student'] .
  "
        </td>
        <td>
  <form name=\"FRMdelete" . $row['Student'] . "\" action=\"deletestudent.php\" method=\"POST\" style=\"margin-bottom:0;\">
  <input name=\"delete\" type=\"submit\" id=\"" . $row['Student'] . "\" value=\"Delete\" OnClick=\"return confirm('Are you sure you want to Delete "  . $row['Student'] . "?')\">
  </form>
         </td>
     </tr>
  ";
  }
echo"</table>";
mysql_close($con);
$result = mysql_query("SELECT * FROM Students");

echo "<table border=\"1\">";

while($row = mysql_fetch_array($result))
  {
  print "
    <tr>
         <td>
  " 
  . $row['Student'] .
  "
        </td>
        <td>
  <form name=\"FRMdelete" . $row['Student'] . "\" action=\"deletestudent.php\" method=\"POST\" style=\"margin-bottom:0;\">
  <input name=\"delete\" type=\"submit\" id=\"" . $row['Student'] . "\" value=\"Delete\" OnClick=\"return confirm('Are you sure you want to Delete "  . $row['Student'] . "?')\">
  </form>
         </td>
     </tr>
  ";
  }
echo"</table>";
mysql_close($con);

Then I using POST, I pass the name of the student from the ID of the input to deletestudent.php, which looks like this:

PHP Syntax (Toggle Plain Text)
<?php
$studentremoved = $_POST['delete'];
$sql = "DELETE FROM Students WHERE Student='" . $studentremoved . "'";
$con = mysql_connect("localhost","root","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_query($sql);
mysql_close($con);
header("Location: ".$_SERVER['HTTP_REFERER']);  
?>
<?php
$studentremoved = $_POST['delete'];
$sql = "DELETE FROM Students WHERE Student='" . $studentremoved . "'";
$con = mysql_connect("localhost","root","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_query($sql);
mysql_close($con);
header("Location: ".$_SERVER['HTTP_REFERER']);  
?>

For some reason the scripts execute without throwing and errors to my debugger, but it doesn't delete the record =/

What am I missing, I know its probably obvious. Sorry for the sloppy code, I am a beginner =/

Similar Threads

Getting users added to MySQL table. Please Help! in PHP

onethirtyone

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2009

Permalink

May 7th, 2009

Re: Deleting Entry From MySQL Table

Your form should look like this:

html Syntax (Toggle Plain Text)
<form ...>
  <input type="hidden" name="student" value="$row['student']" />
  <input type="submit" name="delete" value="Delete" />
</form>
<form ...>
  <input type="hidden" name="student" value="$row['student']" />
  <input type="submit" name="delete" value="Delete" />
</form>

Then you can get which student to delete on deletestudent.php via $_POST['student']. (you can use isset($_POST['delete']) to see if they clicked "Delete" but $_POST['delete'] will hold the value "Delete").

The id attribute in html is used for javascript or CSS to select that particular element.

Last edited by humbug; May 7th, 2009 at 4:05 am. Reason: premature post :P

humbug

Reputation Points: 20

Solved Threads: 13

Junior Poster in Training

Offline

93 posts
since Oct 2005

Permalink

May 8th, 2009

Re: Deleting Entry From MySQL Table

Something simple but have you given your database user permissions to delete?

Im also an old newbie and still trying to get my head round it all. lol

justted

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

140 posts
since Dec 2007

Permalink

May 9th, 2009

Re: Deleting Entry From MySQL Table

Might also be a good idea to do

php Syntax (Toggle Plain Text)
if (!mysql_query($sql)){
  die (mysql_error());
}
if (!mysql_query($sql)){
  die (mysql_error());
}

humbug

Reputation Points: 20

Solved Threads: 13

Junior Poster in Training

Offline

93 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Combine Two RSS Feeds to Appear as One in PHP

Next Thread in PHP Forum Timeline: variable in URL called from database

DaniWeb Message

Cancel Changes

User Name
Password