PHP - Need Some Help With News Adding.

I have a news code that posts news on the home page like a CMS would.

How would i make it so when I post news using the code, I can use HTML within the post to change around what it looks like? Instead of just having it display the HTML like "<font color="blue">Example</font>"

Regards,
NW

I need to set when new news is posted from 7 days to now, to put echo that it is new..
Code: [Select]
while ($var = mysql_fetch_array($result)) {
$name = $var['name'];
$date = $var['date'];
echo " - {$s_name} [new]<br />";
}Now i need to put "[new]" when news is written in past 7 days(1 week), can someone help me?

Got this script he
http://www.codewalkers.com/c/a/Database-Articles/PHPMySQL-News-with-Comments/6/

Everything works, and I mean EVERYTHING. The problem is, when the form gets submitted, the database isn't being queried/updated/whatever. It worked at first, but after I started customizing/modifying it, it quit working.

Here's my modified script:
Code: [Select]
<?php
//**********************************//
//**********************************//
/*******user config variables********/
/* max number of news items to show */
//**********************************//
//**********************************//
$max_items = 5; 

//***********************//
//***********************//
//***********************//
//make database connection//
//***********************//
//***********************//
//***********************//
$db = mysql_connect ('my hostname','my username','my password');
mysql_select_db ('my database name',$db);


//If not all of the news articles are being displayed...
function displayNews($all = 0) {

/* bring in two variables
* $db is our database connection
* $max_items is the maximum number
* of news items we want to display */
    global $db, $max_items;
    
/* query for news items */
    if ($all == 0) {

/* this query is for up to $max_items; only five news articles will be displayed */
        $query = "SELECT id,title,body," . 
                 "DATE_FORMAT(date, '%m-%d-%Y') as date " . 
                 "FROM news ORDER BY id DESC LIMIT $max_items";
    } else {


/* this query will get all news; $max_items will be false */
        $query = "SELECT id,title,body," . 
                 "DATE_FORMAT(date, '%Y-%m-%d') as date " .
                 "FROM news ORDER BY id DESC";
    }


    $result = mysql_query ($query);
    while ($row = mysql_fetch_assoc ($result)) {
        
/* place table row data in 
* easier to use variables.
* Here we also make sure no
* HTML tags, other than the
* ones we want are displayed */
$date = $row['date'];        
        $title = htmlentities ($row['title']);
        $news = nl2br (strip_tags ($row['body'], '<a><b><i><u>'));
$url = $row['id'];

/* display the data (news) */
        echo "<table border=\"0\" width=\"100%\"><tr><td><strong><h2><a href=\"{$_SERVER['PHP_SELF']}" .
             "?action=show&amp;id={$row['id']}\">$title</a></h2></strong> <em>posted on $date</em> | by <strong>DJ Smiley</strong></td></tr>\n";
        echo "<tr><td>";
echo stripslashes(substr($news, 0, 500));
echo "...<a href=\"{$_SERVER['PHP_SELF']}" .
             "?action=show&amp;id={$row['id']}\">read more</a></td></tr>\n";
        
/* get number of comments from database */
        $comment_query = "SELECT count(*) FROM comments " .
                         "WHERE news_id={$row['id']}";
        $comment_result = mysql_query ($comment_query);
        $comment_row = mysql_fetch_row($comment_result);
        
/* display number of comments with link; add twitter, facebook, digg, and share widgets; and add email sharing widget */
echo "</table>\n<table width=\"100%\" border=\"0\">
<tr>
<td width=\"6%\"><a href=\"{$_SERVER['PHP_SELF']}" .
"?action=show&amp;id={$row['id']}\"><img src=\"images/Icons/Comment/2.png\" width=\"20\" height=\"20\" class=\"fltlft2\"/></a>$comment_row[0]</td>
<td width=\"13%\"><!-- FreeTellaFriend BEGIN -->
<a href=\"http://www.freetellafriend.com/tell/\" onclick=\"window.open('http://www.freetellafriend.com/tell/?option=email&heading=Tell+A+Friend&bg=14&url=http%3A%2F%2Fhttp://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}', 'freetellafriend', 'scrollbars=1,menubar=0,width=435,height=500,resizable=1,toolbar=0,location=0,status=0,left='+(screen.width-435)/2+',top='+(screen.height-500)/3);return false;\"><img alt=\"Tell a Friend\" src=\"http://serv1.freetellafriend.com/s14.png\" border=\"0\" /></a>
<!-- FreeTellaFriend END --></td>
<td width=\"81%\"><span class=\"st_twitter_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}\" displayText=\"Tweet\" st_title=\"{$row['title']}\"></span><span class=\"st_facebook_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}\" displayText=\"Share\" st_title=\"{$row['title']}\"></span><span class=\"st_email_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}\" displayText=\"Email\"></span><span class=\"st_sharethis_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}\" displayText=\"Share\"></span></td>
</tr>
</table><br>";
       
    }
    
/* if we aren't displaying all news, 
 * then give a link to do so */
    if ($all == 0) {
        echo "<br><div style=\"border-radius: 10px; border: solid 2px #E5E5E5; padding: 10px; margin: 5px; background: #F6F6F6;\"></p><a href=\"{$_SERVER['PHP_SELF']}" .
             "?action=all\">View All Articles</a></p></div>";
    }
}

//function for displaying only one item
function displayOneItem($id) {
    global $db;
    
/* query for item */
    $query = "SELECT * FROM news WHERE id=$id";
    $result = mysql_query ($query);
$row = mysql_fetch_assoc($result);

/* easier to read variables and 
* striping out tags */
    $title = htmlentities ($row['title']);
    $news = nl2br (strip_tags ($row['body'], '<a><b><i><u>'));
    
/* if we get no results back, error out */
    if (mysql_num_rows ($result) == 0) {
        echo "This news article does not exist!\n";
        return;
    }
    
    echo "<TABLE border=\"0\" width=\"100%\">\n";


    
/* displays individual article user visits */    
echo "<tr><td><strong><h2><a href=\"{$_SERVER['PHP_SELF']}" .
 "?action=show&amp;id={$row['id']}\">$title</a></h2></strong> <em>posted on $date</em> | by <strong>DJ Smiley</strong></td></tr>\n";
        echo "<tr><td>";
echo stripslashes($news);
echo "</td></tr>\n";
echo "</table>\n";
echo "<br>\n";
echo ("</table>\n<table width=\"100%\" border=\"0\">
  <tr>
    <td width=\"6%\"><a href=\"{$_SERVER['PHP_SELF']}" .
"?action=show&amp;id={$row['id']}\"><img src=\"images/Icons/Comment/2.png\" width=\"20\" height=\"20\" class=\"fltlft2\"/></a>$comment_row[0]</td>
    <td width=\"13%\"><!-- FreeTellaFriend BEGIN -->
<a href=\"http://www.freetellafriend.com/tell/\" onclick=\"window.open('http://www.freetellafriend.com/tell/?option=email&heading=Tell+A+Friend&bg=14&url=http%3A%2F%2Fhttp://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}', 'freetellafriend', 'scrollbars=1,menubar=0,width=435,height=500,resizable=1,toolbar=0,location=0,status=0,left='+(screen.width-435)/2+',top='+(screen.height-500)/3);return false;\"><img alt=\"Tell a Friend\" src=\"http://serv1.freetellafriend.com/s14.png\" border=\"0\" /></a>
<!-- FreeTellaFriend END --></td>
    <td width=\"81%\"><span class=\"st_twitter_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}\" displayText=\"Tweet\"></span><span class=\"st_facebook_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}\" displayText=\"Share\"></span><span class=\"st_email_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}\" displayText=\"Email\"></span><span class=\"st_sharethis_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&amp;id={$row['id']}\" displayText=\"Share\"></span></td>
  </tr>
</table>");
    
/* now show the comments */
    displayComments($id);
}

function displayComments($id) {

/* bring db connection variable into scope */
    global $db;
    
/* query for comments */
    $query = "SELECT * FROM comments WHERE news_id=$id";
    $result = mysql_query ($query);
echo "<h2>Comments</h2>";
    
/* display the all the comments */
    while ($row = mysql_fetch_assoc ($result)) {
        
//sets variables
$comment = strip_tags ($row['comment'], '<a><b&><i><u>');
        $comment = nl2br ($comment);
        $name = htmlentities ($row['name']);
$time = ($row['time']);

echo "<div style=\"border-radius: 10px; border: solid 2px #E5E5E5; padding: 10px; margin: 5px; background: #F6F6F6;\"><p><table border=\"0\" width=\"100%\"><tr><td><strong>$name</strong> says:</td></tr></table>
<table><tr><td><img src=\"images/Icons/People/Anonymous 2.png\" alt=\"\" width=\"50\" height=\"50\"/></td><td>$comment</td></tr></table><table><tr><td>added on $time</td></tr></table></p></div>";
    }
    
/* add a form where users can enter new comments */
    echo "<form action=\"{$_SERVER['PHP_SELF']}" .
 "?action=addcomment&amp;id=$id\" method=post>
 <h2>Comment</h2><table width=\"37%\" border=\"0\">
  <tr>
<td width=\12%\">Name:</td>
<td width=\"88%\"><label>
  <input type=\"text\" name=\"name\" id=\"name\" class=\"commentBoxforms\">
</label></td>
  </tr>
  <tr>
<td>Comment:</td>
<td><label>
  <textarea name=\"comment\" id=\"comment\" cols=\"45\" rows=\"5\" class=\"commentField1\"></textarea>
</label></td>
  </tr>
  <tr>
<td>&nbsp;</td>
<td><label>
  <input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Comment\" class=\"Button1\">
</label></td>
  </tr>
</table>
</form>\n";
     
}

function addComment($id) {
    global $db;
    
    /* insert the comment */
    $query = "INSERT INTO comments " .
           "VALUES('',$id,'{$_POST['name']}'," .
             "'{$_POST['comment']}')";
    mysql_query($query);
    
    echo "Your comment has been posted!<br>\n";
    echo "<a href=\"{$_SERVER['PHP_SELF']}" .
         "?action=show&amp;id=$id\">Return To Previous Page</a>\n";
}


/* this is where the script decides what do do */
switch($_GET['action']) {
    
    case 'show':
        displayOneItem($_GET['id']);
        break;
    case 'all':
        displayNews(1);
        break;
    case 'addcomment':
        addComment($_GET['id']);
        break;
    default:
        displayNews();
}
?>
Can anyone tell me where this script is going wrong? I've literally tried EVERYTHING. I even went back to the original script and compared every single character to mine, but NO luck.

PLEASE HELP!

I was wondering what approach you would take to code a news feed like Facebook has.

I have a status, users,  and photo mysql tables. Would you create a new table called "feed" and have a query run everytime someone updates, inserts, etc anything in those three tables? or something else?
What would be the most efficient way to code a news feed?

Thanks in advanced!

What's the best way to create a news feed?  How would you guys do it?  Would you have to have a time stamp stored for when each action occurred? 

Hi,
I'm currently coding a script, where I would like to post news & versions changes etc into my client's portal. So my client install the script, they login to the admin area, and they see messages from me, optionally if there's a new version available.

I was thinking about doing this with cUrl, and just have a page that display my news, and then call it from the client portal, not sure about it though. What would you guys suggest?

hi i want to make a script like http://www.greatdane.ru/eng/site/news/ and i dont have problem too add dogs but i want a auto news update after specific  change like the link

example : after add new dog or update dog or add image to a dog

the link tell exactly what i want but also it has a feature that group added dogs and send a news

any one have idea for make it?

it is also so similar to facebook profile that after user do something page will auto update like : user change his cover

Hello All, I am new here so first off hello to you all

Right my problem, I am trying to find a way to be able to display news items with comments under them and a form for somebody to write a comment. Like on facebook where a person has a status then comments under it.

I have two tables in MySql already, news and newscomments. The way I have linked the tables is by ID, newscomments has a field called News_ID which matches with the ID of a news item.

I can get all news items to display however I can't get the comments to display with them.

Please could somebody give me a hand with this?

Thanks

Richard

Hello,

can you help me on my news article?
I would like to be able to add photo on the article. Below is my codes

Quote

=======
html
=======
<?php
include_once ('post_news.php');
?>

<form Action="add_news.php" Method="post">
   <input name="postdate" type="text" id="postdate">
   <input name="title" type="text" id="title">
   <textarea name="newstext" cols="60" rows="15" id="newstext"></textarea>
<input type="submit" name="submit" value="Submit">
<input type="reset" name="reset" value="Reset">
</form>

==============
php - post_news.php
==============
<?php

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

if (isset ($_POST['submit']))

{

   require_once ('inc/dbConfig.php');
   
// Define the query.
$query = "INSERT INTO news (id, postdate, title, newstext) VALUES
(0,'{$_POST['postdate']}', '{$_POST['title']}','{$_POST['newstext']}')";

// Execute the query.
if (@mysql_query ($query)) {
   print "<p>Data has been added.</p>";
} else {
   print "<p>Could add the entry because: <b>" . mysql_error() . "</b>. The query was $query.</p>";
}

 mysql_close();

}

?>

=====
db structure
======
 id int(10) unsigned NOT NULL auto_increment,
   postdate timestamp(14),
   title varchar(50) NOT NULL,
   newstext text NOT NULL,
   PRIMARY KEY (id),
   KEY postdate (postdate)



Hope you guys can help me.

Thanks!

I have manage to create my own script that add news article, however, I would like to add a comment form below the news article. How can I relate the news and the comments? also, when I delete the articles, it should also delete the comments in mysql.

Your help is highly appreciated!

hey guys im having trouble showing the news by the date it was submitted, I want to also seperate it into 3 seperate parts,

first section will have the Main news which is only 1 row, it will have the value 1 in the column named type (is this news main or recent). The date on it doesn't matter because i want to show it even tho there might be news that is ahead of it.

The next section will have 3 rows of recent news parts. I want to show the 3 most recent news that there are in the database with the value 2 in the column named type. I want it to show the recent news by the date submitted.

Okay the last part will have the old news. There I want to show 3 rows of news that is after the 3 rows of news in recent news. That value will be 2 in the column named type.

Here is my current code.


<?php
session_start();
if(isset($_SESSION['username']))
{

mysql_connect("localhost","root","");
mysql_select_db("chat");


        $result = mysql_query("SELECT * FROM `news` WHERE `type`='1' ORDER BY `news`.`newsid` DESC LIMIT 1");
        $query = mysql_query("SELECT * FROM news WHERE `type`='1' ");
        //$ifadmin_result = mysql_query("SELECT * FROM users WHERE `username`='$loggedin' ");

if(mysql_num_rows($query)!=0)
{
$loggedin = $_SESSION['username'];
    $myrow = mysql_fetch_array($result);
       echo "<b>Title: ";
       echo $myrow['title'];
       echo "</b><br>On: <i>";
       echo $myrow['dtime'];
       echo "</i><hr align=left width=160>";
       echo $myrow['text1'];
       
       
       //check if admin
       $ifadmin_result = mysql_query("SELECT * FROM users WHERE `username`='$loggedin'");
       $ifadmin = mysql_fetch_array($ifadmin_result);
       if ($ifadmin['admin'] == 1) { 
       echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>
        || <a href=\"edit_news.php?newsid=$myrow[newsid]\">Edit</a>
         || <a href=\"delete_news.php?newsid=$myrow[newsid]\">Delete</a><BR><BR>";
            }  
                else {
                echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a><BR>";
            }
         //check if admin
         
       echo "<hr align=left width=500>";
       }
       else
       {
       echo "no rows<br>";
       }

        $iCount=0;
        $var=false;
        //RECENT
        $result = mysql_query("SELECT * FROM `news` WHERE `type`='2' ORDER BY `news`.`newsid` DESC LIMIT 6");
        //lets make a loop and get all news from the database
       while($myrow = mysql_fetch_array($result))
             {//begin of loop
               //now print the results:
               $iCount = $iCount+1;
                if($iCount >= 4) {
                    if($var == false) {
                    $var=true;
                           echo "<hr align=left width=500>";
                    echo '<div> More News</div';
                    }
                    //Generate your refcent news here echo the title etc.ma
                   echo "<div><b>Title: ";
                   echo $myrow['title'];
                   echo "</b> <i>On:" . $myrow['dtime'] . '</i></div>';
                   echo "<a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>";
                } 
                else
                {
               echo "<b>Title: ";
               echo $myrow['title'];
               echo "</b><br>On: <i>";
               echo $myrow['dtime'];
               echo "</i><br>";
               //echo "<hr align=left width=160>";
               echo $myrow['text1'];
               // Now print the options to (Read,Edit & Delete the news)
               
               
                              $ifadmin_result = mysql_query("SELECT * FROM users WHERE `username`='$loggedin'");

       $ifadmin = mysql_fetch_array($ifadmin_result);
       if ($ifadmin['admin'] == 1) 
            { 
       echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>
        || <a href=\"edit_news.php?newsid=$myrow[newsid]\">Edit</a>
         || <a href=\"delete_news.php?newsid=$myrow[newsid]\">Delete</a><BR><hr align=\"left\" width=\"160\">";
            }  
                else
            {
                echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a><hr align=\"left\" width=\"160\">";
            }
               
               
               
               
               
               
               
               
               /*
               echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>
                || <a href=\"edit_news.php?newsid=$myrow[newsid]\">Edit</a>
                 || <a href=\"delete_news.php?newsid=$myrow[newsid]\">Delete</a><br><hr align=\"left\" width=\"160\">";
                 */
                }
                
                
             }//end of loop
             
}
else
{

mysql_connect("localhost","root","");
mysql_select_db("chat");

$result = mysql_query("SELECT * FROM `news` WHERE `type`='1' ORDER BY `news`.`newsid` DESC LIMIT 1");
        $query = mysql_query("SELECT * FROM news WHERE `type`='1' ");
if(mysql_num_rows($query)!=0)
{
    $myrow = mysql_fetch_array($result);
       echo "<b>Title: ";
       echo $myrow['title'];
       echo "</b><br>On: <i>";
       echo $myrow['dtime'];
       echo "</i><hr align=left width=160>";
       echo $myrow['text1'];
       echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a><BR>";
       echo "<hr align=left width=500>";
       } else {
       echo "no rows<br>";
       }
        $iCount=0;
        $var=false;
        //RECENT
        $result = mysql_query("SELECT * FROM `news` WHERE `type`='2' ORDER BY `news`.`newsid` DESC LIMIT 6");
        //lets make a loop and get all news from the database
       while($myrow = mysql_fetch_array($result)) {
       //begin of loop
               //now print the results:
               $iCount = $iCount+1;
                if($iCount >= 4) {
                    if($var == false) {
                    $var=true;
                           echo "<hr align=left width=500>";
                    echo '<div> More News</div';
                    }
                    //Generate your refcent news here echo the title etc.ma
                   echo "<div><b>Title: ";
                   echo $myrow['title'];
                   echo "</b> <i>On:" . $myrow['dtime'] . '</i></div>';
                   echo "<a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a>";
                } else {
               echo "<b>Title: ";
               echo $myrow['title'];
               echo "</b><br>On: <i>";
               echo $myrow['dtime'];
               echo "</i><br>";
               //echo "<hr align=left width=160>";
               echo $myrow['text1'];
               // Now print the options to (Read,Edit & Delete the news)
               echo "<br><a href=\"read_more.php?newsid=$myrow[newsid]\">Read More...</a><hr align=left width=160>"; 
                }
                                                    }//end of loop        





}             
?>

<br>
<hr align=left width=500>
<!--
<hr align=left width=500>
<br><br>
<a href=index.php>Home</a> 

<a href=add_news.php>Add News</a>
-->


Here is how my database table looks like


Dont mind the number of rows it is, I want it to show the first I guess 7 rows of news that is dated to the earliest time from present.
There soon will be hundreds of rows.

Here is how I made it fill in the row with the most recent time it was posted.
NOW()
in
$result = mysql_query("INSERT INTO news (title, dtime, text1, text2, type) VALUES ('$title',NOW(),'$text1','$text2','$type')");


Basically I want it to show the most recent rows based on the time they were posted.



Also, incase you need more information please post and il give me information.

i want a script which should be easily integrated with the website and should fully customizable like cutephp.. the problem with cutephp is that it can't handle large data since it stores all the news articles in one .txt file on the server.. as the number of articles grow.. the size of .txt file increases and it becomes impossible for the server to handle the script.. i want a script which should be easily integrated into the website and should have the following features.

- article categories
- admin panel to add news
- should use mySQL to store articles or it should create .htm files for articles..

i hope you get the point..

by the way if i want to write my own script.. what is the easiest way to write a script which should have categories, show news on webpages, have admin password protected add news area.. should create seperate files on the server or use mysql..nothing complicated.. simple news posting script..

Hello everyone, I have a script that shows the news posted on my website in a bigger format with comments ect... but it gives me the error
Code: [Select]
Parse error: syntax error, unexpected '}' in /home/stormgc/public_html/sources/news_view.php  on line 50
I reviewed the code, I know what the error fix would be, but I cannot find the proper place to put it.

If someone could please review the script and help that would be awesome!
--> Code: [Select]
<?

$id = $_GET['id'];

$news = mysql_query("SELECT * FROM `news` WHERE id='$id'");

if(mysql_num_rows($news) > 0){

$newz = mysql_fetch_array($news);

loadHeader($newz['title']);
}
if($_GET['update'] == 1){

confirm('You have successfully updated this news.');

}

?>

<br />

<div class="title"><? echo $newz['title']; ?><span class="options"><a href="index.php">Home</a> / <? echo $newz['title']; ?></span></div>

<div class="content">

<?
$username = $newz['username'];

?>

<div class="category"><a href="index.php?action=news_view&id=<? echo $newz['id']; ?>"><? echo $newz['title']; ?></a> posted on <? displayTime($newz['time'], 'F jS, Y \a\t g:i a'); ?>

<span class="options">By

<?

$accounts = mysql_query("SELECT * FROM accounts JOIN profiles ON accounts.username=profiles.username WHERE accounts.username='$username'");

if(mysql_num_rows($accounts) > 0){

$account = mysql_fetch_array($accounts);

?>

<a href="index.php?action=profile&user=<? echo $account['username']; ?>">{<? } echo $account['display_name']; ?></a>

<?

} else {

echo $username;

}

?>

</span></div>

<div class="cell1">

<?

echo parseText($newz['message']);

?>

<br /><br />
<a href="index.php?action=forums">Discuss this in the forums...</a>

<?

if($cur_account['staff'] == "on" || $cur_admin == 1){

?>

<br />
<br />

<a href="index.php?action=news_modify&id=<? echo $newz['id']; ?>">Modify</a> | <a href="" onClick="if(confirm('Are you sure you want to delete this news?')){ location.href='index.php?action=news_delete&id=<? echo $newz['id']; ?>'; } return false;">Delete</a>

<?

}

?>

</div>

<?

loadFooter();

} else {

fatalError('The news article you are trying to view does not exist.');

}

?>
Thanks,
NW

Hi again PhpFreakz, yet again I have some issues with my PHP part of my website.

Is there any simple algorithm to summarize web news articles in PHP?