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/finance

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: edit-investment.php

<?php
// Enable error logging instead of displaying errors
ini_set('display_errors', 0);
ini_set('log_errors', 1);
ini_set('error_log', '/home/u329947844/domains/hifi11.in/public_html/finance/error_log');
// Start session
session_start();

// Include database connection
include 'includes/db.php';

// Check if investment ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    $_SESSION['error'] = "Investment ID is required.";
    header("Location: manage-investment.php");
    exit;
}

$investment_id = intval($_GET['id']);

// Fetch investment data
$sql = "SELECT * FROM investments WHERE id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $investment_id);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows === 0) {
    $_SESSION['error'] = "Investment not found.";
    header("Location: manage-investment.php");
    exit;
}

$investment = $result->fetch_assoc();
$result->free();
$stmt->close();

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Get and sanitize form data
    $investment_name = trim($_POST['investment_name'] ?? '');
    $amount = floatval($_POST['amount'] ?? 0);
    $investment_date = trim($_POST['investment_date'] ?? '');
    $category = trim($_POST['category'] ?? '');
    $remark = trim($_POST['remark'] ?? '');

// Validate required fields
    if (empty($investment_name) || $amount <= 0 || empty($investment_date) || empty($category)) {
        $_SESSION['error'] = "All required fields must be filled correctly.";
        header("Location: edit-investment.php?id=" . $investment_id);
        exit;
    }

// Validate date format
    if (!preg_match('/^\d{4}-\d{2}-\d{2}$/', $investment_date)) {
        $_SESSION['error'] = "Invalid date format.";
        header("Location: edit-investment.php?id=" . $investment_id);
        exit;
    }

// Validate category
    $valid_categories = ['Fixed Deposit', 'Mutual Fund', 'Stocks', 'Real Estate', 'Gold', 'Bonds', 'Other'];
    if (!in_array($category, $valid_categories)) {
        $_SESSION['error'] = "Invalid category selected.";
        header("Location: edit-investment.php?id=" . $investment_id);
        exit;
    }

// Update investment using prepared statement (removed updated_at)
    $sql = "UPDATE investments SET investment_name = ?, amount = ?, investment_date = ?, category = ?, remark = ? WHERE id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("sdsssi", $investment_name, $amount, $investment_date, $category, $remark, $investment_id);
    
    if ($stmt->execute()) {
        $_SESSION['success'] = "Investment updated successfully!";
        header("Location: manage-investment.php");
        exit;
    } else {
        $_SESSION['error'] = "Error updating investment: " . $stmt->error;
        header("Location: edit-investment.php?id=" . $investment_id);
        exit;
    }

$stmt->close();
}

$conn->close();
?>

<!DOCTYPE html>
<html lang="en" dir="ltr" data-startbar="dark" data-bs-theme="light">
<?php include 'includes/head.php'; ?>

<div class="startbar d-print-none">
        <?php include 'includes/leftbar-tab-menu.php'; ?> 
        <?php include 'includes/leftbar.php'; ?>
        <div class="startbar-overlay d-print-none"></div>

<?php if (isset($_SESSION['success'])): ?>
                        <div class="alert alert-success alert-dismissible fade show" role="alert">
                            <strong>Success!</strong> <?php echo $_SESSION['success']; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['success']); ?>
                    <?php endif; ?>
                    <?php if (isset($_SESSION['error'])): ?>
                        <div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <strong>Error!</strong> <?php echo $_SESSION['error']; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['error']); ?>
                    <?php endif; ?>

<div class="row align-items-center mb-3">
                        <div class="col">
                            <h3 class="mb-0">Edit Investment</h3>
                            <small class="text-muted">Update investment details.</small>
                        </div>
                        <div class="col-auto">
                            <a href="manage-investment.php" class="btn btn-light">Back to Investments</a>
                        </div>
                    </div>

