My first xml try

[Ronald Wiplinger <ronald@xxxxxxxxx>]

I must use php 4 and mysql 4.x !

I tried an example I found on the net and modified it so that it should
work with php4 and mysql 4. The code is below.
I need to access a database and get an xml feed output.
I tried to use echo statements for debugging and found that it seems I
do not get the information of require().

What do I need to change?

bye

Ronald

|<?
    header("Content-Type: application/xml; charset=ISO-8859-1");

class RSS
{
    function RSS()
    {
        require("../mysyql-config");
    }
    
    function GetFeed()
    {
        return $this->getDetails() . $this->getItems();
    }
    
    
    function getDetails()
    {
        $detailsTable = "webref_rss_details";
        $query = "SELECT * FROM ". $detailsTable;
        $db = mysql_connect($dbhost, $dbuname, $dbpass);
        mysql_select_db($dbname,$db);
        $result = mysql_query($query, $db);
//    echo "dbhost=$dbhost<br>dbuname=$dbuname";
        while($myrow = mysql_fetch_array($result))
        {
            $details = '<?xml version="1.0" encoding="utf-8" ?>
                    <rss version="2.0">
                        <channel>
                            <title>'. $myrow['title'] .'</title>
                            <link>'. $myrow['link'] .'</link>
                            <description>'. $myrow['description']
.'</description>
                            <language>'. $myrow['language'] .'</language>
                            <image>
                                <title>'. $myrow['image_title'] .'</title>
                                <url>'. $myrow['image_url'] .'</url>
                                <link>'. $myrow['image_link'] .'</link>
                                <width>'. $myrow['image_width'] .'</width>
                                <height>'. $myrow['image_height']
.'</height>
                            </image>';
        }
        return $details;
    }
    
    function getItems()
    {
        $itemsTable = "webref_rss_items";
        $query = "SELECT * FROM ". $itemsTable;
        $db = mysql_connect($dbhost, $dbuname, $dbpass);
        mysql_select_db($dbname,$db);
        $result = mysql_query ($query, $db);
        $items = '';
        while($myrow = mysql_fetch_array($result))
        {
            $items .= '<item>
                         <title>'. $myrow["title"] .'</title>
                         <link>'. $myrow["link"] .'</link>
                         <description><![CDATA['. $myrow["description"]
.']]></description>
                     </item>';
        }
        $items .= '</channel>
                 </rss>';
        return $items;
    }

}

    $rss = new RSS();
    echo $rss->GetFeed();
?>
|

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php