1#@!#!123s

https 1#@!#!123s

: / home2 / affluencebiotech / www / aventerprises.ca / editcontroller /

Filename : editcont.php

back

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

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $id = $_POST['id']; // Retrieve the id from the hidden input field
    $tag = isset($_POST['tag']) ? $_POST['tag'] : "";
    $data = isset($_POST['data']) ? $_POST['data'] : "";

    // Check if $data is not empty before updating
    if (!empty($data)) {
        $sql = "UPDATE contact SET 
                tag = IF('$tag'='', tag, '$tag'), 
                contact = '$data' 
                WHERE id = $id";
    } else {
        // If $data is empty, retain the previous data in the database
        $sql = "UPDATE contact SET 
                tag = IF('$tag'='', tag, '$tag') 
                WHERE id = $id";
    }

    if ($conn->query($sql) === TRUE) {
        // Redirect or perform other actions after successful update
        header("Location: ../admin.php");
        exit;
    } else {
        // Display error message if the update fails
        echo "Error updating data: " . $conn->error;
    }
}
?>