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-investment.php

<?php
// Database connection
include 'includes/db.php';

// Fetch all investments
$sql = "SELECT id, investment_name, amount, investment_date, category, remark FROM investments";
$result = mysqli_query($conn, $sql);

// Check for query errors
if (!$result) {
    echo "<pre>Error fetching investments: " . mysqli_error($conn) . "</pre>";
    die();
}

// Debug query results
$rows = mysqli_num_rows($result);
echo "";

<!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 Investments";
                    $breadcrumb_active = "Manage Investments";
                    ?>
                    <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>

<div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header d-flex align-items-center justify-content-between">
                                    <h6 class="card-title mb-0" style="font-weight: bold; font-size: 1.1rem; color: #333;">Add New Investment</h6>
                                    <a href="manage-investment.php" class="btn btn-sm btn-primary">New Investment</a>
                                </div>
                                <div class="card-body">
                                    <form id="investmentForm" action="save-investment.php" method="post" novalidate>
                                        <div class="row g-3">
                                            
                                            <div class="col-md-6">
                                                <label for="investment_name" class="form-label" style="font-weight: bold; font-size: 1rem;">Investment Name <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="investment_name" name="investment_name" placeholder="e.g., Mutual Fund Investment" required>
                                                <div class="invalid-feedback">Investment name is required.</div>
                                            </div>

<div class="col-md-3">
                                                <label for="amount" class="form-label" style="font-weight: bold; font-size: 1rem;">Amount (₹) <span class="text-danger">*</span></label>
                                                <input type="number" class="form-control" id="amount" name="amount" min="0" step="0.01" placeholder="e.g., 100000" required>
                                                <div class="invalid-feedback">Please enter a valid amount.</div>
                                            </div>

<div class="col-md-3">
                                                <label for="investment_date" class="form-label" style="font-weight: bold; font-size: 1rem;">Investment Date <span class="text-danger">*</span></label>
                                                <input type="date" class="form-control" id="investment_date" name="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" style="font-weight: bold; font-size: 1rem;">Category <span class="text-danger">*</span></label>
                                                <select class="form-control" id="category" name="category" required>
                                                    <option value="" disabled selected>Select a category</option>
                                                    <option value="Mutual Funds">Mutual Funds</option>
                                                    <option value="Stocks">Stocks</option>
                                                    <option value="Fixed Deposits">Fixed Deposits</option>
                                                    <option value="Real Estate">Real Estate</option>
                                                    <option value="Bonds">Bonds</option>
                                                </select>
                                                <div class="invalid-feedback">Please select a category.</div>
                                            </div>

<div class="col-md-6">
                                                <label for="remark" class="form-label" style="font-weight: bold; font-size: 1rem;">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"></textarea>
                                            </div>

<div class="col-12 pt-2">
                                                <button type="submit" class="btn btn-primary">Save Investment</button>
                                                <a href="manage-investment.php" class="btn btn-light">Reset</a>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="card-title mb-0">Investment List</h4>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table id="tblInvestments" class="table table-striped table-bordered align-middle w-100">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#Investment ID</th>
                                                    <th>Investment Name</th>
                                                    <th>Amount (₹)</th>
                                                    <th>Investment Date</th>
                                                    <th>Category</th>
                                                    <th class="text-end">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php if (mysqli_num_rows($result) > 0) { ?>
                                                    <?php while ($row = mysqli_fetch_assoc($result)) { ?>
                                                        <tr>
                                                            <td>
                                                                <a href="#" class="investment-id" data-investment-id="<?php echo $row['id']; ?>" data-bs-toggle="modal" data-bs-target="#investmentDetailsModal">
                                                                    <?php echo "INV-" . $row['id']; ?>
                                                                </a>
                                                            </td>
                                                            <td><?php echo htmlspecialchars($row['investment_name']); ?></td>
                                                            <td><?php echo number_format($row['amount'], 2); ?></td>
                                                            <td><?php echo $row['investment_date']; ?></td>
                                                            <td><?php echo htmlspecialchars($row['category']); ?></td>
                                                            <td class="text-end">
                                                                <a href="edit-investment.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-soft-primary">
                                                                    <i class="las la-edit"></i>
                                                                </a>
                                                                <a href="delete-investment.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-soft-danger" onclick="return confirm('Are you sure you want to delete this investment?')">
                                                                    <i class="las la-trash"></i>
                                                                </a>
                                                            </td>
                                                        </tr>
                                                    <?php } ?>
                                                <?php } else { ?>
                                                    <tr>
                                                        <td colspan="6" class="text-center">No investments found.</td>
                                                    </tr>
                                                <?php } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

</div>

<div class="modal fade" id="investmentDetailsModal" tabindex="-1" aria-labelledby="investmentDetailsModalLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="investmentDetailsModalLabel">Investment Details</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                            </div>
                            <div class="modal-body">
                                <div id="investmentDetailsContent">
                                    <p>Loading investment details...</p>
                                </div>
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                            </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>

// Initialize DataTable
            $(document).ready(function() {
                $('#tblInvestments').DataTable({
                    pageLength: 10,
                    order: [[0, 'desc']], // Sort by Investment ID
                });

// Handle click on investment ID to fetch details via AJAX
                $('.investment-id').on('click', function(e) {
                    e.preventDefault();
                    var investmentId = $(this).data('investment-id');
                    
                    $.ajax({
                        url: 'get-investment-details.php',
                        type: 'GET',
                        data: { investment_id: investmentId },
                        dataType: 'html',
                        beforeSend: function() {
                            $('#investmentDetailsContent').html('<p>Loading investment details...</p>');
                            console.log('Sending AJAX request for investment ID: ' + investmentId);
                        },
                        success: function(response) {
                            $('#investmentDetailsContent').html(response);
                            $('#investmentDetailsTable').DataTable({
                                pageLength: 10,
                                searching: false,
                                paging: false,
                                info: false
                            });
                            console.log('AJAX request successful for investment ID: ' + investmentId);
                        },
                        error: function(xhr, status, error) {
                            $('#investmentDetailsContent').html('<p class="text-danger">Error loading investment details: ' + error + '</p>');
                            console.log('AJAX Error Details:');
                            console.log('Status: ' + status);
                            console.log('Error: ' + error);
                            console.log('Response Text: ' + xhr.responseText);
                            console.log('Status Code: ' + xhr.status);
                            console.log('Status Text: ' + xhr.statusText);
                            console.log('URL: ' + this.url);
                        }
                    });
                });
            });
        </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-investment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation