how to put mysql connection and php code within xml file

[amel86]

Hello everyone,
I'm new in xml. I have faces some problem
that is i dont know how to connect mysql and put php code in xml file.

Below is the code about 10 images (slideshow) which are static. I would like to make it dynamic which is the images called from database and uses while looping there.

Please help me to solve this matter.

p/s:or u all can download the file and change from there.. thanks u all.

 
 
 
<artworkinfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album1.jpg</artLocation>
        <artist>The Doors</artist>
        <albumName>Greatest Hits</albumName>
        <artistLink>http://www.google.com</artistLink>
        <albumLink>http://www.yahoo.com</albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album2.jpg</artLocation>
        <artist>The White Stripes</artist>
        <albumName>Elephant</albumName>
        <artistLink>http://www.weberdesignlabs.com</artistLink>
        <albumLink>http://www.freelanceswitch.com</albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album3.jpg</artLocation>
        <artist>Kanye Wests</artist>
        <albumName>Graduation</albumName>
        <artistLink>http://www.kanyewest.com</artistLink>
        <albumLink></albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album4.jpg</artLocation>
        <artist>A Fine Frenzy</artist>
        <albumName>One Cell In The Sea</albumName>
        <artistLink>http://www.google.com</artistLink>
        <albumLink>http://www.yahoo.com</albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album5.jpg</artLocation>
        <artist>Amy Winehouse</artist>
        <albumName>Back to Black</albumName>
        <artistLink>http://www.google.com</artistLink>
        <albumLink>http://www.yahoo.com</albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album6.jpg</artLocation>
        <artist>The Vines</artist>
        <albumName>Highly Evolved</albumName>
        <artistLink>http://www.google.com</artistLink>
        <albumLink>http://www.yahoo.com</albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album7.jpg</artLocation>
        <artist>The Strokes</artist>
        <albumName>Is This It</albumName>
        <artistLink>http://www.google.com</artistLink>
        <albumLink>http://www.yahoo.com</albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album8.jpg</artLocation>
        <artist>Yeah Yeah Yeahs</artist>
        <albumName>Maps - Single</albumName>
        <artistLink>http://www.google.com</artistLink>
        <albumLink>http://www.yahoo.com</albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album9.jpg</artLocation>
        <artist>DangerDoom</artist>
        <albumName>The Mouse and the Mask</albumName>
        <artistLink>http://www.google.com</artistLink>
        <albumLink>http://www.yahoo.com</albumLink>
    </albuminfo>
 
    <albuminfo>
        <artLocation>http://bytes.com/images/album10.jpg</artLocation>
        <artist>Fort Minor</artist>
        <albumName>The Rising Tied</albumName>
        <artistLink>http://www.google.com</artistLink>
        <albumLink>http://www.yahoo.com</albumLink>
    </albuminfo>
 
 
</artworkinfo>

[Dormilich]

i dont know how to connect mysql and put php code in xml file.

you do that by putting it all in a .php file (don’t forget to declare the output as XML). you may achieve the same by an XSL transformation, though that’s a rather complicated way to go.

[amel86]

sorry.. im still not clear

[Dormilich]

to put it simple, you don’t put PHP instructions in an XML file, you put XML data in a PHP file.

[jkmyoung]

You would almost never pass PHP code through the XML, for security among other reason. Do you want to be able to read the XML using PHP? Are you viewing this 'slideshow' in an internet browser?