1.数据库表
CREATE TABLE `bang` (
`id` int(11) NOT NULL auto_increment,
`name` char(20) NOT NULL,
`point` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`day` tinyint(4) NOT NULL,
`createtime` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`,`createtime`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
2.函数
我做的是3个榜单,每个月都会更新一会榜单的name,榜单的point每天都会默认加上随机值。数据每天都会变化
/*虚假排行榜*/
function weblistpaihang($type){
$datetime =$this -> getthemonth(date('Y-m-d'));
$starttime = $datetime[0];//每月的第一天
$redtime = $datetime[1];//每月的最后一天
$day = date("d",time());
$name = "";
$point = "";
$nameArray = array("1","2","3","4","e", "输","入","和","参","指","明","了","主","法","f","g","安","国","磊","h","i","j","k","l","m","n","o","安","国","磊","p","q","r","s","t","u","安","国","磊","v","w","x","y","z","A","B","C","D","安","国","磊","E","F","G","H","I","J","安","国","磊","K","L","O","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","安","国","磊","葡","糖","酒","爱","心","小","甜","点","亲","部","长","张","达","王","成","徐","大","也","你","5","6","7","8","9","0","a","b","c","d","干","旱","王","杨","在","你","想","从","o","p","q","r","s","t","u","v","w","x","y","z","A","B","数","组","中","取","出","一","个","或","多","个","随","机","的","单","元","时","相","当","有","用","它","接","受","输","入","和","参","指","明","了","主","法");
switch ($type) {
case 'pub_Count':
$typenum=1;
break;
case 'rec_Count':
$typenum=2;
break;
case 'ref_Count':
$typenum=3;
break;
}
$sql = "select * from `bang` where type='".$typenum."' and createtime>'".$starttime."' and createtime<'".$redtime."' limit 10";
$result = $db->query($sql);
$arr_Count = $result->fetchAll();
if(count($arr_Count) < 10){
for($i=0;$i<10;$i++){
foreach (array_rand($nameArray,5) as $value) {
$name .= $nameArray[$value];
}
switch ($type) {
case 'pub_Count':
$point = rand(800,1200);
break;
case 'rec_Count':
$point = rand(500,800);
break;
case 'ref_Count':
$point = rand(100,300);
break;
}
$sql = "insert into `bang` (name,point,type,day,createtime) values ('".$name."','".$point."',".$typenum.",'".$day."','".date("Y-m-d H:i:s",time())."')";
$db->query($sql);
$arr_Count[$i]["name"] = $name;
$arr_Count[$i]["point"] = $point;
$name = "";
}
}else{
for($i=0;$i<10;$i++){
if($arr_Count[$i]["day"] != $day){
switch ($type) {
case 'pub_Count':
case 'rec_Count':
$rand = rand(100,200);
break;
case 'ref_Count':
$rand = rand(50,100);
break;
}
$arr_Count[$i]["point"] = $arr_Count[$i]["point"] + $rand;
$sql = "update `bang` set point='".$arr_Count[$i]["point"]."',day='".$day."' where id=".$arr_Count[$i]["id"]." and type=".$typenum;
$db->query($sql);
}
}
}
return $arr_Count;
}