Help me create a news script

qubstudent

Hi there. Could someone please give me some advice about creating a news script for my site.

I would like to create a site with an admin section with a basic HTML form where I can enter a "headline" and the "story" as well as the submission date.

Using PHP I would like for the "headline" only to appear on the front index.php page but for the headline, story and submission date to appear on the news.php page. Is this possible?

In the past, I used a duplicate copy of the same script to create this effect but having two scripts running in the admin section is double the workload.

Surely there must be a way of having a simply script that can do the above.

Any ideas or links to articles would be excellent.

Thanks,

Terry

planetsim

well this is quite simple.. So im taking your a nOOb just starting out in PHP so ill be real nice....

ok...

these are the mysql functions well use.. Im assuming you have mysql database..

INSERT,SELECT you can use UPDATE and DELETE use the mysql manual to read on what they are for... its mainly edit a row or delete one..

the real basic ones.. you can read up on those at the mysql official site... http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Optimise_Overview

table set up.. call it news

feild names
id ,int ,autoincrement,
primary key
Now for the form...
call this addnews.php or something similar
<table>
<form action="newsadd.php" method="post">
<tr>
<td>Headline</td><td><input type="text" name="headline">
<tr>
<td>News</td><td><textarea cols="30" rows="5" name="news"></textarea></td>
<tr>
<td></td><td><input type="submit" name="submit" value="submit"></td>
</form></table>

Now for newsadd.php

<?
$date = date("Y-m-d");// this is your date function will get todays date, and add to database
mysql_connect("hostname","user","pass");
mysql_select_db("database name here");
mysql_query("INSERT INTO news (id,headline,news,date) VALUES ('NULL','$headline','$news',$date)");

echo"<table><tr><td>Headline</td><td>$headline</td><tr><td>News</td><td>$new</td></table>";?>

Now thats your addnews..

Now lets select 5 news of the latest news articles for index.php

<?
mysql_connect("hostname","user","pass");
mysql_select_db("database name here");
$result = mysql_query("SELECT * news ORDER BY date DESC LIMIT 5");
while($r=mysql_fetch_array($result))
{

echo"<table><tr><td>$r[headline]</td><tr><td>Date Submitted on $r[date]</td><tr><td>$r[news]</td></table><br>";
}?>

that will get the latest news according to the date... and it will only have 5 of them..

now for news.php this is just the headlines.. which ill also limit to 5.

<?
echo"<table>
mysql_connect("hostname","user","pass");
mysql_select_db("database name here");
$result = mysql_query("SELECT * FROM news ORDER BY date DESC LIMIT 5");
while($r=mysql_fetch_array($result))
{
echo"<tr><td>$r[headline]</td>";
}?>

qubstudent

Thank you so much for your help. I'm a nOOB to php and mysql but I managed to get the database set up and the correct files. However I keep getting the following error:

Warning: Supplied argument is not a valid MySQL result resource in /home/web/news1.php on line 39

Line 39 reads as:

while($r=mysql_fetch_array($result))

Any ideas?

I really appreciate your help.

Terry

qwertykey

Typically when you get that error it means that there is a problem with the query you executed. You might want to go back over those and make sure that you did not make any parsing mistakes. like quotations or semicolons.

planetsim

well that error you get doesnt always mean semi colans etc are missing.

As its our while loop my best bet is that you have a different set up for the database then the one i showed you.. It can also mean that the table name which i made news isnt called news. Id take a look at this, although i didnt test the script which i wrote, id suspect its pretty clean, and should work