Manager

Back Back Up Advanced Editor

<?php

if(isset($_SESSION['errorMsg'])){ echo $_SESSION['errorMsg']; unset($_SESSION['errorMsg']);}

<h4 class="card-title">Product List</h4>

<thead>

<tr>

<th width="10%">Image</th>

<th width="12%">Category</th>

<th width="13%">Subcategory</th>

<th width="30%">Skucode</th>

<th width="30%">Weight</th>

<th width="30%">Price</th>

<th width="30%">Selling Price</th>

<th width="30%">Delivery Chr.</th>

<th width="10%">Status</th>

<th width="20%">Action</th>

</tr>

</thead>

<tbody>
				<?php
                $i = 1;						  
                $sqlEmployee = mysqli_query($cn, "select * from `tbl_product` where `status` IN(0,1) order by `name`");
                while($sqlEmployeeData = mysqli_fetch_array($sqlEmployee))
				{
					$sqlCategory = mysqli_query($cn, "select * from `tbl_category` where id='".$sqlEmployeeData['category_id']."'");
					$sqlCategoryData = mysqli_fetch_array($sqlCategory);					
					$sqlSubCategory = mysqli_query($cn, "select * from `tbl_subcategory` where id='".$sqlEmployeeData['subcategory_id']."'");
					$sqlSubCategoryData = mysqli_fetch_array($sqlSubCategory);															
					$productImage = explode("$",$sqlEmployeeData['image']); 
					
					/*$name      = $sqlEmployeeData['name'];//$_GET['name'];
					$tableName = "tbl_product";//$_GET['tableName']; 
					if(!empty($name))
					{
						$slug = preg_replace("/-$/","",preg_replace('/[^a-z0-9]+/i', "-", strtolower($name)));
						$query = "SELECT COUNT(*) AS NumHits FROM $tableName WHERE  slug_url  LIKE '$slug%'";
						$result = mysqli_query($cn, $query);
						$row    = mysqli_fetch_array($result);
						$numHits = $row['NumHits'];
						$slug = ($numHits > 0) ? ($slug . '-' . $numHits) : $slug;
						mysqli_query($cn, "update `tbl_product` set `slug_url`='".$slug."' where `id`='".$sqlEmployeeData['id']."'");
					}*/
                	?>

<tr>

<td><img src="../products/<?php echo $productImage[0];?>" height="150" width="200"></td>

<?php

if($sqlEmployeeData['status']==1){?>

<?php }else{?>

<?php }?>

</td>

<td>

<a href="home.php?pages=product&edit_id=<?php echo $sqlEmployeeData['id'];?>" class="btn btn-outline-success btn-sm">Edit</a>

<a href="home.php?pages=productList&delete_id=<?php echo $sqlEmployeeData['id'];?>" class="btn btn-outline-danger btn-sm" onclick="return deleteConfirm();">Delete</a>

</td>

</tr>

<?php } ?>

</tbody>

</table>

</div>

<?php

if(isset($_GET['delete_id']))

{

$id      = $_GET['delete_id'];

$sql     = mysqli_query($cn, "update `tbl_product` SET `status`=2 where id='$id'");

if($sql)

{

$_SESSION['errorMsg'] = '<div class="alert alert-success"><strong>Success!</strong> Product Deleted Successfully.</div>';

}

else

{

$_SESSION['errorMsg'] = "error: " . $sql . "<br>" . mysqli_error($conn);

}

header("location:home.php?pages=productList");

}

if(isset($_GET['status']))

{

$id      = $_GET['status'];

$val     = $_GET['val'];

$sql     = mysqli_query($cn,"update `tbl_product` SET `status`='".$val."' where id='".$id."'");

$_SESSION['errorMsg'] = '<div class="alert alert-success"><strong>Success!</strong> Product Status Updated Successfully.</div>';

header("location:home.php?pages=productList");

}

if(isset($_SESSION['errorMsg'])){ echo $_SESSION['errorMsg'];}