Gecko [ 36julay.space ]

Name	Size	Permission	Date
crystal	[ DIR ]	drwxr-xr-x	2025-09-10 21:35
dashboard	[ DIR ]	drwxr-xr-x	2025-09-11 17:10
dist	[ DIR ]	drwxr-xr-x	2025-09-12 06:21
faces	[ DIR ]	drwxr-xr-x	2025-09-10 16:42
smilies	[ DIR ]	drwxr-xr-x	2025-09-10 21:35
wp	[ DIR ]	drwxr-xr-x	2025-09-10 16:42
.htaccess	237 B	-rw-r--r--	2025-09-01 07:26
LucidaCalligraphyNewBold.woff	36.96 KB	-rw-r--r--	2023-12-20 13:06
bd_logo.png	14.52 KB	-rw-r--r--	2025-01-04 06:54
cardTokenName.txt	8 B	-rw-r--r--	2025-05-29 16:31
configuration.php	250 B	-rw-r--r--	2024-12-04 06:50
createLink.php	4.61 KB	-rw-r--r--	2024-11-14 09:25
deduction_amount.txt	2 B	-rw-r--r--	2025-08-20 19:12
footer.php	2.17 KB	-rw-r--r--	2024-11-15 15:08
htaccess.txt	126 B	-rw-r--r--	2025-08-20 10:17
index.php	59.06 KB	-rw-r--r--	2025-07-03 07:08
logo-mini.png	6.04 KB	-rw-r--r--	2024-12-04 07:12
logo-mini.svg	318 B	-rw-r--r--	2024-10-25 15:16
logo.png	18.1 KB	-rw-r--r--	2024-12-04 06:42
logo.svg	6.59 KB	-rw-r--r--	2024-10-25 15:16
main_logo.png	18.1 KB	-rw-r--r--	2024-12-04 06:52
media-button-music-2x.gif	12.27 KB	-rw-r--r--	2025-07-31 08:34
new-min-one.jpg	170.97 KB	-rw-r--r--	2024-11-06 06:57
new_server_one.jpg	75.98 KB	-rw-r--r--	2024-11-06 06:52
on_off.php	15.09 KB	-rw-r--r--	2024-11-17 07:16
ri_1.png	208.48 KB	-rw-r--r--	2025-01-04 06:54
server-bg-img-two.jpg	78.63 KB	-rw-r--r--	2024-11-06 07:07
smartTokenName.txt	8 B	-rw-r--r--	2025-05-29 16:31
update_marquee.php	4.88 KB	-rw-r--r--	2024-10-27 17:24
upload_animation.gif	88.87 KB	-rw-r--r--	2024-10-25 15:16
v_1.jpg	414.43 KB	-rw-r--r--	2024-11-06 11:08
v_2.jpg	385.8 KB	-rw-r--r--	2024-11-06 11:12
wp-blog-header.php	2.73 KB	-rw-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); 
?>