1#@!#!123s

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

: / proc / self / root / home / etteodyr / public_html / newsletter.ettechx.com / admin / actions /

Filename : educators_exec.php

back

<?php
ob_start();
include 'dbconnection.php';

$title = mysqli_real_escape_string($conn, $_POST['title']);
$details = mysqli_real_escape_string($conn, $_POST['details']);
$url = mysqli_real_escape_string($conn, $_POST['url']);
$color = mysqli_real_escape_string($conn, $_POST['color']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
$eid = mysqli_real_escape_string($conn, $_POST['eid']);
$image = $_FILES["image"];

// Check if the file was properly uploaded
if ($image['error'] !== UPLOAD_ERR_OK) {
    echo "Error uploading file.";
    exit;
}

$newfilename = round(microtime(true)) . '.' . pathinfo($image["name"], PATHINFO_EXTENSION);
$targetDirectory = "../uploads_educators/";
$targetPath = $targetDirectory . $newfilename;

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

$sql = "INSERT INTO educators (title, details,url,color, image, description,eid, time) 
        VALUES ('{$title}', '{$details}', '{$url}', '{$color}', '{$newfilename}', '{$description}','{$eid}', NOW())";

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

mysqli_close($conn);
?>