? require “config.php”; dl(“extensions/php_mssql70.dll”); if
(!isset($page)) { $page=1; } if ($page=0) { $page=1; }
$db=mssql_connect($local,$user,$pass); mssql_select_db($name,$db);
$query=mssql_query(“select count(*) as date from news”,$db);
$query=mssql_fetch_array($query);
$pages=ceil($query[0]/$userperpage); if ($page$pages) { $page=$pages;}
if ($query[0]$userperpage) { $userperpage=$query[0]; }
$dangqian=($page-1)*$userperpage; echo “titleNews/title”; echo “style
type=text/css”; echo “!–“; echo “A{text-decoration:none}”; echo
“A:hover{color:blue;; text-decoration: underline}”; echo “td {font-size:
9pt}”; echo “–/style”; echo “div align=centercenter”; echo “table
border=0 width=100% cellspacing=0 cellpadding=0 height=19”; echo “tr”;
echo ” td width=52% colspan=5img src=xw.gif width=100%/td/tr”; echo
“tr”; echo “td width=52% height=19 valign=bottom bgcolor=#B5C6B0p
align=centerfont”; echo “color=#408080新闻标题/font/td”; echo “td
width=14% height=19 valign=bottom align=center bgcolor=#B5C6B0font”;
echo “color=#408080发表日期/font/td”; echo “td width=19% height=19
valign=bottom align=center bgcolor=#B5C6B0font”; echo
“color=#408080发表部门/font/td”; echo “td width=7% height=19
valign=bottom align=center bgcolor=#B5C6B0font”; echo
“color=#408080阅读/font/td”; echo “td width=8% height=19 valign=bottom
align=center bgcolor=#B5C6B0font”; echo “color=#408080图像/font/td”;
echo “/tr”; echo “/table”; echo “/center/div”; echo “div
align=centercenter”; echo “table border=0 width=100% cellspacing=0
cellpadding=0 height=19”; $db=mssql_connect($local,$user,$pass);
mssql_select_db($name,$db); $query=mssql_query(“select * from news
order by date desc”,$db); $roro=mssql_num_rows($query); if ($roro==0)
{ echo “brbrp align=”center”font color=”#FF0000″ size=”2″marquee
behavior=”alternate” border=”0″ width=”300″ height=”16″
scrolldelay=”70″目前数据库中无任何记录!/marquee/font/p”; exit; }
mssql_data_seek($query,$dangqian); $i=0; while
($arr=mssql_fetch_array($query)) { if ($i=$userperpage) { break;} echo
“tr”; echo “td width=52% bgcolor=#F3F3F3 height=19 valign=bottomp
align=lefta href=”readnews.php?id=$arr[date]” target=”_blank”font
color=#3D5449$arr[title]/font/a/td”;
$datee=date(“Y-m-d”,$arr[date]); echo “td width=14% bgcolor=#F3F3F3
height=19 valign=bottom align=centerfont color=#3D5449$datee/font/td”;
echo “td width=19% bgcolor=#F3F3F3 height=19 valign=bottom
align=centerfont color=#3D5449$arr[type]/font/td”; echo “td width=7%
bgcolor=#F3F3F3 height=19 valign=bottom align=centerfont
color=#808080$arr[click]/font/td”; echo “td width=8% bgcolor=#F3F3F3
height=19 valign=bottom align=center”;
$arr[photo]=trim($arr[photo]); if (($arr[photo]””) ||
(file_exists($arr[photo]))) { echo “img src=picture.gif”; } else {
echo “nbsp;”; } echo “/td”; echo “/tr”; $i++; }//while echo “tr”; echo
“td width=100% height=20 colspan=5/td”; echo “/tr”; echo “trtd
width=100% colspan=5center”; if ($page1) { echo “a
href=$PHP_SELF?page=1font color=#408080首页/font/a”; } if ($page1) {
$upage=$page-1; echo “a href=$PHP_SELF?page=$upagefont
color=red/font/a”; } for($y=1;$y=$pages;$y++) { echo “a
href=$PHP_SELF?page=$y$y/a”; } if ($page$pages) { $npage=$page+1; echo
“a href=$PHP_SELF?page=$npagefont color=red/font/a”; } if
($page$pages){ echo “a href=$PHP_SELF?page=$pagesfont
color=#408080尾页/font/a”; } echo “/center/td”; echo “/tr”; echo
“/table”; echo “/center/div”; ?

相关文章