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> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.