MAINHACK

Viewing / Editing File: add_material.php

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

?>
<script>
    
    $(document).ready(function(){
$("#category").change(function() {
var category = $('#category').val();
//alert(category);
if(category=="")
{
$("#display").html("");
}
else
{
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "category="+ category ,

success: function(html){
$("#display").html(html).show();
	$("#loader").hide();
$("#scate").hide();

}
});
}

});
});
    
</script>

<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 Material (Home Decor)</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-12">
            <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']."'";echo ">".$row['category']."</option>";	}
        
        }
        
        ?>
        </select>	
             </div>
      
            </div>   
            	<div class="form-group">
             <div  id="subc">
            <label>Sub Category</label>
            <select name="sub_cate" class="form-control" id="scate">
                <option name="">Choose</option>
            </select>
	
            <div id="display"></div>
             </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">Material <span class="required-label">*</span></label>
				<div class="col-lg-8 col-md-9 col-sm-8">
					<input type="text" class="form-control" name="material" placeholder="Material " 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'])){
  $table="type";
$col="type";
$data=htmlspecialchars(trim($_POST['type']));

//$r=$show->readwithdata($table,$col,$data);
//$num=$r->rowCount();

$sq="select * from material where sub_category='".$_POST['sub_category']."' and material='".$_POST['material']."'";//echo $sq;
$s1=$con->prepare($sq);
$s1->execute();
$num=$s1->rowCount();//echo $num;
if($num>0){
echo "<script>sweetAlert('Oops',' material Exists','error');</script>";
}else{
	$data=array(
    'material'=>strip_tags($_POST['material']),
    'category'=>strip_tags($_POST['category']),
    'sub_category'=>strip_tags($_POST['sub_category']),
	);
	$r1=$show->insert('material',$data);
 if($r1){
 echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You!",
            text: "material 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 Material</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>Material</th>
								  <th>Delete</th>
								</tr>
							    </thead>
							   <tbody>

<?php
			
$sr='material';
$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>".$row['material']."</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_material.php

Server Info

System Features

User Info