PHP - Making Php Output A File In Html

I am using SimpleXMLElement to generate an xml file.

I am having some difficulty with formating the file. Hoping someone can assist.
(not having problem getting the data...just unsure when to use ->addChild, ->addAttribute and anything else)

This is the structure of how the file needs to be appear:

Code: [Select]
<?xml version="1.0"?>
<rss version="2.0" xmlns:media="http://search.yahoo.com/mrss/" xmlns:jwplayer="http://developer.longtailvideo.com/trac/" >
<channel>
<title>MRSS Playlist</title>
<item>
<title>Cardio routine with handweights</title>
<media:content url="videos/set2_first_5min.flv" />
<media:thumbnail url="thumbs/set2_first.png" />
<description>side jumps, arm curls, leg squats, arm lifts</description>
<jwplayer:duration>25</jwplayer:duration>
<jwplayer:start>5</jwplayer:start>
</item>
</channel>
</rss>
Thanks as always!
DK

Hello

I need help with making a script.

The script shall get the output of a jar file, by reading it from the stream.


First it should start up the jar file. (exec I guess?)
Then it should start to read from the stream and post it on the site.

As a little "bonus", it would be nice if it could input things to the stream!

Kind regards
Worqy

I just wrote a php page that pulls live data from a database and presents it in an XML layout.

In Internet Explorer, I can Edit, Select All, then Copy-Paste and save as XML. The resulting XML works fine.

In Firefox, I can click File, Save Page As, select Text Files, then name it as an XML. Again, it works fine as XML.

So..... how do I skip the Copy/Paste (IE) or Save Page As (Firefox) steps and write the output directly to an XML file? I've played with stdout(), buffers, page capturing utilities (wget, cURL, httrack, etc....), but no luck so far. This creates a pretty intense page due to the amount of data involved (1.3+ MB).

Any help is appreciated!


 

Given this script:

<?php
$file = file('info.txt');
$statelist = array (1=> "California", "Florida", "Illinois", "New York", "Texas");
foreach ($file as $line => $data)
{
list($state, $abbrev, $population) = explode('|', trim($data));
for ($x=1; $x<5; $x++) {
     if ($statelist[$x] == $state) {
echo $state . ", " . $abbrev . " - " . $population . '<br />';
}
}
}
?>

and this flat file (info.txt):

Code: [Select]
California|CA|36,756,666
Texas|TX|24,326,974
New York|NY|19,490,297
Florida|FL|18,328,340
Illinois|IL|12,901,563

This is what is outputted:
Code: [Select]
California, CA - 36,756,666
Texas, TX - 24,326,974
New York, NY - 19,490,297
Florida, FL - 18,328,340
Illinois, IL - 12,901,563
How can I sort the output by the index value of the "statelist array" so get this output:
Code: [Select]
California, CA - 36,756,666
Florida, FL - 18,328,340
Illinois, IL - 12,901,563
New York, NY - 19,490,297
Texas, TX - 24,326,974
Could  ksort($statelist) be implemented?

I use this code:
Code: [Select]
<?php
$databasehost = "localhost";
$databasename = "export_ajur";
$databasetable = "invoice";
$databaseusername ="root";
$databasepassword = "password";
$fieldseparator = ",";
$lineseparator = "\n";
$csvfile = "1.csv";

$addauto = 0;


$save = 1;
$outputfile = "output.sql";
if(!file_exists($csvfile)) {
echo "File not found. Make sure you specified the correct path.\n";
exit;
}
$file = fopen($csvfile,"r");

if(!$file) {
echo "Error opening data file.\n";
exit;
}

$size = filesize($csvfile);

if(!$size) {
echo "File is empty.\n";
exit;
}

$csvcontent = fread($file,$size);

fclose($file);

$con = @mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
@mysql_select_db($databasename) or die(mysql_error());

$lines = 0;
$queries = "";
$linearray = array();

foreach(explode($lineseparator,$csvcontent) as $line) {

$lines++;

$line = trim($line," \t");

$line = str_replace("\r","",$line);


$linearray = explode($fieldseparator,$line);

$linemysql = implode("','",$linearray);

if($addauto)

$query = "insert into $databasetable values('$linemysql');";
else
$query = "insert into $databasetable values ('$linemysql');";

$queries .= $query . "\n";

@mysql_query($query);
}

@mysql_close($con);

if($save) {

if(!is_writable($outputfile)) {
echo "File is not writable, check permissions.\n";
}

else {
$file2 = fopen($outputfile,"w");

if(!$file2) {
echo "Error writing to the output file.\n";
}
else {
fwrite($file2,$queries);
fclose($file2);
}
}

}

echo "Found a total of $lines records in this csv file.\n";


?>

And th output is:

Code: [Select]
insert into invoice values ('ID_PURCHASE_INVOICE','DOC_TYPE_NAME','DOC_EXT_CODE','DOC_NUM','DOC_DATE','WOVAT_AMOUNT','VAT_AMOUNT','TOTAL_AMOUNT','CONTRAGENT_NAME','CONTRAGENT_BULSTAT','CONTRAGENT_VATNUMBER','CONTRAGENT_POST_ADDRESS','CONTRAGENT_ZIP','CONTRAGENT_CITY','CONTRAGENT_AREA','CONTRAGENT_STREET','CONTRAGENT_MOL','CONTRAGENT_PHONE','CONTRAGENT_BANK','CONTRAGENT_BANK_CODE','CONTRAGENT_BANK_ACCOUNT','CONTRAGENT_EXT_CODE','CONTRAGENT_EMAIL','PAYMENT_NAME','DOC_MARKER1','DOC_MARKER2','DOC_MARKER3','DOC_MARKER4','DOC_MARKER5','DOC_MARKER6','DOC_MARKER7','DOC_MARKER8','DOC_MARKER9','DOC_MARKER10');
insert into invoice values ('108826','ДАНЪЧНА ФАКТУРА','1','111366','2/15/2012','160.08','32.02','192.1','ПРЕЦИЗ ООД','103565237','BG103565237','ВАРНА ГЕН.КОЛЕВ 38','','','','','','','','','','','','БАНКА','','','','','','','','','','');
insert into invoice values ('108830','ДАНЪЧНА ФАКТУРА','1','1002304974','2/15/2012','872.33','174.46','1046.79','ОМВ БЪЛГАРИЯ ООД','121759222','BG121759222','','','СОФИЯ','','','','','','','','','','БАНКА','','','','','','','','','','');
insert into invoice values ('');

I need to remove last line ' insert into invoice values (''); . How to change my code?