<?php
require 'includes/db-conn.inc.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if (isset($_FILES['txtimage2']) && $_FILES['txtimage2']['error'] == 0) {
        $uploadDir = 'media/visitingcard/';
        $uploadFile = $uploadDir . basename($_FILES['txtimage2']['name']);

        // Ensure the uploads directory exists
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true);
        }

        if (move_uploaded_file($_FILES['txtimage2']['tmp_name'], $uploadFile)) {
            // Insert file info into the database
           $randomValue = bin2hex(random_bytes(16));

            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            }

            $fileName = $conn->real_escape_string(basename($_FILES['txtimage2']['name']));
            $filePath = $conn->real_escape_string($uploadFile);

            $sql = "INSERT INTO visitng_card_images (file_name, file_path ,random_value) VALUES ('$fileName', '$filePath','$randomValue')";

            if ($conn->query($sql) === TRUE) {
                  echo json_encode(['status' => 'success', 'message' => 'File uploaded and saved to database successfully', 'random_value' => $randomValue]);
            } else {
                echo json_encode(['status' => 'error', 'message' => 'Error saving file info to database: ' . $conn->error]);
            }

            $conn->close();
        } else {
            echo json_encode(['status' => 'error', 'message' => 'Failed to move uploaded file']);
        }
    } else {
        echo json_encode(['status' => 'error', 'message' => 'No file uploaded or there was an upload error']);
    }
} else {
    echo json_encode(['status' => 'error', 'message' => 'Invalid request method']);
}
?>