Skip to main content

Generate RSS Feed with PHP & MySQL

RSS (Really Simple Syndication) is a very useful way to share content over internet. If you are running a website or blog RSS feeds can help you a lot by sharing your contents to readers. RSS feeds are based on XML markup. It holds some information about your post contents like post title, description, link, publish date etc.

In this post you will learn how we can create simple RSS feed with PHP and MySQL.

Creating MySQL Database Table

At first we need to create a database table that can hold our post contents.

CREATE TABLE `post` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) NOT NULL,
  `body` text NOT NULL,
  PRIMARY KEY (`id`)
);

PHP Code

# configurations
$db_host = 'localhost';
$db_user = 'root';
$db_pass = 'root';
$db_name = 'test';
$max_post_limit = 10;


# set content type application/rss+xml
header("Content-Type: application/rss+xml; charset=UTF-8");

# connect to mysql db
mysql_connect($db_host, $db_user, $db_pass);
# select mysql db
mysql_select_db($db_name);

# query in db table
$query = mysql_query(
  'SELECT *
  FROM post
  ORDER BY id DESC
  LIMIT ' . $max_post_limit
);

?>
<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:media="http://search.yahoo.com/mrss/" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

  <channel>

    <title>My RSS Feed</title>
    <description>w3bees RSS Feed</description>
    <link>http://www.w3bees.com</link>
    <language>en-us</language>
    <copyright>Copyright (C) 2013 w3bees.com</copyright>

  <?php while( $row = mysql_fetch_array($query) ): ?>

    <item>
      <title><?php echo $row['title']?></title>
      <description><?php echo $row['body']?></description>
      <link>http://mysite.com/post.php?id=<?php echo $row['id']?></link>
    </item>

  <?php endwhile?>

  </channel>
</rss>
Labels:

Popular posts from this blog

Multiple File Upload with Progress Bar using PHP & jQuery

Some days age I have created a post that deals with How we can upload file with progress bar using php and jQuery . Some of my readers asked me how we can upload multiple files with progress bar. In this post I am going to show you how we can upload multiple files with progress bar. We can upload multiple files with progress bar exactly same way as I shown previous. But we need to do some modification with our file upload form and our php script to handle multiple files.
Read more

Multiple File Upload with PHP

Sometimes we need to allow our users to upload multiple file upload. On my previous post I was shown the basic of simple file upload with PHP. Today I am going to show you how to allow users to upload multiple files. It is almost similar like simple file upload but we need to do some modification with html markup and php code . multiple attribute is needed to add on the html markup. Major web browsers like Firefox, Chrome, Safari and IE 9+ support this attribute. Now I am going to show you how to upload multiple file with PHP and basic HTML form.
Read more

File Upload with Progress Bar using jQuery and PHP

In this post you will learn how to create a AJAX file uploading system with progress bar using jQuery and PHP. For this purpose we will going to use jQuery Form Plugin . It is a easy to use and powerful jQuery AJAX form submitting plugin. It supports XMLHttpRequest Level 2 and iframe file transportation. That's why it will work for both old and new browsers.
Read more