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

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: edit-loan.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 for flash messages and finance_id
session_start();

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

// Check if the 'id' parameter is provided in the URL
if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    $_SESSION['error'] = "Invalid loan ID.";
    header("Location: manage-loans.php");
    exit;
}

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

// Query to fetch loan data based on the ID
$sql = "SELECT l.*, f.finance_name 
        FROM loans l 
        LEFT JOIN finance f ON l.finance_id = f.id 
        WHERE l.id = $loan_id";
$result = mysqli_query($conn, $sql);

// Check if the loan exists
if (!$result || mysqli_num_rows($result) == 0) {
    $_SESSION['error'] = "Loan not found.";
    header("Location: manage-loans.php");
    exit;
}

// Fetch the loan data
$loan = mysqli_fetch_assoc($result);

// Fetch all finance records for the dropdown
$sql_finance = "SELECT id, finance_name FROM finance ORDER BY finance_name ASC";
$result_finance = mysqli_query($conn, $sql_finance);
$finance_options = [];
if ($result_finance) {
    while ($row = mysqli_fetch_assoc($result_finance)) {
        $finance_options[] = $row;
    }
    mysqli_free_result($result_finance);
}

// Close the database connection
mysqli_close($conn);

// Convert loan_documents to an array for pre-selecting in the form
$loan_documents_array = explode(", ", $loan['loan_documents'] ?? '');
?>

<!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 Loan</h3>
                            <small class="text-muted">Update the details of the loan.</small>
                        </div>
                        <div class="col-auto">
                            <a href="manage-loans.php" class="btn btn-light">Back to Loans</a>
                        </div>
                    </div>

<div class="card">
                        <div class="card-header">
                            <h4 class="card-title mb-0">Edit Loan Details</h4>
                        </div>
                        <div class="card-body">
                            <form id="loanForm" action="update-loan.php" method="POST" novalidate>
                                <input type="hidden" name="id" value="<?php echo $loan['id']; ?>">
                                <div class="row g-3">
                                    
                                    <div class="col-md-6">
                                        <label for="finance_id" class="form-label" style="font-weight: bold; font-size: 1rem;">Select Finance <span class="text-danger">*</span></label>
                                        <select class="form-select" id="finance_id" name="finance_id" required>
                                            <option value="">Choose Finance</option>
                                            <?php foreach ($finance_options as $finance): ?>
                                                <option value="<?php echo $finance['id']; ?>" 
                                                        <?php echo $loan['finance_id'] == $finance['id'] ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($finance['finance_name']); ?>
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                        <div class="invalid-feedback">Please select a finance.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="loan_name" class="form-label" style="font-weight: bold; font-size: 1rem;">Loan Name <span class="text-danger">*</span></label>
                                        <input type="text" class="form-control" id="loan_name" name="loan_name" value="<?php echo htmlspecialchars($loan['loan_name']); ?>" required>
                                        <div class="invalid-feedback">Loan name is required.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="loan_amount" class="form-label" style="font-weight: bold; font-size: 1rem;">Loan Amount (₹) <span class="text-danger">*</span></label>
                                        <input type="number" class="form-control" id="loan_amount" name="loan_amount" min="0" step="0.01" value="<?php echo $loan['loan_amount']; ?>" required>
                                        <div class="invalid-feedback">Please enter a valid loan amount.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="interest_rate" class="form-label" style="font-weight: bold; font-size: 1rem;">Loan Interest Rate (%) <span class="text-danger">*</span></label>
                                        <input type="number" class="form-control" id="interest_rate" name="interest_rate" min="0" max="100" step="0.01" value="<?php echo $loan['interest_rate']; ?>" required>
                                        <div class="invalid-feedback">Please enter a valid interest rate.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="loan_tenure" class="form-label" style="font-weight: bold; font-size: 1rem;">Loan Tenure (Months) <span class="text-danger">*</span></label>
                                        <input type="number" class="form-control" id="loan_tenure" name="loan_tenure" min="1" value="<?php echo $loan['loan_tenure']; ?>" required>
                                        <div class="invalid-feedback">Please enter loan tenure in months.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="loan_documents" class="form-label" style="font-weight: bold; font-size: 1rem;">Required Documents <span class="text-danger">*</span></label>
                                        <select class="form-select" id="loan_documents" name="loan_documents[]" multiple required>
                                            <?php
                                            $available_documents = [
                                                "Aadhar Card",
                                                "PAN Card",
                                                "Bank Statement",
                                                "Salary Slip",
                                                "Tax Returns",
                                                "Proof of Address"
                                            ];
                                            foreach ($available_documents as $doc): ?>
                                                <option value="<?php echo $doc; ?>" 
                                                        <?php echo in_array($doc, $loan_documents_array) ? 'selected' : ''; ?>>
                                                    <?php echo $doc; ?>
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                        <div class="invalid-feedback">Please select at least one document.</div>
                                    </div>

<div class="col-md-6">
                                        <label for="loan_purpose" class="form-label" style="font-weight: bold; font-size: 1rem;">Loan Purpose <span class="text-muted">(optional)</span></label>
                                        <textarea class="form-control" id="loan_purpose" name="loan_purpose" rows="2"><?php echo htmlspecialchars($loan['loan_purpose'] ?? ''); ?></textarea>
                                    </div>

<div class="col-12 pt-3">
                                        <button type="submit" class="btn btn-primary">Save Changes</button>
                                        <a href="manage-loans.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'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-loan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation