Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : how to fetch data from mysql to xml file using php

[scal]

Hi there

i have 1 file ( index.php ) and one table in database

the table structure is : ( ID , Name , Phone )

i want to fetch this data to xml file look like that :

<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/">
<string>
1|Adam|100001
</string>
<string>
1|Calaman|100001
</string>
<string>
1|Serah|100001
</string>
</ArrayOfString>

i want to php code to select the data and the show it on xml file .

can you please tell me how can i do this ?

Thank you

[scal]

i'am still need help .

[nickelsack]

Not pretty, but it's close:



mysql_connect($dbhost, $dbuser, $dbpass);
@mysql_select_db($dbschema);

$query = "select ID, NAME, PHONE, from table_name";

$result = mysql_query($query);

$i = 0;

print "<ArrayOfString">\n";

while ($i < mysql_numrows($result)) {
print "<string>\n";
print mysql_result($result,$i,"ID") . "|";
print mysql_result($result,$i,"ID") . "|";
print mysql_result($result,$i,"ID") . "\n";
print "</string>\n"

$i++;
}

print "</ArrayOfString>\n";



May the force be with you.

[scal]

Originally Posted by nickelsack

Not pretty, but it's close:



mysql_connect($dbhost, $dbuser, $dbpass);
@mysql_select_db($dbschema);

$query = "select ID, NAME, PHONE, from table_name";

$result = mysql_query($query);

$i = 0;

print "<ArrayOfString">\n";

while ($i < mysql_numrows($result)) {
print "<string>\n";
print mysql_result($result,$i,"ID") . "|";
print mysql_result($result,$i,"ID") . "|";
print mysql_result($result,$i,"ID") . "\n";
print "</string>\n"

$i++;
}

print "</ArrayOfString>\n";



May the force be with you.

thank you man for your help ,

but i think this will not export it xml file

[nickelsack]

I guess I need to know more about how you're trying to do it.

Perhaps you need to change the headers to tell the client you're sending xml. Put this at the top of your php:


header ("Content-Type:text/xml");