 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
//the following is list.php3 <head> <STYLE TYPE="text/css"> td{ font-size: 9pt } td.note{font-size:10.5pt} .input {background="#ccddff";font-size: 9pt} A:link {text-decoration:none} A:hover {color:red;text-decoration:underline} </style> </head> <? switch($modID){ case 0: include "list.inc"; //***********************Connect the db***************************** $db=mysql_connect($server,$uid,$pwd); mysql_select_db($dbname,$db); //********************Insert a record******************************* if($name&&$mess) { $date=date("y-m-d H:i:s"); $date=strval($date); $flag=date("z"); $flag=intval($flag); $sql="insert into book(name,title,mess,date,flag,email) values('$name','$title','$mess','$date','$flag','$email')"; $result=mysql_query($sql); @mysql_free_result($result); echo"<meta http-equiv=\"refresh\" content=\"0;URL=$PHP_SELF\">"; } $sql = "select count(*) as total from book";//生成查询记录数的SQL语句 $rst = mysql_query($sql); $row = mysql_fetch_array($rst) ; $rowcount = $row["total"];//取出记录数 mysql_free_result($rst); $pagecount = bcdiv($rowcount+$pagesize-1,$pagesize,0);//算出总共有几页 if(!isset($pageno)) $pageno = $pagecount;//在没有设置pageno时，缺省为显示第1页 if($pageno<1) $pageno = 1;//若pageno比1小，则把它设置为1 if($pageno>$pagecount) $pageno = $pagecount;//若pageno比总共的页数大，则把它设置为最后 一页 echo "<table width=\"92%\" cellpadding=\"5\" cellspacing=\"0\" bgcolor=\"#ddffff\" align=\"center\" border=\"1\" bordercolorlight=\"#000000\" bordercolordark=\"#FFFFFF\"> <tr> <td class=note>资讯交流</td> <td class=note><a href=\"$PHP_SELF?modID=1\">添加资讯</a></td>"; if($pageno>0){ $href = eregi_replace("%2f","/",urlencode($PHP_SELF)); if($pageno>1){//显示上一页的裢接 echo '<td ><a class=note href="' . $href . '?pageno=' . ($pageno-1) . '">前一页 </a></td>'; } else{ echo '<td>前一页</td>'; } if($pageno<$pagecount){//显示下一页的裢接 echo '<td><a class=note href="' . $href . '?pageno=' . ($pageno+1) . '">下一页 </a></td>'; } else{ echo '<td>下一页</td>'; } echo "</tr></table>"; $sql = "select * from book order by id desc LIMIT 0,$pagesize";//生成查询本页数据的SQL语句 $rst = mysql_query($sql);//查询本页数据 $num_fields = mysql_num_fields($rst);//取得字段总数 echo mysql_error(); $i = 0; while($i<$num_fields){//取得所有字段的名字 $fields[$i] = mysql_field_name($rst,$i);//取得第i+1个字段的名字 $i++; } echo "<table width=\"92%\" cellpadding=\"5\" cellspacing=\"0\" align=\"center\" border=\"1\" bordercolorlight=\"#000000\" bordercolordark=\"#FFFFFF\">\n"; while ($myrow=mysql_fetch_array($rst)) { printf("<tr><td bgcolor=\"ACD3FF\"> <a href=\"$PHP_SELF?id=$myrow[id]&pageno=$pageno#$myrow[id]\"> 标题:%s牋牋 姓名:<strong>%s<strong></a></td> <td bgcolor=\"#ddffff\">来源:%s <a name=\"$myrow[id]\">时间:%s</a></td></tr>\n", $myrow[title],$myrow[name],$myrow[email],'20'.$myrow[date]); if ($myrow[id]==$id) { echo "<tr><td bgcolor=\"cee5ff\"><font color=\"004890\">内容:</font> <pre>".$myrow[mess]."</pre></td></tr>"; } } } echo "</table>"; @mysql_free_result($ret); $action="null"; //****************************************************************** mysql_close($db); break; case 1; echo '<hr><div align=center> <a name="post"><b>欢迎来到资讯中心</b></a><br> <form action="'.$PHP_SELF.'?" method="POST"> 标题: <input type="Text" name="title" size="40" maxlength="50" class="input"><br> 姓名 : <input type="Text" name="name" size="40" maxlength="50" class="input"><br> EMAIL: <input type="Text" name="email" size="40" maxlength="50" class="input"><br> 内容:<br> <textarea name="mess" cols="48" rows="8" wrap="hard" class="input"></textarea><br> <input type="Submit" name="action" value="Submit" class="input"> <input type="reset" class="input"> </form> </div> <hr>'; $modID=0; break; } ?> //the following is list.inc <? $server="localhost"; //mysql server address $dbname="sanry"; // mysql database name $uid="jtan"; // username for that database $pwd="8888"; // password for that database $pagesize = 10;//每页显示10条记录 ?> | |||||
| Related Code Examples | |||||
