I can't seem to figure out how to delete a record with my code. I've tried pretty much everything I could. I'm new to php.... btw
Here is my code....'
<?php
$student_name = $_SESSION['student_name'];
$student_id = $_SESSION['student_id'];
$query = "SELECT * FROM grades WHERE student_id = :student_id ";
$statement = $db->prepare($query);
$statement->bindValue (':student_id', $student_id);
$statement->execute();
$grades = $statement->fetchAll();
$statement->closeCursor();
echo "<h1>Show Grades for $student_name </h1>";
?>
<div id="content">
<!-- display a table of products -->
<table>
<tr>
<th>Grade Type</th>
<th>Grade Name</th>
<th>Grade Points</th>
<th>Remove</th>
</tr>
<?php foreach ($grades as $grade) : ?>
<tr>
<td><?php echo $grade['grade_type']; ?></td>
<td><?php echo $grade['grade_name']; ?></td>
<td><?php echo $grade['grade_points']; ?></td>
<td><form action="delete_grade.php" method="post">
<input type="submit" name="remove" value="Delete" />
</form></td>
</tr>
<?php endforeach; ?>
</table>
</div>
</div>
<div id="footer">
</div>
<form name="grades" method="post" action="grades.php">
<p>Grade Type<SELECT NAME="grade_type">
<OPTION VALUE="Mid-Term">Mid-Term
<OPTION VALUE="Final">Final
<OPTION VALUE="Lab">Lab
</SELECT>
<br>
Grade Name:<input type="text" name="grade_name" value=""><br />
Grade Points:<input type="text" name="grade_point" value="">
<input type="submit" name="add_grade" value="Add Grade">
</form>
</table>
</body>
</html>
And here is the delete page... not sure if this page is needed...
<html>
<form method="post" action="grades.php">
<?php
$dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266')
or die(mysql_error());
//delete users
echo '<b>Delete or Update User</b>.<br />';
if (isset($_POST['remove']))
{
foreach($_POST['delete'] as $delete_id)
{
$query = "DELETE FROM grades WHERE grade_id = $delete_id";
mysqli_query($dbc, $query) or die ('can\'t delete user');
}
echo 'user has been deleted.<br />';
}
//display users info with checkbox to delete
$query = "select*from se266";
$result = mysql_query($dsn, $query);
while($row = mysql_fetch_array($result))
{
echo '<input type="checkbox" value="' .$row['grade_id'] . '"name="delete[]" />';
echo ' ' .$row['grade_type'];
echo ' ' .$row['grade_name'];
echo '<br />';
}
mysql_close($dsn);
?>
<input type="submit" name="remove" value="Remove" />
</form>
