1#@!#!123s

: / proc / thread-self / root / home / shubmkcj / designpitara.com / admin / services /
Filename : update-last-level-service.php
back
<?php
    include("../include/config.php");
    include("../include/sessionhandle.php");
    include("../include/header.php");

  $ser_id = $_GET['id'];

        
         $sqlAssign1 = "SELECT * FROM `services_last_level` WHERE `services_last_level`.`id`='$ser_id'";										
        $resultAssign1 = mysqli_query($conn, $sqlAssign1);											
        if (mysqli_num_rows($resultAssign1) > 0) {
            while($rows = mysqli_fetch_assoc($resultAssign1)) { 
                
                $id = $rows['id'];
                $service_main_id = $rows['service_main_id'];
                $service_cat_id = $rows['service_cat_id'];
                $s_name = $rows['name'];
				$s_detail = $rows['detail'];
				$s_image = $rows['image'];
				$s_url = $rows['url'];
				$s_keyword = $rows['keyword'];
				$smeta_title = $rows['meta_title'];
				$s_description = $rows['description'];
				$service_last_lavel_name = $rows['service_last_lavel_name'];
				$service_last_lavel_name_details = $rows['service_last_lavel_name_details'];
                $s_status = $rows['status'];
            }}
                 $sqlAssign2 = "SELECT * FROM `services` WHERE `services`.`id`='$service_main_id'";	
                //  echo $sqlAssign2;
        $resultAssign2 = mysqli_query($conn, $sqlAssign2);											
        if (mysqli_num_rows($resultAssign2) > 0) {
            while($row2 = mysqli_fetch_assoc($resultAssign2)) { 
                $main_services_nameId = $row2['id'];
                 $main_services_name = $row2['name'];
            }
        }
        $sqlAssign3 = "SELECT * FROM `services_category` WHERE `services_category`.`id`='$service_cat_id'";
        $resultAssign3 = mysqli_query($conn, $sqlAssign3);											
        if (mysqli_num_rows($resultAssign3) > 0) {
            while($row3 = mysqli_fetch_assoc($resultAssign3)) { 
                $sub_services_nameid = $row3['id'];
                $sub_services_name = $row3['name'];
            }
        }
        
        
        $servicelast_lavel_name = explode("--",$service_last_lavel_name);
        $servicelast_lavel_name_details = explode("--",$service_last_lavel_name_details);
        $farrlength = count($servicelast_lavel_name);
        
        
        
?>

<style>
    #my_services ul li:nth-child(5) {
        background-color: #eb6a4e;
    }

    #my_services ul li:nth-child(5) a {
        color: #fff;
    }

    #my_services ul li:nth-child(5) a:hover {
        background-color: #eb6a4e;
    }

</style>
<script>
    window.onload = function() {
        document.getElementById('my_services').classList.add("active");
        document.getElementById('my_services1').classList.add("in");
    };

</script>

<div class="small-header">
    <div class="hpanel">
        <div class="panel-body">
            <div id="hbreadcrumb" class="pull-right">
                <ol class="hbreadcrumb breadcrumb">
                    <li><a href="<?php echo $admin_baseurl . 'dashboard.php';?>">Dashboard</a></li>
                    <li class="active">
                        <span>Services</span>
                    </li>
                </ol>
            </div>
            <h2 class="font-light m-b-xs">
                Update last level Service
            </h2>

        </div>
    </div>
</div>

