<?php
require 'db_connect.php';
?>
<?php
if(isset($_POST["fullname"]) && isset($_POST["regNo"]) && isset($_POST["comment"]))
{
$name = $_POST["fullname"];
$regNumber = $_POST["regNo"];
$comment = $_POST["comment"];
}
else
{
$error = "One or more fields are not filled";
echo $error;
}
if(isset($_POST["insert"]))
{
$insertString = "INSERT INTO ITA_Comments VALUES('$regNumber','$name','$comment')";
if(!mysql_query($insertString)) {
die('Error : '.mysql_error());
} else {
echo '<br/>';
echo '1 record added...';
}
}
else if (isset($_POST["update"]))
{
$updateString = "UPDATE ITA_Comments SET name='$name', comment='$comment' WHERE RegNo='$regNumber'";
if(!mysql_query($updateString)) {
die('Error : '.mysql_error());
} else {
echo '<br/>';
echo '1 record updated...';
}
}
else if (isset($_POST["delete"]))
{
$updateString = "DELETE FROM ITA_Comments WHERE RegNo='$regNumber'";
if(!mysql_query($updateString)) {
die('Error : '.mysql_error());
} else {
echo '<br/>';
echo '1 record deleted...';
}
}
$selectString = "SELECT * FROM ITA_Comments";
$comments = mysql_query($selectString);
while($row = mysql_fetch_array($comments)) { ?>
<tr>
<td> <?php echo $row['RegNo']; ?> </td>
<td> <?php echo $row['Name']; ?> </td>
<td> <?php echo $row['Comment']; ?> </td>
<?php
}
?>