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

Expand|Select|Wrap|Line Numbers

 
    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

Quote:

Originally Posted by flexteacher

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

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...

Expand|Select|Wrap|Line Numbers

 
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:webmaster@thenewsflash.net">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)

changing actionscript to read php/mysql instead of xml

re: changing actionscript to read php/mysql instead of xml

re: changing actionscript to read php/mysql instead of xml

re: changing actionscript to read php/mysql instead of xml

Similar Flash / Actionscript bytes

/bytes/development

/bytes/it

/bytes/about