Mr.Moghadam
سه شنبه 24 دی 1392, 14:28 عصر
این رو تست کنید :
<?php
if (isset($_GET['riazi'])) {
?>
<p></p>
<table border="0" style="border-collapse:collapse" cellpadding="10" width="300" >
<tr>
<td align="left" bgcolor="#6699FF" dir="rtl" style="border-left:2px solid #000; text-align:center; font-size:12px"
width="10px" colspan="3" height="30px">شماره </td>
<td bgcolor="#6699FF" dir="rtl" style="border-left:2px solid #000; font-size:12px""
width="20px" colspan="3" height="30px">کدملی </td>
<td align="left" bgcolor="#6699FF" dir="rtl" style="border-left:2px solid #000; font-size:12px""
width="40px" colspan="3" height="30px">نام </td>
<td align="left" bgcolor="#6699FF" dir="rtl" style="border-left:2px solid #000; font-size:12px""
width="30px" colspan="3" height="30px">نمره </td>
</tr>
<form action="" method="post" >
<?php
$result = doquery("SELECT user.lname , user.melicode FROM user
WHERE user.type='0' ");
if ($result->num_rows) {
$i = 0;
while ($row = mysqli_fetch_array($result)) {
?>
<tr>
<td align="left" bgcolor="#6699FF" dir="rtl" style="border-left:2px solid #000"
width="50px" colspan="3" height="30px">
<input type="text" size="20px" style="font-size:10px; text-align:center" name="st[<?php echo $i?>][idcourse]"
value="1">
</td>
<td align="left" bgcolor="#6699FF" dir="rtl" style="border-left:2px solid #000"
width="50px" colspan="3" height="30px">
<input type="text" style="font-size:10px; text-align:center" name="st[<?php echo $i?>][melicode]"
value="<?php echo $row['melicode']; ?>" > </td>
<td align="left" bgcolor="#6699FF" dir="rtl" style="border-left:2px solid #000"
width="50px" colspan="3" height="30px">
<input type="text" style="font-size:10px; text-align:center" name="st[<?php echo $i?>][lname]"
value="<?php echo $row['lname']; ?>" > </td>
<td align="left" bgcolor="#6699FF" dir="rtl" style="border-left:2px solid #000"
width="50px" colspan="3" height="30px">
<input type="text" style="font-size:10px; text-align:center" name="st[<?php echo $i?>][grade]" > </td>
</tr>
<?php
$i++;
}
} if (!empty($_POST) && isset($_POST["saveg"])) {
/*$melicode = $_POST['melicode'];
$idcourse = $_POST['idcourse'];
$grade = $_POST['grade'];
if (doquery("INSERT INTO `result` SET `melicode`= '" . $melicode . "',
`idcourse`='" . $idcourse . "',`grade`='" . $grade . "' "))
; {
echo "اطلاعات مورد نظر با موفقیت ثبت شد ";
}*/
$sql = "INSERT INTO `result` (`melicode` , idcourse , grade ) VALUES ";
$v = array();
foreach($_POST['st'] as $s){
$v[] = "( '{$s['`melicode`']}' ,'{$s['idcourse']}' , '{$s['grade']}' )";
}
$values = implode(',' , $v);
if (doquery($sql . $values))
{
echo "اطلاعات مورد نظر با موفقیت ثبت شد ";
}
}
?>
<tr>
<td align="left" dir="rtl" width="20px">
<input class="button" onClick="document.getElementById('form1').submit() "
type="submit"name="saveg" value="ثبت"/></td>
<td align="right" dir="rtl" width="20px">
<input class="button" margin-top:335px
onClick="document.getElementById('form1').reset()"
type="submit"name="clear" value="پاک کردن"/></td></tr>
</form></table>
<?php } ?>