- Messages
- 1
- Reaction score
- 0
- Points
- 16
pano ko po ba ma sto-store ang value nang mga radio button ko sa database gamit ang for each ?
hindi na poh talaga makaya nang utak ko
inikot-ikot ko na codes koh
--------------------------------------------------------------------------------------------------------------------------------------------
<?php
$query="SELECT * FROM questionnaire";
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{
$question_id=$row['id'];
?>
<tr>
<form method="post">
<td><?php echo $row['question']?></td>
<?php
$radio="SELECT * FROM evaluation_value"; // nag set poh ako ng value sa tig iisang radio button
$radioresult=mysql_query($radio) or die (mysql_error);
while($row=mysql_fetch_array($radioresult))
{
echo "<td><input type='radio' name='rate[]' value='".$row['rate_value']."'required></td>";
}
?>
</form>
<?php
}
?>
</tr>
</table>
<input type="submit" name="submit" value="Submit"> //submit button ko poh
<?php
if(isset($_POST['submit']))
{
$teach="SELECT subject_teacher,subject FROM schedule WHERE id='$id'";
$teachresult=mysql_query($teach);
while($rows=mysql_fetch_array($teachresult))
{
$teacher=$rows['subject_teacher'];
$code=$rows['subject'];
}
//--------------------- etoh na po yong foreach ko sa radio button --------------------------------//
$value=$_POST['rate'];
foreach($value as $check)
{
$studRecord = "INSERT INTO result (value,subject_teacher,subject,question_id) VALUES ('$check','$teacher','$code','$question_id')";
$studResult = mysql_query($studRecord) or die (mysql_error);
}
}
?>
--------------------------------------------------------------------------------------------------------------------------------------------------
Pagpasinsyahan nyo na po talaga codes ko hindi po ako ganun ka hasa
salamat poh
hindi na poh talaga makaya nang utak ko
inikot-ikot ko na codes koh
--------------------------------------------------------------------------------------------------------------------------------------------
<?php
$query="SELECT * FROM questionnaire";
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{
$question_id=$row['id'];
?>
<tr>
<form method="post">
<td><?php echo $row['question']?></td>
<?php
$radio="SELECT * FROM evaluation_value"; // nag set poh ako ng value sa tig iisang radio button
$radioresult=mysql_query($radio) or die (mysql_error);
while($row=mysql_fetch_array($radioresult))
{
echo "<td><input type='radio' name='rate[]' value='".$row['rate_value']."'required></td>";
}
?>
</form>
<?php
}
?>
</tr>
</table>
<input type="submit" name="submit" value="Submit"> //submit button ko poh
<?php
if(isset($_POST['submit']))
{
$teach="SELECT subject_teacher,subject FROM schedule WHERE id='$id'";
$teachresult=mysql_query($teach);
while($rows=mysql_fetch_array($teachresult))
{
$teacher=$rows['subject_teacher'];
$code=$rows['subject'];
}
//--------------------- etoh na po yong foreach ko sa radio button --------------------------------//
$value=$_POST['rate'];
foreach($value as $check)
{
$studRecord = "INSERT INTO result (value,subject_teacher,subject,question_id) VALUES ('$check','$teacher','$code','$question_id')";
$studResult = mysql_query($studRecord) or die (mysql_error);
}
}
?>
--------------------------------------------------------------------------------------------------------------------------------------------------
Pagpasinsyahan nyo na po talaga codes ko hindi po ako ganun ka hasa
salamat poh