query("SELECT * FROM contact_details LIMIT 1"); $contact = $result->fetch_assoc(); // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $address = trim($_POST['address']); $email = trim($_POST['email']); $phone = trim($_POST['phone']); if (!empty($address) && !empty($email) && !empty($phone)) { if ($contact) { // Update existing $stmt = $conn->prepare("UPDATE contact_details SET address = ?, email = ?, phone = ? WHERE id = ?"); $stmt->bind_param("sssi", $address, $email, $phone, $contact['id']); } else { // Insert if empty $stmt = $conn->prepare("INSERT INTO contact_details (address, email, phone) VALUES (?, ?, ?)"); $stmt->bind_param("sss", $address, $email, $phone); } if ($stmt->execute()) { $success = "Contact details updated successfully!"; header("Location: contactdetalis.php?msg=updated"); exit; } else { $error = "Failed to update contact details."; } $stmt->close(); } else { $error = "All fields are required."; } } ?> OM INTERIOR - Dashborad

Edit Contact Detalis

Edit Contact Details

Cancel
$tmp_name) { $originalName = basename($_FILES['images']['name'][$key]); $fileType = pathinfo($originalName, PATHINFO_EXTENSION); // Allow certain file formats $allowTypes = array('jpg', 'png', 'jpeg', 'gif', 'webp'); if (in_array(strtolower($fileType), $allowTypes)) { // Generate unique name using timestamp + random ID $uniqueName = uniqid('img_') . "_" . time() . "." . $fileType; $targetFilePath = $uploadDir . $uniqueName; if (move_uploaded_file($tmp_name, $targetFilePath)) { $values[] = "('$uniqueName')"; } } } if (!empty($values)) { echo "Images uploaded successfully!"; } if (!empty($category) && !empty($ptype) && !empty($pname) && !empty($pdes) &&!empty($values)) { $stmt = $conn->prepare("INSERT INTO project_list (client_name, project_category, project_type, project_title, project_description, project_images) VALUES (?, ?, ?, ?, ?, ?)"); if (!$stmt) { die("Statement preparation failed: " . $conn->error); } $stmt->bind_param("ssssss",$client, $category, $ptype, $pname, $pdes, implode(",",$values)); if ($stmt->execute()) { echo "Project added successfully!"; } else { echo "Error executing statement: " . $stmt->error; } $stmt->close(); } } ?> ?>