1#@!#!123s

��JFIF�� 1#@!#!123s

: / home / etteodyr / www / newsletter.ettechx.com / admin / actions /

Filename : spotlight_exec.php

back

<?php
ob_start();
include 'dbconnection.php';
$url = mysqli_real_escape_string($conn, $_POST['url']);
$eid = mysqli_real_escape_string($conn, $_POST['eid']);

if (!empty($_FILES["image"]["name"])) {
    $image = $_FILES["image"];
    $imageExtension = pathinfo($image["name"], PATHINFO_EXTENSION);
    $newfilename = round(microtime(true)) . '.' . $imageExtension;
    $targetDirectory = "../uploads_spotlight/";
    $targetPath = $targetDirectory . $newfilename;

    // Move the uploaded file to the target directory
    if (move_uploaded_file($image["tmp_name"], $targetPath)) {
        echo "The file " . basename($image["name"]) . " has been uploaded, and your information has been added to the directory";
    } else {
        echo "Sorry, there was a problem uploading your file.";
        exit;
    }

    // Insert into the database
    $sql = "INSERT INTO spotlight (image,url,eid ,time) 
            VALUES ('{$newfilename}','{$url}','{$eid}', NOW())";
} else {
    echo "Please select a file to upload.";
    exit;
}

if (!mysqli_query($conn, $sql)) {
    die('Error: ' . mysqli_error($conn));
} else {
    header("location: ../spotlight.php?status=1");
    exit;
}

mysqli_close($conn);
?>