PHP Excel导入和导出

来源：互联网发布：网络征婚投资编辑：程序博客网时间：2024/05/18 17:00

导入：

<?php//获取excel内容$str = file_get_contents('use.xls');//去除字符串两边空格$str = trim($str);//通过回车把字符串分割成数组$arr = explode("\n",$str);//处理数组通过\t（制表符）foreach($arr as $k=>$v){if($k!=0){$data[] = explode("\t",$v);}}//连接数据库$link = mysql_connect('127.0.0.1','root','root') or die('no');mysql_select_db('test',$link) or die('yes');//由于excel编码格式问题  必须设置为gbkmysql_query('set names gbk');//$sql = '';foreach($data as $k=>$v){$sql = "insert into user(username,pwd) values('$v[1]','$v[2]')";$info = mysql_query($sql);//print_r($info);die;}?>

导出：

<?php  header("content-type:text/html;charset=utf-8");//exit;   $link=mysql_connect("127.0.0.1","root",'root');   mysql_select_db($link,'test');   mysql_query("set names utf8");   $sql="select * from user";   $res=mysql_query($sql);   while($row=mysql_fetch_assoc($res)){    $data[]=$row;   }   //var_dump($data);    $str="编号\t姓名\t密码"."\n";   foreach($data as $key=>$v){     $str.=implode("\t",$v)."\n";   }   header("content-type:application/vnd.ms-excel");   header("content-disposition:attachment;filename=use.xls");   echo $str;

0 0