Xtremer360 Posted October 22, 2008 Share Posted October 22, 2008 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.