Hi All
I am busy with the edit page for the assignment and have run into an issue. The issue being that I cannot get the UPDATE query to function.
What I have tried.
1.I get the Player Id from the list_players page.
2.I use the select query to pull the information for the specific rows information using the player id.
3. This populates the fields in the form and will allow me to change the information in the txt box.
4. I use the server request method to make sure the update query only actions once I post from the form.
5.I get this error once I post execute --> Notice: Undefined index: player_id in C:\Program Files (x86)\EasyPHP-5.3.3\www\edit.php on line 6, Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Thanks All. Will appreciate any help to sort this out.
Regards,
Language: PHP
<?php
//Get the Player Id that is in the URL
$player_id=$_GET[';player_id';];
//DB Query using the player ID
$query = "SELECT * FROM registration WHERE player_id=$player_id";
$result = mysql_query($query)
or die ("Query Failed: " . mysql_error());
$row = mysql_fetch_array($result);
// get data from db
$name = $row[';name';];
$surname = $row[';surname';];
$contact_number = $row[';contact_number';];
$email = $row[';email';];
$position = $row[';position';];
$username = $row[';username';];
$password = $row[';password';];
//Will action if the Request method is post, so only once you update information
if ($_SERVER[';REQUEST_METHOD';] === ';POST';)
{
//Get the Player Id that is in the URL
//$player_id=$_GET[';player_id';];
$query = "UPDATE registration 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($query)
or die ("Query Failed: " . mysql_error());
$row = mysql_fetch_array($result);
echo "Successfully Updated :" .$player_id;
}
?>
Language: HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>
Edit Players
</title>
</head>
<center>
<div style="position:absolute;top:0px;left:30%;right:30%"><a href="insert.php">Insert a Player</div>
<div style="position:absolute;top:0px;left:15%;right:15%"><a href="edit.php">Edit a players Information</div>
</center>
<body>
<form action="edit.php" method="post">
Player ID: <?php echo $player_id; ?> </br>
First Name: <input type="text" name="name" value="<?php echo $name; ?>"/><br/>
Surname : <input type="text" name="surname" value="<?php echo $surname; ?>"/><br/>
Contact Number : <input type="text" name="contact_number" value="<?php echo $contact_number; ?>"/><br/>
Email : <input type="text" name="email" value="<?php echo $email; ?>"/><br/>
Position : <input type="text" name="position" value="<?php echo $position; ?>"/><br/>
User Name : <input type="text" name="username" value="<?php echo $username; ?>"/><br/>
Password : <input type="text" name="password" value="<?php echo $password; ?>"/><br/>
<input type="submit" name="submit" value="Submit">
</body>
</html>
