php excelインポート

6324 ワード

<?php
date_default_timezone_set("prc");
if (
($_FILES["foot"]["size"] < 20000)&&($_FILES["foot"]["type"]=="application/octet-stream" ))
  {
  if ($_FILES["foot"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["foot"]["error"] . "<br />";
    }
  else
    {
  //  echo "Upload: " . $_FILES["foot"]["name"] . "<br />";
   // echo "Type: " . $_FILES["foot"]["type"] . "<br />";
  //  echo "Size: " . ($_FILES["foot"]["size"] / 1024) . " Kb<br />";
   // echo "Temp file: " . $_FILES["foot"]["tmp_name"] . "<br />";

    if (file_exists("upload/" . $_FILES["foot"]["name"]))
      {
      echo $_FILES["foot"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["foot"]["tmp_name"],
      "upload/" . $_FILES["foot"]["name"]);
   require_once 'reader.php';
   require_once "oleread.inc";
   $data=new Spreadsheet_Excel_Reader();
   $data->setOutputEncoding("utf-8");
   $data->read( "upload/" . $_FILES["foot"]["name"]);
     $conn=mysql_connect('localhost','root','123456')or die("    ".mysql_errno());
				
				
				mysql_select_db("stu",$conn)or die("       ".mysql_errno());
			
				mysql_query("set names 'gbk'");
 $m=new match();
   for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {  // execl         $i   excel  $i       
                   $nameteamA=$data->sheets[0]['cells'][$i][1];
                   $nameteamA=iconv("utf-8","gbk",$nameteamA);
                   $idteamA=$m->findteam($nameteamA);
                   $nameteamB=$data->sheets[0]['cells'][$i][2];
                     $nameteamB=iconv("utf-8","gbk",$nameteamB);
                    $idteamB=$m->findteam($nameteamB);
                    $scoreA=$data->sheets[0]['cells'][$i][3];
                     $scoreB=$data->sheets[0]['cells'][$i][4];
                     if($scoreA>$scoreB){
                     	$result=1;
                     }
                     if($scoreA<$scoreB){
                     	$result=-1;
                     }
                     if($scoreA==$scoreB){
                     	$result=0;
                     }
                     $endtime=0;
                     $state=1;
                      $starttime=$data->sheets[0]['cells'][$i][5];
                       $detail= $data->sheets[0]['cells'][$i][6];
                       $detail=iconv("utf-8","gbk",$detail);
                        $timeflag= $data->sheets[0]['cells'][$i][7];
                         $locaild= $data->sheets[0]['cells'][$i][8];
                         $locaild=iconv("utf-8","gbk",$locaild);
                         $id=$m->findchang($locaild);
                         	if(empty($id)){
                         		$m->addchang($locaild);
                         		  $id=$m->findchang($locaild);
                         	}
   $c= strtotime($starttime);
           
 	
	mysql_query("set default gbk");
	$sql="insert into matches values('','$idteamA','$idteamB','$nameteamA','$nameteamB','$scoreA','$scoreB','$c','$endtime','$result','$state','$detail','$timeflag','$id');";
	$res=mysql_query($sql);
	if(!$res){
		echo "      ";
	}
                         }
        @unlink( "upload/" . $_FILES["foot"]["name"]);   
      }
    
   
      }
    }
  
else
  {
  	$alert=iconv("utf-8","gbk","    2M   (2003-2005)excel  ");
  echo $alert;
  }
  class match{
 public  function findteam($nameteam){
  $conn=mysql_connect('localhost','root','123456')or die("    ".mysql_errno());
				
				
				mysql_select_db("stu",$conn)or die("       ".mysql_errno());
			
				mysql_query("set names 'gbk'");
	$sql="select id from team where tname='{$nameteam}';";
	  $res=mysql_fetch_array(mysql_query($sql));
	if(empty($res)){
		$sql="insert into team values('','$nameteam','');";
	mysql_query($sql);{
		
	}
	}
	return $res['id'];
  }
  function findchang($locaild){
  		 $conn=mysql_connect('localhost','root','123456')or die("    ".mysql_errno());
				
				
				mysql_select_db("stu",$conn)or die("       ".mysql_errno());
			
				mysql_query("set names 'gbk'");
	
$sql="select id from chang where name='$locaild'";
   $res=mysql_fetch_array(mysql_query($sql));
	if(!res){
		echo "    ".mysql_error();
	}
	return $res['id'];
  }
  function addchang($rs){
   $conn=mysql_connect('localhost','root','123456')or die("    ".mysql_errno());
				
				
				mysql_select_db("stu",$conn)or die("       ".mysql_errno());
			
				mysql_query("set names 'gbk'");
$sql="insert into chang values('','$rs');";
	$res=mysql_query($sql);
	if(!$res){
		echo "      ";
	}	
  }
  }
 
?>

download.php
<?php
$name="data.xls";
 $path="download/$name";
 if(file_exists($path)){
    		header('Cache-control: max-age=31536000');
			header('Expires: '.gmdate('D, d M Y H:i:s', time() + 31536000).' GMT');
			header('Content-Encoding: none');
			header("Accept-Ranges:bytes"); 
 	header("Content-type:application/vnd.ms-excel");
    header( 'Content-Length: '.filesize($path));
	header("Content-Disposition:attachment;filename=".$name);
	readfile($path);
			exit;
 } else{
 	echo "     ";
 }
?>