Jump to content

Deleting Individual records.


Xtremer360

Recommended Posts

Okay with my following code when a user clicks delete on a record in the html table I want it to delete that record and that's it instead of having it go to showname.php?action=edit&id='.$row['id'].' So how do I go about accomplishing that.

 

<html>
<head>
<title>Show Name Script</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

<?php

/* showname.php */
/* This form after submission takes the results of the form and inserts the values into the database as a new show name is created. */

require ('database.php');

//This code runs if the form has been submitted
if (isset($_POST['submit']))
    {
      // checks if the show name is in use
      if (!get_magic_quotes_gpc())
      {
         $_POST['showname'] = addslashes($_POST['showname']);
      }
      $showname = $_POST['showname'];
      $check = mysql_query("SELECT showname FROM shownames WHERE showname = '$showname'")   or die(mysql_error());
      $check2 = mysql_num_rows($check);
    
      //if the name exists it gives an error
      if ($check2 != 0)
      {
         die('Sorry, the show name '.$_POST['showname'].' is already in use.');
      }
    
      // now we insert it into the database
      $insert = "INSERT INTO shownames (type, showname) VALUES ('".$_POST['type']."','".$_POST['showname']."')";
      
      $add_show = mysql_query($insert) or die(mysql_error());
    }

print '<center><caption><strong>Add A Show</strong></caption></center>';
print '<table border="1" style="margin: auto; width: 60%;">';
print '<form name="showname" method="post">';
print '<tr><td>Show Type:</td> ';
print '<td><select name="type"><option value="">Select a Show Type</option><option value="Weekly Show">Weekly Show</option><option value="Pay Per View">Pay Per View</option></select></td>';
print '<tr><td>Show Name:</td> ';
print '<td><input name="showname" type="text"></td></tr>';
print '<tr><th colspan=2><input type="submit" name="submit" value="Add Show Name" /><input name="sumbitted" type="hidden" value="TRUE"></th></tr></table></form><br><br><br>';

print '<center><caption><strong>List of Shows</strong></caption></center>';
print '<table width="60%" border="1" align="center">';
print '<tr><th align="center">Type</th><th align="center">Show Name</th><th align="center">Edit</th><th align="center">Delete</th></tr>';

if(!isset($_GET['action']) && !isset($_POST['name']))
{
   //Define the query
   $query = "SELECT * FROM shownames";
   if ($r = mysql_query ($query)) // Run the query.
   {
       if (mysql_num_rows($r) > 0)
       {
           // Retrieve and print every record
           while ($row = mysql_fetch_array ($r))
           {
              print '<tr><td align="center">'.$row['type'].'</td><td align="center">'.$row['showname'].'</td><td align="center"><a href="showname.php?action=edit&id='.$row['id'].'"><center>Edit</center></a></td><td align="center"><a href="showname.php?action=delete&id='.$row['id'].'">Delete</a></td></tr>';
           }
        }else{
           print "<center>No Shows</center>\n";
        }
   }else{
      die ('<p>Could not retrieve the data because <b>' . mysql_error() . '</b>. The query was '."$query.".'</p>');
   } //End of query IF
   print '</table>';
   
}
?>

</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/129652-deleting-individual-records/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.