MAINHACK

Viewing / Editing File: add_banner.php

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

?>
<script>
  $(document).ready(function(){
 $("#page").on('change', function(){
    var page=$('#page').val();  
    if(page=="category"){
    $('#category_div').show();
    $("#category").attr("required", true);
      
}else{
    $('#category_div').hide();
    $("#category").attr("required", false);
    
}
     
 });
  });
    
</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 Banner</div>
	</div>
        <form method="post" data-toggle="validator" enctype="multipart/form-data">     
          
        
              
             <div class="form-group" id="category_div" style="display:none">
            <select class="form-control" id="category" name="category" >
            <option value="">Category</option>
            
            <?php
            $table1='category';
            $stmt=$show->readAll_clause($table1,'order by id asc');
            $num=$stmt->rowCount();
            if($num>0){
            while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
            
            echo "<option value='".$row['category']."'>".$row['category']."</option>";	}
            
            }
            
            ?>
            
            </select>	
            </div>         
                    <div class="form-group">
                    <label> Image</label>
					<input type="file" name="service_img" required>
                 </div>
                 
             <div class="form-group">
                    <label> Image Link</label>
					<input type="text" name="link" class="form-control" required>
                 </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>
					
					</form>
</div>	
</div>

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

$img=$show->imageEdit($_FILES['service_img']['name']);
move_uploaded_file($_FILES['service_img']['tmp_name'],"../product_img/".$img);

$data=array(
    'banner'=>$img,
    'link'=>htmlentities(strip_tags($_POST['link']))
	);
	$r1=$show->insert('page_banner',$data);
	if($r1){
	echo "<script>sweetAlert('Ok','banner is added','success');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 Banners</h5>
		<table id="basic-datatables" class="display table table-striped table-hover">
			<thead>
				<tr>
				<th>ID</th>
			    <th>Banner Image</th>
			    <th>Link</th>
				<th>Delete</th>
                                            
				</tr>
			</thead>
			<tbody>
	<?php
			
$count=1;
$sr='page_banner';
$stmt =$show->readAll($sr);
$num = $stmt->rowCount();
     
     if($num>0){
 
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];

echo "<tr>
		<td>$count</td>
		<td><img src='$pic_img/".$row['banner']."' width='100px'></td>		
	    <td><a href='".$row['link']."'>URL</a></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_banner.php

Server Info

System Features

User Info