Viewing file:  update_certificate.php (1.07 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include 'connect.php';
$enroll = $_POST['enrollment'];
$name = $_POST['name'];
$course = $_POST['course'];
$cert_no = $_POST['certificate_no'];
$issue_date = $_POST['issue_date'];
// Check if new photo uploaded
if ($_FILES['photo']['name']) {
$photoName = basename($_FILES['photo']['name']);
$targetDir = "../data/files/"; // You must ensure this folder exists and is writable
$targetPath = $targetDir . $photoName;
move_uploaded_file($_FILES['photo']['tmp_name'], $targetPath);
$sql = "UPDATE certificate SET Name='$name', Course='$course', CertificateNo='$cert_no', certifcate_issue_date='$issue_date', photo='$photoName' WHERE enrollment='$enroll'";
} else {
$sql = "UPDATE certificate SET Name='$name', Course='$course', CertificateNo='$cert_no', certifcate_issue_date='$issue_date' WHERE enrollment='$enroll'";
}
if (mysqli_query($link, $sql)) {
echo "<script>alert('Certificate updated successfully'); window.location.href='generate_certificate.php';</script>";
} else {
echo "Error updating record: " . mysqli_error($link);
}
mysqli_close($link);
?>
|