??php require_once 'includes/smarty.php'; require_once 'includes/conn.php'; //require_once 'includes/func.php'; //require_once 'includes/c_mysql_page.php'; mysql_query("set names 'utf8'"); require_once 'config.php'; /*---------任何页面都需要的部分----------------------*/ $tid = 1; $smarty->assign('tid',$tid); /*----------------------------------------------*/ //读取最新活动的列表 $active = array(); $sql = "select id,title,post_time from article where category=8 order by post_time desc limit 0,7"; $result = mysql_query($sql); while($rs = mysql_fetch_array($result)){ $active[$rs['id']]['id'] = $rs['id']; $active[$rs['id']]['title'] = $rs['title']; } $smarty->assign('actives',$active); //读取展示? $bactive = array(); $bsql = "select * from banner order by id desc limit 0,1"; $bresult = mysql_query($bsql); while($brs = mysql_fetch_array($bresult)){ $bactive[$brs['id']]['id'] = $brs['id']; $bactive[$brs['id']]['title'] = $brs['title']; $bactive[$brs['id']]['image'] = $brs['image']; $bactive[$brs['id']]['url'] = $brs['url']; } $smarty->assign('bactives',$bactive); $smarty->display('index.html'); ?>