Xml - Vb - Php

[NZ_Kiwis]

I want to make a Visual Basic application which talked at a XML script on my website. I want this XML script to send data back to my VB application which will show for the users.

How I do write a XML script which will run MySQL queries ect to collect information to add into the XML file?

[Weedpacket]

What does this have to do with PHP?

[_theworks]

NZ_Kiwis wrote:

How I do write a XML script which will run MySQL queries ect to collect information to add into the XML file?

XML script? i thought XML was a markup language not a scripting language...

[NZ_Kiwis]

well i want to do a sql search useing php to create a xml document....
<name>The name in the xml is from a php mysql quert</name>

[_theworks]

outputting to XML shouldnt be a problem

you could just do your mysql queries first and then out put it from arrays to xml

$xml = "<queries>\n";

foreach ($querys as $name ){
 $xml .="<query>\n";
 $xml .="<title>".$name."</title>\n";
 $xml .= "</query>";
}

$xml .="<query>";

echo $xml;

[NZ_Kiwis]

$xml = "<queries>\n"; 

foreach ($querys as $name ){ 
$xml .="<query>\n"; 
$xml .="<title>".$name."</title>\n"; 
$xml .= "</query>"; 
} 

$xml .="<query>"; 

echo $xml; 

would this be saved as a .xml or .php file?

[_theworks]

Output as .xml

[NZ_Kiwis]

<?php
mysql_connect (localhost, , );
mysql_select_db (**);
$result2 = mysql_query ("SELECT * From members where id = '2");
$row2 = mysql_fetch_array($result2);
$name = $row[username];
?>

<?php

$xml = "<queries>\n";

foreach ($querys as $name ){
$xml .="<query>\n";
$xml .="<title>".$name."</title>\n";
$xml .= "</query>";
}

$xml .="<query>";

echo $xml;

?>

i get this error

The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

---

XML document must have a top level element. Error processing resource 'http://www.site.com/zz.xml'.

[_theworks]

output to an .xml file.

[_theworks]

ok i didnt think you would put

<?php

$xml = "<queries>\n";

foreach ($querys as $name ){
$xml .="<query>\n";
$xml .="<title>".$name."</title>\n";
$xml .= "</query>";
}

$xml .="<query>";

echo $xml;

?>

in an xml file...

put that in tha same php file as the query's that then outs puts $xml to a .XML file.. ie SAMPLE.XML

[NZ_Kiwis]

how does that work? look at my above code it still does not work from .php

[_theworks]

the code i gave you wasnt just to throw straight into your code it was an example of the concept.

instead of just Echoing $xml write it to a file using [man]fopen[/man] and [man]fwrite[/man] etc...

$handle = fopen('SAMPLE.xml','w');

fwrite($handle,$xml);

fclose($handle);

etc...