save xml file php code?

[jaiffed]

I have this code

 

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

$database = "rprice";

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");

mysql_select_db($database, $linkID) or die("Could not find database.");

 

$query = "SELECT * FROM plist ORDER BY date DESC";

$resultID = mysql_query($query, $linkID) or die("Data not found.");

 

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

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

 

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

    $row = mysql_fetch_assoc($resultID);

    $xml_output .= "\t<set date =\"" . $row['date'] . "\" value =\"" . $row['sprice'] . "\">\n";

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

}

$xml_output .= "</graph>";

 

echo $xml_output;

 

 

 

I want to save this xml file into the folder name Data what is the code of that Plz help

[possien]

You already have your file content in the variable $xml_output.  Do a search on php fwrite to write it to a file.

[jaiffed]

echo $xml_output .= saveXML();

$xml_output .= save("write.xml")

 

i found this but its not working

[xyph]

Use SimpleXML. It was built for this.

 

Comments explain what I'm doing.

 

<?php

// Set up our headers
header( 'Content-type: text/xml; charset=UTF-8' ); 

// Bare bones XML to generate from.
$xml_str = '<?xml version="1.0" ?><users></users>';

// Create a new instance of SimpleXML using the bones
$xml = new SimpleXMLElement( $xml_str );
// Connect to database
$db = new MySQLi( 'localhost','root','','db' );

// Grab all the users and the data we need
$q = 'SELECT `id`,`name`,`email`,`realname`
FROM `users`';
// Perform Query
$r = $db->query( $q );
// Check if query failed. If so, echo empty XML file. Should log error.
if( $r === FALSE ) die( $xml->asXML() );

// Loop through results
while( $row = $r->fetch_assoc() ) {
// Create a new child in '<users>' called '<user>'. Save this to
// variable so we can give it arrtibutes and children
$user = $xml->addChild( 'user' );
// Set attribute - '<user id="$id">'
$user->addAttribute( 'id', $row['id'] );
// Give '<user>' children '<user id="$id"><name>$name</name></user>' etc.
$user->addChild( 'name', $row['name'] );
$user->addChild( 'email', $row['email'] );
$user->addChild( 'realname', $row['realname'] ); 
}

// Free up MySQL results
$r->free();

// Echo our finished XML file.
echo $xml->asXML();

?>

[jaiffed]

im having error in this

$db = new MySQLi( 'localhost','root','12345','rlist' );

[jaiffed]

i want xml file in ths format

<graph>

<set name='Jan' value='17400' hoverText='January'/>

</graph>

[xyph]

i want xml file in ths format

<graph>

<set name='Jan' value='17400' hoverText='January'/>

</graph>

 

It's very easy to change my code to do that exactly.

 

im having error in this

$db = new MySQLi( 'localhost','root','12345','rlist' );

 

Then you've entered incorrect database information. That's my guess, without seeing the error.

[possien]

Are you trying to write to a database or a file?  If file try this.

Try this after your echo statement.

$fhandle = fopen("data.xml", 'w') or die("can't  create file");
fwrite($fhandle, $xml_output) or die("can't write to the file");
fclose($fhandle)

This should write your date to the file data.xml.

[jaiffed]

yes i want to save as a .xml file

&  thanks u so much thiswork

[jaiffed]

everything is done after using possien code at the end the script

 

$fhandle = fopen("data.xml", 'w') or die("can't  create file");

fwrite($fhandle, $xml_output) or die("can't write to the file");

fclose($fhandle)

?>

 

Its work but after that how could i open html file i put include 'dream.html'; & some other codes but its not working help me again guys

[possien]

I am not sure what you are asking?

[jaiffed]

after the end of script i want to call a HTML file called dream.html i used

include ' dream.html';

but its gettin error

so plz help me what is the code to call html file after the script processed.

[possien]

If you want to do it in php you might try this.  Take the dream.html page and rename it to dream.php.  In the page at the beginning create a variable say $dream and put all of the html in that variable.

$dream= 'all of your html goes here.....';

In your main page use :

require_once('dream.php');
echo $dream;

[jaiffed]

I have an dream.html file so i have to know how can i open this file after the end of this php file which create xml file.

 

<?php

 

// Set up our headers

header( 'Content-type: text/xml; charset=UTF-8' );

 

// Bare bones XML to generate from.

$xml_str = '<?xml version="1.0" ?><users></users>';

 

// Create a new instance of SimpleXML using the bones

$xml = new SimpleXMLElement( $xml_str );

// Connect to database

$db = new MySQLi( 'localhost','root','','db' );

 

// Grab all the users and the data we need

$q = 'SELECT `id`,`name`,`email`,`realname`

FROM `users`';

// Perform Query

$r = $db->query( $q );

// Check if query failed. If so, echo empty XML file. Should log error.

if( $r === FALSE ) die( $xml->asXML() );

 

// Loop through results

while( $row = $r->fetch_assoc() ) {

// Create a new child in '<users>' called '<user>'. Save this to

// variable so we can give it arrtibutes and children

$user = $xml->addChild( 'user' );

// Set attribute - '<user id="$id">'

$user->addAttribute( 'id', $row['id'] );

// Give '<user>' children '<user id="$id"><name>$name</name></user>' etc.

$user->addChild( 'name', $row['name'] );

$user->addChild( 'email', $row['email'] );

$user->addChild( 'realname', $row['realname'] );

}

 

// Free up MySQL results

$r->free();

 

// Echo our finished XML file.

echo $xml->asXML();

$fhandle = fopen("data.xml", 'w') or die("can't  create file");

fwrite($fhandle, $xml_output) or die("can't write to the file");

fclose($fhandle);

?>

 

this file create the .xml file & save after that processing i want to open a html file which is dream.html i used

include ' dream.html';

after the

fclose($fhandle);

but its not working getting errror

 

[possien]

Show me your dream.html

[possien]

I think I see what you are trying to do.

 

Try this as your last line of code:

 

header("Location: dream.html");

[possien]

Try this as the last line of code:

 

header("Location:dream.html");

[jaiffed]

this is my file which make graph from saved .xml file

 

change its ext .txt to .html

 

[attachment deleted by admin]

[jaiffed]

header("Location:dream.html");

 

not working...

[jaiffed]

thanx possien

 

your worked header("Location: dream.html");

 

after remove the echo $xml_output;

 

great person thnx a lot.

[possien]

Your welcome!