日本国产亚洲-日本国产一区-日本国产一区二区三区-日本韩国欧美一区-日本韩国欧美在线-日本韩国欧美在线观看

當前位置:雨林木風下載站 > 技術開發教程 > 詳細頁面

新聞公布系統 (例子) 一 news

新聞公布系統 (例子) 一 news

更新時間:2022-05-16 文章作者:未知 信息來源:網絡 閱讀次數:

<?
/*
News Donkey v1.0d8b db d88888b db d8b db .d8888.
by Oscar Rylin [oscar@mgon.com] 888o88 88' 88 I8I 88 88'YP
88V8o 88 88ooooo 88 I8I 88 `8bo. 
88 V8o88 88~~~~~ Y8 I8I 88 `Y8b.
88V888 88. `8b d8'8b d8' db 8D
VP V8P Y88888P`8b8' `8d8'`8888Y'
 
 
d8888b..d88b.d8b db db dD d88888b dbdb
88`8D .8PY8. 888o88 88 ,8P' 88' `8bd8'
88 88 8888 88V8o 88 88,8P 88ooooo`8bd8'
88 88 8888 88 V8o88 88`8b 88~~~~~88
88.8D `8bd8' 88V888 88 `88. 88.88
Y8888D'`Y88P'VP V8P YP YD Y88888PYP

This script was made by Oscar Rylin (oscar@mgon.com) while learning PHP w/
MySQL connections.

What the script Does:
 * Provides an easy way to Read news from a MySQL database
 * Prints it out in a nice HTML format which is customizable
 * Provides a secure interface (user/password validation through a MySQL db)
 * Updating news, deleting and adding users and lots of other stuff
*/

include "dbconn.php"; // This is http://zend.com/codex.php?id=35&single=1
include "settings.php"; // The settings file
?>

<html>
<head>
<title>newsM0nger1.0</title>
<style type="text/css">
 .section { font-weight: bold; font-size:10pt; }
 .newsTxt { font-weight: normal; font-size:10pt; color: #ffffff; font-family: verdana; }
 a{ font-weight: bold; font-size:10pt; color: #ffffff; font-family: verdana; }
 a.normal { font-weight: bold; font-size:10pt; color: #000000; font-family: verdana; }
</style>
</head>
<body bgcolor="white">
<? print $header; ?>
<center>
 <table border="1" cellpadding="0" cellspacing="0" bordercolor="black">

<?

$db = mysql_connect($dbHost, $dbUser, $dbPass);
mysql_select_db($dbName,$db);
$result = mysql_query("select count(id) as Total from news",$db);
$row = mysql_fetch_array($result);
mysql_close($db);

if ($row[Total] > 5) {
$pCount = 0;
print "<b>Archive</b> ?";
print "<a href=\"$PHP_SELF?start=0\" class=\"normal\">Main</a> ";
while ($pCount < ($row[Total]/5)-1) {
 ++$pCount;
 print "<a href=\"$PHP_SELF?start=". ($pCount*5) ."\" class=\"normal\">$pCount</a> ";
}
}

$tmpDL = 0;

$sql = new CDBMySQL($dbHost, $dbUser, $dbPass, $dbName);
if ($start) {
 $sql -> Query ("SELECT * FROM news WHERE id < ". ($row[Total] - $start) . " ORDER BY id DESC");
} else {
$sql -> Query ("SELECT * FROM news ORDER BY id DESC");
}

while (($sql -> ReadRow()) && ($tmpDL < $newsDL)){
 
 $id = ($sql -> RowData["id"]);
 $date = ($sql -> RowData["date"]);
 $poster = ($sql -> RowData["user"]);
 $header = ($sql -> RowData["header"]);
 $news = ($sql -> RowData["news"]);
 $news = nl2br($news);

 $uDB = new CDBMySQL($dbHost, $dbUser, $dbPass, $dbName);
 $uDB -> Query ("SELECT * FROM users where user=\"$poster\"");

 while ($uDB -> ReadRow()){
$email = ($uDB -> RowData["email"]);
 }
 $uDB -> Close();
 
 $format = "

<tr>
<td width=\"579\" height=\"20\" background=\"section.gif\" class=\"section\" colspan=\"2\">
 <font color=\"white\">$date</font>   -  <font color=\"#003366\">$header</font>
</td>
</tr>

<tr>
<td bgcolor=\"#666688\" class=\"newsTxt\" colspan=\"2\">
$news
<br>
-- <a href=\"mailto:$email\">$poster</a>
</td>
</tr>

<tr>
<td bgcolor=\"#ffffff\" height=\"20\" colspan=\"2\">
</td>
</tr>
";
 print "$format";
 ++$tmpDL;
}
//$sql -> Close();
?>

<table border="0" cellpadding="0" cellspacing="0" width="579">
 <tr><td width="50%" align="left"><img src=http://cfan.net.cn/info/"php.gif"></td><td width="50%" align="right"><img src=http://cfan.net.cn/info/"mysql.gif"></td></tr>
 
</center>
<? print $footer; ?>
</body>
</html>

溫馨提示:喜歡本站的話,請收藏一下本站!

本類教程下載

系統下載排行

主站蜘蛛池模板: 国产综合久久久久久 | 天天干天天干天天操 | 高清中文字幕在线 | 夜夜操美女| 久久久噜噜噜久久 | 午夜影视在线观看免费完整高清大全 | 99精品这里只有精品高清视频 | 8x8x国产| 999热精品这里在线观看 | 亚洲综合一区二区三区四区 | 91社区视频在线观看 | 久久综合九色综合97小说 | 一区视频在线 | 中文字幕第一页国产 | 国内精品免费网站牛牛 | 欧洲激情| 久久久久欧美国产精品 | 免费久久 | xxxxwwww欧美| a视频在线观看 | 99热久久这里只有精品6 | caoporn97人人做人人爱最新 | 中文字幕在线一区 | 麻豆视频福利 | 日本免费观看完整视频 | 天天爽夜夜爽人人爽免费 | 日本欧美色十大禁片毛片 | 亚洲精品综合在线 | 久久免费99精品久久久久久 | 91精品国产免费久久 | 日韩国产有码在线观看视频 | 久久er99热精品一区二区 | 波多野结衣免费观看视频 | 韩国三级一线观看久 | 久久国产成人午夜aⅴ影院 久久国产精品免费一区二区三区 | 91在线综合 | 日韩a毛片| 你懂的国产高清在线播放视频 | 色综久久 | 青青国产成人久久91网 | 国内大片在线免费看 |