php快速导出csv格式数据程序代码

$exportdata = '规则111,有效期'."＼n";

header("Content-type:application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$filename");

$exportdata = '规则111,规则222,审222,规222,服2222,规则1,规则2,规则3,匹配字符,设置时间,有效期'."＼n";
$date = date("YmdHis");
if (!empty($lists)){
    foreach($lists as $key => $value){
      $time = date("Y-m-d_H:i:s", $value['add_time']);
      $exportdata .= "＼"＼t".$value['Rule_id']."＼",＼"＼t".$value['Rule_name']."＼",＼"＼t".$value['Matching_level']."＼",＼"＼t"."{$value['Rule_action']}"."＼",＼"＼t".$value['Service_type']."＼",＼"＼t".$value['Keyword1']."＼",＼"＼t".$value['Keyword2']."＼",＼"＼t".$value['Keyword3']."＼",＼"＼t".$value['Matching_word']."＼",＼"＼t".$value['Set_time']."＼",＼"＼t".$value['Validation_time']."＼"＼n";
    }
}
$filename = "plcnetinfo_{$date}.csv";
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$filename");
header("Expires: 0");
header("Pragma: public");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: public");
     
echo(mb_convert_encoding($exportdata,"gb2312","UTF-8"));

<?php
export_csv();
function export_csv() {
$filename = date('YmdHis').".csv";//文件名
header("Content-type:text/csv");
header("Content-Disposition:attachment;filename=".$filename);
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Expires:0');
header('Pragma:public');
echo array_to_string(get_export_data());
}
function array_to_string($result) {
if(empty($result)) {
return i("没有符合您要求的数据！^_^");
}
$data = '书ID,书名'."＼n"; //栏目名称
$size_result = sizeof($result);
for($i = 0 ; $i < $size_result ; $i++) {
$data .= i($result[$i]['name']).','.i($result[$i]['option'])."＼n";
}
return $data;
}
function get_export_data() {
$link = mysql_connect('localhost','root','121051xz') or die(mysql_error());
mysql_select_db('ht');
mysql_query("set names 'utf8'");//定义编码
$sql = 'select * from booklist';
$result = mysql_query($sql);
$rowaa = mysql_fetch_array($result);
$res = array();
$i = 0;
while($row = mysql_fetch_array($result)) {
$res[$i]['name'] = $row['bookid'];
$res[$i]['option'] = $row['bookname'];
$i++;
}
return $res;
}
function i($strInput) {
return iconv('utf-8','gb2312',$strInput);//页面编码为utf-8时使用，否则导出的中文为乱码
}

$cfg['Servers'][$i]['AllowNoPassword'] = false;

改为：

$cfg['Servers'][$i]['AllowNoPassword'] = true;

//团购1
$t=1;
$tugou = esf(" * "," setindex='1' $cwhere  order by id desc limit 0,6","A表");
foreach( $tugou as $v =>$_v )
{
 $tugou[$v]['i'] =$t++;  
}

$abpccount = count( $tugou );

//echo $abpccount;
if( $abpccount < 6 )
{
 $page->tpl->assign('notg',1);//调用团购标签
 $abpclimit = 6 - $abpccount;
 
 $tugou_loupan = esf(" * "," index_dt='1' $cwhere  order by id desc limit 0,$abpclimit ","B表");
 foreach( $tugou_loupan as $v =>$_v )
 {  
  $tugou_loupan[$v]['i'] =$t++; 
  $tugou_loupan[$v]['abpcindexpic'] = $_v['abpcthumb']; 
  $tugou_loupan[$v]['abpclitpic'] = $_v['abpcthumb'];
  $tugou_loupan[$v]['abpcname'] = mt_rand(10,80);
  $tugou_loupan[$v]['abpcdown'] = 'xx 惠';
  $tugou_loupan[$v]['abpclpname'] = $_v['abpcname'];
 }
 $tugou = array_merge($tugou,$tugou_loupan);
 
}

$page->tpl->assign('tugou',$tugou);

;no-debug-non-zts-20090626 这个文件夹名称和php版本是一一对应的
zend_extension= "/usr/local/php/lib/php/extensions/no-debug-non-zts-20090626/xdebug.so"
xdebug.default_enable = On
xdebug.show_exception_trace = On
xdebug.show_local_vars = 1
xdebug.max_nesting_level = 50
xdebug.var_display_max_depth = 6

xdebug.dump_once = On
xdebug.dump_globals = On
xdebug.dump_undefined = On
xdebug.dump.REQUEST = *
xdebug.cli_color = 2

echo xdebug_time_index();
sleep(3);echo "<br>";
echo xdebug_time_index();

