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/theclimb.co.in/public_html/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: updateprotbl.php

<?php
ob_start();
session_start();
include("includes/inall.php");  
/*$sql="select * from `newproduct` where 1";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($res)) {
	$sku=trim($row['sku']);
	mysqli_query($con,"update `newproduct` set `sku`='".$sku."' where `pro_id`='".$row['pro_id']."'");
}
$sql="select distinct `sku` from `newproduct` where `pro_st`='1'";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($res)) {
	$respr=mysqli_query($con,"select `pro_id` from `newproduct` where `sku`='".$row['sku']."'");
	if(mysqli_num_rows($respr)>1) {
		$rowpr=mysqli_fetch_array($respr);
		$size="";
		$count=1;
		$resa=mysqli_query($con,"select `size` from `newproduct` where `sku`='".$row['sku']."'");
		while($rowa=mysqli_fetch_array($resa)) {
			$size.=$count==1?$rowa['size']:", ".$rowa['size'];
			$count++;
		}
		mysqli_query($con,"update `newproduct` set `size`='".$size."' where `pro_id`='".$rowpr['pro_id']."'");
		mysqli_query($con,"delete from `newproduct` where `pro_id`!='".$rowpr['pro_id']."' and `sku`='".$row['sku']."'");
	}
}*/
$uppath="docs/update-pro-1.xls";
require_once 'excel_reader.php';
$excel=new PhpExcelReader;
$excel->read($uppath);
$nr_sheets=count($excel->sheets);
for($x=1;$x<=$excel->sheets[0]['numRows'];$x++) {
	$sku=addslashes(trim($excel->sheets[0]["cells"][$x][1]));
	$mrp=addslashes(trim($excel->sheets[0]["cells"][$x][3]));
	$dprice=addslashes(trim($excel->sheets[0]["cells"][$x][5]));
	$subcate=addslashes(trim($excel->sheets[0]["cells"][$x][6]));
	$row=mysqli_fetch_array(mysqli_query($con,"select * from `subcategory` where `name`='".$subcate."'"));
	mysqli_query($con,"update `newproduct` set `category`='".$row['category']."', `subcategory`='".$row['id']."', `mrp`='".$mrp."', `dprice`='".$dprice."' where `sku`='".$sku."'");
}	
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: updateprotbl.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation