MAINHACK

Viewing / Editing File: all_offer.php

<?php

include('header.php');
$show=new Oops($db);

<h3 class="title1" style="margin-top: 20px;">All  Offers</h3>
 			<table class="table" id='example'>
							<thead>
								<tr>  
								 <th>Sl</th>
								  <th>Title </th>
							      <th>Description </th>
							      <th> Image</th>
							      <th> Meta Key</th>
							      <th> Meta Data</th>
							      <th> Start Date-End Date</th>
							      <th> Link</th>
                                 <th>Action</th>
								</tr>
							 </thead>
			 <tbody>

<?php
			
    $count=1;
    $sr='offers';
    $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['title']."</td>
 <td>".substr($row['description'],0,270)."....</td>
 <td><img src='../product_img/".$row['img']."' width='100'></td>
 <td>".$row['meta_key']."</td>
 <td>".$row['meta_data']."</td>
 <td>".$row['start_date']."-".$row['end_date']."</td>
 <td><a href='".$row['link']."' target='_blank'>Link</a></td>
   
 <td>
<a href='edit_offers.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='label label-success'>Edit</a>
<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>
<?php
if(isset($_POST['sub'])){

$sq="select * from service where client_id='".$_SESSION['login_id']."' and service_title='".$_POST['service_title']."'";
$r=$con->prepare($sq);
$r->execute();
$num=$r->rowCount();
    if($num>0){
	
echo "<script>sweetAlert('Oops','service Exists','error');</script>";

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

$data=array(
    'client_id'=>$_SESSION['login_id'],
    'service_title'=>htmlentities(strip_tags($_POST['service_title'])),
    'service_img'=>$img,
    'date'=>date('Y-m-d'),
	);
	$r1=$show->insert('service',$data);
	if($r1){
	echo "<script>sweetAlert('Ok','service is added','success');window.location.href='".$_SERVER['request_uri']."';</script>";
	
	}
	
}
}
?>	
<script src="js/bootstrap-datepicker.js"></script>
<script type="text/javascript">
            // When the document is ready
             $(document).ready(function(){
       $("#date").datepicker({
	   format: 'dd-mm-yyyy',
	   
	   });
	  
	 
       });
</script>
		
<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all_offer.php

Server Info

System Features

User Info