Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

7.4.33

User:

u727167137

Directory:

/home/u727167137/domains/bulbird.in/public_html/admin

Free Space:

1.38 TB

🔧 Quick Actions

✏️ Editing: importcsvfile.php

<?php
require_once 'config.php';
if(isset($_POST['importSubmit'])){
  $csvMimes=array('text/x-comma-separated-values','text/comma-separated-values','application/octet-stream','application/vnd.ms-excel','application/x-csv','text/x-csv','text/csv','application/csv','application/excel','application/vnd.msexcel','text/plain');
if(!empty($_FILES['file']['name']) && in_array($_FILES['file']['type'],$csvMimes)) {
if(is_uploaded_file($_FILES['file']['tmp_name'])) {
  $csvFile=fopen($_FILES['file']['tmp_name'],'r');
fgetcsv($csvFile);
while(($line=fgetcsv($csvFile)) !==false) {
  $code=$line[0];
  $name=$line[1];
  $url=$line[2];
  $catid=$line[3];
  $subcatid=$line[4];
  $oldprice=$line[5];
  $newprice=$line[6];
  $image=$line[7];
  $showin=$line[8];
  $lastmd=$line[9];
  $delivery=$line[10];
  $weight=$line[11];
  $material=$line[12];
  $googlecatid=$line[13];
  $description=$line[14];
  $highlight=$line[15];
  $brand=$line[16];
  $added=$line[17];
  $editer=$line[18];
  $branch=$line[19];
  $status=$line[20];
  $dimension=$line[21];
$prevQuery=$con->prepare("SELECT products_id FROM products WHERE products_code='".$code."'");
  $prevQuery->bindColumn(1,$id);
  $prevQuery->execute();
  $rowcount=$prevQuery->fetch();
if($rowcount >0){
  $sql=$con->prepare("UPDATE products SET products_productname=:name,products_url=:url,products_catid=:catid,products_subcatid=:subcatid,products_oldprice=:oldprice,products_newprice=:newprice,products_images=:image,products_showin=:showin,product_showinlmdeal=:lastmd,products_deliverycharge=:delivery,products_weight=:weight,products_material=:material,google_product_category=:googlecatid,products_description=:description,products_highlights=:highlight,
    products_brands=:brand,added_by=:added,editer_type=:editer,pro_branch=:branch,products_status=:status,products_dimension=:dimension WHERE products_id='$id'");
  $sql->execute(array(':name'=>$name,':url'=>$url,':catid'=>$catid,':subcatid'=>$subcatid,':oldprice'=>$oldprice,':newprice'=>$newprice,':image'=>$image,':showin'=>$showin,':lastmd'=>$lastmd,':delivery'=>$delivery,':weight'=>$weight,':material'=>$material,':googlecatid'=>$googlecatid,':description'=>$description,':highlight'=>$highlight,':brand'=>$brand,':added'=>$added,':editer'=>$editer,':branch'=>$branch,':status'=>$status,':dimension'=>$dimension));
}else{
  $sql=$con->prepare("INSERT INTO products(products_code,products_productname,products_url,products_catid,products_subcatid,products_oldprice,products_newprice,products_images,products_showin,product_showinlmdeal,products_deliverycharge,products_weight,products_material,google_product_category,products_description,products_highlights,products_brands,added_by,editer_type,pro_branch,products_status,products_dimension)
   VALUES(:productcode,:productname,:createurl,:category,:subcategory,:oldprice,:newprice,:path2,:showin,:lastminutedeal,:delivery,:weight,:material,:googlecatid,:description,:highlight,:brands,:added,:editer,:branch,:status,:dimension)");
  $sql->execute(array(':productcode'=>$code,':productname'=>$name,':createurl'=>$url,':category'=>$catid,':subcategory'=>$subcatid,':oldprice'=>$oldprice,':newprice'=>$newprice,':path2'=>$image,':showin'=>$showin,':lastminutedeal'=>$lastmd,':delivery'=>$delivery,':weight'=>$weight,':material'=>$material,':googlecatid'=>$googlecatid,':description'=>$description,':highlight'=>$highlight,':brands'=>$brand,':added'=>$added,':editer'=>$editer,':branch'=>$branch,':status'=>$status,':dimension'=>$dimension));
    } }
fclose($csvFile);
$qstring='?status=succ';
}else{ $qstring='?status=err';}
}else{ $qstring='?status=invalid_file';} }
header("Location:mainindex.php".$qstring); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: importcsvfile.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation