张宏良博客?'':(张洪量?'':张虹亮'blog)

<?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');