[debug]select * from `dt` where 1=1 and `key`='admin'
[debug]当前页面原始路径:index
[debug]select * from `home_layout` where 1=1 and `Id`='1'
[debug]select * from `home_column` Array
[debug]select * from `home_link`
[debug]select * from `home_music`
[debug]select * from `home_user_info` where 1=1 and `ip`='3.236.107.249'
[debug]SELECT
NUMERIC_SCALE,COLUMN_NAME,DATA_TYPE
FROM
information_schema. COLUMNS
WHERE TABLE_NAME = 'home_user_info' and COLUMN_NAME='hits';
[debug]SELECT
NUMERIC_SCALE,COLUMN_NAME,DATA_TYPE
FROM
information_schema. COLUMNS
WHERE TABLE_NAME = 'home_user_info' and COLUMN_NAME='hits';
[debug]START TRANSACTION
[debug]insert into `home_user_info` (`ip`,`browser`,`hits`,`first_time`,`time`) values('3.236.107.249','CCBot/2.0 (https://commoncrawl.org/faq/)','0','2022-07-07 21:00:57','2022-07-07 21:00:57')
[debug]COMMIT
[debug]SELECT LAST_INSERT_ID()
//布局
#header()
#body()
#footer()
#header{}#
#body{}#
#footer{}#
//打印参数
!!$str!!
//执行php代码
!{}!
//遍历数组,来循环显示多条数据
!{each $arr}
!``
!{/each}
//这里放关键字,防止整理代码格式的时候关键字被破坏
/*d
d*/
//if语句
!{if true}
!{elif false}
!{else}
!{/else}
#查询#
//有多行就输出数组,否则返回单个list(有些情况必须返回数组,就添加order)
show("df",1,"type"," ");
// 根据字符串进行查询
show("df","谷雨光影","subs");
// 按id降序输出全表
show("df",-1,"id","desc");
//输出type为1的特定数目的数据
show("df",1,"type","limit 0,5");
//输出type为1的数据并进行排序
show("df",1,"type","order by id desc");
//执行sql语句
show("select * from df",0);
//按条件输出全表
show("menu",$param,"parent","order by oderNum desc");
//分页查询(页数,行数)
show_page(self::$db_d,$page,$rows);
##新增、修改##
//新增数据,之后不进行任何操作
update("df",$arr)
//根据id新增、修改数据,之后进行页面跳转
update(self::$db_hc,$dt,$id,("homepage/column/".self::$db_hc));
##删除##
//根据id进行删除
del("db",3);
//清空表
clear("db")
#查询返回json数据
//根据id查询
tableToJson("df","id","desc",1);
//根据time降序排列
tableToJson("df","time");
//根据time升序排列
tableToJson("df","time","asc");
//自定义sql查询
tableToJson("sql","select * from df");
#更新返回json
jsonUpdate("db",array("nm"=>"123"),3);
#清空
jsonClear("db")
-由Df打造的php版的Mvc框架,结构简洁,使用方便
-可以在此框架的基础上开发出各种各样的网站
-有很好的拓展性,可以不断增加新的功能
-由df提供技术支持
-此项目将不断完善
-工作QQ:3504725309
-个人网站:www.dfer.top
-论坛:forum.dfer.top
-QQ群:76673820