Gecko [ 36julay.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.34 KB	-rw-r--r--	2024-10-25 15:30
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
include_once("header.php");

// Prepare the SQL query to fetch existing records
$sql = "SELECT * FROM marquee";
$result = $conn->query($sql);

// Initialize an array to store the users
$users = array();

// Check if any records were found
if ($result->num_rows > 0) {
    // Fetch all rows as an associative array and store them in the $users array
    while ($row = $result->fetch_assoc()) {
        $users[] = $row;
    }
} else {
    $users = []; // No users found
}

// Check if the form has been submitted for updating numbers
if (isset($_POST['update'])) {
    $updateSuccess = true; // Flag to track success

foreach ($_POST['numbers'] as $id => $new_number) {
        $new_number_encoded = base64_encode($new_number); // Encode here
        $query = "UPDATE marquee SET marquee_text = ? WHERE id = ?";
        $stmt = $conn->prepare($query);

if ($stmt) { // Check if statement was prepared successfully
            $stmt->bind_param("si", $new_number_encoded, $id);
            if (!$stmt->execute()) {
                $updateSuccess = false; // Update failed
            }
            $stmt->close();
        } else {
            $updateSuccess = false; // Prepare failed
        }
    }

// Show alert based on the success of the update operation
    if ($updateSuccess) {
        echo '<div class="alert alert-info" style="position: fixed; top: 20px; right: 20px; z-index: 1033;">
                <p>
                    <span class="fa fa-fw fa-info-circle me-1"></span>
                    <span class="title"></span>
                    <span class="message">Successfully Updated All</span>
                </p>
                <a class="close" aria-label="Close" onclick="this.parentElement.style.display=\'none\';">
                    <i class="fa fa-times"></i>
                </a>
              </div>';
    } else {
        echo '<div class="alert alert-danger" style="position: fixed; top: 20px; right: 20px; z-index: 1033;">
                <p>
                    <span class="fa fa-fw fa-exclamation-circle me-1"></span>
                    <span class="message">Failed to Update Some Entries</span>
                </p>
                <a class="close" aria-label="Close" onclick="this.parentElement.style.display=\'none\';">
                    <i class="fa fa-times"></i>
                </a>
              </div>';
    }
}

// Fetch all numbers from the marquee_text table
$query = "SELECT id, page_name, marquee_text FROM marquee";
$result = mysqli_query($conn, $query);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="path/to/your/css/styles.css"> 
    <title>Update Marquee Text</title>
</head>
<body>
    <main id="main-container">
        <div class="content">
            <div class="card mb-3 p-3">
                <h4 class="py-1">নোটিশ টেক্স আপডেট করুন এখান থেকে</h4>
                <form method="POST" action="">
                    <table border="1" class="table">
                        <tr>
                            <th>ID</th>
                            <th>Page Name</th>
                            <th>Number</th>
                        </tr>
                        
                        <?php
                        // Loop through the result and display numbers
                        if (mysqli_num_rows($result) > 0) {
                            while ($row = mysqli_fetch_assoc($result)) {
                                echo "<tr>";
                                echo "<td><b>" . $row['id'] . ":</b></td>";
                                echo "<td>" . $row['page_name'] . "</td>";
                                // Each number has a textarea for editing
                                echo "<td>
                                    <textarea class='form-control mb-2' name='numbers[" . $row['id'] . "]' required>" . base64_decode($row['marquee_text']) . "</textarea>
                                </td>";
                                echo "</tr>";
                            }
                        } else {
                            echo "<tr><td colspan='3'>No numbers found</td></tr>";
                        }
                        ?>
                    </table>
                    <input type="submit" class="btn btn-secondary mx-3" name="update" value="Update All">
                </form>
            </div>
        </div>
    </main>

<?php include_once("footer.php"); ?>
    
    <script>
        $(document).ready(function () {
            // Set active class on the appropriate navigation link
            $('a.nav-main-link').removeClass("active");
            $('a.update_marquee').addClass("active");
        });
    </script>
</body>
</html>

<?php 
// Close the database connection here, at the end of your script
mysqli_close($conn); 
?>