Newbie: Looping thru XML

wcboyd

Hello All,

I am trying to extract certain pieces of data from an XML file.
I need to go from start to finish in the file and repeatedly extract two elements from the file.

Here is what I have so far, it is not much...


$xml = simplexml_load_file('c:/sample.xml');
$fp1 = fopen("c:/output.ddl"), "w");
$num = 0;
$xml->package->class->name as $RSMClassName;
$xml->package->class->rdbPhysicalName as $TableName;

I want to output the two variables ($RSMClassName & $TableName) to the output file.

Here are my specific questions
1) Am I defining the two variables mentioned above correctly?
2) What is the best way to loop through the xml object?

Thanks.

wcboyd

OK, I think I have made some progress on my own. Here is what I have now:

<?php

$xml = simplexml_load_file('c:\input.xml');
$fp1 = fopen('c:\output.txt'), 'w');
$num = 0;
foreach ($xml->package->class->name as $RSMClassName)
{
	fwrite($fp1 $RSMClassName);
	$xml->package->class->rdbPhysicalName as $TableName;
	fwrite($fp1 $Tablename);
}
fclose($fp1);

?>

But now I am getting the following error message:
Parse error: syntax error, unexpected ',' in C:\createfromxml.php on line 4

Any ideas? I am sure I am missing something easy and obvious...

Thanks.

Craig

laserlight

Use a little syntax highlighting and you'll spot a typo error in the line with fopen()

<?php

$xml = simplexml_load_file('c:\input.xml');
$fp1 = fopen('c:\output.txt'), 'w');
$num = 0;
foreach ($xml->package->class->name as $RSMClassName)
{
	fwrite($fp1 $RSMClassName);
	$xml->package->class->rdbPhysicalName as $TableName;
	fwrite($fp1 $Tablename);
}
fclose($fp1);

?>

wcboyd

Laserlight,

Thanks for the quick response.

So I should use double quotes instead of single quotes?

Thanks.

Craig

laserlight

Single quotes are fine. The problem is that:

$fp1 = fopen('c:\output.txt'), 'w');

should be:

$fp1 = fopen('c:\output.txt', 'w');

wcboyd

Thank you so much laserlight. It is obvious now that you point it out! 🙂

wcboyd

OK, I fixed that. Now what am I doing wrong?
Here is the error I get:

Parse error: syntax error, unexpected T_VARIABLE on line 8

Thanks.

Craig

NogDog

You left out the comma between the arguments to fwrite().

wcboyd

NogDog,

Thanks for the reply. I put the comma in and got the following error:

Parse error: syntax error, unexpected T_AS on line 10

Any more ideas?

Thanks,

Craig

laserlight

It looks like you intended to write another foreach loop, but somehow did not.

NogDog

I assume line 10 is this line?

	$xml->package->class->rdbPhysicalName as $TableName;

It looks like maybe you want another foreach loop, but I'm just guessing:

foreach($xml->package->class->rdbPhysicalName as $TableName)
{
   fwrite($fp1, $Tablename); // note that I added another missing comma here
}

wcboyd

NogDog,

Thanks again for your help.
Unfortunately I am now getting a different error:

Warning: Invalid argument supplied for foreach() on line 6

Here is the new code:

<?php

$xml = simplexml_load_file('c:\input.xml');
$fp1 = fopen('c:\output.txt', 'w');
$num = 0;
foreach ($xml->package->class->name as $RSMClassName)
{

fwrite($fp1, $RSMClassName);

foreach	($xml->package->class->rdbPhysicalName as $TableName)
{
	fwrite($fp1, $Tablename);
}

}
fclose($fp1);

?>

Line 6 is the first "foreach"

Thanks.

Craig

NogDog

That would seem to indicate that $xml->package->class->name is not an array.

wcboyd

NogDog,

Again, thanks for your help.🙂

I am still getting the same error. Here is my current code. To make things easier/simpler I am just trying to extract a single XML element and write it to a text file.

Here is the newer smaller code:

<?php

$xml = simplexml_load_file('c:\input.xml');
$fp1 = fopen('c:\output.txt', 'w');
foreach ($xml->root->package->class->name as $RSMClassName) 
{
	fwrite($fp1, $RSMClassName);
}
fclose($fp1);

?>

What am I missing?!!?

NogDog

What do you get as output if you do:

<?php

$xml = simplexml_load_file('c:\input.xml');
printf("<pre>%s</pre>\n", print_r($xml->root->package->class, 1));

wcboyd

Here is the output I get:

<pre></pre>

Does that help?

Thanks,

Craig

NogDog

wcboyd wrote:
Here is the output I get:

Does that help?

Thanks,

Craig

Yeah, it tells us why you're got getting any data. 🙂

Try backing up through the chain until you get something:

printf("<pre>%s</pre>\n", print_r($xml->root->package, 1));

If nothing from that, then:

printf("<pre>%s</pre>\n", print_r($xml->root, 1));

And if nothing from that, then (hopefully):

printf("<pre>%s</pre>\n", print_r($xml, 1));

wcboyd

NogDog,

It was the last one that did it! It printed EVERYTHING!

printf("<pre>%s</pre>\n", print_r($xml, 1));

So what does that mean? I think I am following my structure as shown to me by my editor, anyway.

Thanks,

Craig

NogDog

Can you share the output with us? (We don't need to see every record, but enough to see the pattern.)

wcboyd

Will this sufficient?