Ad block is installed and active. Please support us by disabling it.
HomeWednesday, April 25, 2018, 08:54:16
1

MySQL to RSS

Tuesday, February 10, 15, 00:36:07, 3 Yaers Ago Via wain, Hits: 5776
Publishing MySQL data in RSS
config.php

Code:
<?php
$dbhost = 'localhost';
$dbusername = 'root';
$dbpassword = 'mydbpass';
$dbname = 'test';
$conn=mysql_connect($dbhost, $dbusername, $dbpassword);
if(!$conn) :
die('Could not connect: ' . mysql_error());
endif;
$db=mysql_select_db($dbname, $conn);
if(!$db) :
die (mysql_error());
endif;
?>


rss.php

Code:
<?php header('Content-type: application/rss+xml'); ?>
<?php echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n"; ?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
<title>example.com</title>
<description>news example.com</description>
<link>http://example.com</link>
<?php
include ('config.php');
$res = mysql_query("SELECT id, title, description, date
FROM news ORDER by date DESC LIMIT 5")
or die(mysql_error());
while($row = mysql_fetch_array($res)){
?>
<item>
<title> <?php echo $row['title']; ?></title>
<description> <?php echo htmlspecialchars($row['description'], ENT_QUOTES); ?> </description>
<link>http://example.com/?id=<?php echo $row['id']; ?></link>
<guid>http://example.com/<?php echo $row['id']; ?>.html</guid>
<pubDate> <?php echo date("r", strtotime($row["date"])); ?></pubDate>
</item>
<?php
}
?>

Sign In

Sponsor

Related

FeedBack Form with Captcha

It allows your visitors to send you an email directly from your website.

Email Link

HTML email link example

PHP Jquery Form

PHP Jquery Form allow your visitors to contact you directly from your website.

Meta Tags Generator 1.1. PHP Script

This script will allow your visitors to create meta tags online.

Preg_Match - PHP Email Validation

Validate email with preg_match in php

Link Generator PHP Script

This script will allow your visitors to create links online.To use the "link generator" script completely free , the "powered by" link at the bottom of the pages must stay intact.

Smarty - Create dynamic Web Pages with PHP & MySQL

Creating Dynamic Web Pages Using Smarty and MySQL - Requirement(s): PHP Server, MySQL

Bookmark Current Page - PHP Tutorial

Bookmark current page with PHP example.

PHP Form Basic

PHP Form - PHP form basic, Requirement(s): PHP Server

Comments 1.1. :: PHP Script

This script allows your visitors to add comments to any single page on your web site.
About Author

wain

Date Registered: Sun, Feb 8, 15
Last Time Online: Sun, Mar 18, 18
So far has created 115 entries.
wain
This author has not yet filled in any details.