php根据单个年月日文件夹总量返回下一个年月日文件夹名称
<?php
$page=10;//起始的默认开始年月日
$row=$db->query_first('select id,years,length from photo_path_ymd_temp where id=1 limit 1');
$start_date=$row['years'];
$length=$row['length'];
function getymd_temp($start_date,$length,$page){
if(empty($start_date) && empty($length)){
$start_date='20130101';
}
$length=$length+1;
if($length==$page+1){//不能用%运算
$start_date=date('Ymd',strtotime($start_date)+86400);
$length=1;//注意,这里初始值应该为1
}
return array($start_date,$length);
}
for($i=1;$i<=2000;$i++){//测试2000条
$ymdPathArr=getymd_temp($start_date,$length,$page);
$start_date=intval($ymdPathArr[0]);
$length=$ymdPathArr[1];
$db->query('update photo_path_ymd_temp set years='.$start_date.',length='.$length.' where id=1 limit 1');
echo substr($start_date,0,4).substr($start_date,4,2).'/'.substr($start_date,6,2).':'.$length.'<br />';
}
?>
附上mysql表的sql语句
DROP TABLE IF EXISTS `photo_path_ymd_temp`;
CREATE TABLE `photo_path_ymd_temp` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`years` int(8) DEFAULT '0' COMMENT '年月日',
`length` int(11) unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of photo_path_ymd_temp
-- ----------------------------
INSERT INTO `photo_path_ymd_temp` VALUES ('1', '0', '0');
近期评论