changing actionscript to read php/mysql instead of xml

[anfetienne]

is it possible to change the below code so it reads arrays that php creates and uses it to display the images and captions instead of reading from xml? the purpose of this is because there is not actual html as all codes are stored in a db and all images and clips etc are linked in using http:// links instead of your local /image.jpg etc

i know the main focus is from lines 5 to 9

    function loadXML(loaded)
    {
        if (loaded)
        {
            xmlNode = this.firstChild;
            total = xmlNode.childNodes.length;
            for (i = 0; i < total; i++)
            {
                _root.small_image[i] = xmlNode.childNodes[i].childNodes[1].firstChild.nodeValue;
                _root.big_image[i] = xmlNode.childNodes[i].childNodes[0].firstChild.nodeValue;
                _root.description[i] = xmlNode.childNodes[i].childNodes[2].firstChild.nodeValue;
                if (i == 0)
                {
                    _root.loadGImage(_root.description[i], _root.big_image[i]);
                } // end if
                ++_root.total_images;
            } // end of for
            createSmall();
            _root.downloadButton._visible = true;
        }
        else
        {
            content = "file not loaded!";
        } // end else if
    } // End of the function
    xmlData = new XML();
    xmlData.ignoreWhite = true;
    xmlData.onLoad = loadXML;
    if (_root.xml_file == undefined)
    {
        _root.xml_file = "images.xml";
    } // end if
    xmlData.load(xml_file);
} // End of the function
 

[flexteacher]

root.xml_file = "images.php";



php do you press the screen, I let my skin again attribution xml server

[anfetienne]

@flexteacher
i dont understand what you mean?

[gopan]

Dear anfetienne,
I hope you know that the flash cannot directly take data from mysql. it can take data as xml or variables... in case of large data we prefer xml.

So all you have to do is to echo the data with a php as an xml. You see the below example...

newsfeed.php
 
<?php 
 header('Content-Type: text/xml');
 echo '<?xml version="1.0"?>
<doc xml:base="http://thenewsflash.net/" xmlns:xlink="http://www.w3.org/1999/xlink">';
 $query = "SELECT ddate,heading,matter FROM news ORDER BY ddate DESC";
 $result = mysql_query($query,$link) or die('Fatal error occured! Inform <a href="mailto:[e-mail]">webmaster</a>');
 $rec = mysql_num_rows($result);
 echo ' <news totrec="'.$rec.'">';
 $i= 1;
 while ($row = mysql_fetch_assoc($result)) {
    $matq=$row["matter"];
    $matq=str_replace ("\r\n","<br>",$matq);
    $matq=htmlspecialchars($matq,ENT_QUOTES);
    echo '  <newsrow id="'.$i.'" heading="'.$row["heading"].'" date="'.$ddate.'" mattr="'.$matq.'"/>';
    $i++;
 }
 mysql_free_result($result);
 mysql_close($link);
 echo ' </news>
</doc>';
?>
 

and replace xmlData.load("newsfeed.xml") to xmlData.load(newsfeed.php)