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 |
Update script no extracting values April 23, 2013 02:33PM |
Registered: 11 years ago Posts: 7 Rating: 0 |
Language: PHP//get value of id $player_id = $_GET[';player_id';]; //update data in database $query = "UPDATE playerinfo SET name = ';$name';, surname = ';$surname';, contactnumber = ';$contactnumber';, email = ';$email';, position = ';$position';, username = ';$username';, password = ';$password'; WHERE player_id = ';$player_id';"; //retrieve data from database $query = "SELECT * FROM playerinfo WHERE player_id = ';$player_id';"; $result = mysql_query($query) or die("Query failed: ".mysql_error());
Re: Update script no extracting values April 23, 2013 03:11PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Re: Update script no extracting values April 25, 2013 01:11PM |
Registered: 11 years ago Posts: 7 Rating: 0 |
Language: PHP$query = "SELECT * FROM playerinfo"; $result = mysql_query($query) or die("Query failed: ".mysql_error()); echo"<table border=';1';><tr bground=';#CCCCCC';><td>Name</td><td>Surname</td><td>Contact number</td><td>Email</td><td>Position</td><td>Username</td><td>Password</td><td colspan=';2';>Action</td></tr>"; while($row = mysql_fetch_array($result)) { $phone_id=$row[';player_id';]; echo"<tr><td>"; echo $row[';name';]; echo"</td><td>"; echo $row[';surname';]; echo"</td><td>"; echo $row[';contact number';]; echo"</td><td>"; echo $row[';email';]; echo"</td><td>"; echo $row[';position';]; echo"</td><td>"; echo $row[';username';]; echo"</td><td>"; echo $row[';password';]; echo"</td><td>"; echo"<a href=edit.php?player_id=$player_id&update=yes>Edit</a>"; echo"</td><td>"; echo"<a href=delete.php?player_id=$player_id&delete=yes>Delete</a>"; echo"</tr>"; } echo"</table>";
Re: Update script no extracting values April 25, 2013 01:17PM |
Registered: 11 years ago Posts: 54 Rating: -1 |
Language: PHP$query = "UPDATE playerinfo SET name = ';$name';, surname = ';$surname';, contactnumber = ';$contactnumber';, etc...';";
Language: PHP$query = "SELECT * FROM playerinfo WHERE player_id = ';$player_id';";
Re: Update script no extracting values April 25, 2013 02:15PM |
Admin Registered: 18 years ago Posts: 10,001 Rating: 353 |
Language: PHP//use this to see if there are rows with data given your query $num_rows = mysql_num_rows($result); echo "Number of rows: $num_rows";
Re: Update script no extracting values April 29, 2013 02:08PM |
Registered: 11 years ago Posts: 7 Rating: 0 |
Language: PHP//get value of id $player_id = $_GET[';player_id';]; //update data in database $query = "UPDATE playerinfo SET name = ';$name';, surname = ';$surname';, contactnumber = ';$contactnumber';, email = ';$email';, position = ';$position';, username = ';$username';, password = ';$password'; WHERE player_id = ';$player_id';"; //retrieve data from database $query = "SELECT * FROM playerinfo WHERE player_id = ';$player_id';"; $result = mysql_query($query) or die("Query failed: ".mysql_error()); $num = mysql_numrows($result); echo "Number of rows: $num"; $i = 0; while($i < $num){ $name = mysql_result($result,$i,"name"); $surname = mysql_result($result,$i,"surname"); $$contactnumber = mysql_result($result,$i,"contactnumber"); $email = mysql_result($result,$i,"email"); $position = mysql_result($result,$i,"position"); $username = mysql_result($result,$i,"username"); $password = mysql_result($result,$i,"password"); $i++;