Need help finishing: RSS Feeds

[sonontse]

Hey Rodolfo,

I got most of the RSS feed information pulled from my SQL table. I am however stuck on getting the image link since I am not familiar with G and the image page link is not in the database. Can you please help with the image link that gives a link to the image page? Thanks.

RSS.class.php

<?php

class RSS
{
public function RSS()
{
DEFINE ('SITE_TITLE', 'Cheverto');
DEFINE ('SITE_DESCRIPTION', 'Cheverto Hosting Script');
DEFINE ('SITE_URL', 'http://www.cheverto.com');
}

public function GetFeed()
{
return $this->getItems();
}

private function dbConnect()
{
DEFINE ('DB_USER', 'root');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'cheverto');
DEFINE ('LINK', mysql_connect (DB_HOST, DB_USER, DB_PASSWORD));
}


private function getItems()
{

$items = '';
$items .= '<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<description>'. SITE_DESCRIPTION. '</description>
<title>'. SITE_TITLE. '</title>
<link>'. SITE_URL .'/explore/</link>';

$itemsTable = "chv_images";
$this->dbConnect($itemsTable);
$query = "SELECT * FROM chv_images ORDER BY image_id DESC LIMIT 50";
mysql_query("SET NAMES 'utf8'", LINK);
$result = mysql_db_query (DB_NAME, $query, LINK);
while($row = mysql_fetch_array($result))
{
$d = $row["image_date_gmt"];
$items .= '
<item>
<title>'. $row["image_description"] .'</title>
<description>
&lt;img src="'. SITE_URL .'/images/'. $row["image_name"] .'.md.'. $row["image_extension"] .'"/&gt;
</description>
<pubDate>'. gmdate(DATE_RSS, strtotime($d)) .'</pubDate>
<link></link>
<guid></guid>
</item>';
}
$items .= '</channel>
</rss>';
return $items;
}

}

?>

rss.php

<?php
header("Content-Type: application/xml; charset=UTF-8");
include("RSS.class.php");
$rss = new RSS();
echo $rss->GetFeed();
?>

 

[Rodolfo]

There are several baddies in your code. For instance, you are connecting to the database and having trouble to get the image info because you are doing the code from scratch. You should use the routes override and create your own route.rss.php file and use all the functions of the CHV and G namespace.

More info here: http://chevereto.com/docs/routes

Also, you should cache the rss to an static file. Is just insane to run it on the fly.

 

[sonontse]

Yeah.. im not so good at programming. I basically jerry-rigged this together from guides online.

 

[sonontse]

I am stuck on getting the direct image link encoded to the image viewer link, any hints?

 

[Rodolfo]

use CHV\Image::get functions.

 

[ebturner]

Any luck with working code? I really need a RSS feed to for the recently uploaded images.

 

[sonontse]

No. Not quite sure how to work with routes so I haven't made any progress on it.

 

[Rodolfo]

Get the public ID and viewer is quite easy... But you need to rely on the system libraries, if you do it on your own you will need to code a lot of stuff.

$id_encoded = CHV\encodeID($id);
$viewer_url = CHV\Image::getUrlViewer($id_encoded);