<div class="card">
                        <div class="card-header">
                            <h4 class="card-title mb-0">Investment Details</h4>
                        </div>
                        <div class="card-body">
                            <form id="investmentForm" action="edit-investment.php?id=<?php echo $investment_id; ?>" method="POST" novalidate>
                                <div class="row g-3">
                                    
                                    <div class="col-md-12">
                                        <label for="investment_name" class="form-label fw-bold">Investment Name <span class="text-danger">*</span></label>
                                        <input type="text" class="form-control" id="investment_name" name="investment_name" 
                                               value="<?php echo htmlspecialchars($investment['investment_name']); ?>" 
                                               placeholder="e.g., HDFC Mutual Fund SIP" required>
                                        <div class="invalid-feedback">Investment name is required.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="amount" class="form-label fw-bold">Amount (₹) <span class="text-danger">*</span></label>
                                        <input type="number" class="form-control" id="amount" name="amount" 
                                               min="0" step="0.01" value="<?php echo $investment['amount']; ?>" 
                                               placeholder="e.g., 100000.00" required>
                                        <div class="invalid-feedback">Please enter a valid amount greater than 0.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="investment_date" class="form-label fw-bold">Investment Date <span class="text-danger">*</span></label>
                                        <input type="date" class="form-control" id="investment_date" name="investment_date" 
                                               value="<?php echo $investment['investment_date']; ?>" required>
                                        <div class="invalid-feedback">Please select a valid date.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="category" class="form-label fw-bold">Category <span class="text-danger">*</span></label>
                                        <select class="form-control" id="category" name="category" required>
                                            <option value="" disabled>Select a category</option>
                                            <option value="Fixed Deposit" <?php echo ($investment['category'] == 'Fixed Deposit') ? 'selected' : ''; ?>>Fixed Deposit</option>
                                            <option value="Mutual Fund" <?php echo ($investment['category'] == 'Mutual Fund') ? 'selected' : ''; ?>>Mutual Fund</option>
                                            <option value="Stocks" <?php echo ($investment['category'] == 'Stocks') ? 'selected' : ''; ?>>Stocks</option>
                                            <option value="Real Estate" <?php echo ($investment['category'] == 'Real Estate') ? 'selected' : ''; ?>>Real Estate</option>
                                            <option value="Gold" <?php echo ($investment['category'] == 'Gold') ? 'selected' : ''; ?>>Gold</option>
                                            <option value="Bonds" <?php echo ($investment['category'] == 'Bonds') ? 'selected' : ''; ?>>Bonds</option>
                                            <option value="Other" <?php echo ($investment['category'] == 'Other') ? 'selected' : ''; ?>>Other</option>
                                        </select>
                                        <div class="invalid-feedback">Please select a category.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="remark" class="form-label fw-bold">Remark <span class="text-muted">(optional)</span></label>
                                        <textarea class="form-control" id="remark" name="remark" rows="2" 
                                                  placeholder="e.g., Long-term growth plan, 5-year horizon"><?php echo htmlspecialchars($investment['remark'] ?? ''); ?></textarea>
                                    </div>
                                </div>

<div class="row mt-4">
                                    <div class="col-12">
                                        <button type="submit" class="btn btn-primary">Update Investment</button>
                                        <a href="manage-investment.php" class="btn btn-light">Cancel</a>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>

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

<?php include 'includes/scripts.php'; ?>

// Set max date to today for investment date
            document.addEventListener('DOMContentLoaded', function() {
                const investmentDateInput = document.getElementById('investment_date');
                if (investmentDateInput) {
                    const today = new Date().toISOString().split('T')[0];
                    investmentDateInput.max = today;
                }

// Auto-format amount input
                const amountInput = document.getElementById('amount');
                if (amountInput) {
                    amountInput.addEventListener('blur', function() {
                        const value = parseFloat(this.value);
                        if (!isNaN(value) && value >= 0) {
                            this.value = value.toFixed(2);
                        }
                    });
                }
            });
        </script>
    </body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-investment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation