It consists of 3 main parts
1. Mysql data base (news)
| num (auto inc) | name (title) | date | text |
2. Adding news script
Newnews.html
Code: <html>
<body>
<form action="newsform.php" method="post"><br>
<input type="text" name="name" value="title"><br>
<input type="text" name="date" value="date & time"><br>
<textarea type="textarea" name="text" value="text" ROWS="10" COLS="100"></textarea><br><br>
password:<input type="password" name="pass" value="DB password"><br>
<input type="submit" value="Add"><br>
</form>
newsform.php
Code: <?php
$username="URSERNAME";
$password=$_POST['pass'];
$database="DATABASE";
$host="localhost";
$text=$_POST['text'];
$date=$_POST['date'];
$name=$_POST['name'];
mysql_connect($host,$username,$password);
@mysql_select_db($database);
$sqlstring="Insert into news (name, date, text) values('$name', '$date', '$text')";
mysql_query($sqlstring);
?>
3. Drawing Up News (news.php)
Code:
ALL YOUR NORMAL HTML CODE OUT HERE
<?php
$username="USERNAME";
$password="PASSWORD";
$database="DATABASE";
$host="localhost";
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = 'SELECT `name`, `date`, `text` FROM `news` ORDER BY `num` DESC';
$result = mysql_query($query) or die('query:<br />'.mysql_error());
while ($row = mysql_fetch_assoc($result)){
print ' ALL YOUR PRE ARTICAL NAME STUFF HERE';
echo "{$row['name']}";
print 'ALL PRE DATE STUFF HERE';
echo "{$row['date']}";
print ' HERE WOULD BE LINK TO DISCUSS STUFF';
print ' I THINK YOU GET IT BY NOW';
echo "{$row['text']}";
print ' ';
}
?>
ALL YOUR FOOTER STUFF CAN GO HERE
that will display all the news in the data base, to make it display a limited number (say 5) just replaceCode: $query = 'SELECT `name`, `date`, `text` FROM `news` ORDER BY `num` DESC';
with Code: $query = 'SELECT `name`, `date`, `text` FROM `news` ORDER BY `num` DESC LIMIT 0, 5';
Should work well
Spring break sucks when everyone else in you family has school or is working