PHP - News Article Page

I have a database in which i store articles that contain all type of special characters including slashes, single quotes, double quote etc.

Previously it was working fine, but now after the updating the xampp, things are not going as usual.

I insert are articles using following code

$query = "INSERT INTO `articles` (`source`, `heading`, `description`, `catagory`, `detail`, `date`, `timestamp`)
          values ('$source', '$heading', '$desc', '$catagory', '$detail', '$date', '$timestamp')";

Error I am getting is

Error Running query 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's economy and emphasized that international community should provide its complet' at line 2

Can anybody tell me whats wrong with my script?

I am developing a CMS with articles and categories.  I am making a feature for the admin panel that shows all the categories.  In the table, I would like to include each category's latest article.  My traditional method is to select just the categories in one query, loop through the results, and then inside the category loop have a query that gets the information on the latest article... So something like...

$query = "
     SELECT category_id, title, description
     FROM categories
     ORDER BY title ASC";
 
if($query = mysql_query($query)){
 
     while($cat=mysql_fetch_assoc($query)){
 
            $query_article = "
                 SELECT article_id, category_id, title
                 FROM articles
                 WHERE category_id = ".$cat['category_id']."
                 ORDER BY article_id DESC
                 LIMIT 1";
 
            $last = mysql_fetch_assoc($query_article);
 
       }
 
}

          How could I use joins and/or subqueries to achieve my goal of combining these two queries into one?  I have come up with a query which is below:

SELECT
c.category_id, c.title, c.description,
a.article_id, a.category_id, a.title, COUNT(a.article_id) AS total_articles
FROM article_categories AS c
LEFT JOIN articles AS l ON (
SELECT
article_id AS article_id, category_id, title AS article_title
FROM articles AS l
WHERE l.category_id = c.category_id
ORDER BY l.article_id
DESC LIMIT 1)
LEFT JOIN articles AS a ON (c.category_id = a.category_id)
GROUP BY c.category_id
ORDER BY c.title ASC

  When I use the above query, I get an error saying "Operand should contain 1 column(s)"   I would also like to add something that counts the total number of articles in the category.   Thanks for your time!  

I'm building an article system, what im trying to do is when a user choose the article to be published tomorrow to able to.  Write today the article but the system will show it from tomorrow

Code: [Select]
        $gettoday = date("Y:m:d");
$query = "SELECT * FROM tblnews WHERE MainArticle = 1 AND NewsDate = '".$gettoday."'  ORDER BY `Id` DESC LIMIT 1";
$result = mysql_query($query);

This is my code, but when i use this and the article is not posted for today is not showing anything.. any suggestions please?

Thank you

hi there,

basically in my database i have  DATETIME for when an article was posted, using this, I'd like to make it possible for viewers of the article to see when it was posted in a "Posted Today", "Posted Yesterday" or Posted 23 hours ago" format. If it was posted longer ago than yesterday, then I would like it to just be the normal date.

I know how to work out if it was posted today, just through:

$date = date('j F', strtotime($rows['date']));
$today=date('j F');

but not sure how to do the hours.

thanks!

Hello,

I am trying to create article directory for learning PHP MySql and i want to write a script for recording number of views for an article and store it in Database. Can anyone please direct me to a nice simple tutorial or help me with the steps or algorithm?

Suppose the link for an article is http://www.domain.com/article.php?id=123
Do i need to put extra variables and create a tracking PHP file for it?

This topic has been moved to Apache HTTP Server.

http://www.phpfreaks.com/forums/index.php?topic=322454.0

Hi all -

I'm setting up a custom PHP blog. It pulls the data from a MySQL database which includes HTML tags (<p><div><span> etc...).

I would like to display only up to 50 words per post on the blog page, which users can then read and click a link to then see the entire post.

I've developed some code which does this, however, it seems to be stripping my HTML tags... Very sad!

Would be very very grateful if one (or more) of you kind lot would have a look at my code and let me know if there is a easier (I'm all for easy) and proper way of implementing this so that it works without stripping my HTML tags.

Cheers!!!

Code: [Select]
// Counts number of blog words in the content
$blog_content_words = str_word_count($blog["content"], 1);

// Sets the blog_words variable to 0
$blog_words = 0;

// Prints title on page as a permalink to a post
echo '<h1><a href="blog.php?id='.$blog["id"].'">'.$blog["title"].'</a></h1><p>';

// Loops while blog_word is under 50
while($blog_words < 50) {

// Prints a word from blog_content_words array of blog post and adds a space afterwards
echo $blog_content_words["$blog_words"]." ";

// Adds 1 to the blog_words counter
++$blog_words;
}

// Adds a read more link to the post which links to full blog post
echo '... <a href="blog.php?id='.$blog["id"].'">[read more]</a></p>';

i need to submit 1 article (3 input fields: title, category, description), to multiple sites. it must be done with 1 click.

one more thing... each site to which i have to submit has different input names, but are the same 3, also 1 is for title 1 for category and 1 for description.

I have this code..
<?php
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
mysql_query("INSERT INTO blog (date, name, desc) VALUES ('" . date("Y-m-d") . "', '". realEscape($_POST['name']) ."', '". realEscape($_POST['desc']) ."')  ") or die(mysql_error());
echo "News Added.";
}
?>
<center><h1>Adding News</h1>
<form action="news.php" method="POST">
Your News Name:<br>
<input id="name" type="text" name="name" autocomplete="off" maxlength="25"><br>Your News Description: <br>
<textarea name="desc" id="desc" rows="3" cols="60" maxlength="250"> </textarea><br>
<input type="submit" name="submit" value="Add News">
</form>

And the error is
Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc) VALUES ('2010-09-02', 'vcv', ' xcvxc')' at line 1
Note: vcv and xcvxc are the inputs we(I) used for a test so we(I) could get the error.

Hi guys

i have been racking my brains been on about 5 different forums now with no joy either.. so here goes

I am looking for a PHP news script thing, so I can have a column on the right hand side of my home page
updating students results in passing or failing.

I have looked and looked for php news scripts and none work they all are defect
i am using a windows server, using wampserver to test my files locally..

any ideas or help.. would be oh so much appreciated

Hi all, i have a form for add-/edit- news.
my fields are :id    postdate    title    newstxt    formember    preimg    img1    img2    img3    authr.
i store (modified by concat date)names of news images in table and upload theme in folder /dir/newsimg.
i want my images in jpg/gif format and for preimage (103*103 pixel & <5KB) and for img1,2,3 (width:650 pixel & <50KB ).
Here is my (multipart)form:

<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>"  enctype="multipart/form-data">
<div><input id="post_title" type="text" size="30" tabindex="1" value="news title" /></div>
<textarea cols="80" rows="10"></textarea>
<div >
<h3>Just For Members:</h3>
<ul>
<li>
                <label><input type="checkbox" name="chbox"  />yes</label></li>
</ul><BR/>
                <ul>
                <h4>news pics</h4>
                <li><p>preimg pic must be 103*103 pixel and maxsize <5kb.
                </p></li>
                <li><p>
                for image1,image2,image3 weightsize must ebe 650pixel and maxsize mustbe <50 kb.
                </p></li>
                <li>
                <INPUT TYPE=file NAME="preimg" size=20 accept="image/jpeg,image/gif">
                </li>
                <li><INPUT TYPE=file NAME="image1" size=20 accept="image/jpeg,image/gif">
                </li>
                <li><INPUT TYPE=file NAME="image2" size=20 accept="image/jpeg,image/gif">
                </li>
                <li><INPUT TYPE=file NAME="image3" size=20 accept="image/jpeg,image/gif">
                </li>
                </ul>
<p>
<input type="submit" value="preview" />
<input type="submit" value="save" />
</p>
</div>
</form>
in INSERT and for TEST MY IMAGES what should i add?
my php code is :

  include_once '../../config.inc.php';
  if (!include '../autorization.php')
  {
    echo 'Access denied!';
    exit ();
  }

if ($_POST['submit'])
  {
    $SQL = 'INSERT INTO news VALUES(?:for images);
    if (!(mysql_query ($SQL)))
    {
      exit ('Can\'t PUBLISH news!');
      ;
    }

    if ($_FILES['logo']['name'])
    {
      if (copy ($_FILES['preimg']['tmp_name'], $documentroot . ('' . ' /dir/newsimg/' . NOW() . '.') . substr ($_FILES['preimg']['type'], 6)))
      {
        unlink ($_FILES['logo']['tmp_name']);
      }
    }

    if ($_FILES['image1']['name'])
    {
      if (copy ($_FILES['image1']['tmp_name'], $documentroot . ('' . ' /dir/newsimg/' . NOW() . '.') . substr ($_FILES['image1']['type'], 6)))
      {
        unlink ($_FILES['image1']['tmp_name']);
      }
    }

    if ($_FILES['image2']['name'])
    {
      if (copy ($_FILES['image2']['tmp_name'], $documentroot . ('' . ' /dir/newsimg/' . NOW() . '.') . substr ($_FILES['image2']['type'], 6)))
      {
        unlink ($_FILES['image2']['tmp_name']);
      }
    }

    if ($_FILES['image3']['name'])
    {
      if (copy ($_FILES['image3']['tmp_name'], $documentroot . ('' . ' /dir/newsimg/' . NOW(). '.') . substr ($_FILES['image3']['type'], 6)))
      {
        unlink ($_FILES['image3']['tmp_name']);
      }
    }
  }

TNX.

Before I posted in here about a content management system for posting news.  I was wondering how I could make so that when you fill out a form and send all the data to the database, it creates a new page from a template and includes that data within it? I know I asked this before, and some mentioned the _get method, but im using _post to process the form data and have no idea where to integrate the _get method.

Here's the form in question:
Code: [Select]
<form action="http://www.djsmiley.net/cms/news/process.php" method="post" id="news">
        <h1>Post New Article</h1>
        <p>Please fill out all of the following fields:</p>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td height="55" class="cmsNewsformText">Type*:</td>
            <td><font size="1">
              <input name="type" type="text" class="Form1" size="50" />
            </font></td>
          </tr>
          <tr>
            <td height="55" class="cmsNewsformText">News Topic/Title*: </td>
            <td><font size="1">
              <input name="title" type="text" class="Form1" size="50" />
            </font></td>
          </tr>
          <tr>
            <td height="55" class="cmsNewsformText">Username*:</td>
            <td><font size="1">
              <input name="user" type="text" class="Form1" value="DJ Smiley" size="50" />
            </font></td>
          </tr>
          <tr>
            <td height="55" class="cmsNewsformText">Url*:</td>
            <td><font size="1">
              <input name="url" type="text" class="Form1" size="50" />
            </font></td>
          </tr>
          <tr>
            <td height="55" class="cmsNewsformText">Message*:</td>
            <td><font size="1">
              <textarea name="message" cols="43" rows="10" class="TextField1"></textarea>
            </font></td>
          </tr>
          <tr>
            <td height="55" class="cmsNewsformText">&nbsp;</td>
            <td><font size="1">
              <input name="Submit" type="submit" class="Button1" value="Submit" />
              <input name="Submit2" type="reset" class="Button1" value="Reset" />
            </font></td>
          </tr>
        </table>
      </form>
and here's the code that sends the data from the forms to the database:
Code: [Select]
<?php
 $user=$_POST['user']; 
 $title=$_POST['title']; 
 $message=$_POST['message']; 
 $type=$_POST['type']; 
 $url=$_POST['url']; 
 mysql_connect("hostname", "username", "password") or die(mysql_error()); 
 mysql_select_db("database") or die(mysql_error()); 
 
 $sql = sprintf("INSERT INTO mynews (user, title, message, type, url)
VALUES ('%s', '%s', '%s', '%s', '%s')",
mysql_real_escape_string($user),
mysql_real_escape_string($title),
mysql_real_escape_string($message),
mysql_real_escape_string($type),
mysql_real_escape_string($url));
$result = mysql_query($sql); 
 
 
 Print "The article has successfully been posted"; 
 ?>
can someone help or at least point me in the right direction?

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

Hello everyone, 
I'm making a site with PHP script and PHPmyadmin database,  i need some help with how to add news and then edit them or delete them on the site, not in the Database(if that is even possible to do it there), so far i can only delete the news,  but when i try to add new stuff i just get the error message of my code, which is not very nice of it but hey, i'm a noob at this PHP so i must be doing something wrong.

this is the code i have for the current situation.
Code: [Select]
<?php
include_once( 'database_functions.php' );


$connectID = 
connectToDatabase( 'login' );  
mysql_set_charset( 'utf8', $connectID );
$categories = mysql_query('SELECT * FROM ref_categories', $connectID);

if( @$_POST && @$_POST['submitted'] && ( !@$_GET[ 'id' ] ) )
{
$title  = ( $_POST[ 'topic_name' ] );
$topic  = ( $_POST[ 'topic_desc' ] );

//write to database
mysql_query ( "INSERT into news (title, topic) 
VALUES ('$title', '$topic')", 
$connectID )
or die ("Unable to insert record into database");
print "Record successfully added";
}
elseif( !$_POST && $_GET && $_GET['id'] )
{
$id = $_GET['id'];
$thisRecord = mysql_query("SELECT * FROM ref_categories WHERE id = $id", 
$connectID )
or die( "Can't Read this record." );

$recordData = mysql_fetch_array( $thisRecord, MYSQL_ASSOC );
}

elseif( $_POST && $_POST['submitted'] && ( $_GET['id'] ) )
{

$title  = ( $_POST[ 'title' ] );
$topic = ( $_POST[ 'topic_desc' ] );
$id  = $_GET['id'];

$success = mysql_query( "SELECT * FROM news", $connectID )
or die( "Can't Update this record" );

if( $success )
{
header( 'Location: links_admin.php?updated=1' );
}

}
else
{

}

?>