The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> XML in flash
joyful
post Jun 3 2011, 12:41 AM
Post #1


Advanced Member
****

Group: Members
Posts: 239
Joined: 15-November 10
Member No.: 13,147



Hey!

I am pretty new to Flash (and AS)... I am trying to display data from a mySQL database in flash...
I have configured my server to pierce xml as PHP... So I have a XML file with all of the data from the database...

I would now like to display this in Flash...
As I said: I really don't know a whole lot of Flash... I am working in AS2.
I have set up a dynamic text box called: "xmlBox"... This is my XML:
CODE

<?php header('Content-type: text/xml'); ?>

<?php

$error = "Couldn't connect".mysql_error();

$connect = mysql_connect("localhost", "root", "") or die($error);
mysql_select_db("mydatabase") or die($error);

?>

<channel>

<?php
$q="SELECT id,title,body,UNIX_TIMESTAMP(pubDate) AS pubDate
FROM mytable ORDER BY pubDate DESC LIMIT 0,15";
$doGet=mysql_query($q);

while($result = mysql_fetch_array($doGet)){
?>
     <item>
        <title> <?=htmlentities(strip_tags($result['title'])); ?></title>
        <description> <?=htmlentities(strip_tags($result['body'],'ENT_QUOTES'));?></description>
        <link>http://www.mysite.com/</link>
        <pubDate> <?=strftime( "%a, %d %b %Y %T %Z" , $result['pubDate']); ?></pubDate>
     </item>  
<?php } ?>

</channel>

This works great!

Here is my AS2:
CODE

var myXML = new XML();
myXML.ignoreWhite=true;
myXML.onLoad = function(sucess){
    if(sucess){
        xmlBox.text=this;
    }
}
myXML.load("../blog/blog.xml");

This gives me some bazar combination of letters in the text box:

logllglogogool:oo::llollooloo::llo

I have no clue what this is... When I "trace" "this" it all shows up (all of the xml)...

What are all of those weird letters? How can I just display all of the XML? Is there a simpler way to just display all of my XML?

Thanks in advance! smile.gif

--


--------------------
"When I was 5 years old, my mother always told me that happiness was the key to life. When I went to school, they asked me what I wanted to be when I grew up. I wrote down ‘happy’. They told me I didn’t understand the assignment, and I told them they didn’t understand life.” ~ John Lennon
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
joyful
post Jun 3 2011, 07:07 PM
Post #2


Advanced Member
****

Group: Members
Posts: 239
Joined: 15-November 10
Member No.: 13,147



Anyone?

One thing I noticed:
When I select the "bazar jumbled text" like:
CODE
o:oo

and copy it, then paste it (in text edit). It says this:
CODE
<br /><b>Parse error</b>:  syntax error, unexpected & a p o s;

*NOTE* I had to add those spaces after the & because otherwise it makes a: '

So, what I am seeing in my SWF, (and copying) is not actually what the text is (when I paste it)... What does that mean? What Is going on??

Please... Any help? wacko.gif

--

This post has been edited by joyful: Jun 3 2011, 07:10 PM


--------------------
"When I was 5 years old, my mother always told me that happiness was the key to life. When I went to school, they asked me what I wanted to be when I grew up. I wrote down ‘happy’. They told me I didn’t understand the assignment, and I told them they didn’t understand life.” ~ John Lennon
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
joyful
post Jun 7 2011, 04:08 PM
Post #3


Advanced Member
****

Group: Members
Posts: 239
Joined: 15-November 10
Member No.: 13,147



Hey! Sorry... I am quite new to Flash...
The issue was that text was not set to "TLF"... Once I set it to that, the text worked fine...


--------------------
"When I was 5 years old, my mother always told me that happiness was the key to life. When I went to school, they asked me what I wanted to be when I grew up. I wrote down ‘happy’. They told me I didn’t understand the assignment, and I told them they didn’t understand life.” ~ John Lennon
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 26th November 2014 - 12:12 AM