echo "<br>";
echo xdebug_memory_usage();
echo "<br>";
echo xdebug_peak_memory_usage();

testXdebug();
function testXdebug() {
       requireFile();
}

function requireFile() {
       require_once('abc.php');
}

xdebug.remote_enable = 0
xdebug.profiler_enable = 0
xdebug.remote_autostart = false

 <script type="text/javascript" src="jquery.js"></script>
 <script type="text/javascript" src="ajaxfileupload.js"></script>
 <script type="text/javascript">
 function ajaxFileUpload()
{
$.ajaxFileUpload
(
  {
 url:'doajaxfileupload.php', //你处理上传文件的服务端
 secureuri:false,
 fileElementId:'img',
 dataType: 'json',
 success: function (data)
 {
alert(data.file_infor);
 }
 }
 )
  return false;
  }
  </script>
相应的HTML为：
  <input id="img" type="file" size="45" name="img" class="input">
  <button class="button" id="buttonUpload" onclick="return ajaxFileUpload();">Upload</button>

<div class="frm">
  <form name="uploadFrom" id="uploadFrom" action="upload.php" method="post"  target="tarframe" enctype="multipart/form-data">
   <input type="file" id="upload_file" name="upfile">
  </form>
  <iframe src=""  width="0" height="0" style="display:none;" name="tarframe"></iframe>
 </div>
 <div id="msg">
 </div>

index.js
$(function(){
 $("#upload_file").change(function(){
   $("#uploadFrom").submit();
 });
});

function stopSend(str){
 var im="<img src='upload/images/"+str+"'>";
 $("#msg").append(im);
}
 
upload.php

<?php
 $file=$_FILES['upfile'];
 $name=rand(0,500000).dechex(rand(0,10000)).".jpg";
 move_uploaded_file($file['tmp_name'],"upload/images/".$name);
//调用iframe父窗口的js 函数
 echo "<script>parent.stopSend('$name')</script>";
?>

<!DOCTYPE html>
<html>
<head>
    <title>Html5 Ajax 上传文件</title>
    <meta charset="utf-8">
<script type="text/javascript">

    var xhr;
    function createXMLHttpRequest()
    {
        if(window.ActiveXObject)
        {
            xhr = new ActiveXObject("Microsoft.XMLHTTP");
        }
        else if(window.XMLHttpRequest)
        {
            xhr = new XMLHttpRequest();
        }
    }

    function UpladFile()
    {
        var fileObj = document.getElementById("file").files[0];
        var FileController = 'upload.php';
        var form = new FormData();
        form.append("myfile", fileObj);
        createXMLHttpRequest();
        xhr.onreadystatechange = handleStateChange;
        xhr.open("post", FileController, true);
        xhr.send(form);
    }

    function handleStateChange()
    {
        if(xhr.readyState == 4)
        {
            if (xhr.status == 200 || xhr.status == 0)
            {
                var result = xhr.responseText;
                var json = eval("(" + result + ")");
                alert('图片链接:n'+json.file);
            }
        }
    }

</script>

<style>
    .txt{ height:28px; border:1px solid #cdcdcd; width:670px;}
    .mybtn{ background-color:#FFF; line-height:14px;vertical-align:middle;border:1px solid #CDCDCD;height:30px; width:70px;}
    .file{ position:absolute; top:0; right:80px; height:24px; filter:alpha(opacity:0);opacity: 0;width:260px }
</style>
</head>

<body>
<div class="form-group">
    <label class="control-label">图片</label>
    <br/>
    <input type='text' name='textfield' id='textfield' class='txt' />
    <span onclick="file.click()"  class="mybtn">浏览...</span>
    <input type="file" name="file" class="file" id="file" size="28" onchange="document.getElementById('textfield').value=this.value" />
    <span onclick="UpladFile()" class="mybtn">上传</span>
</div>
</body>

</html>

<?php
if(isset($_FILES["myfile"]))
{
$ret = array();
$uploadDir = 'images'.DIRECTORY_SEPARATOR.date("Ymd").DIRECTORY_SEPARATOR;
$dir = dirname(__FILE__).DIRECTORY_SEPARATOR.$uploadDir;
file_exists($dir) || (mkdir($dir,0777,true) && chmod($dir,0777));
if(!is_array($_FILES["myfile"]["name"])) //single file
{
$fileName = time().uniqid().'.'.pathinfo($_FILES["myfile"]["name"])['extension'];
move_uploaded_file($_FILES["myfile"]["tmp_name"],$dir.$fileName);
$ret['file'] = DIRECTORY_SEPARATOR.$uploadDir.$fileName;
}
echo json_encode($ret);
}
?>