<h2>Edit File - dappointment1.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u616847985/domains/dial4healthcare.com/public_html/dial-admin/dappointment1.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include_once(&quot;lock.php&quot;);
include &quot;header.php&quot;;
?&gt;
&lt;link rel=&quot;stylesheet&quot; href=&quot;//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css&quot;&gt;
&lt;script src=&quot;//code.jquery.com/jquery-1.10.2.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;//code.jquery.com/ui/1.11.4/jquery-ui.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
  $(function() {
    $( &quot;#skills&quot; ).autocomplete({
      source: &#039;ajax_search.php&#039;
    });
  });
&lt;/script&gt;
&lt;body data-page=&quot;tables_dynamic&quot;&gt;
&lt;?php
include &quot;top.php&quot;;
?&gt;
&lt;div id=&quot;wrapper&quot;&gt;
  &lt;?php
include &quot;left.php&quot;;
?&gt;
  &lt;div id=&quot;main-content&quot;&gt;
    &lt;div class=&quot;page-title&quot;&gt; &lt;i class=&quot;icon-custom-left&quot;&gt;&lt;/i&gt; &lt;/div&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-heading bg-blue&quot;&gt;
            &lt;h3 class=&quot;panel-title&quot;&gt;&lt;a class=&quot;btn btn-default fl-right&quot; href=&#039;index1.php&#039;&gt;Back&lt;/a&gt;
              &lt;center&gt;
                List Of All Doctor Appointments
              &lt;/center&gt;
            &lt;/h3&gt;
            &lt;form method=&quot;post&quot; action=&quot;dappointment1.php&quot;&gt;
              &lt;div class=&quot;col-sm-1&quot;&gt;&lt;label&gt;From Date : &lt;/label&gt;&lt;/div&gt;
                  &lt;div class=&quot;col-sm-2&quot;&gt;
                &lt;input type=&quot;date&quot; name=&quot;from&quot; class=&quot;form-control&quot; placeholder=&quot;From Date&quot; required&gt;
              &lt;/div&gt;
              &lt;div class=&quot;col-sm-1&quot;&gt;&lt;label&gt;To Date : &lt;/label&gt;&lt;/div&gt;
              &lt;div class=&quot;col-sm-2&quot;&gt;
                &lt;input type=&quot;date&quot; name=&quot;to&quot; class=&quot;form-control&quot; placeholder=&quot;To Date&quot; required&gt;
              &lt;/div&gt;
              &lt;div class=&quot;col-sm-2&quot;&gt;
                &lt;input type=&quot;text&quot; name=&quot;doctor&quot; class=&quot;form-control&quot; id=&quot;skills&quot; placeholder=&quot;Doctor Name&quot; required&gt;
              &lt;/div&gt;
              &lt;input type=&quot;submit&quot; name=&quot;search&quot; value=&quot;Search&quot; class=&quot;btn btn-danger m-b-10&quot;&gt;
            &lt;/form&gt;
          &lt;/div&gt;
          &lt;div class=&quot;panel-body&quot;&gt;
            &lt;div class=&quot;row&quot;&gt;
              &lt;div class=&quot;col-md-12 col-sm-12 col-xs-12 table-responsive table-red&quot;&gt;
                &lt;div class=&quot;ui-widget&quot;&gt; &lt;/div&gt;
                &lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; class=&quot;table table-striped table-hover table-dynamic&quot;&gt;
                  &lt;thead&gt;
                    &lt;tr&gt;
                      &lt;th&gt;Name&lt;/th&gt;
                      &lt;th&gt;Contact&lt;/th&gt;
                      &lt;th&gt;Doctor Name&lt;/th&gt;
                      &lt;th&gt;Referred By Dr&lt;/th&gt;
                      &lt;th&gt;Appointment Date&lt;/th&gt;
                      &lt;th&gt;Timing&lt;/th&gt;
                      &lt;th&gt;Comment&lt;/th&gt;
                      &lt;th class=&quot;text-center&quot;&gt;Option&lt;/th&gt;
                    &lt;/tr&gt;
                  &lt;/thead&gt;
                  &lt;?php
include(&#039;classes/db.php&#039;);
$id=$_GET[&quot;id&quot;];
$sql = &quot;DELETE FROM appointment1 WHERE id=&#039;$id&#039;&quot;;
if ($db-&gt;query($sql) === TRUE) {

    echo &quot;Record deleted successfully&quot;;
}
?&gt;
                  &lt;form method=&quot;post&quot; action=&quot;&quot;&gt;
&lt;?php
$from=$_POST[&quot;from&quot;];
$to=$_POST[&quot;to&quot;];
$doctor=$_POST[&quot;doctor&quot;];
$result = $db-&gt;prepare(&quot;SELECT * FROM appointment1 where doctor=&#039;$doctor&#039; and adate between &#039;$from&#039; and &#039;$to&#039; ORDER BY id DESC&quot;);
$result-&gt;execute();
for($i=1; $row = $result-&gt;fetch(); $i++){
?&gt;
                    &lt;tbody&gt;
                      &lt;tr&gt;
                        &lt;td&gt;&lt;?php echo $row[&#039;name&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $row[&#039;mobile&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $row[&#039;doctor&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $row[&#039;preferred&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo date(&quot;d-M-Y&quot;,strtotime($row[&#039;adate&#039;])); ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $row[&#039;atime&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td&gt;&lt;?php echo $row[&#039;comment&#039;]; ?&gt;&lt;/td&gt;
                        &lt;td class=&quot;text-center&quot;&gt;&lt;a class=&quot;delete confirmation&quot; title=&quot;Delete&quot; href=&quot;dappointment1.php?id=&lt;?php echo $row[&#039;id&#039;]; ?&gt;&quot;&gt;&lt;i class=&quot;fa fa-trash-o&quot;&gt;&lt;/i&gt;&lt;/a&gt;&amp;nbsp;&amp;nbsp; &lt;/td&gt;
                      &lt;/tr&gt;
                      &lt;?php
					}
					?&gt;
                  &lt;/form&gt;
                  &lt;script type=&quot;text/javascript&quot;&gt;
    var elems = document.getElementsByClassName(&#039;confirmation&#039;);
    var confirmIt = function (e) {
        if (!confirm(&#039;Are you want to delete this?&#039;)) e.preventDefault();
    };
    for (var i = 0, l = elems.length; i &lt; l; i++) {
        elems[i].addEventListener(&#039;click&#039;, confirmIt, false);
    }
&lt;/script&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;/div&gt;
&lt;/div&gt;
&lt;script src=&quot;assets/plugins/jquery-1.11.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/jquery-migrate-1.2.1.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/jquery-ui/jquery-ui-1.10.4.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/bootstrap/bootstrap.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/bootstrap-dropdown/bootstrap-hover-dropdown.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/bootstrap-select/bootstrap-select.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/mcustom-scrollbar/jquery.mCustomScrollbar.concat.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/mmenu/js/jquery.mmenu.min.all.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/nprogress/nprogress.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/charts-sparkline/sparkline.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/breakpoints/breakpoints.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/plugins/numerator/jquery-numerator.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/js/application.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
    $(&#039;#checkAll&#039;).click(function () {    
    $(&#039;:checkbox.checkItem&#039;).prop(&#039;checked&#039;, this.checked);    
 });
&lt;/script&gt;
&lt;/body&gt;
&lt;/html&gt;</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/dial-admin/image/doctor/10471754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>