<html>
<body>
<form action="insert.php" method="post">
<p>Name:
<input type="text" name="name" id="name" />
</p>
<p>Mark 1
<input type="text" name="mark1" id="mark1" />
</p>
<p>Mark 2
<input type="text" name="mark2" id="mark2" />
</p>
<p>
<input type="submit" />
</p>
</form>
</body>
</html><?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("yourDb_here", $con);
$sql="INSERT INTO marks (name, mark1, mark2)
VALUES
('$_POST[name]','$_POST[mark1]','$_POST[mark2]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?><?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("yourDB_here", $con);
$result = mysql_query("SELECT * FROM marks");
echo "<table border='1'>
<tr>
<th>Name</th>
<th>Mark1</th>
<th>Mark2</th>
<th>Average</th>
</tr>";
while($row = mysql_fetch_array($result))
{
$average = $row['mark1'] + $row['mark2'] / 100;
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['mark1'] . "</td>";
echo "<td>" . $row['mark2'] . "</td>";
echo "<td>" . $average . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>
