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/rutzotech.com/public_html/bill

Free Space:

10.24 TB

🔧 Quick Actions

✏️ Editing: search_bills.php

<?php
require_once 'db_connection.php';

header('Content-Type: application/json');

$search = $_GET['search'] ?? '';

if (strlen($search) < 2) {
    echo json_encode([]);
    exit;
}

// Escape search term for safety
$searchTerm = $conn->real_escape_string($search);

// Search bills by bill number or customer name
$query = "
    SELECT 
        b.id,
        b.bill_no,
        b.customer_name,
        b.total_amount,
        b.created_at,
        b.payment_mode,
        u.name as user_name,
        (SELECT COUNT(*) FROM bill_items WHERE bill_id = b.id) as item_count
    FROM bills b
    LEFT JOIN users u ON b.user_id = u.id
    WHERE b.bill_no LIKE '%$searchTerm%' 
       OR b.customer_name LIKE '%$searchTerm%'
       OR b.customer_mobile LIKE '%$searchTerm%'
    ORDER BY b.created_at DESC
    LIMIT 10
";

$result = $conn->query($query);
$bills = [];

if ($result) {
    while ($row = $result->fetch_assoc()) {
        $bills[] = [
            'id' => $row['id'],
            'bill_no' => $row['bill_no'],
            'customer_name' => $row['customer_name'],
            'total_amount' => $row['total_amount'],
            'created_at' => $row['created_at'],
            'payment_mode' => $row['payment_mode'],
            'user_name' => $row['user_name'],
            'item_count' => $row['item_count']
        ];
    }
    $result->free();
}

echo json_encode($bills);
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: search_bills.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation