[whatashareman]

how to call a php query in xml file???


i want to make a dynamic mp3 player who reads song from xml file. i want to give the dynamic path of the song so that i can upload the song from admin and it will save in the song folder. how can i do this??


thanks in adv

[dgreenhouse]

You've answered your own question - to a degree...

This is a little too involved to just explore it without some upfront work on your part.
If you just want something working, maybe you should go to the script request section.

If you've already started doing some of your work and have some questions, it would
then be appropriate to ask for help with that.

If you've already started playing around with the xml and need help with that, post the relevant code snippets.

On another note...

From just a design overview standpoint, these are some of the items you'll need for the app:
(this is basic and doesn't reflect all that you'll need)

Admin:

1- Database calls
2- Presentation
3- Upload song (manage songs i.e. rename, delete, etc.)
4- Read xml
5- Generate xml

User:
1- Database calls
2- Read xml
3- Presentation (display songs)
4- Get song
5- Play song

[Jcbones]

You call the query the same as any other time...

PHP Code:

<?php

//file poll.xml.php;



header('Content-Type: application/xml; charset=ISO-8859-1');

echo '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>';

include('php/connect.php');





$xml_output .= "<graph caption='AM I HOT???:)' subCaption='' yaxisname='Votes' xaxisname='' showAlternateVGridColor='1' alternateVGridAlpha='10' alternateVGridColor='AFD8F8' numDivLines='4' decimalPrecision='0' canvasBorderThickness='1' canvasBorderColor='114B78' baseFontColor='114B78' hoverCapBorderColor='114B78' hoverCapBgColor='E7EFF6'>";



$query = mysql_query("SELECT * FROM `poll`");

                    $add1 = 0;

                    $add2 = 0;

                    $total = 0;

                    while($r = mysql_fetch_array($query))

                        {

                            $value = $r['result'];

                            

                            if($value == 1) $add1 = $add1 + 1000;  //;)

                         elseif($value == 2) $add2 = $add2 + 1;

                         

                         $total++;

                         

                        }

                mysql_free_result($query);

$xml_output .= "<set name='Yes' value='$add1' color='AFD8F8' alpha='70'/>"

                . "<set name='No' value='$add2' color='F6BD0F' alpha='70'/>";



$xml_output .= "</graph>";



echo $xml_output;



?>

This is from a recent project, and is an xml file that is used to generate a chart.