MAINHACK

Viewing / Editing File: add_room_cate.php

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

<div id="page-wrapper">
<div class="main-page">
    
 <div class="row">
 <div class="col-md-6">
    <div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
         <div class="form-title">
         <h4>Add Category  :</h4>
         </div>
         <div class="form-body">
                                    <form role="form" method="post">
                                        <div class="form-group">
                                         <label>Room Category</label>
                       
					<input type="text" name="category" class="form-control" placeholder="Category" required>
                     </div>
                     <div class="form-group">
                    <label>GST(%)</label>
                       
					<input type="number" name="gst" class="form-control" placeholder="GST (number only)" required>
                     </div>
                    
						<input type="submit" class="btn btn-primary" name="sub" value="submit">
						<button type="reset" class="btn btn-success">Reset Button</button>
					</form>
	     
 <?php
if(isset($_POST['sub'])){
	$table="hotel_category";
	$col="category";
	$category=htmlentities(strip_tags($_POST['category']));
    $r=$show->readwithdata($table,$col,$category);
    $num=$r->rowCount();
    if($num>0){
	
echo "<script>sweetAlert('Oops','Category Exists','error');</script>";

}else{
    $gst_amt=(htmlentities(strip_tags($_POST['gst']))/100)*100;
	$data=array(
    'category'=>$category,
    'gst'=>htmlentities(strip_tags($_POST['gst'])),
    'gst_amt'=>$gst_amt,

);
	$r1=$show->insert('hotel_category',$data);
	if($r1){

echo "<script>sweetAlert('Ok','Category is added','success');</script>";
	
	}
	
}
}
?>        
         
         
         
         </div>
    </div>		
 </div>	
 <div class="col-md-6">
<div class="tables">

<h3 class="title1" style="margin-top: 20px;">All Room Category</h3>
 			<table class="table" id='example'>
							<thead>
								<tr>  
								 <th>Sl</th>
								  <th>Category </th>
								  <th>Gst(%) </th>
								  <th>Gst </th>
							       <th>Action</th>
								</tr>
							 </thead>
			 <tbody>

<?php
			
    $count=1;
    $sr='hotel_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['gst']."(%)</td>
  <td>".$row['gst_amt']."</td>
   
 <td>
<a href='delete.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='label label-danger' onclick='return send();'>Delete</a>
</td>
</tr>";

++$count;
 }
}

?>							
</tbody>
</table>
</div>
</div>
</div></div>
</div>

</div>

<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: add_room_cate.php

Server Info

System Features

User Info