PHP框架模板原理分析

<?php

//这里写绝对路径

//这里写数据库连接

//这里写模板初始化，配置

//这里判断连接变量

//这里包含文件进来运行

//这里输出模板

//这里关闭数据库
?>

class NewsAction {
    public function head() {
        在这里处理每一页头部
    }

    public function index() {
        $this->head();
        在这里处理这一页
    }

    public function show() {
        $this->head();
        在这里处理这一页
    }

$encode = mb_detect_encoding($q, array('GB2312','GBK','UTF-8'));
echo $encode."<br/>";
if($encode=="GB2312")
{
    $q = iconv("GBK","UTF-8",$q);
}
else if($encode=="GBK")
{
    $q = iconv("GBK","UTF-8",$q);
}
else if($encode=="EUC-CN")
{
    $q = iconv("GBK","UTF-8",$q);
}
else//CP936
{
    //$q = iconv("GB2312","UTF-8",$q);
}

// 使用 iconv 转换并判断是否等值，效率不高
function is_utf8 ($str) {
    if ($str === iconv('UTF-8', 'UTF-8//IGNORE', $str)) {
        return 'UTF-8';
    }
}
// 多种编码的情况
function detect_encoding ($str) {
    foreach (array('GBK', 'UTF-8') as $v) {
        if ($str === iconv($v, $v . '//IGNORE', $str)) {
            return $v;
        }
    }
}

$encode = mb_detect_encoding($keytitle, array('ASCII','GB2312′,'GBK’,'UTF-8');

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

改为：

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

$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时使用，否则导出的中文为乱码
}

//团购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);