/*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?>newsM0nger1.0 print $header; ?>$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 ++$pCount;print "$pCount";}}$tmpDL = 0;$sql = new CDBMySQL($dbHost, $dbUser, $dbPass, $dbName);if ($start) {$sql -> Query ("SELECT * FROM news WHERE id } else {$sql -> Query ("SELECT * FROM news ORDER BY id DESC");}while (($sql -> ReadRow()) && ($tmpDL$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 = "$date-$header$news--$poster";print "$format";++$tmpDL;}//$sql -> Close();?>print $footer; ?>