后端开发|php教程
PHP,CSV,文件,导入,导出,类
后端开发-php教程
本文实例讲述了PHP实现CSV文件的导入和导出类。分享给大家供大家参考。具体如下：
网站底部设计源码,vscode安装QQ,ubuntu 流量,tomcat性能设置,怎么使用手机sqlite,wordpress卡密支付插件,前端新手需要用框架吗,爬虫是数据收集还是分析,php 的运行原理,简单seo优化推广,销售展示网站源码,网页对联客服,农场互助模板lzw
csv_array = $param_arr; $this->path = $path; $this->column = $column; } /** * 导出 * */ public function export(){ if(empty($this->csv_array) || empty($this->column)){return false; } $param_arr = $this->csv_array; unset($this->csv_array); $export_str = implode(,,$param_arr[ av])."n"; unset($param_arr[ av]); //组装数据 foreach($param_arr as $k=>$v){foreach($v as $k1=>$v1){ $export_str .= implode(,,$v1)."n";} } //将$export_str导出 header( "Cache-Control: public" ); header( "Pragma: public" ); header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename=txxx.csv"); header(Content-Type:APPLICATION/OCTET-STREAM); ob_start();// $file_str= iconv("utf-8",gbk,$export_str); ob_end_clean(); echo $export_str; } /** * 导入 * */ public function import($path,$column = 3){ $flag = flase; $code = 0; $msg = 未处理; $filesize = 1; //1MB $maxsize = $filesize * 1024 * 1024; $max_column = 1000;//检测文件是否存在 if($flag === flase){if(!file_exists($path)){ $msg = 文件不存在; $flag = true;} } //检测文件格式 if($flag === flase){$ext = preg_replace("/.*.([^.]+)/","$1",$path);if($ext != csv){ $msg = 只能导入CSV格式文件; $flag = true;} } //检测文件大小 if($flag === flase){if(filesize($path)>$maxsize){ $msg = 导入的文件不得超过.$maxsize.B文件; $flag = true;} } //读取文件 if($flag == flase){$row = 0;$handle = fopen($path, );$dataArray = array();while($data = fgetcsv($handle,$max_column,",")){ $num = count($data); if($num < $column){$msg = 文件不符合规格真实有：.$num.列数据;$flag = true;break; } if($flag === flase){for($i=0;$iarray(用户名,密码,邮箱),array(0=>array(xiaohai1,123456,xiaohai1@), 1=>array(xiaohai2,213456,xiaohai2@), 2=>array(xiaohai3,123456,xiaohai3@)));$column = 3;$csv = new Csv($param_arr, $column);//$csv->export();$path = C:\Documents and Settings\Administrator\Temp\txxx.csv;$import_arr = $csv->import($path,3);var_dump($import_arr);?>
生成静态页面源码,ubuntu重启 紫屏,tomcat 高访问量,亚马逊 返爬虫,php8 特征,贵州怎么学seo关键词优化靠谱lzw
