@session_start();require_once(smarty.php);//加载smarty模板类require_once(adodb/adodb.inc.php);//加载adodb数据库//连接数据库
$dbhost = 'localhost'; // 数据库服务器$dbuser = 'root'; // 数据库用户名$dbpwd= 'root'; // 数据库密码$dbname='hejia'; //数据库名称$conn = newadoconnection('mysql'); // 建立连接对象
$conn->connect($dbhost, $dbuser, $dbpwd, $dbname); //连接数据库$conn->query(set names 'gb2312');//来源于mysql_query(set names gbk);date_default_timezone_set(prc); //php获取时间差8小时的解决办法,也可在php.ini里修改date.timezone为prc?>
复制代码
首页 index.php:
require_once(const.php);$sql1=select id,hits,title,add_date from oa_art order by id desc; //sql语句$pagesize=4; //设置每页记录数$sql=$sql1. limit .($pagesize * ((empty($_request['page']) ? 1 : $_request['page'])-1))., .$pagesize;$news_array=$conn->getall($sql); $news_array1=$conn->getall($sql1);$page_url=index.php; //页面url地址$totalnumber=count($news_array1); //获得总记录数$midpage=5; //数字导航链接数page();// 调用分页函数for ($i = 0; $i $smarty->assign(page_option,$page_option);
$smarty->assign(news_data,$news_array);
$smarty->assign(mytitle,企业网站首页);$smarty->display(tpl.htm,$page);?>
复制代码
分页函数：
1?\n:; $next = $currentpage >>\n:; $first = $currentpage > 1?首页\n:; $last = $currentpage 尾页\n:; // 导航链接
$midpages = ''; $num = $currentpage-floor($midpage/2); if($num > 0) { if(($totalpage-$num) { $tmp = $totalpage - $midpage; $num = $tmp } }else $num = 1; for($i=1; $i { if($num > $totalpage) break; $midpages .= ($num == $currentpage) ? '['.$num.'] ' : .$num. ; } $smarty->assign(page_total,$total); // 总计 $smarty->assign(page_currentpage,$currentpage); // 当前页码 $smarty->assign(page_totalpage,$totalpage); // 总页数 $smarty->assign(page_back,$back); // 上一页 $smarty->assign(page_next,$next); // 下一页 $smarty->assign(page_first,$first); // 首页 $smarty->assign(page_last,$last); // 尾页 $smarty->assign(page_midpages,$midpages); // 中间页 $smarty->assign(page_url,$page_url); // 当前页地址 }?>
复制代码
模板页 tpl.htm: