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.com/public_html/admin

Free Space:

1.38 TB

🔧 Quick Actions

✏️ Editing: importattrfile.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) {
  $id=htmlentities($line[0]);
  $code=htmlentities($line[1]);
  $name=htmlentities($line[2]);
  $wsqty=htmlentities($line[3]);
  $wsprice=htmlentities($line[4]);
  $mrp=htmlentities($line[5]);
  $price=htmlentities($line[6]);
  $size=htmlentities($line[7]);
  $color=htmlentities($line[8]);
  $qty=htmlentities($line[9]);
  $image=htmlentities($line[10]);
  $image1=htmlentities($line[11]);
  $image2=htmlentities($line[12]);
  $image3=htmlentities($line[13]);
  $added=htmlentities($line[14]);
$prevQuery=$con->prepare("SELECT attr_code FROM productattr WHERE attr_id='".$id."'");
  $prevQuery->bindColumn(1,$cod);
  $prevQuery->execute();
  $rowcount=$prevQuery->fetch();
if($rowcount >0){
  if($cod==$code){
  $sql=$con->prepare("UPDATE productattr SET attr_name=:name,attr_wsqty=:wsqty,attr_wsprice=:wsprice,attr_mrp=:mrp,attr_price=:price,attr_size=:size,attr_color=:color,attr_qty=:qty,image=:image,image1=:image1,image2=:image2,image3=:image3,added_by=:added WHERE attr_id='$id'");
  $sql->execute(array(':name'=>$name,':wsqty'=>$wsqty,':wsprice'=>$wsprice,':mrp'=>$mrp,':price'=>$price,':size'=>$size,':color'=>$color,':qty'=>$qty,':image'=>$image,':image1'=>$image1,':image2'=>$image2,':image3'=>$image3,':added'=>$added));
}else{}}else{
  $sql=$con->prepare("INSERT INTO productattr(attr_code,attr_name,attr_wsqty,attr_wsprice,attr_mrp,attr_price,attr_size,attr_color,attr_qty,image,image1,image2,image3,added_by)
   VALUES(:code,:name,:wsqty,:wsprice,:mrp,:price,:size,:color,:qty,:image,:image1,:image2,:image3,:added)");
  $sql->execute(array(':code'=>$code,':name'=>$name,':wsqty'=>$wsqty,':wsprice'=>$wsprice,':mrp'=>$mrp,':price'=>$price,':size'=>$size,':color'=>$color,':qty'=>$qty,':image'=>$image,':image1'=>$image1,':image2'=>$image2,':image3'=>$image3,':added'=>$added));
}}
fclose($csvFile);
$qstring='?status=succ';
}else{ $qstring='?status=err';}
}else{ $qstring='?status=invalid_file';} }
header("Location:import-exportattr.php".$qstring); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: importattrfile.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation