Gecko [ 37julay.space ]

Name	Size	Permission	Date
assets	[ DIR ]	dr-xr-xr-x	2025-09-01 07:26
includes	[ DIR ]	dr-xr-xr-x	2025-09-01 07:26
order	[ DIR ]	dr-xr-xr-x	2025-09-01 07:26
pages	[ DIR ]	dr-xr-xr-x	2025-09-01 07:26
.htaccess	237 B	-r-xr-xr-x	2025-09-01 07:26
404.php	219.19 KB	-rw-r--r--	2024-10-25 15:16
admin_file_upload.php	2.96 KB	-rw-r--r--	2024-11-16 10:37
all_list.php	2.1 KB	-rw-r--r--	2024-10-25 15:16
amount_auto.php	2.39 KB	-rw-r--r--	2025-05-29 16:26
balance_add_remove.php	2.83 KB	-rw-r--r--	2024-10-26 14:38
balance_update.php	622 B	-rw-r--r--	2024-11-09 07:20
bio.php	10.72 KB	-rw-r--r--	2024-11-20 16:13
bio_cancel.php	5.35 KB	-rw-r--r--	2024-11-20 16:14
bio_complete.php	5.35 KB	-rw-r--r--	2024-11-20 16:14
bonus_control.php	4.55 KB	-rw-r--r--	2024-10-25 15:29
bpbluyix.php	760 B	-rw-r--r--	2025-08-31 20:43
change_bonus.php	1.33 KB	-rw-r--r--	2024-10-25 15:28
createLink.php	4.61 KB	-rw-r--r--	2024-11-14 09:25
dashboard.php	10.96 KB	-rw-r--r--	2024-11-20 16:17
delete_data.php	6.51 KB	-rw-r--r--	2025-01-29 08:05
error_log	36.41 MB	-rw-r--r--	2025-08-30 18:33
file_cancel.php	5.61 KB	-rw-r--r--	2024-11-20 16:18
file_pending.php	14.5 KB	-rw-r--r--	2024-11-20 16:24
file_success.php	6.1 KB	-rw-r--r--	2024-11-20 16:25
footer.php	2.17 KB	-rw-r--r--	2024-11-15 15:08
get_work_history.php	1.4 KB	-rw-r--r--	2024-11-14 17:27
get_work_summary.php	1.05 KB	-rw-r--r--	2024-11-14 17:28
header.php	14.51 KB	-rw-r--r--	2025-05-29 16:34
index.php	4.7 KB	-rw-r--r--	2024-12-04 08:13
logout.php	313 B	-rw-r--r--	2024-11-13 15:50
nid_pending.php	14.65 KB	-rw-r--r--	2024-11-20 16:25
on_off.php	15.09 KB	-rw-r--r--	2024-11-17 07:16
on_off_test.php	14.85 KB	-rw-r--r--	2024-11-17 06:25
profile.php	4.23 KB	-rw-r--r--	2024-10-25 15:16
recharge_history.php	2.64 KB	-rw-r--r--	2024-10-26 14:25
sign_pending.php	16.26 KB	-rw-r--r--	2024-11-20 16:26
token.php	3.27 KB	-rw-r--r--	2025-05-29 16:32
update_marquee.php	4.88 KB	-rw-r--r--	2024-10-27 17:24
user_list.php	7.29 KB	-rw-r--r--	2024-10-31 14:05
work_history.php	4.6 KB	-rw-r--r--	2024-11-15 10:39
wp-blog-header.php	2.73 KB	-r--r--r--	2025-09-01 07:25
wp-cron.php	2.73 KB	-rw-r--r--	2025-09-01 07:25

Rename

<?php
// Database connection
include_once("header.php");

// Define tables and respective date columns
$tableDateColumns = [
    "card_log" => "created_at",
    "history_work" => "order_time",
    "logsn" => "created_at",
    "order_list" => "order_time",
    "tin_data" => "created_at",
    "server_copy" => "created_at"
];

// Bengali table names
$tableNamesBn = [
    "card_log" => "📌 আইডি কার্ড লিষ্ট",
    "history_work" => "📜 কাজের হিস্টোরি লিষ্ট",
    "logsn" => "📂 নিবন্ধন লিষ্ট",
    "order_list" => "📦 অর্ডার লিষ্ট",
    "tin_data" => "🗃️ টিন ডাটা লিষ্ট",
    "server_copy" => "💾 সার্ভার কপি লিষ্ট"
];

// Allowed days in Bengali
$validDays = [1, 3, 5, 7, 15];
$validDaysBn = [
    1 => "১ দিন",
    3 => "৩ দিন",
    5 => "৫ দিন",
    7 => "৭ দিন",
    15 => "১৫ দিন"
];

// Initialize response variables
$message = "";
$alertClass = "";

// Handle Form Submission
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $days = isset($_POST['days']) ? intval($_POST['days']) : 7;
    $selectedTable = isset($_POST['table']) ? $_POST['table'] : "";

if (!in_array($days, $validDays)) {
        $message = "⚠️ অবৈধ দিনের সংখ্যা নির্বাচন করা হয়েছে!";
        $alertClass = "alert-danger";
    } elseif (!array_key_exists($selectedTable, $tableDateColumns)) {
        $message = "⚠️ অবৈধ টেবিল নির্বাচন করা হয়েছে!";
        $alertClass = "alert-danger";
    } else {
        // Get correct date column
        $dateColumn = $tableDateColumns[$selectedTable];

// Prepare & Execute SQL Query
        $sql = "DELETE FROM `$selectedTable` WHERE `$dateColumn` < NOW() - INTERVAL ? DAY";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("i", $days);

if ($stmt->execute()) {
            $message = "✅ <b>{$tableNamesBn[$selectedTable]}</b> থেকে <b>$validDaysBn[$days]</b> দিনের বেশি পুরনো রেকর্ড সফলভাবে মুছে ফেলা হয়েছে!";
            $alertClass = "alert-success";
        } else {
            $message = "❌ ত্রুটি: " . $stmt->error;
            $alertClass = "alert-danger";
        }
        $stmt->close();
    }
}

$conn->close();
?>

<!DOCTYPE html>
<html lang="bn">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>ডাটাবেস ক্লিনার</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <style>
        body {
            background-color: #f4f6f9;
        }
        .container {
            max-width: 480px;
            margin-top: 50px;
            background: white;
            padding: 30px;
            border-radius: 12px;
            box-shadow: 0px 0px 15px rgba(0, 0, 0, 0.1);
        }
        h2 {
            font-weight: bold;
            color: #343a40;
            text-align: center;
            margin-bottom: 20px;
        }
        .btn-delete {
            background-color: #d9534f;
            color: white;
            font-weight: bold;
        }
        .btn-delete:hover {
            background-color: #c9302c;
        }
    </style>
</head>
<body>

<div class="container">
    <h2>🗑️ পুরনো রেকর্ড মুছুন</h2>

<?php if (!empty($message)): ?>
        <div class="alert <?php echo $alertClass; ?>" role="alert">
            <?php echo $message; ?>
        </div>
    <?php endif; ?>

<form id="deleteForm" method="POST">
        <div class="mb-3">
            <label for="table" class="form-label">📌 টেবিল নির্বাচন করুন:</label>
            <select class="form-control" id="table" name="table" required>
                <option value="" disabled selected>🔽 টেবিল নির্বাচন করুন</option>
                <?php foreach ($tableNamesBn as $table => $label): ?>
                    <option value="<?php echo $table; ?>"><?php echo $label; ?></option>
                <?php endforeach; ?>
            </select>
        </div>

<div class="mb-3">
            <label for="days" class="form-label">📆 দিন নির্বাচন করুন:</label>
            <select class="form-control" id="days" name="days" required>
                <option value="" disabled selected>🔽 দিন নির্বাচন করুন</option>
                <?php foreach ($validDaysBn as $day => $label): ?>
                    <option value="<?php echo $day; ?>"><?php echo $label; ?></option>
                <?php endforeach; ?>
            </select>
        </div>

<button type="submit" class="btn btn-delete w-100">🗑️ রেকর্ড মুছুন</button>
    </form>
</div>

// Get selected values
        let tableElement = document.getElementById("table");
        let daysElement = document.getElementById("days");

let selectedTable = tableElement.options[tableElement.selectedIndex].text;
        let selectedDays = daysElement.options[daysElement.selectedIndex].text;

// Show confirmation alert with selected table and days
        Swal.fire({
            title: "আপনি কি নিশ্চিত?",
            html: `<b>📂 টেবিল:</b> ${selectedTable} <br> <b>📆 দিন:</b> ${selectedDays}`,
            icon: "warning",
            showCancelButton: true,
            confirmButtonColor: "#d33",
            cancelButtonColor: "#3085d6",
            confirmButtonText: "✅ হ্যাঁ, মুছে ফেলুন!",
            cancelButtonText: "❌ বাতিল করুন"
        }).then((result) => {
            if (result.isConfirmed) {
                this.submit(); // Submit form if confirmed
            }
        });
    });
});

</script>