HomeSunday, June 24, 2018, 01:37:16
1

MySQL to RSS

Tuesday, February 10, 15, 00:36:07, 3 Yaers Ago Via wain, Hits: 6146
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

PHP File Create

Create and write data to a file using the php frwite function.

Creating a CAPTCHA with PHP with imagecreate

This tutorial will show you how to create a form with Captcha, Requirement(s): PHP Server, GD Graphics Library

Process Form Data with Jquery

jQuery, Process form data

ShoutBox 1.1. PHP Script

ShoutBox allows your users to post short messages on your site. The script is lightweight and very easy to install and use.

Captcha V1 - Free PHP Script

An anti-spam form protection image written in PHP, Version: 1.1.

FeedBack Form with Captcha

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

PHP form with file upload

Advanced Contact Form with email and form field validation. It allows your visitors to send you an email directly from your website.

PHP form with image upload

Advanced Contact Form with email and form field validation.It allows your visitors to send you an email directly from your website.Features: Image Upload, HTML Output, Captcha Image.

Advanced Contact Form - PHP Script

Advanced Contact Form with email and form field validation. Features: HTML Output(Response), Captcha Image.

Show / Hide Div with CSS

CSS Display and Visibility:The visibility property specifies whether or not an element is visible.
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.