随机排序
发表于 : 2010年 3月 3日 00:59
var/Typecho/Db.php 第36行添加:
/** 随机排序 */
const SORT_RAND = 'RAND()';
const SORT_RANDOM = 'RANDOM()';
如果数据库是sqlite,模板里添加:
<?php
$Posts = $this->db->fetchAll($this->db->select()->from('typecho_contents')->where('type = ?', 'post')->order('', Typecho_Db::SORT_RANDOM)->limit('10'), array($this, 'push'));
foreach ($Posts as $Post) {
echo '<li><a href="'.$Post['permalink'].'" target="_blank">'.$Post['title'].'</a></li>';
}
?>
如果数据库是mysql,模板里添加:
<?php
$Posts = $this->db->fetchAll($this->db->select()->from('typecho_contents')->where('type = ?', 'post')->order('', Typecho_Db::SORT_RAND)->limit('10'), array($this, 'push'));
foreach ($Posts as $Post) {
echo '<li><a href="'.$Post['permalink'].'" target="_blank">'.$Post['title'].'</a></li>';
}
?>
/** 随机排序 */
const SORT_RAND = 'RAND()';
const SORT_RANDOM = 'RANDOM()';
如果数据库是sqlite,模板里添加:
<?php
$Posts = $this->db->fetchAll($this->db->select()->from('typecho_contents')->where('type = ?', 'post')->order('', Typecho_Db::SORT_RANDOM)->limit('10'), array($this, 'push'));
foreach ($Posts as $Post) {
echo '<li><a href="'.$Post['permalink'].'" target="_blank">'.$Post['title'].'</a></li>';
}
?>
如果数据库是mysql,模板里添加:
<?php
$Posts = $this->db->fetchAll($this->db->select()->from('typecho_contents')->where('type = ?', 'post')->order('', Typecho_Db::SORT_RAND)->limit('10'), array($this, 'push'));
foreach ($Posts as $Post) {
echo '<li><a href="'.$Post['permalink'].'" target="_blank">'.$Post['title'].'</a></li>';
}
?>