[COLOR=#FCE94F][/color]<?php
session_start();
if (isset($_SESSION['playNo']))
{
$playerNo = $_SESSION['playNo'];
unset($_SESSION['playNo']);
}else{
$playerNo = ($_GET['playerId']);
echo "PlayerId = " . $playerNo. "\n";
}
$query = "SELECT PlayerNo, FirstName, Surname, PreferredName, Dob, Street,
TownSuburb, State, Postcode, Handicap, StateRep, Status FROM Player WHERE PlayerNo = ". $playerNo ;
$mysqli = mysqli_connect("localhost", "User", "password", "2015GolfChamps");
if (mysqli_connect_errno($mysqli)) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$res = mysqli_query($mysqli, $query);
$row = mysqli_fetch_assoc($res);
$street = $row['Street'];
$name = $row['Surname'];
echo "Street = " . $street. "\n";
?>
<html>
<head><title>Person Record</title></head>
<h2><center>Player Details</center></h2>
<br /><br /><br /><br />
<body>
<form action="addPlayer.php" method="POST">
<center><table vertical-align: top>
<tr><td><input type="hidden" name="playerNo" value=<?php echo $row['PlayerNo'] ?> ></td></tr>
<tr><td>Surname:</td><td><input type="text" name="surname" value=<?php echo $name ?> ></td></tr>
<tr><td>First Name:</td><td><input type="text" name="firstName" value=<?php echo $row['FirstName'] ?> ></td></tr>
<tr><td>Preferred Name:</td><td><input type="text" name="preferredName" value=<?php echo $row['PreferredName'] ?> ></td></tr>
<tr><td>Date of Birth:</td><td><input type="text" name="preferredName" value=<?php echo $row['Dob'] ?> ></td></tr>
<tr><td>Address - Street:</td><td><input type="text" name="street" maxlength="40" value=<? echo $street ?> ></td></tr>
<tr><td>Town/Suburb:</td><td><input type="text" name="suburb" value=<?php echo $row['TownSuburb'] ?> ></td></tr>
<tr><td>State:</td><td><input type="text" name="state" value=<?php echo $row['State'] ?> ></td></tr>
<tr><td>Postcode:</td><td><input type="text" name="postcode" value=<?php echo $row['Postcode'] ?> ></td></tr>
<tr><td>Handicap:</td><td><input type="text" name="handicap" value=<?php echo $row['Handicap'] ?> ></td></tr>
<tr><td>State playing for:</td><td><input type="text" name="stateRep" value=<?php echo $row['StateRep'] ?> ></td></tr>
<tr><td>Status:</td><td><input type="text" name="status" value=<?php echo $row['Status'] ?> ></td></tr>
<tr><td> </td></tr>
<tr><td> </td></tr>
</table></center>
<center><input type="submit" value="Update record"/></center>
</form>
<center><a href="index.html">Cancel</a></center>
</body>
</html>