📄 project.php
字号:
<?
session_start();
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
<base target="_self">
<style type=text/css>
<!--
A:link {color:#333333;text-decoration:none;}
A:visited {color:#333333;text-decoration:none;}
A:hover {color:#333333;text-decoration:underline overline;}
A:active {color:#333333;text-decoration:none;}
input.radio {background: #EFF3F9; color:#000000}
font { FONT-size: 9pt; line-height: 13pt; FONT-FAMILY:宋体, Arial, Helvetica}
font_size { FONT-size: 9pt; line-height: 13pt; FONT-FAMILY:宋体, Arial, Helvetica}
SELECT { FONT-size: 9pt; line-height: 13pt; FONT-FAMILY:宋体, Arial, Helvetica; BACKGROUND-COLOR: #efefef}
table { FONT-size: 9pt; line-height: 13pt; FONT-FAMILY:宋体, Arial, Helvetica}
td { FONT-size: 9pt; line-height: 13pt; FONT-FAMILY:宋体, Arial, Helvetica}
textarea { BACKGROUND-COLOR: #efefef; BORDER-BOTTOM: 1px double; BORDER-LEFT: 1px double; BORDER-RIGHT: 1px double; BORDER-TOP: 1px double; COLOR: #000000; font-size: 9pt ;FONT-FAMILY:宋体, Arial, Helvetica}
.Coolinput { BACKGROUND-COLOR: #EFF3F9; BORDER-BOTTOM: 1px double; BORDER-LEFT: 1px double; BORDER-RIGHT: 1px double; BORDER-TOP: 1px double; COLOR: #000000; font-size: 9pt; FONT-FAMILY:宋体, Arial, Helvetica}
INPUT { BACKGROUND-COLOR: #EFF3F9; CURSOR: HAND; BORDER-TOP-WIDTH: 1px; PADDING-RIGHT: 1px; PADDING-LEFT: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 9pt; FONT-FAMILY: "宋体, Arial, Helvetica"; BORDER-LEFT-COLOR: #cccccc; BORDER-BOTTOM-WIDTH: 1px; BORDER-BOTTOM-COLOR: #cccccc; PADDING-BOTTOM: 1px; BORDER-TOP-COLOR: #cccccc; PADDING-TOP: 1px; HEIGHT: 18px; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #cccccc}
BODY { FONT-FAMILY: 宋体; FONT-SIZE: 9pt; SCROLLBAR-HIGHLIGHT-COLOR: buttonface; SCROLLBAR-SHADOW-COLOR: buttonface; SCROLLBAR-3DLIGHT-COLOR: buttonhighlight; SCROLLBAR-TRACK-COLOR: #eeeeee; SCROLLBAR-DARKSHADOW-COLOR: buttonshadow }
//-->
</style>
</head>
<body bgcolor="#F2F8FF">
<table width="458" border="0" cellspacing="0" cellpadding="2" align="center">
<tr class="colheader2" bgcolor="#D9EEE4" >
<td colspan="3">项目开发</td>
</tr>
</table>
<table class=table1 cellspacing=1 cellpadding=5 width="472" border=0>
<tbody>
<form class=form1 id=form1 name=form1 action=project.php?act=search method=post>
<tr class=content>
<td>
<input type=hidden value='<?=$id?>' name=id>
<input class=tx3 size=40 name=keyword2 value="<?=$keyword2?>">
<input class=btn2 id=submit1 type=submit value=查找 border=0 name=submit122 valign="middle">
</td>
</tr>
</form>
</tbody>
</table>
<?
include ("../setup.php");
include ("../$db_class.php");
$db_class = "".$db_class."_access";
$db = new $db_class;
$ret = $db->DB_connect();
?>
<table border="0" align="center" width="600" cellspacing="1" cellpadding="5"
class="table1" bgcolor="#B3B3B3">
<?
$pagesize=15;
if($act==search){
$sql1="select id,title,posttime,money,state,zq,completepesent,click from devproject where title like '%$keyword2%' or info like '%$keyword2%' order by id desc";
}else{
$sql1="select id,title,posttime,money,state,zq,completepesent,click from devproject order by id desc";
}
$result1=$db->DB_query($sql1);
$rowcount = $db->DB_num_rows($result1);
$pagecount = intval(($rowcount+$pagesize-1)/$pagesize);
if(!isset($pageno)){
$pageno=1;
}
if($pageno<1) $pageno = 1;
if($pageno>$pagecount) $pageno = $pagecount;
$start=($pageno-1)*$pagesize+1;
$end=$pageno*$pagesize;
if($end>$rowcount){
$end=$rowcount;
}
if($start<1){
$start=0;
}
echo" <tr bgcolor=#D9EEE4>".
" <td colspan=6 valign=TOP>";
echo" 共".$rowcount."个 本页显示第$start-".$end."个</font></td> </tr>";
?>
<tr class="colheader1" bgcolor="#F2FBF6" >
<td width=30>
<div align="center">序号</div>
</td>
<td width=200>
<div align="center">标题 </div>
</td>
<td width="60">
<div align="center">开发费用</div>
</td>
<td width="60">
<div align="center">完成情况</div>
</td>
<td width="50">
<div align="center">浏览数</div>
</td>
<td width="110">
<div align="center">上传日期 </div>
</td>
</tr>
<?
if($pageno>0){
$db->DB_data_seek($result1,($pageno-1)*$pagesize) or die("无法定位数据！");
$i=0;
$j=$start;
while(($i<$pagesize) and (list($id2,$title,$posttime,$money,$state,$zq,$completepesent,$click)=$db->DB_fetch_row($result1))){
$i++;
?>
<tr bgcolor="#FCFCF7" >
<td>
<?=$j?>
</td>
<td> <a href="dispbbspro.php?id=<?=$id2?>">
<?=$title?>
</a> </td>
<td>
<?=$money?>
</td>
<td>
<?=$completepesent?>％
</td>
<td>
<?=$click?>
</td>
<td>
<?=$posttime?>
</td>
</tr>
<?
$j++;
}
echo" <tr bgcolor=#D9EEE4>".
" <td colspan=6 valign=TOP><p align=CENTER>";
if($pageno>1){
echo "<a href=\"project.php?id=$id&pageno=1&keyword2=$keyword2&act=$act\"><font color='000000'>第一页</font></a> ";
echo "<a href=\"project.php?id=$id&pageno=".($pageno-1)."&keyword2=$keyword2&act=$act\"><font color='000000'>上一页</font></a> ";
}
if($pageno<$pagecount){
echo "<a href=\"project.php?id=$id&pageno=".($pageno+1)."&keyword2=$keyword2&act=$act\"><font color='000000'>下一页</font></a> ";
echo "<a href=\"project.php?id=$id&pageno=".$pagecount."&keyword2=$keyword2&act=$act\"><font color='000000'>最后一页</font></a> ";
}
echo"</td>".
" </tr>";
}
$db->DB_close();
?>
</table>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -