<?php session_start(); $con = mysqli_connect("localhost", "root", "password", "database_name"); require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; if(isset($_POST['import_file_btn'])) { $allowed_ext = ['xls', 'xlsx']; $fileName = $_FILES['import_file']['name']; $checking = explode(".", $fileName); $file_ext = end($checking); if (in_array($file_ext, $allowed_ext)) { $targetPath = $_FILES['import_file']['tmp_name']; $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($targetPath); $data = $spreadsheet-> getActiveSheet()->toArray(); $data = array_values ($_POST); //NOT WORKING(?) $flippedArray = array_flip($data); //NOT WORKING(?) foreach ($flippedArray as $row) //NOT WORKING(?) { $sku = $row[ $flippedArray['sku'] ]; //Undefined index $p_name = $row[ $flippedArray['p_name'] ]; //Undefined index $id_category = $row[ $flippedArray['id_category'] ]; //Undefined index $id_brand = $row[ $flippedArray['id_brand'] ]; //Undefined index $checkProduct = "SELECT sku FROM ita WHERE sku='$sku'"; $checkProduct_result = mysqli_query ($con, $checkProduct); if (mysqli_num_rows($checkProduct_result) > 0) { $up_query ="UPDATE ita SET p_name='$p_name', id_category='$id_category', id_brand='$id_brand' WHERE sku='$sku' "; $up_result = mysqli_query($con, $up_query); $msg = 1; } else { $in_query = "INSERT INTO ita (sku, p_name, id_category, id_brand) VALUES ('$sku','$p_name', '$idcategory', '$id_brand')"; $in_result = mysqli_query ($con, $in_query); $msg = 1; } } if(isset($msg)) { $_SESSION['status'] = "All data where imported right"; header("Location: index.php"); } else { $_SESSION['status'] = "Error during file import"; header("Location: index.php"); } } else { $_SESSION['status'] = "Invalid file format"; header("Location: index.php"); exit(0); }
You have javascript disabled. You will not be able to edit any code.
Value for `_results` contains invalid data `array`