Announcements | Last Post | |
---|---|---|
SoC Curricula | 09/30/2017 01:08PM | |
Demarcation or scoping of examinations and assessment | 02/13/2017 07:59AM | |
School of Computing Short Learning Programmes | 11/24/2014 08:37AM | |
Unisa contact information | 07/28/2011 01:28PM |
Edit and Delete links in table October 04, 2013 08:21PM |
Registered: 10 years ago Posts: 23 Rating: 0 |
Re: Edit and Delete links in table October 10, 2013 08:43AM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Edit and Delete links in table October 10, 2013 09:31AM |
Registered: 10 years ago Posts: 16 Rating: 0 |
Re: Edit and Delete links in table October 10, 2013 09:44AM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Edit and Delete links in table October 10, 2013 01:50PM |
Registered: 10 years ago Posts: 15 Rating: 0 |
Re: Edit and Delete links in table October 10, 2013 01:59PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Edit and Delete links in table October 10, 2013 02:22PM |
Registered: 10 years ago Posts: 15 Rating: 0 |
Language: PHP//Get the Player Id $Player_ID =$_GET[';Player_ID';]; if(isset($_POST[';submit';])) { // assign variables $Name = $_POST[';Name';]; $Surname = $_POST[';Surname';]; //etc
Language: PHP$query1 = "UPDATE player_reg SET Surname = ';$Surname';, Name = ';$Name';, Contact_Number=';$Contact_Number';, Email = ';$Email';, Position =';$Position';, Username = ';$Username';, Password = ';$Password'; WHERE Player_ID = ';$Player_ID';"; $result = mysql_query($query1) or die ("Query Failed: " . mysql_error()); if(query1) {
Language: PHP<form action ="list_players.php" method ="POST" align = "center"> <input type = "hidden" name = "Player_ID" value = "<?php echo $row[';Player_ID';]; ?>"/> </br> Name: <input type ="text" name ="Name" value ="<?php echo $row[';Name';]; ?>"/><br/> Surname : <input type ="text" name ="Surname" value ="<?php echo $row[';Surname';]; ?>"/><br/> // and so on <input type ="submit" name ="submit" value ="Submit"/> </form>
Re: Edit and Delete links in table October 10, 2013 02:46PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Language: PHP$Player_ID = $_POST[';Player_ID';];
Re: Edit and Delete links in table October 10, 2013 02:57PM |
Registered: 10 years ago Posts: 15 Rating: 0 |
Re: Edit and Delete links in table October 10, 2013 03:03PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Language: PHPif(query1) // query1 does not exist in any event, the variable name is $query1 {
Language: PHPif ($result) // leave a space between the if and the (. {
Re: Edit and Delete links in table October 10, 2013 03:16PM |
Registered: 10 years ago Posts: 15 Rating: 0 |
Re: Edit and Delete links in table October 10, 2013 03:20PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Edit and Delete links in table October 10, 2013 03:26PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Edit and Delete links in table October 10, 2013 03:27PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Edit and Delete links in table October 10, 2013 03:44PM |
Registered: 10 years ago Posts: 15 Rating: 0 |
Re: Edit and Delete links in table October 10, 2013 04:36PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Re: Edit and Delete links in table October 13, 2013 06:51PM |
Registered: 10 years ago Posts: 16 Rating: 0 |
Language: PHPecho "Please update " . $fname . " " . $sname . ';\';s'; . '; '; . "information"; //Inform the user to edit the data in the form if needed if (isset($_POST[';Submit';])) //check if submit button was clicked { $player_id = $_GET[';player_id';]; //Update the table $query = "UPDATE playerregistration SET player_name = ';$fname';, player_surname = ';$sname';, player_contact_num = ';$cnumber';, player_email = ';$email';, player_position = ';$pos';, player_username = ';$uname';, player_password = ';$pword'; WHERE player_id = ';$player_id';"; $result = mysql_query($query); if ($result) { echo "Player';s information updated successfully"; //Was the data updated? } else { echo "Failed to update player';s information."; } mysql_close($connection);
Language: PHPif (player_id==$player_id&action==yes) // Check if yes was chosen to definetely delete { $query = "DELETE * FROM playerregistration WHERE player_id = ';$player_id';"; //use player_id to retrieve the player';s information $result = mysql_query($query); $result = mysql_query($query) or die("Query failed: " . mysql_error()); if ($result) { echo "Player deleted successfully."; } else { echo "Failed to delete a player <br>"; } mysql_close($connection); }
Language: PHP//Option[yes or no] to make sure that the user really wants to delete the player echo "Are you sure you want to delete $fname $sname?  <a href=delete.php?player_id=$player_id&action=yes>Yes |</a> <a href=list_players.php>No</a>";
Re: Edit and Delete links in table October 13, 2013 06:53PM |
Registered: 10 years ago Posts: 16 Rating: 0 |
Re: Edit and Delete links in table October 13, 2013 07:19PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Language: PHPif (player_id==$player_id&action==yes) // Check if yes was chosen to definitely delete
Language: PHPif (isset($_GET[';player_id';])) { $player_id = $_GET[';player_id';]; $action = $_GET[';action';]; // You don';t actually need this.
Re: Edit and Delete links in table October 13, 2013 07:42PM |
Admin Registered: 11 years ago Posts: 6,606 Rating: 396 |
Language: PHPecho "Please update " . $fname . " " . $sname . ';\';s'; . '; '; . "information"; //Inform the user to edit the data in the form if needed if (isset($_POST[';Submit';])) //check if submit button was clicked { $player_id = $_GET[';player_id';]; //Update the table
Language: PHP{ $player_id = $_POST[';Player_ID';];
Quote
When do i really have to check when the SUBMIT button was clicked.