Jump to content

xml problems with php


Porkie

Recommended Posts

<? 

  class RSS 
  { 
    public function RSS() 
    { 
        require_once ('mysql_connect.php'); 
    } 

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

    private function dbConnect() 
    { 
        DEFINE ('LINK', mysql_connect (DB_HOST, DB_USER, DB_PASSWORD)); 
    } 

    private function getDetails() 
    { 
        $detailsTable = "webref_rss_details"; 
        $this->dbConnect($detailsTable); 
        $query = "SELECT * FROM ". $detailsTable; 
        $result = mysql_db_query (DB_NAME, $query, LINK); 

        while($row = mysql_fetch_array($result)) 
        { 
            $details = '<?xml version="1.0" encoding="ISO-8859-1" ?> 
                <rss version="2.0"> 
                    <channel> 
                        <title>'. $row['title'] .'</title> 
                        <link>'. $row['link'] .'</link> 
                        <description>'. $row['description'] .'</description> 
                        <language>'. $row['language'] .'</language> 
                        <image> 
                            <title>'. $row['image_title'] .'</title> 
                            <url>'. $row['image_url'] .'</url> 
                            <link>'. $row['image_link'] .'</link> 
                            <width>'. $row['image_width'] .'</width> 
                            <height>'. $row['image_height'] .'</height> 
                        </image>'; 
        } 
        return $details; 
    } 

    private function getItems() 
    { 
        $itemsTable = "webref_rss_items"; 
        $this->dbConnect($itemsTable); 
        $query = "SELECT * FROM ". $itemsTable; 
        $result = mysql_db_query (DB_NAME, $query, LINK); 
        $items = ''; 
        while($row = mysql_fetch_array($result)) 
        { 
            $items .= '<item> 
                <title>'. $row["title"] .'</title> 
                <link>'. $row["link"] .'</link> 
                <description><![CDATA['. $row["description"] .']]></description> 
            </item>'; 
        } 
        $items .= '</channel> 
                </rss>'; 
        return $items; 
    } 

} 

?> 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.