Results for query "inputfilename"

import excel to mysql Error

I am trying to import data from an Excel file to Mysql, but it is not inserting the data

Controller

public function guardar_horario(){


if (!empty($_FILES['file']['name'])) {


$pathinfo = pathinfo($_FILES["file"]["name"]);


if (($pathinfo['extension'] == 'xlsx' || $pathinfo['extension'] == 'xls')
&& $_FILES['file']['size'] > 0 ) {

// Temporary file name
$inputFileName = $_FILES['file']['tmp_name'];

// Read excel file by using ReadFactory object.

excel file upload to database using Php

empty($_FILES['file']['name'])) {
echo "ks";
$pathinfo = pathinfo($_FILES["file"]["name"]);

if (($pathinfo['extension'] == 'xlsx' || $pathinfo['extension'] == 'xls')
&& $_FILES['file']['size'] > 0 ) {
$inputFileName = $_FILES['file']['tmp_name'];
// Read excel file by using ReadFactory object.if ($count > 1) {
echo "ks4";
// Data of excel sheet
$data['Member_no'] = $row[0];
$data['Member_name'] = $row[1];
$data['Gender'] = $row[2];
$data['Club_name'] = $row[3];
$data['member_since'] = $row[4];
$data['Expiry_date'] = $row[3];

$member_no = $data['Member_no'];
$member_name = $data['Member_name'];
$gender = $data['Gender'];
$club_name = $data['Club_name'];
$member_since = $data['member_since'];
$expiry_date = $data['Expiry_date'];

$query="INSERT INTO `mmholdin_management`.

How to read subscript/superscript/new line using PHPExcel library when importing excel file to PHP and storing in MySQL

I am having trouble saving the excel file in mysql database, It contains enter(new line) inside a cell and symbols & superscripts as well.$objReader = new PHPExcel_Reader_Excel5();
$objPHPExcel = $objReader->load($inputFileName);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);


then i read some data and use

reset($sheetData);


to reset the pointer.