php - PHPExcel - Getting irrelevant value in MySQL -


whenever import excel file mysql using phpexcel don't values , values inserted irrespective columns.

but when use echo showing excel file shows exact report.

also, want few selected columns imported 10-15 columns.

thanks in advance

my code

<?php     //include following 2 files     require 'c:\xampp\phpexcel_1.7.9_doc\classes\phpexcel.php';     require_once 'c:\xampp\phpexcel_1.7.9_doc\classes\phpexcel\iofactory.php';      $conn = mysql_connect("localhost","root",""); mysql_select_db("invoice",$conn);  $file=$_post['file']; $srow=$_post['srow'];    $objphpexcel = phpexcel_iofactory::load($file); foreach ($objphpexcel->getworksheetiterator() $worksheet) {     $worksheettitle     = $worksheet->gettitle();     $highestrow         = $worksheet->gethighestrow(); // e.g. 10     $highestcolumn      = $worksheet->gethighestcolumn(); // e.g 'f'     $highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);     $nrcolumns = ord($highestcolumn) - 64;     echo "<br>the worksheet ".$worksheettitle." has ";     echo $nrcolumns . ' columns (a-' . $highestcolumn . ') ';     echo ' , ' . $highestrow . ' row.'; }    echo 'data: <table width="100%" cellpadding="3" cellspacing="0"><tr>'; ($row = $srow; $row <= $highestrow-1; ++ $row) {    echo '<tr>';    ($col = 0; $col < $highestcolumnindex; ++ $col) {        $cell = $worksheet->getcellbycolumnandrow($col, $row);        $val = $cell->getvalue();        if($row === 1)             echo '<td style="background:#000; color:#fff;">' . $val . '</td>';        else            echo '<td>' . $val . '</td>';    } echo '</tr>'; } echo '</table>';     ($row = $srow; $row <= $highestrow; ++ $row) {     $val=array(); ($col = 0; $col <= $highestcolumnindex; ++ $col) {    $cell = $worksheet->getcellbycolumnandrow($col, $srow); $val[] = $cell->getvalue();  } $dropdownval=$_post['menu'];  if ($dropdownval!='none') { $sql="insert $dropdownval(`bkng date`,`id number`,`pax name`,`ticket number`,`pnr`,`sector`,`travel date`,`basic`,`tax`,`net payable`) values('".$val[1]."','".$val[2]."','".$val[3]."','" .$val[4]."','".$val[5]."','".$val[6]."','".$val[7]."','".$val[8]."','".$val[9]."','".$val[10]."')"; mysql_query($sql)or die('invalid query: ' . mysql_error());      if(mysql_query($sql))     echo "successfully uploaded ".$file;     else         echo "error while uploading ".$file;     //echo $sql."\n"; }  else     {     $tname=$_post['tname']; $createtable="create table $tname(  `bkng date` date not null ,  `id number` int not null ,  `pax name` varchar( 100 ) not null ,  `ticket number` varchar( 100 ) not null ,  `pnr` varchar( 50 ) not null ,  `sector` varchar( 50 ) not null ,  `travel date` date not null ,  `basic` decimal not null ,  `tax` decimal not null ,  `net payable` decimal not null)"; mysql_query($createtable);  $sql1="insert $tname(`bkng date`,`id number`,`pax name`,`ticket number`,`pnr`,`sector`,`travel date`,`basic`,`tax`,`net payable`) values('".$val[1]."','".$val[2]."','".$val[3]."','" .$val[4]."','".$val[5]."','".$val[6]."','".$val[7]."','".$val[8]."','".$val[9]."','".$val[10]."')";     mysql_query($sql1)or die('invalid query: ' . mysql_error());         if(mysql_query($sql1))     echo "table $tname has been created...successfully uploaded ".$file;     else         echo "error while uploading ".$file; }  }  ?>


-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more