---------------------关于CMF邮箱注册------------------------------------------------
https://www.thinkcmf.com/topic/1917.html
还要配置数字验证码–》邮件模板标题{$code}
判断用户是否存在
<div style="padding-top:15px;margin-bottom: -22px;">
<span><a href="{:url('user/login/index')}">登录</a></span>
<span><a href="{:url('user/register/index')}">注册</a></span>
</div>
<else/>
<div style="padding-top:15px;margin-bottom: -22px;">
<span><a href="{:url('user/profile/center')}">个人中心</a></span>
<span><a href="{:url('user/index/logout')}">退出</a></span>
</div>
</if>
----------------------关于CMF表格导出----------------------------------------
参考地址—》https://www.cnblogs.com/hzhenx/p/9604747.html
public function explode_post(){
vendor(“PHPExcel.PHPExcel”);
$objPHPExcel = new \PHPExcel(); //创建PHPExcel实例
/--------------1设置表头信息------------------/
//
o
b
j
P
H
P
E
x
c
e
l
−
>
g
e
t
A
c
t
i
v
e
S
h
e
e
t
(
)
−
>
m
e
r
g
e
C
e
l
l
s
(
′
A
1
:
C
2
′
)
;
/
/
objPHPExcel->getActiveSheet()->mergeCells('A1:C2'); //
objPHPExcel−>getActiveSheet()−>mergeCells(′A1:C2′);//objPHPExcel->getActiveSheet()->getColumnDimension(‘D’)->setWidth(10);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue(‘A1’, ‘ID’);
$objPHPExcel->getActiveSheet(0)
->setCellValue(‘A1’, ‘ID’)
->setCellValue(‘B1’, ‘name’)
->setCellValue(‘C1’, ‘number’)
->setCellValue(‘D1’, ‘status’);
/--------------2开始从数据库提取信息插入Excel表中------------------/
d
a
t
a
=
M
(
′
g
r
a
d
e
′
)
−
>
s
e
l
e
c
t
(
)
;
f
o
r
e
a
c
h
(
data=M('grade')->select(); foreach(
data=M(′grade′)−>select();foreach(data as
k
=
>
k=>
k=>v){
$key = $k + 2;
o
b
j
P
H
P
E
x
c
e
l
−
>
s
e
t
A
c
t
i
v
e
S
h
e
e
t
I
n
d
e
x
(
0
)
−
>
s
e
t
C
e
l
l
V
a
l
u
e
(
"
A
"
.
objPHPExcel->setActiveSheetIndex(0) ->setCellValue("A".
objPHPExcel−>setActiveSheetIndex(0)−>setCellValue("A".key,
v
[
′
i
d
′
]
)
−
>
s
e
t
C
e
l
l
V
a
l
u
e
(
"
B
"
.
v['id']) ->setCellValue("B".
v[′id′])−>setCellValue("B".key,
v
[
′
n
a
m
e
′
]
)
−
>
s
e
t
C
e
l
l
V
a
l
u
e
(
"
C
"
.
v['name']) ->setCellValue("C".
v[′name′])−>setCellValue("C".key,
v
[
′
n
u
m
b
e
r
′
]
)
−
>
s
e
t
C
e
l
l
V
a
l
u
e
(
"
D
"
.
v['number']) ->setCellValue("D".
v[′number′])−>setCellValue("D".key, $v[‘status’]);
}
$objPHPExcel->getActiveSheet()->setTitle(‘成功’); //设置sheet的名称
/--------------3下面是设置保存路径------------------/
date_default_timezone_set(“Asia/Shanghai”);
d
a
t
e
=
d
a
t
e
(
"
Y
m
d
H
i
"
)
;
h
e
a
d
e
r
(
′
p
r
a
g
m
a
:
p
u
b
l
i
c
′
)
;
h
e
a
d
e
r
(
′
C
o
n
t
e
n
t
−
t
y
p
e
:
a
p
p
l
i
c
a
t
i
o
n
/
v
n
d
.
m
s
−
e
x
c
e
l
;
c
h
a
r
s
e
t
=
u
t
f
−
8
;
n
a
m
e
=
"
′
.
date = date("YmdHi"); header('pragma:public'); header('Content-type:application/vnd.ms-excel;charset=utf-8;name="'.
date=date("YmdHi");header(′pragma:public′);header(′Content−type:application/vnd.ms−excel;charset=utf−8;name="′.date.’.xls"’);
header(“Content-Disposition:attachment;filename=$date.xls”);//attachment新窗口打印inline本窗口打印
KaTeX parse error: Expected 'EOF', got '\PHPExcel' at position 13: objWriter = \̲P̲H̲P̲E̲x̲c̲e̲l̲_IOFactory::cre…objPHPExcel, ‘Excel5’);//Excel5为xls格式，excel2007为xlsx格式
$objWriter->save(‘php://output’);//这句话必须要加，否侧会报错
exit;
}
/--------------jqeury 判断input是否为空------------------/
<script>
$(".akmall-submit").click(function () {
var defaults = $(".akmall-input-text").val();
if(defaults.length == 0){
alert('请输入必填项信息');
return false;
}
});
</script>
/--------------TP5实现错误跳转404------------------/
将404模板放置在app下
在config里加入以下代码
把 ‘app_debug’ => false,
‘http_exception_template’ => [
// 定义404错误的重定向页面地址
404 => APP_PATH.‘404.html’,
// 还可以定义其它的HTTP status
401 => APP_PATH.‘401.html’,
],
参考地址 http://www.thinkphp.cn/topic/47582.html
662
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
