Blank Space at top of xml

mcborzu

The end result of my project is to have PHP create an xml file that Flash can use.

My Flash can read the XML file I wrote but the one that PHP creates I get nothing. The thing I guessing right now is that my PHP created XML is leaving a blank space at the very top, first line of the XML.

I am trying 2 examples one-PHP spitting out XML and another using the fopen method. Both are leaving a blank space at the top.

Here are my test results:
http://www.myborzu.com/test/index.php
http://www.myborzu.com/test/main.xml

And my code:

@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM xmas";
$result=mysql_query($query);

$num=mysql_numrows($result); 

mysql_close();


echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";


$i=0;
while ($i < $num) {
$name=mysql_result($result,$i,"name");
$pic1=mysql_result($result,$i,"pic1");
$desc1=mysql_result($result,$i,"desc1");
$pic2=mysql_result($result,$i,"pic2");
$desc2=mysql_result($result,$i,"desc2");
$pic3=mysql_result($result,$i,"pic3");
$desc3=mysql_result($result,$i,"desc3");
$pic4=mysql_result($result,$i,"pic4");
$desc4=mysql_result($result,$i,"desc4");  

++$i;
} 

echo "<slideshow>\n<photo url=\"lost1.jpg\" caption=\"Bob tries to explain to electronics theory to Kate.\" />\n
<photo url=\"lost2.jpg\" caption=\"Bob tries to explain to electronics theory to Kate.\" />\n
<photo url=\"lost3.jpg\" caption=\"bob tries to explain to electronics theory to Kate.\" />\n
<photo url=\"lost4.jpg\" caption=\"bob tries to explain to electronics theory to Kate.\" />\n
<photo url=\"lost5.jpg\" caption=\"bob tries to explain to electronics theory to Kate.\" />\n</slideshow>";

?>

Excuse the PHP code, first I want to make sure the XML to works before I dig into database stuff.

Thx for any help you can give me....

Nevermind I insert a blank space in the handtyped XML and flash read it fine....so it must be how I have my flash coded that causing the problem

NogDog

For your XML document's structure to be valid, there must be nothing, including spaces or newlines, before the <?xml tag. (Flash may be forgiving and ignore the space, but I would still try to fix it to match the specification.) I don't see where you are outputting a space in the code you've provided, but all you need is one space not within your <?php . . . ?> tags to do so.

You should send a content-type header letting the client know what you're sending it:

header('Content-Type: text/xml');
echo "<"."?xml version="1.0" encoding='UTF-8' ?".">\n";

mcborzu

Now I'm following a simple example/tutorial. I've solved my space issue but still can't get Flash to read my PHP XML. I can get it to work on my local machine even when I point it to my website but when I upload everything I get nothing...

Here's my PHP code:


<?PHP

$link = mysql_connect("localhost","****","*****");
mysql_select_db("*****");

$query = 'SELECT * FROM xmas';
$results = mysql_query($query);
header('Content-Type: text/xml');
echo "<?xml version=\"1.0\"?>\n";
echo "<products>\n";

while($line = mysql_fetch_assoc($results)) {
	echo "<item>" . $line["desc1"] . "</item>\n";
}

echo "</products>\n";

mysql_close($link);

?>

Here's my actionscript:


var theXML:XML = new XML();
theXML.ignoreWhite = true;

theXML.onLoad = function() {
	var nodes = this.firstChild.childNodes;
	for(i=0;i<nodes.length;i++) {
		theList.addItem(nodes[i].firstChild.nodeValue,i);
	}
}

theXML.load("http://www.myborzu.com/test/lee/products.php");

Thx again for your time to look over it.....

Piranha

Exactly how do your PHP generated XML look like? Post all of it and it iw possible we will find out.

mcborzu

THx for the quick reply.

This is how my PHP created XML looks like:

<?xml version="1.0"?>
<products>
<item>gdgdshfghfggfgh</item>
<item>ghfjhjhgjhgjhgjgh</item>
</products>

This is the page that is creating the XML:
http://www.myborzu.com/test/lee/products.php

I have added the encoding UTF-8 also in other tries but nothing has worked.
I just can't put my finger on why it's working locally but not on the net?

Thx again guys

Update:
Something must have been up with my webhost because now it works fine. Now I can move on to more PHP/database stuff now that I know this works. Thx again...