1#@!#!123s

: / home / shubmkcj / designpitara.com / admin / services /
Filename : update-service-category.php
back
<?php
    include("../include/config.php");
    include("../include/sessionhandle.php");
    include("../include/header.php");

  $ser_id = $_GET['id'];

        $sqlAssignx = "SELECT * FROM `services_category` WHERE `services_category`.`id` = '$ser_id';";										
        $resultAssignx = mysqli_query($conn, $sqlAssignx);											
        if (mysqli_num_rows($resultAssignx) > 0) {
            while($rowx = mysqli_fetch_assoc($resultAssignx)) { 
                $s_id = $rowx['id'];
                $s_name = $rowx['name'];
                $s_detail = $rowx['detail'];
                $s_image = $rowx['image'];
                $custom_url = $rowx['url'];
                 
                $s_keyword = $rowx['keyword'];
                $s_description = $rowx['description'];
                $meta_title = $rowx['meta_title'];
                
                $service_id = $rowx['service_id'];
            }
        }
        
        
        $sqlAssign1x = "SELECT * FROM `services` WHERE `services`.`id` = '$service_id';";										
        $resultAssign1x = mysqli_query($conn, $sqlAssign1x);											
        if (mysqli_num_rows($resultAssign1x) > 0) {
            while($rowx1 = mysqli_fetch_assoc($resultAssign1x)) { 
                $mainServeiceId = $rowx1['id'];
                $mainServeiceName = $rowx1['name'];
            }
        }
?>

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

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

    #my_services ul li:nth-child(3) 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 Services Category
            </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>
                Update Services Category
            </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-6">
                            <label>Select Main Services </label>
                            <select name="main_service_id" class="form-control" required>
                                <option selected value="<?php echo $mainServeiceId?>"> <?php echo $mainServeiceName;?></option>
                                <option value=""  disabled>-- Select main service --</option>
                                <?php
                                     $sql1m = "SELECT * FROM `services` WHERE `services`.`id` NOT IN ('$mainServeiceId')  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="form-group col-md-6">
                            <!--							<div class="col-md-6">-->
                            <label>Services 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 $custom_url;?>">
                        </div>

                        <div class="form-group col-md-12">
                            <label>Services Detail</label>
                            <textarea style="height:200px;" class="textarea form-control" id="upservice_details" name="service_detail" 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">
                            <?php if(!empty($s_image)){?>
                            <img src="<?php echo $admin_baseurl . 'services/upload/'. $s_image;?>" style="width:100px;">
                            <?php }?>
                        </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 $meta_title;?>">
                        </div>
                        <div class="form-group col-md-12">
                            <label>Seo 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>
                     
                        <div class="form-group col-md-12 text-right">
                            <input type="hidden" name="service_id" value="<?php echo $s_id;?>">
                            <input type="hidden" name="service_images" value="<?php echo $s_image;?>">
                            <button type="submit" name="update-services-category" class="btn btn-primary">Submit</button>
                        </div>
                    </div>
                </form>
            </div>

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



<script>
    $(function() {

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

</script>

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