[punky79]

I have code written to generate xml data in PHP from my MySQL database. I can display this in my browser using "echo" but wbat I really want is to write this xml data to a seperate xml file so that I can have flash use it.

Here is my code:

PHP Code:

<?php require_once('Connections/PhotoABC.php'); ?>

<?php

if (!isset($_SESSION)) {

  session_start();

}



$sqluserid = "SELECT `user_id` FROM `user` WHERE `username` = '".$_SESSION['MM_Username']."'";

            $useridqueryresult = mysql_query($sqluserid)

               or die (mysql_error());

            if (mysql_num_rows($useridqueryresult) > 0) {

            $row=mysql_fetch_assoc($useridqueryresult);

            $userid=$row['user_id'];

            }

            

$sqlimagename = "SELECT `image_name` FROM `gallery` WHERE `user_id` = '$userid'";

            $imagenamequeryresult = mysql_query($sqlimagename)

               or die (mysql_error());



$xml_output  = "<?xml version=\"1.0\"?>\n";

$xml_output .= "<images>\n";



for($x =  0 ;  $x <  mysql_num_rows($imagenamequeryresult) ; $x++){

    $row = mysql_fetch_assoc($imagenamequeryresult);

    $xml_output .= "\t<image>\n";

xml_output .= "\t\t<image>" . $row['image_name'] . "</image>\n";

    $xml_output .= "\t</image>\n";

} 



 $xml_output  .=  "</images>"; 

 

 echo $xml_output;



?>

I would like to write this xml data to a new xml file called "images" and to save it to this directory
"C:\htdocs\PhotoABC\upload_test\Jordan"

Any help would be great

[Nico]

Take a look at www.php.net/file_put_contents

[punky79]

thanks....I should really have tried this first.
I will give it a go!

[punky79]

I have tried this but I am getting an error:

Warning: file_put_contents(C:\htdocs\PhotoABC\upload_test\J ordan) [function.file-put-contents]: failed to open stream: Permission denied in C:\htdocs\PhotoABC\xml.php on line 43

I understand in Java I have to have inpout and output streams but not sure how to go about this in PHP.

Can anyone help?

this is my added code:

PHP Code:

$filename= 'C:\htdocs\PhotoABC\upload_test\\'.$_SESSION['MM_Username'];



file_put_contents($filename ,$xml_output); 

just added these 2 lines.

Thanks

[Jay6390]

It may just be a file security issue on the machine. check your setting in the properties for the folder / file to make sure you have sufficient priviliges. Also, there is a space in the word Jordan between the J and the o, if that makes any difference.

[Nico]

You have to escape backslashes. Try:

PHP Code:

 $filename= 'C:\\htdocs\\PhotoABC\\upload_test\\\\'.$_SESSION['MM_Username']; 

[punky79]

Thanks guys

I tried the new line Nico but same error:

Warning: file_put_contents(C:\htdocs\PhotoABC\upload_test\J ordan) [function.file-put-contents]: failed to open stream: Permission denied in C:\htdocs\PhotoABC\xml.php on line 43

Could it be my permissions?
How do I check this?
I have a script that uploads images and creates folders to store the images and had no problems with permissions running those...

Thanks

[punky79]

I have this working now.
Here is the code I used:

PHP Code:

$filenamepath .=   "images.xml";

 

 $fp = fopen($filenamepath,'w');



            $write = fwrite($fp,$xml_output);

 

 echo $xml_output; 

Thanks for your help

[tolga]

Originally Posted by punky79

I have code written to generate xml data in PHP from my MySQL database. I can display this in my browser using "echo" but wbat I really want is to write this xml data to a seperate xml file so that I can have flash use it.

Here is my code:

PHP Code:

<?php require_once('Connections/PhotoABC.php'); ?>

<?php

if (!isset($_SESSION)) {

  session_start();

}



$sqluserid = "SELECT `user_id` FROM `user` WHERE `username` = '".$_SESSION['MM_Username']."'";

            $useridqueryresult = mysql_query($sqluserid)

               or die (mysql_error());

            if (mysql_num_rows($useridqueryresult) > 0) {

            $row=mysql_fetch_assoc($useridqueryresult);

            $userid=$row['user_id'];

            }

            

$sqlimagename = "SELECT `image_name` FROM `gallery` WHERE `user_id` = '$userid'";

            $imagenamequeryresult = mysql_query($sqlimagename)

               or die (mysql_error());



$xml_output  = "<?xml version=\"1.0\"?>\n";

$xml_output .= "<images>\n";



for($x =  0 ;  $x <  mysql_num_rows($imagenamequeryresult) ; $x++){

    $row = mysql_fetch_assoc($imagenamequeryresult);

    $xml_output .= "\t<image>\n";

xml_output .= "\t\t<image>" . $row['image_name'] . "</image>\n";

    $xml_output .= "\t</image>\n";

} 



 $xml_output  .=  "</images>"; 

 

 echo $xml_output;



?>

I would like to write this xml data to a new xml file called "images" and to save it to this directory
"C:\htdocs\PhotoABC\upload_test\Jordan"

Any help would be great

Hello,

I would like to do exactly the same thing for the same purpose. My question is, how do you get multiple fields from a table and have those written?

Regards,