codeigniter - php excel reader date format getting 1970-01-30 for any input date given in excel sheet -


enter image description here

i'am getting date format 1970-01-30 input date given date in excel

there 2 fields having date format cells date given in excel showing 1970-01-30 output in echo

please can 1 me 

this code   public function clientfileupload($list_id){     $clientarr = array('client_name','client_nick_name', 'client_email','client_phone','client_address','client_location','contract_name','contract_description','contract_value','renewal_date','expiry_date','payment_mode');     $this->load->library('phpexcel');     $name = $_files["images"]["name"];     $filetype = explode(".",$name);     $name = str_replace(' ', '',$name. "_" . time());     $abs = getcwd();     $path = $abs . "/upload/excelfiles/";     $pathfile = $path . $name;     if (move_uploaded_file($_files["images"]["tmp_name"], $path . $name))     if($filetype[1] == 'xlsx')     {         $objreader = phpexcel_iofactory::createreader('excel2007');         $objreader->setreaddataonly(true);         $objphpexcel = $objreader->load($pathfile);         $objworksheet = $objphpexcel->getactivesheet();         $highestrow = $objworksheet->gethighestrow();         $highestcolumn = $objworksheet->gethighestcolumn(); // e.g 'f'          $highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);     }     else      {         $objphpexcel = phpexcel_iofactory::load($pathfile);         $objworksheet = $objphpexcel->getactivesheet();         $highestrow = $objworksheet->gethighestrow();         $highestcolumn = $objworksheet->gethighestcolumn(); // e.g 'f'          $highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);     }     $notinserted = array();     ($row = 1; $row <= $highestrow; ++$row)      {         $arr = array();         ($col = 0; $col <= $highestcolumnindex - 1; ++$col)          {              if($col == 9 || $col == 10)             {                 $rowname = date('y-m-d', phpexcel_shared_date::exceltophp($objworksheet->getcellbycolumnandrow($col, $row)->getvalue()));             }else             {                 $rowname =  $objworksheet->getcellbycolumnandrow($col, $row)->getvalue();             }             if ($row != 1)              {                 $arr[$clientarr[$col]] = $rowname;             }         }              }     print_r($arr);exit;                echo true;     exit; }

can 1 me thank in advance


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl>
Read more

javascript - IE9 error '$'is not defined -

Image
<!--[if lte ie 9]><html class="lte9"><![endif]--><!--[if gt ie 9]><html><![endif]--> <!--[if !ie]><!--> <html> <!--<![endif]--> blah blah <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> <script src="{{ asset('js/mypage.js') }}" type="text/javascript"></script> </body> </html> when load page, ie9 brings error '$' not defined . how can solve error? +++ mypage.js $(function(){ //when load page, //ie9 tag not moving. $(window).load(function() { $('div.mask').hide(); }); // when click , willshow show. //for not ie 9 if (!$('html').hasclass('lte9')) { var = $('ul.about > li > span.activebtn');
Read more