query("INSERT INTO `assignment` (file, description) VALUES ('$fileName', '$description')"); echo ''; exit; } else { echo ''; } } else { echo ''; } } // Delete Assignment if (isset($_GET['action']) && $_GET['action'] == 'delete' && isset($_GET['id'])) { $id = mysqli_real_escape_string($con, $_GET['id']); // Get file name to delete from server $fileQuery = $con->query("SELECT file FROM `assignment` WHERE id = '$id'"); if ($fileQuery && $fileQuery->num_rows) { $fileData = $fileQuery->fetch_assoc(); if (!empty($fileData['file'])) { $filePath = '../uploads/assignment/' . $fileData['file']; if (file_exists($filePath)) { unlink($filePath); } } } $con->query("DELETE FROM `assignment` WHERE id = '$id'"); echo ''; exit; } ?>
| # | Date | Document Name | Description | Action |
|---|---|---|---|---|
| = $i++ ?> | = date('d-M-Y', strtotime($row['date'])) ?> | = htmlspecialchars($row['file']) ?> | = htmlspecialchars($row['description']) ?> | |
|
No Files Found
Upload your first file using the form above. |
||||