作者:李华顺http://huacn.cnblogs.com
利用Ajax实现多文件无刷新上传,可以无限制增加上传文件的数量,并可以在线控制是否显示图片等,上传图片按日期进行分类存储
-Author:李华顺http://huacn.cnblogs.com realize multi-use Ajax file upload without refresh, you can upload unlimited increase in the quantity, and can control whether to display online pictures, upload pictures by date classification of storage
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001530s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.083442s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000843s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001098s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000924s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003147s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000886s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003753s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014806s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001131s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 117959 [ RunTime:0.028642s ]