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/sp/admin

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: manage-loans.php

<?php
// Database connection
include 'includes/db.php';  // Make sure this file contains your database connection logic

// Query to fetch loan data
$sql = "SELECT * FROM loans";
$result = mysqli_query($conn, $sql);

// Check for errors in the query
if (!$result) {
    die("Error fetching data: " . mysqli_error($conn));
}

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

// Check if a success or error message is passed in the URL
$msg = isset($_GET['msg']) ? $_GET['msg'] : '';
$error = isset($_GET['error']) ? $_GET['error'] : '';
?>

<!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">
    <div class="brand">
      <a href="index.php" class="logo">
        <span>
          <img src="assets/images/logo-sm.png" alt="logo-small" class="logo-sm">
        </span>
        <span class="">
          <img src="assets/images/logo-light.png" alt="logo-large" class="logo-lg logo-light">
          <img src="assets/images/logo-dark.png" alt="logo-large" class="logo-lg logo-dark">
        </span>
      </a>
    </div>
    <?php include 'includes/leftbar.php'; ?>
    <div class="startbar-overlay d-print-none"></div>

<div class="page-wrapper">
      
      <div class="page-content">
        <div class="container-fluid">
         
 
                    <?php
                    $page_title = "manage-loans";
                    $breadcrumb_active = "manage-loans";
                    ?>
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="page-title-box d-md-flex justify-content-md-between align-items-center">
                                <h4 class="page-title"><?php echo $page_title; ?></h4>
                                <div class="">
                                    <ol class="breadcrumb mb-0">
                                        <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                        <li class="breadcrumb-item active"><?php echo $breadcrumb_active; ?></li>
                                    </ol>
                                </div>                            
                            </div>
                        </div>
                    </div>
                    
          
          <?php if ($msg): ?>
            <div class="alert alert-success alert-dismissible fade show" role="alert">
              <strong>Success!</strong> <?php echo $msg; ?>
              <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
          <?php endif; ?>

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

<div class="row align-items-center mb-3">
            <div class="col">
              <h3 class="mb-0">Manage Loans</h3>
              <small class="text-muted">Manage and update loan details with ease.</small>
            </div>
            <div class="col-auto d-flex gap-2">
              <a href="add-loan.php" class="btn btn-primary">
                <i class="iconoir-plus me-1"></i> Add New Loan
              </a>
            </div>
          </div>

<div class="card">
            <div class="card-header">
              <h4 class="card-title mb-0">Loan List</h4>
            </div>
            <div class="card-body">
              <div class="table-responsive">
                <table id="tblLoans" class="table table-striped table-bordered align-middle w-100">
                  <thead class="table-light">
                    <tr>
                      <th>#ID</th>
                      <th>Loan Name</th>
                      <th>Loan Amount</th>
                      <th>Interest Rate (%)</th>
                      <th>Tenure (Months)</th>
                      <th>Documents Required</th>
                      <th>Loan Purpose</th>
                      <th class="text-end">Action</th>
                    </tr>
                  </thead>
                  <tbody>
                    
                    <?php while ($row = mysqli_fetch_assoc($result)) { ?>
                      <tr data-json='{
                        "id": <?php echo $row['id']; ?>,
                        "loan_name": "<?php echo $row['loan_name']; ?>",
                        "loan_amount": "<?php echo $row['loan_amount']; ?>",
                        "interest_rate": "<?php echo $row['interest_rate']; ?>",
                        "loan_tenure": "<?php echo $row['loan_tenure']; ?>",
                        "loan_documents": "<?php echo $row['loan_documents']; ?>",
                        "loan_purpose": "<?php echo $row['loan_purpose']; ?>"
                      }'>
                        <td><?php echo "LN-" . $row['id']; ?></td>
                        <td><?php echo $row['loan_name']; ?></td>
                        <td><?php echo number_format($row['loan_amount'], 2); ?></td>
                        <td><?php echo $row['interest_rate']; ?>%</td>
                        <td><?php echo $row['loan_tenure']; ?> Months</td>
                        <td><?php echo $row['loan_documents']; ?></td>
                        <td><?php echo $row['loan_purpose']; ?></td>
                        <td class="text-end">
                          <a href="edit-loan.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-soft-primary">
                            <i class="las la-edit"></i>
                          </a>
                        </td>
                      </tr>
                    <?php } ?>
                  </tbody>
                </table>
              </div>
            </div>
          </div>

</div>

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

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

<link rel="stylesheet" href="https://cdn.datatables.net/1.13.8/css/dataTables.bootstrap5.min.css">
    <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.8/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.8/js/dataTables.bootstrap5.min.js"></script>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-loans.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation