how to creat xml files from php.

[aron]

how do i start this.

what i want to do is. i have be givin a layout of a xml document that i need to produce from my php script. so step 1 would be uploading the data to the database and step 2 would be creating a xml file with the exact imformation that was sent to the database.

anyone able to start me off.

cheers aron.

[sid]

is your problem retrieving the db data or creating xml output?

[aron]

i know what its ment to look like. but i dont know how to request it and build the xml.

cheers aron.

[parawizard]

Originally posted by aron
i know what its ment to look like. but i dont know how to request it and build the xml.

cheers aron.

well the database retrival will be the easy part

first off connect to database and retrieve all info into variables

then

output XML lines like

<cats>$cats<cats> 
[CODE]

to a xml file using Fopen (same as a text file) i would think


if your dealing with alot of data to output use loops and retrieve database info into arrays

[aron]

i also need to create the xml file and tell it a folder to be stored in.

also how would i creat child nodes and child nodes of childs.

how do i do that.

cheers aron.

[parawizard]

well theres probally a easy way of creating and determining path of file in PHP that will be easy now for child nodes!

well what i would do is create functions that take in variables

like CREATE NODE, CLOSE NODE, CREATEcNODE, CLOSE cNODE

try to make a system that will work for all situations!

[Shrike]

Creating the XML is the easy part. The tricky part is retreiving the correct data from the database at the correct time. If you know the XML structure and know exactly what data is needed then there should be no problem.

Example for simplicities sake. I want to create some XML from my imaginary database.

<mystuff>
  <stuff id="1">
    <title>This is the title</title>
    <desc>Ths is the description</desc>
  </stuff>
  <stuff id="2">
    ....
  </stuff>
</mystuff>

$result = mysql_query("SELECT t1.id, t2.description, t3.desc
FROM stuff as t1, titles as t2, descriptions as t3
WHERE t1.id = $id AND t2.tbl1_id = t1.id AND t3.tbl1_id = t1.id");
$xmloutput = "<mystuff>";
while($row = mysql_fetch_assoc($result)){
$xmloutput .= "
\t<stuff id=".$row['id'].">
\t\t<title>".$row['title']."</title>
\t\t<desc>".$row['desc']."</desc>
\t</stuff>
";
}
$xmloutput .= "</mystuff>

hth in some way 🙂

[aron]

echo "create";

$fp = @fopen('members.xml','w');
if(!$fp) {
die('Error cannot create XML file');
}
fwrite($fp,$doc->dumpmem());
fclose($fp);
echo "end";

if i add this to tjhe end of your code will it output the xml ast that file.

cheers aron.

[aron]

$member->new_child('lastName','John');
$member->new_child('firstName','Adams');
$member->new_child('contribution','3400');

how can i set an attribute to these

cheers aron