[phplearner]

i wan to display rows from my table with an additional column call edit. users will be able to edit the reports that they reported. for each row that is displayed, a radio button is displayed with the value of the reportid. i linked this page to another page where by i need to get the reportid of the radio button selected on the previous page.

<?
$query = "SELECT ReportID, AircraftType, AircraftTailNo, AirFrameHours, ServicingType, DefectInfo FROM Report WHERE UserID='$UserID'";
$result = mysql_query($query)
or die ("couldn't execute query.");

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>
<td>$row[ReportID]</td>
<td>$row[AircraftType]</td>
<td>$row[AircraftTailNo]</td>
<td>$row[AirFrameHours]</td>
<td>$row[ServicingType]</td>
<td>$row[DefectInfo]</td>
<td><input type=\"radio\" name=\"Edit\" value=\"'$row[ReportID]'\"></td>
</tr>";
}
?>

i know its something to do with $_GET, but i m not really sure about it. mind giving a few pointers or give a a really brief sample code.

[End User]

Originally Posted by phplearner

i wan to display rows from my table with an additional column call edit. users will be able to edit the reports that they reported. for each row that is displayed, a radio button is displayed with the value of the reportid. i linked this page to another page where by i need to get the reportid of the radio button selected on the previous page.

<?
$query = "SELECT ReportID, AircraftType, AircraftTailNo, AirFrameHours, ServicingType, DefectInfo FROM Report WHERE UserID='$UserID'";
$result = mysql_query($query)
or die ("couldn't execute query.");

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>
<td>$row[ReportID]</td>
<td>$row[AircraftType]</td>
<td>$row[AircraftTailNo]</td>
<td>$row[AirFrameHours]</td>
<td>$row[ServicingType]</td>
<td>$row[DefectInfo]</td>
<td><input type=\"radio\" name=\"Edit\" value=\"'$row[ReportID]'\"></td>
</tr>";
}
?>

i know its something to do with $_GET, but i m not really sure about it. mind giving a few pointers or give a a really brief sample code.

Just grab the vars from the $_REQUEST superglobal:

$ReportID = $_REQUEST['Edit'];

$ReportID will hold the value of whichever radio button was checked.

[phplearner]

thx alot! i will try it out right away.

[phplearner]

erm.. i linked the form to another page to test whether the value of the selected radio button is stored or not. i juz did a simple echo out but there is an error.

Notice: Undefined variable: ReportID in c:\inetpub\wwwroot\SIP\first\asd.php on line 3
= Edit

<?php

echo "$ReportID = $_REQUEST[Edit]";


?>

does that mean i cant get the value?

[perleo]

why are you using extract() in your first code? extract makes variables the same name as the column name and then you echo $row['column']; ??

you cant echo a variable = value string, either do

PHP Code:

 echo $ReportID = $_REQUEST['Edit']; 

or

PHP Code:

 echo $_REQUEST['Edit']; 

You cant name a key like you have in REQUEST, it has to be in quotes

I would suggest you start here:
http://ie2.php.net/manual/en/tutorial.php

The PHP Manual is very good..

The purpose of GET or POST or REQUEST are listed under the variables (predefined I think) in the manual

[rrwh]

The thing you are missing is that you probably need a form so you can pass the value to your new page


You may want to wrap the whole table up in a form so you can post the value to the next page.

<form action=\"newpage.php\" method=\"post\">
<table>

//insert your original code here

extract($row);
echo "<tr>
<td>$row[ReportID]</td>
<td>$row[AircraftType]</td>
<td>$row[AircraftTailNo]</td>
<td>$row[AirFrameHours]</td>
<td>$row[ServicingType]</td>
<td>$row[DefectInfo]</td>
<td>Edit this record <input type=\"radio\" name=\"Edit\" value=\"'$row[ReportID]'\"></td>
</tr>";

</table>
<input type=\"radio\" name=\"Edit\" value=\"'$row[ReportID]'\">
</form>

[phplearner]

thx for the replies guys... sorry my codes are taken from some php beginner book. i juz started so pls bear with mi =)

[phplearner]

i did the way u guys suggested but when i echo out the radio button value, it shows Edit instead of the report id value like 1 , 2 etc..

[FiRe]

PHP Code:

$ReportID = $_REQUEST['Edit']; 

echo $ReportID;