1#@!#!123s

file_get_contents 1#@!#!123s
: / home / ujaneybc / jogiagroup.com / admin /
Filename : sub-category-list.php
back
<?php include'loginQuery/session_start.php';
include'dbc.php';
$pageTitle="List of Area Level 3";
$pageName="Area Level 3 List";
$tableName="tbl_sub_category";
$addPageUrl="sub-category.php";
$deleteMode="deleteSubCategory";

?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
            <meta content="width=device-width, initial-scale=1.0" name="viewport">
                <meta content="IE=edge" http-equiv="X-UA-Compatible">
                    <!-- Page title -->
                    <title>
                        <?php echo $pageTitle;?>
                    </title>
                    <!-- Place favicon.ico and apple-touch-icon.png in the root directory -->
                    <!--<link rel="shortcut icon" type="image/ico" href="favicon.ico" />-->
                    <!-- Vendor styles -->
                    <?php include'include/header-file.php';?>
					<!--select feild css-->                    
					<link rel="stylesheet" href="vendor/select2-3.5.2/select2.css" />
                    <link rel="stylesheet" href="vendor/select2-bootstrap/select2-bootstrap.css" />
				    <link rel="stylesheet" href="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.css" />
                    
                         <?php include'message.php';?>


                </meta>
            </meta>
        </meta>
        <style>
		.small-header .panel-body h2 {
		margin-top:3px;
		}
		.hbreadcrumb {
		margin-top:0;
		}
		
        </style>
    </head>
    
    <body>
        <!-- Simple splash screen-->
       
        <!--[if lt IE 7]>
<p class="alert alert-danger">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your experience.</p>
<![endif]-->
        <!-- Header -->
        <?php include'include/header.php';?>
        <!-- Header End-->

        <!-- Navigation -->
        <?php include'include/side-menu.php';?>
        <!-- Navigation -->
        
        <!-- Main Wrapper -->
        <div id="wrapper">
<!----------------start top normal header--------------------->
	<div class="small-header">
        <div class="hpanel">
            <div class="panel-body">
                <div id="hbreadcrumb" class="pull-right">
                    <ol class="hbreadcrumb ">
                        <li><a class="btn btn-danger" href="<?php echo $addPageUrl?>"><strong>Add New Sub Category</strong></a></li>
                        
                    </ol>
                </div>
                <h2 class="font-light m-b-xs">
               <?php echo $pageName;?>
               
            </h2>
            <small><?php echo $pageTitle;?></small>
            </div>
        </div>
    </div>
<!----------------end top normal header--------------------->        

<!--model window-->

<!--model window-->
        
        
            <div class="content ">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="hpanel">
                            <div class="panel-heading">
                                <div class="panel-tools">
                                    <!--<a class="showhide">
                                        <i class="fa fa-chevron-up">
                                        </i>
                                    </a>
                                    <a class="closebox">
                                        <i class="fa fa-times">
                                        </i>
                                    </a>-->
                                </div>
                                
                            </div>
                            <div class="panel-body">
                            
                            <!---------------------------
                            
                        <br>
                        <div class="panel-body">
 <!------------------------------------------------>     
  <?php 
  

  		$queryString="";
	   $typeString="";
	   if(isset($_GET['search'])){
	   	$queryString.="where sku='$search'";
	   }
	   
	   ?>
       
      
       <!--<input type="hidden" id="getbackurl" value="<?php //echo $finalBackURL;?>">-->
       <input type="hidden" id="getquerystring" value="<?php echo $queryString;?>">
 
 <style type="text/css">
 .getstatus{ margin:10px; cursor:pointer}
  .l{ margin-right:10px; cursor:pointer}
 </style>    
 <div style="float:left">
 
 </div>
 <?php  
$limit = 50;  
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };  
$start_from = ($page-1) * $limit;  
//======================================				
$rs_result = mysqli_query($conn,"SELECT COUNT(id) FROM  $tableName $queryString ") or die(mysqli_error());  
$row = mysqli_fetch_row($rs_result);  
$total_records = $row[0];  
echo  " Total Record ".$total_records2 = $row[0];  
$total_pages = ceil($total_records / $limit);  
$pagLink = "<nav style='float:right'><ul class='pagination'>";  
for ($i=1; $i<=$total_pages; $i++) {  
             $pagLink .= "<li><a href='tbl_banner-list.php?page=".$i."'>".$i."</a></li>";  
};  
echo $pagLink . "</ul></nav>";  
?>        

<?php 
// $sql=mysqli_query($conn,"select * from tbl_course")or die(mysqli_error());
// while($row=mysqli_fetch_assoc($sql))
// {
//     $courseNameAry[$row['id']]=$row['name'];
// }
// SELECT s.id,s.name,c.name as subject_name, s.course_id FROM tbl_subject s,tbl_course c WHERE c.id=s.course_id
// SELECT count(*) as total_question FROM `tbl_raw_question` WHERE course_id=4 and subject_id=5


/*SELECT s.id,s.name,c.name as course_name, s.course_id ,
(SELECT count(*) as total_question FROM `tbl_raw_question` WHERE course_id=s.course_id and subject_id=s.id) as total_question 

FROM tbl_subject s,tbl_course c WHERE c.id=s.course_id*/
$sqlC=mysqli_query($conn,"select * from tbl_category ") or die(mysqli_error($conn));
while($rows=mysqli_fetch_assoc($sqlC)){
    $categoryNameAry[$rows['id']]=$rows['name'];
}
?>
<div class="clearfix"></div>    

   <div id="showrecord">                                  
                                
					<table cellpadding="1" cellspacing="1" class="table table-bordered table-striped">
                    <thead>
                    <tr>
                        <th width="30">#</th>
                        <th width="300">Category Name</th>
                        <th width="300">Sub Category Name</th>
                        <th width="40">Order</th>
                        <th width="120">Control</th>
                    </tr>
                    </thead>
                    <tbody>
                   <?php  
				   $i=1;
                   
                   $sql=mysqli_query($conn,"select * from  $tableName $queryString order by id desc");
                    while($row=mysqli_fetch_assoc($sql))
                {
                    extract($row);
				?>
                    <tr>
                        <td><?php echo $i++;?></td>
                        <td><?php echo $categoryNameAry[$category_id];?></td>
                         <td><?php echo $name;?></td>
                        <td><?php echo $order_number;?></td>
                        <td style="position:relative">	
                       <a class="dropdown-toggle" href="#" data-toggle="dropdown"><strong>Action</strong></a>
                    		<ul class="dropdown-menu animated flipInX m-t-xs" role="menu" style="top:0;">
                                <!-- <li><a href="raw-question.php?sid=<?php echo $id;?>&cid=<?php echo $course_id;?>"><i class="fa fa-plus"> </i> Add Question</a></li> -->
                                <li><a href="<?php echo $addPageUrl ?>?id=<?php echo $id;?>"><i class="fa fa-pencil"> </i> Edit</a></li>
                                <li><a class="demo3" path="dataQuery/process.php?action2=<?php echo $deleteMode ?>&id=<?php echo $id?>" ><i class="fa fa-trash"> </i> Remove</a></li>
                                <li class="divider"></li>
                                <li><a ><i class="fa "> </i> Cancel</a></li>
                            </ul>
                    </td>
					</tr>
                    <?php }?>
                    </tbody>
                </table>
				
 
                            </div>
                            
                            <?php  echo $pagLink . "<ul></ul>";  ?>  
                            
                            
                        </div>
                    </div>
                </div>
            </div>
            
            <!-- Footer-->
         



 <?php include'include/footer-file.php';?>

<!--select feild css-->                    
<script src="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.js"></script>
<script src="vendor/select2-3.5.2/select2.min.js"></script>

 






<!-- App scripts -->


    </body>
</html>
<link rel="stylesheet" href="vendor/sweetalert/lib/sweet-alert.css" />
<script src="vendor/sweetalert/lib/sweet-alert.min.js"></script>

    <script>

   $(document).on('click','.demo3',function(){
		var path=$(this).attr('path');

            swal({
                        title: "Are you sure?",
                        text: "Your will not be able to recover this imaginary file!",
                        type: "warning",
                        showCancelButton: true,
                        confirmButtonColor: "#DD6B55",
                        confirmButtonText: "Yes, delete it!"
                    },
                    function () {
                        window.location.href=path
                    });
    });

</script>

<script type="text/javascript">
//======================= add name start ==================================*/

//======================= add name end ==================================*/
$(document).on('click','.page-link',function(){
	var pageID=$(this).attr("pageid");
	var status=$(this).attr("pageid2");
	var getbackurl=$("#getbackurl").val();
	
	$("#showrecord").html('<center><i  class="fa fa-spinner fa-spin" aria-hidden="true"></i></center>');
	var cid= $("#applicationid").val();
	var getquerystring= $("#getquerystring").val();

		$.ajax({
			type: "POST",
			url: "function/getBrandPageList.php",
			data: "pageID="+ pageID+"&getquerystring="+getquerystring,
			success: function(html){

			$("#showrecord").html(html);
		}
	});
	return false;
});
</script>

<!--<script type="text/javascript" charset="utf8" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-2.0.3.js"></script>-->


<script type="text/javascript">

$(document).ready(function(){
$('.pagination').pagination({
        items: <?php echo $total_records;?>,
        itemsOnPage: <?php echo $limit;?>,
        cssStyle: 'light-theme',
		currentPage : <?php echo $page;?>,
		hrefTextPrefix : 'brands-list.php?page='
    });
	});
</script>
<link rel="stylesheet" href="dist/simplePagination.css" />
<script src="dist/jquery.simplePagination.js"></script>

<script>

    $(function(){

        

        $("#form_2").validate({
            rules: {
                name: {
                    required: true,
                    minlength: 3
                },
                username: {
                    required: true,
                    minlength: 5
                },
                url: {
                    required: true,
                    url: true
                },
                number: {
                    required: true,
                    number: true
                },
                last_name: {
                    required: true,
                    minlength: 6
                }
            },
            messages: {
                number: {
                    required: "(Please enter your phone number)",
                    number: "(Please enter valid phone number)"
                },
                last_name: {
                    required: "This is custom message for required",
                    minlength: "This is custom message for min length"
                }
            },
            submitHandler: function(form) {
                form.submit();
            },
            errorPlacement: function(error, element) {
                $( element )
                        .closest( "form" )
                        .find( "label[for='" + element.attr( "id" ) + "']" )
                        .append( error );
            },
            errorElement: "span",
        });


    });
</script>
 <script>

        $(function(){

            $('#datepicker').datepicker();
            $("#datepicker").on("changeDate", function(event) {
                $("#my_hidden_input").val(
                        $("#datepicker").datepicker('getFormattedDate')
                )
            });

            $('#datapicker2').datepicker();
            $('.input-group.date').datepicker({ });
            $('.input-daterange').datepicker({ });

            $("#demo1").TouchSpin({
                min: 0,
                max: 100,
                step: 0.1,
                decimals: 2,
                boostat: 5,
                maxboostedstep: 10,
            });

            $("#demo2").TouchSpin({
                verticalbuttons: true
            });

            $("#demo3").TouchSpin({
                postfix: '%'
            });

            $("#demo4").TouchSpin({
                postfix: "a button",
                postfix_extraclass: "btn btn-default"
            });

            $(".js-source-states").select2();
            $(".js-source-states-2").select2();

            //turn to inline mode
            $.fn.editable.defaults.mode = 'inline';

            //defaults
            $.fn.editable.defaults.url = '#';

            //editables
            $('#username').editable({
                url: '#',
                type: 'text',
                pk: 1,
                name: 'username',
                title: 'Enter username'
            });

            $('#firstname').editable({
                validate: function(value) {
                    if($.trim(value) == '') return 'This field is required';
                }
            });

            $('#sex').editable({
                prepend: "not selected",
                source: [
                    {value: 1, text: 'Male'},
                    {value: 2, text: 'Female'}
                ],
                display: function(value, sourceData) {
                    var colors = {"": "gray", 1: "green", 2: "blue"},
                            elem = $.grep(sourceData, function(o){return o.value == value;});

                    if(elem.length) {
                        $(this).text(elem[0].text).css("color", colors[value]);
                    } else {
                        $(this).empty();
                    }
                }
            });

            $('#dob').editable();

            $('#event').editable({
                placement: 'right',
                combodate: {
                    firstItem: 'name'
                }
            });

            $('#comments').editable({
                showbuttons: 'bottom'
            });

            $('#fruits').editable({
                pk: 1,
                limit: 3,
                source: [
                    {value: 1, text: 'banana'},
                    {value: 2, text: 'peach'},
                    {value: 3, text: 'apple'},
                    {value: 4, text: 'watermelon'},
                    {value: 5, text: 'orange'}
                ]
            });

            $('#user .editable').on('hidden', function(e, reason){
                if(reason === 'save' || reason === 'nochange') {
                    var $next = $(this).closest('tr').next().find('.editable');
                    if($('#autoopen').is(':checked')) {
                        setTimeout(function() {
                            $next.editable('show');
                        }, 300);
                    } else {
                        $next.focus();
                    }
                }
            });

            // ClockPicker
            $('.clockpicker').clockpicker({autoclose: true});

            // DateTimePicker
            $('#datetimepicker1').datetimepicker();

        });

    </script>