| Server IP : 213.186.33.4 / Your IP :
216.73.216.146 [
Web Server : Apache System : Linux webm002.cluster103.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : dealkatnwc ( 662330) PHP Version : 7.0.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/dealkatnwc/www/GARAGE/php_action/ |
Upload File : |
<?php
ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);
require_once 'core.php';
require_once '../libraries/phpexcel/PHPExcel.php';
require_once '../libraries/phpexcel/PHPExcel/IOFactory.php';
$valid['success'] = array('success' => false, 'messages' => array());
//print_r($_FILES);//exit;
if($_FILES) {
$type = explode('.', $_FILES['brandfile']['name']);
$type = $type[count($type)-1];
$url = '../assets/myimages/'.uniqid(rand()).'.'.$type;
//echo "23"$url;exit;
if(in_array($type, array("csv", "xls", "xlsx"))) {
if(is_uploaded_file($_FILES['brandfile']['tmp_name'])) {
if(move_uploaded_file($_FILES['brandfile']['tmp_name'], $url)) {
$objPHPExcel = PHPExcel_IOFactory::load($url);
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$no_error_data = array();
$highestColumn = $sheet->getHighestColumn();
$highestColumn = 'B';
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
for ($row = 2; $row <= $highestRow; $row++) {
$rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row,NULL,FALSE,TRUE);
if(isset($rowData[0][0]) && !empty($rowData[0][0]) && isset($rowData[0][1])) { // check for amount ,rest id and service name
$no_error_data[$row-1] = $rowData[0];
} else {
$error[] = $rowData[0];
}
}
if(!empty($no_error_data)) {
foreach ($no_error_data as $value) {
$select_sql = "SELECT * FROM brands WHERE brand_name ='$value[0]'";
//echo $select_sql;exit;
$result = $connect->query($select_sql);
if($result->num_rows == 0) {
$sql = "INSERT INTO brands (brand_name, brand_active, brand_status) VALUES ('$value[0]', '$value[1]', '$value[1]')";
if($connect->query($sql) === TRUE) {
$valid['success'] = true;
$valid['messages'] = "Successfully Added23";
header('location:../importbrand.php');
} else {
$valid['success'] = false;
$valid['messages'] = "Error while adding the brands";
}
} else {
$valid['success'] = true;
$valid['messages'] = "Successfully Added";
header('location:../importbrand.php');
}
}
}
} else {
$valid['success'] = false;
$valid['messages'] = "Error while adding the brands";
} // /else
} else {
$valid['success'] = false;
$valid['messages'] = "Error while adding the brands";
} // if
} // if in_array
$connect->close();
echo json_encode($valid);
} // /if $_POST