<h2>Edit File - listsscategory.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u616847985/domains/dial4healthcare.com/public_html/dial-admin/listsscategory.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;;

if ($_POST[&quot;search&quot;]){
    if ($_POST[&quot;status&quot;]!==&quot;&quot;){
 $where .=&quot;where action=&#039;$_POST[status]&#039;&quot;;
    } else {
    }
}
?&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;category.php&#039;&gt;Back&lt;/a&gt; &lt;a class=&quot;btn btn-default fl-left&quot; style=&quot;margin:0 0 -37px 0&quot; href=&#039;excel/index.php?sscategory&#039;&gt;Export To Excel&lt;/a&gt; &lt;center&gt;List Of Sub Sub Categories&lt;/center&gt;&lt;/h3&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;form method=&quot;post&quot; action=&quot;&quot; style=&quot;float:left; width:75%&quot;&gt;
                    &lt;select name=&quot;status&quot;&gt;
                        &lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
                        &lt;option value=&quot;&quot;&gt;All&lt;/option&gt;
                        &lt;option value=&quot;1&quot;&gt;Active&lt;/option&gt;
                        &lt;option value=&quot;0&quot;&gt;Deactive&lt;/option&gt;
                    &lt;/select&gt;
                    &lt;input class=&quot;btn btn-primary m-b-10&quot; type=&quot;submit&quot; value=&quot;Search&quot; name=&quot;search&quot;&gt;
                &lt;/form&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 style=&quot;width:20px;&quot;&gt;Check All &lt;br&gt;&lt;input type=&quot;checkbox&quot; id=&quot;checkAll&quot; &gt;&lt;/th&gt;
                      &lt;th style=&quot;width:20px;&quot;&gt;Sr No&lt;/th&gt;
                      &lt;th&gt;Category&lt;/th&gt;
                      &lt;th&gt;Sub Category&lt;/th&gt;
                      &lt;th&gt;Sub Sub Category&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 sscategory WHERE id=&#039;$id&#039;&quot;;
