$data['fselect'] = $titles;
$view = array_shift($args);
if ($view == 'add') {
$data['view'] = 'add';
}
//分类ID
$tnum = intval($view);
if ($tnum != '0') {
if (!in_array($tnum, $t**s)) {
info_page('错误的分类');
}
$where = "AND `tid` = '" . intval($tnum) . "'";
$data['tnum'] = $tnum;
}
//待处理
$waiting = lazy_get_data("SELECT * FROM `app_feed_recommend` ORDER BY `timeline` DESC LIMIT 30 ");
if ($waiting) {
$data['content'] = $content = $waiting;
foreach ($content as $k => $v) {
$uids[] = $v['uid'];
$times[$v['id']] = time2Units($v['timeline']);
}
$data['unames'] = get_name_by_uids($uids);
$data['waiting'] = $waiting;
$data['times'] = $times;
}
//列表
$data['list'] = lazy_get_data("SELECT * FROM `app_feed` WHERE 1 {$where} ORDER BY `time` DESC");
$files = @file_get_contents(dirname(__FILE__) . '/snap.info.txt');
$data['snap'] = unserialize($files);
layout($data, 'default', 'app');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}else{
mysql_select_db("baidunews",$con);
mysql_query("set names 'utf8'");
$sql = "SELECT * FROM `$table` order by `time` desc LIMIT $findNum OFFSET $offset";
// echo $sql;
$result = mysql_query($sql,$con);
while($row = mysql_fetch_array($result)){
//缩短content的字符长度
$subContent = msubstr($row['content'],0,45);
//设置时区
date_default_timezone_set('PRC');
//得到新闻时间
$newstime = strtotime($row['time']);
//当前时间
$now = time();
$difftime = $now - $newstime;
$beforeNow = time2Units($difftime) . '前';
$temp = $img_url.$row['img_url']
.$title.$row['title']
.$content.$subContent
.$time.$beforeNow
.$from.$row['from']
.$last;
echo $temp;
}
}
mysql_close($con);
?>
