Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('memory_limit', '128M');
- define('ROOT', $_SERVER['DOCUMENT_ROOT']);
- require ROOT . '/lib/db.php';
- require ROOT . '/vendor/autoload.php';
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
- $uploadDir = ROOT.'/prices/';
- $uploadFile = $uploadDir . basename($_FILES['priceFile']['name']);
- $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
- //$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
- if (move_uploaded_file($_FILES['priceFile']['tmp_name'], $uploadFile)) {
- $PriceFileName = $_FILES['priceFile']['name'];
- $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReaderForFile($uploadFile);
- $reader->setReadDataOnly(true);
- $sheetData = $reader->load(ROOT.'/prices/only.xlsx');
- $art = 0;
- $name = 1;
- $desc = 2;
- $count = 3;
- $ed = 4;
- $price = 5;
- $category_id = 6;
- foreach ($sheetData as $data => $value) {
- $product = R::dispense('products');
- $product->articul = intval($sheetData[$data][0]);
- $product->name = $sheetData[$data][$name];
- $product->desc = $sheetData[$data][$desc];
- $product->count = $sheetData[$data][$count];
- $product->ed = $sheetData[$data][$ed];
- $product->price = $sheetData[$data][$price];
- $product->category_id = $sheetData[$data][$category_id];
- $id = R::store($product);
- header('location: /pages/show.php/?limit=10&page=1');
- }
- }else{
- echo "DONT WORK";
- }
Advertisement
Add Comment
Please, Sign In to add comment