MAINHACK

Viewing / Editing File: all_product.php

<?php
include('header.php');
$show=new Oops($db);
?>
        
          <div id="page-wrapper">
	<div class="main-page">
          
                <div class="tables">
        	 <h3 class="title1">All Products</h3>
        	<div class="panel-body widget-shadow">

<table class="table" id="example">
							<thead>
								<tr>  
								  <th>Sl</th>
								  <th>Date</th>
								   <th>Product Id</th>
								   <th>SKU NO</th>
								   <th>Gst</th>
								  <th><font color="red">Trending</font></th>   
								   
								  <th>Category</th>
								  <th>Product Name</th>
 								  <th>Color</th>
                                 <th>Stock</th>																
								    <th>Image</th>   
								<th>Edit/Delete</th>
								</tr>
							</thead>
							<tbody>

<?php

$count=1;
$stmt=$show->readAll('product');
$num=$stmt->rowCount();
if($num>0){
while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
	//$status=$row['status'];
$pro_id=$row['product_id'];
$id=$row['id'];
$stock=$row['quantity'];
$qty=$stock<=5?'<font color="red">LOW STOCK</font>':'';
$s=$show->readwithdata_clause('product_img','product_id',$pro_id,'limit 1');
$row1=$s->fetch(PDO::FETCH_ASSOC);
$img=$row1['image'];
	echo "	<tr>
                        <td>$count</td>
                        <td>".date('d-m-Y',strtotime($row['date']))."</td>
                        <td>".$row['product_id']."</td>
                        <td>".$row['stu_number']."</td>
                        <td>".$row['gst']."</td>";
                        ?>
                      <td>
                                <script>
                                $(document).ready(function(){
                                $('#trending<?=$count;?>').change(function(){
                                var trend=$('#trending<?=$count;?>').val();
                                var id=$('#id<?=$count;?>').val();
                                //alert(trend);
                                $.ajax({
                                type: "POST",
                                url: "ajax_check.php", // Name of the php files
                                data: "trending="+trend+"&id="+id,
                                async: false,
                                global: false,
                                success: function(result)
                                {
                                window.location.reload();
                                }
                                });
                                });
                                });
                                </script>			   
						   
						     	<?php 
						     	$interests = array('Yes','No'); 
?>
						<select name="trending" id="trending<?=$count;?>">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['trending']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>	  <input type="hidden" id="id<?=$count?>" value="<?=$row['id']?>" >
                                    </td>    
                    <?php echo "<td>".$row['category']."</td>
                        <td>".$row['name']."</td>
                        <td><span style='width:120px;background-color: ".$row['color'].";color: #FFFFFF;'>".$row['color']."</span></td>
                        <td>".$row['quantity']." $qty</td>                      
                        <td><img src='".$pic_img."/".$img."' width='80' height='50'></td>
                        
                        <td><a href='edit_product_final.php?id=$pro_id' class='label label-info'>Edit</a>
		<a href='delete_pro.php?id=$id&table=product&url=".$_SERVER['REQUEST_URI']."&pid=".$row['product_id']."'' class='label label-danger' onclick='return send();'>Delete</a>
                        </td>
                        </tr>";
                        
                        ++$count;
								}

}else{
    
    
}
?>							
								</tbody></table>
					</div>    	</div>    
                </div>
            </div>

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all_product.php

Server Info

System Features

User Info