1#@!#!123s

https 1#@!#!123s

: / home2 / hershinecreation / public_html / h-kindustries.com / admin / editcontroller /

Filename : editcont.php

back

<?php
require '../DB/db.php'; // Include the database connection file

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $id = intval($_POST['id']); // Ensure ID is integer

    // Check if each field is set and not empty
    $tag = isset($_POST['tag']) ? trim($_POST['tag']) : '';
    $data = isset($_POST['data']) ? trim($_POST['data']) : '';

    // Sanitize input if not empty
    $updates = [];

    if (!empty($tag)) {
        $tag = mysqli_real_escape_string($conn, $tag);
        $updates[] = "tag = '$tag'";
    }

    if (!empty($data)) {
        $data = mysqli_real_escape_string($conn, $data);
        $updates[] = "contact = '$data'";
    }

    // Only run update if there's something to update
    if (!empty($updates)) {
        $updateString = implode(", ", $updates);
        $sql = "UPDATE contact SET $updateString WHERE id = $id";

        if (mysqli_query($conn, $sql)) {
            header("Location: ../admin.php");
            exit;
        } else {
            echo "Error updating data: " . mysqli_error($conn);
        }
    } else {
        echo "No data provided to update.";
    }

}
?>