if ($db-&gt;query($sql) === TRUE) {

    echo &quot;Record deleted successfully&quot;;
}
if (isset($_POST[&quot;delete&quot;])){
    $len = count($_POST[&#039;cid&#039;]);
    for ($i=0; $i &lt; $len; $i++)
    {

foreach ($_POST[&#039;cid&#039;] as $i=&gt;$cid) {

$result1 = $db-&gt;prepare(&quot;DELETE FROM sscategory WHERE id=&#039;$cid&#039;&quot;);
$result1-&gt;execute();
}
}
echo &quot;&lt;script language=&#039;javascript&#039;&gt;
           window.alert(&#039;Deleted Successfully.&#039;);
           window.location.href=&#039;listsscategory.php&#039;;
      &lt;/script&gt;&quot;;
}
if (isset($_POST[&quot;deactive&quot;])){
    $len = count($_POST[&#039;cid&#039;]);
    for ($i=0; $i &lt; $len; $i++)
    {

foreach ($_POST[&#039;cid&#039;] as $i=&gt;$cid) {

    $sql1 = $db-&gt;prepare(&quot;UPDATE sscategory set action=&#039;0&#039; where id=&#039;$cid&#039;&quot;);
    $sql1-&gt;execute();
}
}
echo &quot;&lt;script language=&#039;javascript&#039;&gt;
           window.alert(&#039;Deactivated Successfully.&#039;);
           window.location.href=&#039;listsscategory.php&#039;;
      &lt;/script&gt;&quot;;
}
if (isset($_POST[&quot;active&quot;])){
    $len = count($_POST[&#039;cid&#039;]);
    for ($i=0; $i &lt; $len; $i++)
    {

foreach ($_POST[&#039;cid&#039;] as $i=&gt;$cid) {

    $sql1 = $db-&gt;prepare(&quot;UPDATE sscategory set action=&#039;1&#039; where id=&#039;$cid&#039;&quot;);
    $sql1-&gt;execute();
}
}
echo &quot;&lt;script language=&#039;javascript&#039;&gt;
           window.alert(&#039;Activated Successfully.&#039;);
           window.location.href=&#039;listsscategory.php&#039;;
      &lt;/script&gt;&quot;;
}										
?&gt;
&lt;form method=&quot;post&quot; action=&quot;&quot;&gt;
&lt;?php
$result = $db-&gt;prepare(&quot;SELECT * FROM sscategory $where ORDER BY id ASC&quot;);
$result-&gt;execute();
for($i=1; $row = $result-&gt;fetch(); $i++){
$result1 = $db-&gt;prepare(&quot;SELECT * FROM category where id=&#039;$row[category_name]&#039;&quot;);
$result1-&gt;execute();
$row1 = $result1-&gt;fetch();
$result2 = $db-&gt;prepare(&quot;SELECT * FROM scategory where id=&#039;$row[scategory_id]&#039;&quot;);
$result2-&gt;execute();
$row2 = $result2-&gt;fetch();
?&gt;
                  &lt;tbody&gt;
                    &lt;tr&gt;
                      &lt;td style=&quot;width:20px;&quot;&gt;&lt;input type=&quot;checkbox&quot; value=&quot;&lt;?php echo $row[&#039;id&#039;]; ?&gt;&quot; name=&quot;cid[]&quot; class=&quot;checkItem&quot;&gt; &lt;/td&gt;
                      &lt;td style=&quot;width:20px;&quot;&gt;&lt;?php echo $i; ?&gt;&lt;/td&gt;
                      &lt;td&gt;&lt;?php echo $row1[&#039;category_name&#039;]; ?&gt;&lt;/td&gt;
                      &lt;td&gt;&lt;?php echo $row2[&#039;scategory_name&#039;]; ?&gt;&lt;/td&gt;
                      &lt;td&gt;&lt;?php echo $row[&#039;sscategory_name&#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;listsscategory.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;?php if ($row[&quot;action&quot;]==&quot;1&quot;) { ?&gt; &lt;a href=&quot;status/sscategory.php?sscategory=1&amp;id=&lt;?php echo $row[&#039;id&#039;]; ?&gt;&quot; onClick=&quot;return confirm(&#039;Really you want to Deactivate (&lt;?php echo $row[&#039;sscategory_name&#039;];?&gt;)&#039;);&quot;&gt;Activated&lt;/a&gt; &lt;?php } else { ?&gt; &lt;a href=&quot;status/sscategory.php?sscategory=0&amp;id=&lt;?php echo $row[&#039;id&#039;]; ?&gt;&quot; onClick=&quot;return confirm(&#039;Really you want to Activate (&lt;?php echo $row[&#039;sscategory_name&#039;];?&gt;)&#039;);&quot;&gt;Deactive&lt;/a&gt; &lt;?php } ?&gt;
                      &lt;/td&gt;
                    &lt;/tr&gt;
                    &lt;?php
					}
					?&gt;
					&lt;input class=&quot;btn btn-primary m-b-10&quot; type=&quot;submit&quot; value=&quot;Delete&quot; name=&quot;delete&quot; onClick=&quot;return confirm(&#039;Are you sure You want to delete?&#039;)&quot;&gt; &amp;nbsp;
					&lt;?php if ($_POST[&quot;status&quot;]==&quot;1&quot;) { ?&gt; &lt;input class=&quot;btn btn-primary m-b-10&quot; type=&quot;submit&quot; value=&quot;Deactive&quot; name=&quot;deactive&quot; onClick=&quot;return confirm(&#039;Are you sure You want to Deactivate?&#039;)&quot;&gt; &lt;?php } else { ?&gt;
					&lt;input class=&quot;btn btn-primary m-b-10&quot; type=&quot;submit&quot; value=&quot;Active&quot; name=&quot;active&quot; onClick=&quot;return confirm(&#039;Are you sure You want to Activate?&#039;)&quot;&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>