芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/data.php

<?php
/** Include path **/
set_include_path(get_include_path() . PATH_SEPARATOR . 'Classes/');
mysql_connect("localhost","root","");
mysql_select_db('excel');
/** PHPExcel_IOFactory */
include 'PHPExcel/IOFactory.php';

$inputFileName =  'file/'.$_POST['f_name'];//'./hotel.xlsx';  File to read
//echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory to identify the format<br />';
try {
	$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
} catch(Exception $e) {
	die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());
}

//$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
//$dataArr = array_slice($sheetData,1);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true);
$dataArr = array_slice($sheetData,1);
$start=$_POST['id'];
$end=$start+400;
$count_next=$_POST['id'];
$no_id=count($dataArr);
if(is_numeric($_POST['id'])){
	for($i=$start;$i<$end;$i++)
	{
		if($i<$no_id)
		{
			
			$data=mysql_query("INSERT INTO `hotel_supplier` (`tour_op`, `deta`, `destination`, `destination_vvp`, `destination_name`, `no_hotel`, `star`, `hotel_name`, `room`, `room_description`, `meal`, `product_code`, `hocat`, `hotel_link`, `hotel_link_fr`) VALUES ('".$dataArr[$i][0]."', '".$dataArr[$i][1]."', '".$dataArr[$i][2]."', '".$dataArr[$i][3]."', '".$dataArr[$i][4]."', '".$dataArr[$i][5]."', '".$dataArr[$i][6]."', '".$dataArr[$i][7]."', '".$dataArr[$i][8]."', '".$dataArr[$i][9]."', '".$dataArr[$i][10]."', '".$dataArr[$i][11]."', '".$dataArr[$i][12]."', '".$dataArr[$i][13]."', '".$dataArr[$i][14]."')");
			$count_next++;
			
		}else{
			$count_next="complete";
		}
	}
	}
	else{
		$count_next="complete";
	}

echo $count_next;
?>