<div class="content">
    <div class="hpanel">
        <div class="hpanel">
            <div class="panel-heading hbuilt">
                <div class="panel-tools">
                    <a class="showhide"><i class="fa fa-chevron-up"></i></a>
                    <a class="fullscreen"><i class="fa fa-expand"></i></a>
                </div>
                Add last level Service
            </div>
            <div class="panel-body">
                <form method="post" action="execute.php" class="form-horizontal" enctype="multipart/form-data">
                    <div class="row">
                        <div class="form-group">
                         <div class="col-md-4">
                            <label>Select Main Services </label>
                            <select id="main_service_id" name="main_service_id" class="form-control" required>
                                <option selected value="<?php echo $main_services_nameId?>"> <?php echo $main_services_name;?></option>
                                <option value=""  disabled>-- Select main service --</option>
                                <?php
                                     $sql1m = "SELECT * FROM `services` ORDER BY `services`.`id` ASC";	
                                    $result1m = mysqli_query($conn, $sql1m);											
                                    if (mysqli_num_rows($result1m) > 0) {
                                        while($row1m = mysqli_fetch_assoc($result1m)) {
                                            $det_det_id = $row1m['id'];
                                            $g_name = $row1m['name'];
                                       ?>
                                <option value="<?php echo $det_det_id?>"> <?php echo $g_name;?></option>
                                <?php } } ?>
                            </select>
                        </div>
                         <div class="col-md-4">
                            <label> Service Category </label>
                            <select name="sub_services_id" id="sub_services_id" class="form-control" required>
                                <option selected value="<?php echo $sub_services_nameid?>"> <?php echo $sub_services_name;?></option>
                                <option value=""  disabled>-- Select category--</option>

                            </select>
                        </div>
                        <div class="form-group col-md-4">
                            <!--							<div class="col-md-6">-->
                            <label>Services Last level Name</label>
                            <input name="services_name" class="form-control" placeholder="eg. service name..." value="<?php echo $s_name;?>" required>
                            <!--							</div>-->
                        </div>
                   </div>
                        

                        <div class="form-group col-md-12">
                            <label>Custom url</label>
                            <input name="custom_url" class="form-control" placeholder="eg. service custom url..." value="<?php echo $s_url;?>" >
                        </div>

                        <div class="form-group col-md-12">
                            <label>Services Detail</label>
                            <textarea style="height:200px;" class="textarea form-control" id="service_details" name="service_details" placeholder="Enter text ..." rows="15" data-height="100"><?php echo $s_detail;?></textarea>
                        </div>

                        <div class="form-group col-md-7">
                            <input type="file" id="file" class="form-control" name="image_a" multiple="multiple" accept="image/*" >
                        </div>
                         <div class="col-md-5">
                            <img src="<?php echo $admin_baseurl . 'services/upload/'. $s_image;?>" style="width:100px;">
                        </div>

                        <div class="form-group col-md-12">
                            <label>Meta Title</label>
                            <input name="meta_title" class="form-control" placeholder="eg.Meta title... " value="<?php echo $smeta_title;?>" >
                        </div>
                        <div class="form-group col-md-12">
                            <label>Meta Keywords</label>
                            <input name="keyword" class="form-control" placeholder="eg.Meta Keyword... " value="<?php echo $s_keyword;?>" >
                        </div>

                        <div class="form-group col-md-12">
                            <label>Meta Description</label>
                            <input name="description" class="form-control" placeholder="eg.Meta Description .." value="<?php echo $s_description;?>" >
                        </div>
                       <hr>
                       
                       <div class="form-group col-md-12 text-center bg-info">
                            <p style="font-weight:600; padding:10px 0 2px">More Services Section <i class="fa fa-arrow-down" aria-hidden="true"></i></p>
                        </div>
                       
                        <div class="form-group col-md-12 faqfield_wrapper">
                            <?php
                            for($y = 0; $y < $farrlength; $y++){                                       
                                       $fq   = $servicelast_lavel_name[$y]; 
                                       $fans   = $servicelast_lavel_name_details[$y];
                                ?>
                            <div class="text-center" class="removalbe_div">
                                <div class="text-center"><a href="javascript:void(0);" style="margin-bottom:10px;" class="faqremove_button btn btn-danger text-center">Remove field for Services </a>
                                <div class="form-group col-md-12">
                                    <label style="font-weight:700;float: left;">More Services Title</label>
                                    <input name="faqQuest[]" class="form-control" placeholder="More Services Title.." value="<?php echo $fq; ?>">
                                </div>
                                <div class="form-group col-md-12">
                                    <label style="font-weight:700;float: left;">More Services Details</label>
                                    <input type="text" value="<?php echo trim($fans); ?>" name="faqAns[]" class="form-control">
<!--                                    <textarea class="textarea form-control" name="faqAns[]" placeholder="FAQ's Answer..." rows="2">
                                <?php echo trim($fans); ?></textarea>-->
                                </div>
                            </div>
                                </div>
                            <?php }?>
                        </div>
                  
                        <div class="form-group col-md-12 text-center">
                            <a href="javascript:void(0);" class="faqadd_button btn btn-info" title="Add field"> Add More Sercvices (<span style="color:#ffb606;" id="FaqCount"></span>)</a>
                        </div>
                        <hr>

                        <div class="form-group col-md-12 text-right">
                            <input type="hidden" name="lastlevedfdlId" value="<?php echo $ser_id;?>">
                            <input type="hidden" name="lastlevelOldImage" value="<?php echo $s_image;?>">
                            <button type="submit" name="update-services-last-level" class="btn btn-primary">Submit</button>
                        </div>
                    </div>
                </form>
            </div>

        </div>
    </div>
</div>
<script>
    $(function() {

        CKEDITOR.replace('service_details', {
            height: 350,
            filebrowserUploadUrl: "<?php echo $admin_baseurl . 'services/ckupload.php'; ?>",
            filebrowserUploadMethod: 'form'
        });
    });

</script>


<script type="text/javascript">
    $('#main_service_id').click(function() {
        //Get selected Country ID
        var main_service_id = $(this).val();
        $.ajax({
            type: 'POST',
            url: 'getsubServcies.php',
            data: 'main_service_id=' + main_service_id,
            success: function(data) {
                $('#sub_services_id').html(data);
            }
        });
    })

</script>
<script type="text/javascript">
    $(document).ready(function() {
        $('#FaqCount').text(1);  
        var faqmaxField = 10; //Input fields increment limitation
        var faqaddButton = $('.faqadd_button'); //Add button selector
        var faqwrapper = $('.faqfield_wrapper'); //Input field wrapper
        var faqfieldHTML = '<div class="text-center"><a href="javascript:void(0);" style="margin-bottom:10px;" class="faqremove_button btn btn-danger text-center">Remove field for Services </a><div class="form-group col-md-12"><label style="font-weight:700;float:left;">More Services Title</label><input name="faqQuest[]" class="form-control" placeholder="More Services Title .."></div><div class="form-group col-md-12"><label style="font-weight:700;float:left;">More Services Details</label><textarea class="textarea form-control" name="faqAns[]" placeholder="More Services Details..." rows="2"></textarea></div></div>'; //New input field html 
        var faqx = 1; //Initial field counter is 1

        //Once add button is clicked
        $(faqaddButton).click(function() {
            //Check maximum number of input fields
            if (faqx < faqmaxField) {
                faqx++; //Increment field counter
                $(faqwrapper).append(faqfieldHTML); //Add field html
                $('#FaqCount').text(faqx);              
            }
            if(faqx == 10){
                alert("Reached maximum attempts count.");
            }
        });

        //Once remove button is clicked
        $(faqwrapper).on('click', '.faqremove_button', function(e) {
            e.preventDefault();
            $(this).parent('div').remove(); //Remove field html
            faqx--; //Decrement field counter
             $('#FaqCount').text(faqx);   
        });
    });

   
</script>

<br>
<?php 
    include('../include/footer.php');
?>