I am a student doing a mini project Using PHP. In my administrator page I have a bug. i.e, First it Prompts for.
-->Hall ticket No
-->Semester of the particular student.
Whenever admin enters these details and clicks firstsubmit button, it display the marks of particular student in textboxes.
If the marks are not available it displays empty text boxes, those allows the admin to insert the marks for that particular student.
After entering marks whenever he clicks second submit button, the marks have to be inserted in the database table.
NOTE: Marks and second submit buttons appear only when admin clicks first submit button by enetring Hallticketno and semester.
Bug is when I fill the text boxes with subjectwise marks and click second submit button it is inserting '0's for all the subjects in the table Instead of entered marks in the textboxes.
And here is my code:
<html>
<body bgcolor="#abcdfg">
<center><h2>WELCOME TO ADMINISTRATOR</H2>
<form name="admin" action="admin1.php" method="POST">
Hall Ticket No.:
<input type="text" name="rno" value=""/>
<br>
<br>
Enter The Semister:
<input type="text" name="sem" value=""/>
<br>
<br>
<input type="submit" name="submit1" value="Load the marks">
</form>
=$_POST[=$_POST[= mysql_connect(= mysql_select_db(='SELECT *
FROM `2-1`
WHERE id='=mysql_query($sql);
==0)
';
$empty='SELECT subname
FROM `2-1subjects`';
$eresult=mysql_query($empty);
if(!$eresult)
{
die('invalid Query:'.mysql_error());
}
Print "<table border=0 cellpadding=10>";
//Print "<th>SUBJECT CODE</th>";
Print "<th>SUBJECT NAME</th>";
Print "<th>MARKS</th>";
while($cow = mysql_fetch_array($eresult))
{
Print "<tr>";
//Print "<td>".$row['subcode'] . "</td> ";
print "<td>".$cow['subname'] . "</td> ";
//Print "<td>".$row['marks'] . "</td> ";
?>
<form method="POST">
<td> <input type="text" name="mark" style="text-align:center" value=""/></td>
</form>
";
}
Print "</table>";
?>
<input type="submit" name="submit2" value="Insert Marks"/>
='SELECT subcode
FROM `2-1subjects`'=mysql_query($insq);
=mysql_fetch_array($insre))
=$_POST[='INSERT into `2-1`(id,subcode,marks)
VALUES('=mysql_query($inser);
';
$query='SELECT subname,marks
FROM `2-1subjects`
JOIN `2-1`
ON `2-1subjects`.subcode=`2-1`.subcode
WHERE id='."'".$id."'";
$sql=mysql_query($query);
if(!$sql)
{
die('invalid Query:'.mysql_error());
}
Print "<table border=0 cellpadding=10>";
//Print "<th>SUBJECT CODE</th>";
Print "<th>SUBJECT NAME</th>";
Print "<th>MARKS</th>";
while($row = mysql_fetch_array($sql))
{
Print "<tr>";
//Print "<td>".$row['subcode'] . "</td> ";
print "<td>".$row['subname'] . "</td> ";
//Print "<td>".$row['marks'] . "</td> ";
?>
<td> <input type="text" style="text-align:center" value="<?php echo $row['marks'] ?>" /></td>
";
}
Print "</table>";
print '<input type="submit" name="submit" value="Update Marks"/>';
}
and the values are being inserted in reverse order into the table that means bottom to top rather than that of which I entered at the time of inserting in textboxes. please correct my code.
Thanks in advance.
Submit an article or tip