3

My fellow friend is building site in flash and he uses XML files to access data in Flash.

I want to build editable CMS so that client can edit stuff.

Now I don't' have any experience with XML.

I know PHP, HTML and Mysql very well.

So how can I change those already build XML files using Mysql and PHP?

Improve this question

3 Answers 3

Reset to default
1

Maybe going through

http://library.creativecow.net/articles/brimelow_lee/php_mysql/video-tutorial.php

will clear things for you.

Though, use it only to understand the concepts of XML and how it relates to mysql, php and swf. For real work look at libraries that deal with XML such as serializer mentioned in AvatarKava's answer.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

Output the XML using PHP in exactly the same way the example XML file does and then put this at the top of your code:

header('Content-type: text/xml');

To create the XML file from the database just ouput the data the way you normally would adding XML tags in the right place. Eg:

<news>
<?
    while($item = mysql_fetch_array($data)){
    ?>
    <item>
        <url><?=$item['url']; ?></url>
        <title><?=$item['title']; ?></title>
    </item>
    }
?>
</news>

If you need more assistance, provide the XML file that was given to you with the flash file as a reference.

Improve this answer

3 Comments

sorry guys i have no experience with xml. so if i already have xml file in some where. and i want that data from data field in mysql inside that xml. what are steps to perform? example first i need ti code the from in php to change data in mysql. i can do that. but how can xml file get that chnaged data? do i have to write xml file using php in that folder or something
@Mirage, you seem to think that xml is a template that will get filled with data. It is not (well, not in general case), xml is already data (with hierarchical structure). You need to define how will your relational data map to the xml file.
@Unreason , thanks buddy i think u exactly got what i was thinking but now i got it.
0

You probably should look at the PEAR XML Serializer Package. It makes it easy to convert a multi-dimensional array into XML.

Here's a decent tutorial: http://articles.sitepoint.com/article/xml-php-pear-xml_serializer

Improve this answer

Comments