ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Current Path: home/oshofree/public_html/chbluxuries.com/chb_data/

Name	Size	Permissions	Actions
📁 ..	-	0755	🗑️
📄 config.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 error_log	5704.81 KB	0644	🗑️ ⬇️ ✏️

Editing: flashsales_display.php

<?php

$sql = "SELECT * from stocks where status='Yes' AND flash_promo='1' GROUP BY group_id ORDER BY flashsales_date DESC";  
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
$ord=$row['id'];
$imageURL='stocks/'.$row["media"];
$cat=$row["category"];
$store = $row["store"]; 
$retail=$row['retail_price'];
$wholesales=$row['wholesales_price'] ; 
$group=$row['group_id'] ;

//Get media
$sqlm = "SELECT * from stock_images WHERE id='$group' order by s ASC ";
$sql2m = mysqli_query($con,$sqlm);
while($rowa = mysqli_fetch_array($sql2m))
{
$imageURL=$rowa["media"];
}

// Total Inventory
$sqlb = "SELECT sum(v.shop) as shop,s.store ,v.item 
FROM variation v INNER JOIN stocks s
ON s.id = v.item
WHERE s.group_id ='$group'";
$sql2b = mysqli_query($con,$sqlb);
while($rob = mysqli_fetch_array($sql2b)){
$total=$rob['shop']; }

echo "
   <tr bgcolor='#fff' class='".$disable."'>
   <td width='200px' ><img src='stocks/".$imageURL."' alt='' style='width: 50px;'> <br>" . $row['group_id'] . "</td>
   <td width='200px' >" . $row['name'] . "</td>
   <td width='200px'>&#8358;" . $retail . "</td>
   <td width='200px' >" . $row['flashsales_date'] . "</td>
   <td width='100px'>".$total."</td>
   <td width='200px'><form action='' method='post' >
   <input type='text' name='orderid' value='".$row['group_id']."' required hidden />
   <button style='background-color:red;' value='delete' class='btn btn-sm btn-primary shadow-sm' type='submit' name='stop_promo'>Delete</button></form></td></tr>";  
      
}

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Editing: flashsales_display.php

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33