新闻发布系统(例子)一news_PHP

/*
News Donkey v1.0 d8b db d88888b db d8b db .d8888.
by Oscar Rylin [oscar@mgon.com] 888o 88 88' 88 I8I 88 88' YP
88V8o 88 88ooooo 88 I8I 88 `8bo.
88 V8o88 88~~~~~ Y8 I8I 88 `Y8b.
88 V888 88. `8b d8'8b d8' db 8D
VP V8P Y88888P `8b8' `8d8' `8888Y'


d8888b. .d88b. d8b db db dD d88888b db db
88 `8D .8P Y8. 888o 88 88 ,8P' 88' `8b d8'
88 88 88 88 88V8o 88 88,8P 88ooooo `8bd8'
88 88 88 88 88 V8o88 88`8b 88~~~~~ 88
88 .8D `8b d8' 88 V888 88 `88. 88. 88
Y8888D' `Y88P' VP V8P YP YD Y88888P YP

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
?>












$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 "Archive ?";
print "Main ";
while ($pCount < ($row[Total]/5)-1) {
++$pCount;
print "$pCount ";
}
}

$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 = "












";
print "$format";
++$tmpDL;
}
//$sql -> Close();
?>

$date - $header

$news -- $poster