I'm upgrading all of my feeds to RSS 2.0 so the other syndication format evangelists won't make fun of me. On sites that I publish using PHP and MySQL, I've been offering extremely basic RSS 0.92 feeds that blow up when unusual characters like "¿" are used.
Here's my new MySQL-to-RSS 2.0 PHP script and sourcecode output.
To clean up text from a MySQL database for presentation as XML, the script includes the following function:
function cleanText($intext) {
return utf8_encode(
htmlspecialchars(
stripslashes($intext)));
}
Working my way out of that return statement, the stripslashes method removes the backslash in front of single quote marks ('), double quote marks (") and backslashes (). This replaces escaped character codes, which are often used when storing text in a MySQL database, with the characters they represent.
The htmlspecialchars method turns some characters into HTML entity codes: "<" becomes <, ">" becomes >, and "&" becomes &. These characters have special meaning in XML data, so one way to represent them correctly is to replace them with entities.
The utf8_encode method converts text to UTF-8 format, the default character set for XML, which I decided to use in my RSS feed. I think this cures my problem with unusual characters.
I use another function, date, to turn a MySQL date into a RSS 2.0 timestamp:
@$row = mysql_fetch_array($result1);
$pubDate = date("r", strtotime($row["dateadded"]));
The first argument to the function, "r", establishes the format of the date, RFC 2822, which is compatible with RSS 2.0.
The last upgrade to my script is to stop using URLs as guid values, adopting the Tag URI instead:
$guid = "tag:cadenhead.org,2004-05-20:java21days.".
$row["dex"];
I've always been uncertain about the best way to use guid. Normally, I make it an item's permanent link, adopting the same value as the link element.
The purpose of guid, which provides a unique identifier for each feed item, is enhanced when the value never changes. Using a URL for this value negates that benefit when Web resources change domain names and URLs.
Using the Tag URI has an additional advantage: Looking at the feed, the purposes of link and guid are more clear.
I placed rss.php into the public domain through Creative Commons, so the code can be used in any manner. If you run into any problems on your own MySQL data, let me know so I can improve it.
Hi Rogers,
I've been trying to use your mysql to rss code to extract news items from mysql database with no success. Here is the output (error) I'm getting:
-
-
Psychic News
www.voicesfrombeyond.com
Psychic News
en-us
www.voicesfrombeyond.com
PHP/4.4.1
Warning
: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
/home/voicesfr/public_html/
news/psychics8.php
on line
66
Line 66 begins with:
for ($i = 0; $i < mysql_num_rows($result1); $i++) {
@$row = mysql_fetch_array($result1);
$title = "Day ".cleanText($row["Chapter"])." Update";
$link = "www.voicesfrombeyond.com".
If you can help me get this working I will appreciate it. What does chapter represent in you code?
Everything has its value. Thanks for sharing this informative information with us. GOOD works! forex robot
Thanks for your insight for your fantastic posting. I’m glad I have taken the time to see this. forex robot
If you set out to make me think today; mission accomplished! I really like your writing style and how you express your ideas. Thank you. forex robot
Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. forex robot
Ras El Hekma's North Coast beckons with its exclusive projects, offering a haven of relaxation and luxury living. Explore from Dabaa to Matrouh and discover your perfect coastal retreat. Ù ... شاريع راس الØÙƒÙ ... Ø©
Ras El Hekma's North Coast beckons with its exclusive projects, offering a haven of relaxation and luxury living. Explore from Dabaa to Matrouh and discover your perfect coastal retreat. Ù ... شاريع راس الØÙƒÙ ... Ø©
Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks ë©"ì´ì €ì‚¬ì´íŠ¸
Celebrate with these fun thongs at your bachelorette party. With a humorous saying on the front and a satin-like feel, they are perfect for the party girl. Ideal for bridal showers, they add a touch of humor to the festivities, making them a great gift for a night of mixed drinks and fun. wizard of oz lingerie
Celebrate with these fun thongs at your bachelorette party. With a humorous saying on the front and a satin-like feel, they are perfect for the party girl. Ideal for bridal showers, they add a touch of humor to the festivities, making them a great gift for a night of mixed drinks and fun. wizard of oz lingerie
Converting VHS tapes to digital is simple with the right DIY options. Explore the best methods available online to preserve your precious memories. By researching different solutions, you can ensure your tapes are safely converted to a digital format from the comfort of your home. transfer vhs tapes to digital
i really like this article please keep it up. situs panengg asia
Since 2009, Camp Colley has been providing essential insights into Government Aid, tax, social security, and finance. Stay informed with job notifications and government initiatives. Your reliable source for comprehensive information. Child Tax Credit 2024
Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. MUST SEE TOURIST ATTRACTIONS IN WEST BENGAL
Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. Cultural festival travel
Efficiently written information. It will be profitable to anybody who utilizes it, counting me. Keep up the good work. For certain I will review out more posts day in and day out. acrepairman
Discover the best in online gaming with Gold99 Online Casino. We offer high-quality equipment and the latest technology, along with a variety of professional slot games for top-tier home entertainment. gold99
Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. https://www.special-j0b.com/news/40
All States Industrial Equipment provides the best forklifts and construction machinery for your needs. Choose from top brands like Doosan and Bobcat. Lease or buy today to enhance your business operations. buy forklifts
Next Fertility GynePro, based in Bologna, Emilia Romagna, combines advanced technology with compassionate care. Our expert team provides personalized infertility treatments, pioneering in vitro fertilization in Italy. We ensure comprehensive support and successful outcomes for couples. infertilità merano
Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. bellagio construction
New web site is looking good. Thanks for the great effort. bobbi althoff net worth
I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. Marketing
Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work. poker online panengg
Utilize Import Globals for accurate import-export data, key to global trade success. Our database offers trade insights, aiding informed decisions. Collected from customs documents, our data ensures reliability, helping businesses develop effective strategies. USA Import Data
Top Online Casino Agent: Experience the best live casino games with SLOT138, Indonesia's leading online casino agent. Enjoy games from trusted providers, daily jackpots, and a full range of bonuses. agen casino online
Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up. football
EliteSugarDaddySite.com is the premier platform for affluent individuals seeking attractive younger partners. Our advanced matchmaking algorithm and personalized service ensure perfect connections. Explore the unique world of EliteSugarDaddySite.com and discover the relationship you desire. elite sugar baby dating site
Get genuine Bensedin Diazepam delivered directly to your door with Ukpharmastore. Our online pharmacy provides high-quality medication for anxiety, insomnia, and muscle spasms. With competitive prices and fast UK delivery, Ukpharmastore makes it simple to manage your health. Order Bensedin Diazepam today and feel better with our trusted service. bensedin diazepam 10mg
Access a detailed car history report instantly with our service. Get comprehensive information on ownership history, mileage, outstanding finance, stolen records, and insurance write-offs. Review MOT history and verify VIN accuracy. Enter your vehicle registration now to receive fast and reliable results right at your fingertips. car history check
Please let me know if you’re looking for a article writer for your site. You have some really great posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please send me an email if interested. Thank you! Slot qris
This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!. situs slot gacor
MyGift Mall has the Gift for all. Introducing our new collection at the GiftCardMall. So go ahead, go wild, go Check Your Card Balance www.giftcardmall/mygift
Nice knowledge gaining article. This post is really the best on this valuable topic. 롤ë"€ì˜¤
With a strong commitment to delivering unparalleled solutions for both residential and commercial air conditioning needs o general ac
