Guest User

Untitled

a guest
Feb 8th, 2019
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.63 KB | None | 0 0
  1. <?php
  2. ini_set('memory_limit', '128M');
  3.     define('ROOT', $_SERVER['DOCUMENT_ROOT']);
  4.     require ROOT . '/lib/db.php';
  5.     require ROOT . '/vendor/autoload.php';
  6.     use PhpOffice\PhpSpreadsheet\Spreadsheet;
  7.     use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  8.     $uploadDir = ROOT.'/prices/';
  9.     $uploadFile = $uploadDir . basename($_FILES['priceFile']['name']);
  10.     $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
  11.  
  12.     //$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
  13.  
  14.     if (move_uploaded_file($_FILES['priceFile']['tmp_name'], $uploadFile)) {
  15.         $PriceFileName = $_FILES['priceFile']['name'];
  16.  
  17.         $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReaderForFile($uploadFile);
  18.         $reader->setReadDataOnly(true);
  19.         $sheetData = $reader->load(ROOT.'/prices/only.xlsx');
  20.  
  21.  
  22.  
  23.         $art = 0;
  24.         $name = 1;
  25.         $desc = 2;
  26.         $count = 3;
  27.         $ed = 4;
  28.         $price = 5;
  29.         $category_id = 6;
  30.  
  31.  
  32.         foreach ($sheetData as $data => $value) {
  33.  
  34.             $product = R::dispense('products');
  35.  
  36.             $product->articul = intval($sheetData[$data][0]);
  37.  
  38.  
  39.             $product->name = $sheetData[$data][$name];
  40.  
  41.             $product->desc = $sheetData[$data][$desc];
  42.             $product->count = $sheetData[$data][$count];
  43.             $product->ed = $sheetData[$data][$ed];
  44.             $product->price = $sheetData[$data][$price];
  45.             $product->category_id = $sheetData[$data][$category_id];
  46.             $id = R::store($product);
  47.             header('location: /pages/show.php/?limit=10&page=1');
  48.         }
  49.     }else{
  50.         echo "DONT WORK";
  51.     }
Advertisement
Add Comment
Please, Sign In to add comment