MAINHACK

Viewing / Editing File: add_sub_category.php

<?php
include('header.php');

?>
		<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
			<div class="row">	
<div class="col-md-6">
<div class="card">
	<div class="card-header">
		<div class="card-title">Add Sub Category</div>
	</div>
 	<form method="post" id="exampleValidation" data-toggle="validator" enctype="multipart/form-data" >

<div class="card-body">
		<div class="form-group"> 
                						
     <div class="col-md-6">
        	<label>Category</label>
        				    
      <select  name="category" id="category" class="form-control" required>
        <option value="">Category</option>          				
        <?php  
        $table1='category';
        $stmt=$show->readAll($table1);
        $num=$stmt->rowCount();
        if($num>0){
        while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
        
        echo "<option value='".$row['category']."'";if($state==$row['category']) echo "selected"; echo ">".$row['category']."</option>";	}
        
        }
        
        ?>
        </select>	
                </div>
						</div> 
		
		    <div class="form-group form-show-validation row">
				<label for="name" class="col-lg-3 col-md-3 col-sm-4 mt-sm-2 text-right">Sub-Category Name <span class="required-label">*</span></label>
				<div class="col-lg-8 col-md-9 col-sm-8">
					<input type="text" class="form-control" name="sub_category" placeholder="Sub-Category Name " required>
				</div>
			</div>
			
		
		<div class="card-action">
			<div class="row">
				<div class="col-md-12">
					<input class="btn btn-success" type="submit" name="sub" value="Submit">
					<button class="btn btn-danger">Cancel</button>
				</div>										
			</div>
		</div>

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

<?php
if(isset($_POST['sub'])){

$data=array(
    'category'=>htmlentities(strip_tags($_POST['category'])),
    'sub_category'=>htmlentities(strip_tags($_POST['sub_category'])),
	);
	$r1=$show->insert('sub_category',$data);
 if($r1){
 echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You!",
            text: "sub category has been added",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
 //echo "<script>swal('Thank you for Registration.');window.location.href='".$_SERVER['request_uri']."';</script>";
 }

}
?>	
	
   	
<div class="col-md-6">							<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
											<h5 class="page-title">All Sub Category</h5>

<table id="basic-datatables" class="display table table-striped table-hover">
							<thead>
								<tr>  
								  <th>Sl</th>
								  <th>Category</th>
								  <th>Sub-Category</th>
								 
								
								  <th>Delete</th>
								</tr>
							    </thead>
							   <tbody>

<?php
			
$sr='sub_category';
$stmt =$show->readAll($sr);
$num = $stmt->rowCount();
     
     if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];       
     
								echo "<tr>
							    <td>$count</td>
								<td>".$row['category']."</td>								
								<td>".$row['sub_category']."</td>								
															
								"
 								;
 								?>
 							<td>
							<button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove">
							<a href="delete.php?id=<?=$id?>&table=<?=$sr?>&url=<?=$_SERVER['REQUEST_URI']?>"  class="btn btn-link btn-danger"onclick="return send();"><i class='la la-times'></i></a>	
							</button>
							</td>
								<?php echo"</tr>";

++$count;
 }
}

?>							
</tbody></table>								
									
									</div>
				
									</div>
								</div>
	</div>
  
		
			</div>
			</div>
		
		
		<?php 
		
		include('footer.php');
		?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add_sub_category.php

Server Info

System Features

User Info