正文

php保存数据到文件 php如何把文件保存到本地

IP云
IP云V管理员/4 阅读
03/14
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

PHP中，从数据库取出几条数据，如何先生成xls文件，然后保存到指定文件夹下面？

$keynames=array(

'0'='订单号',

'1'='项目名称',

'2'='单价',

'3'='数量',

'4'='运费',

'5'='金额',

'6'='支付状态',

'7'='支付时间',

'8'='选项',

'9'='备注',

'10'='收件人',

'11'='手机',

'12'='送货地址',

'13'='物流',

'14'='物流单号'

);

down_excel($eorders, $keynames,$array_key, $name);

//生成简单excel。table生成。生成excel非标准。phpexcel生成的标准，可读写excel

function down_xls($data, $keynames, $name = 'dataxls') {

$xls [] = "htmlmeta http-equiv=content-type content=\"text/html; charset=UTF-8\"bodytable border='1'";

$xls [] = "trtdID/tdtd" . implode ( "/tdtd", array_values ( $keynames ) ) . '/td/tr';

foreach ( $data as $o ) {

$line = array (++ $index );

foreach ( $keynames as $k = $v ) {

$line [] = $o [$k];

}

$xls [] = 'trtd' . implode ( "/tdtd", $line ) . '/td/tr';

}

$xls [] = '/table/body/html';

$xls = join ( "\r\n", $xls );

header ( 'Content-Disposition: attachment; filename="' . $name . '.xls"' );

die ( mb_convert_encoding ( $xls, 'UTF-8', 'UTF-8' ) );

}

//add by wqc excel

function down_excel($data, $keynames,$array_key, $name = 'dataxls') {

require_once(dirname(dirname(dirname(__FILE__))) . '/PHPExcel/PHPExcel.php');

require_once(dirname(dirname(dirname(__FILE__))) . '/PHPExcel/PHPExcel/IOFactory.php');

//实例化phpexcel

$objPHPExcel = new PHPExcel();

$objPHPExcel-getActiveSheet()-getDefaultColumnDimension()-setWidth(16);//设置单元格宽度

$objPHPExcel-getActiveSheet()-setTitle('kutuan');//设置当前工作表的名称

foreach($keynames as $k=$r){

$objPHPExcel-getActiveSheet()-getStyleByColumnAndRow($k, 1)-getFont()-setBold(true);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow($k, 1, $r);

}

foreach($data as $key=$value)

{

//$objPHPExcel-getSheet(1)-getProtection()-setSheet(true);

//$objPHPExcel-getSheet(1)-protectCells(0, ($key+2),$value['id']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(0, ($key+2),$value['id']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(1, ($key+2),$value['team_id']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(2, ($key+2),$value['price']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(3, ($key+2),$value['quantity']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(4,($key+2),$value['fare']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(5, ($key+2),$value['origin']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(6, ($key+2),$value['state']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(7, ($key+2),$value['pay_time']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(8, ($key+2),$value['condbuy']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(9, ($key+2),$value['remark']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(10, ($key+2),$value['realname']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(11, ($key+2),$value['mobile']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(12, ($key+2),$value['address']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(13, ($key+2),$value['express']);

$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow(14, ($key+2),$value['express_no']);

}

$objPHPExcel-setActiveSheetIndex(0);//设置打开excel时显示哪个工作表$name.

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

header("Content-Type: application/force-download");

header("Content-Type: application/octet-stream");

header("Content-Type: application/download");

header("Content-Disposition: attachment; filename=".$name);

header("Content-Transfer-Encoding: binary");

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header("Pragma: no-cache");

return $objWriter-save('php://output');

}

相关问答

Q1: php怎么按行保存数据到txt

$name = addslashes(stripslashes($_POST['name']));//主要是反转义用户输入的个别转义字符，然后统一转义；

$password = $_POST['pwd'];

$content = $name."\t".$password."\r\n";

$f = fopen('test.txt', 'a+');//我猜测你应该是想累加存储，在文件的结尾插入，所以用了fopen和a+，

fwrite($f, $content);

fclose($f);

在提取post中的之前，严谨点可以加上空值判断

Q2: PHP 当前表单数据保存为excel文件

构造函数：

function down_xls($data, $keynames, $name='dataxls') {

$xls[] = "htmlmeta http-equiv=content-type content=\"text/html; charset=UTF-8\"bodytable border='1'";

$xls[] = "trtdID/tdtd" . implode("/tdtd", array_values($keynames)) . '/td/tr';

foreach($data As $o) {

$line = array(++$index);

foreach($keynames AS $k=$v) {

$line[] = $o[$k];

}

$xls[] = 'trtd'. implode("/tdtd", $line) . '/td/tr';

}

$xls[] = '/table/body/html';

$xls = join("\r\n", $xls);

header('Content-Disposition: attachment; filename="'.$name.'.xls"');

die(mb_convert_encoding($xls,'UTF-8','UTF-8'));

}

函数引用：

if(strval($_GET['download'])){

$orders = DB::LimitQuery('order', array(

'condition' = $condition,

'order' = 'ORDER BY id DESC',

));

if (!$orders) die('没有符合条件的记录');

$name = 'order_'.date('Ymd');

$kn = array( //excel表列名与数据字段的对应关系

'id' = '订单号',

'price' = '订单金额',

'card' = '代金券',

'create_time' = '下单时间',

'pay_time' = '付款时间',

);

foreach( $orders AS $one ){

$one['create_time'] =date("Y-m-d",$one['create_time']);

$one['pay_time']=date("Y-m-d",$one['pay_time']);

$eorders[] = $one;

}

down_xls($eorders, $kn, $name);

}

Q3: php 把post或get的数据存在文件里

假如你已经定义了get请求方法

$r = get('网址')；

file_put_contents('保存的文件名'，$r);

Q4: PHP将数据写入txt文件

//记录返回值

        $write_data_a = [

            'html_url'  =  $getUrl,

            'ip'    = $this-get_real_ip(),

            'time'  =  date("Y-m-d H:i:s",time()),

            'res'   = $response

        ];

//转化为JSON

        $write_data_a = json_encode($write_data_a) . '||' . "\n";

        $date = date("Y-m-d", time());

//项目路径目录，判断是否存在，不存在则创建

        $lujing = "./360_mobile_res_sd";

        if(!is_dir($lujing)){

            mkdir(iconv("UTF-8", "GBK", $lujing),0777,true);

        }

//文件，判断是否存在，不存在则创建

        $TxtFileName = "./360_mobile_res_sd/" . $date . "_2.txt";

        //以读写方式打写指定文件，如果文件不存则创建

        if(file_exists($TxtFileName))

        {

//存在，追加写入内容

            file_put_contents($TxtFileName, $write_data_a, FILE_APPEND);

        }

        else

        {

//不存在，创建并写入

            if( ($TxtRes=fopen ($TxtFileName,"w+")) === FALSE){

                exit();

            }

            if(!fwrite ($TxtRes,$write_data_a)){ //将信息写入文件

                fclose($TxtRes);

                exit();

            }

            fclose ($TxtRes); //关闭指针

        }

Q5: 关于PHP文件操作: php保存数据到文本文件，怎么弄？

把你要保存的数据序列化一下，保存到文本中，如果需要修改，则从文本中取出，在反序列化化，在修改后，在序列化一下，保存到文本中。

文本的读写 参考fopen 等函数

php保存数据到文件的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于php如何把文件保存到本地、php保存数据到文件的信息别忘了在本站进行查找喔。