Download file, str_replace, split field from XML

nadabro

Hi.

I´m pretty new in PHP, i´m having some issues in putting together what i want from a XML.

xml example

<?xml version="1.0" encoding="UTF-8" ?><channel>
<item><title>Hello</title><asd:qw>38.77</asd:qw><asd:za>40.08</asd:za><ttt:toint>-27.064 -177.623</ttt:toint></item>
<item><title>bye</title><asd:qw>38.77</asd:qw><asd:za>40.08</asd:za><ttt:toint>-27.064 -177.623</ttt:toint></item>
</channel>

-Download a file from url. I use this code that works.

<?php
    $url  = 'http://www.hello.com/test.xml';
    $path = 'test.xml';

$ch = curl_init($url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$data = curl_exec($ch);

curl_close($ch);

file_put_contents($path, $data);
?>

-Replace 2 words, basically i want to remove the ":" from "asd:qw" and "asd:za" fields. But using this code i dont know how to replace two words from the same file..

<?php
// open to read and modify
$file = "test.xml";
$fh = fopen($file, 'r+');

$data = fread($fh, filesize($file));
$data = str_replace("asd:qa", "asdqa", $data);

fclose($fh);

// Open to write
$fh = fopen($file, 'r+');
fwrite($fh, $data);
fclose($fh);
?>

-Split XML field and create two new fields;
From <ttt:toint>-27.064 -177.623</ttt:toint>, i which to split "ttt:toint" from the "space" that separate the two sets of numbers and create two new fields .

ex:

<ttt:toint>-27.064 -177.623</ttt:toint>
<zz>-27.064</zz><aa>-177.623</aa>

And finally i wish to run all in one file (if possible).

I´ve been battling with this issues for some days but my programming skill are pretty green..

Thanks.

Weedpacket

nadabro wrote:
-Replace 2 words, basically i want to remove the ":" from "asd:qw" and "asd:za" fields.

Seems like a funny thing to want to do when processing XML, but...

$data = str_replace("asd:qa", "asdqa", $data);

You've done it once, what about doing it twice - once for each word?

-Split XML field and create two new fields;
From <ttt:toint>-27.064 -177.623</ttt:toint>, i which to split "ttt:toint" from the "space" that separate the two sets of numbers and create two new fields .

So, you want to

Find each <ttt:toint> element;
get its text content;
use something like [man]explode[/man] to separate that text into pieces using " - " as the separator
insert new elements; and
remove the old <ttt:toint> element.

Right?

nadabro

Thanks for answering @.

Weedpacket wrote:
Seems like a funny thing to want to do when processing XML, but...

Apart from editing some lines in a php based forum, my programming skills are pretty null..thanks for pointing out to "DOM".

Weedpacket wrote:
$data = str_replace("asd:qa", "asdqa", $data); 
You've done it once, what about doing it twice - once for each word?

Well i fell a bit dumb on this one lol
It works, but in the end of the XML, it copies twice the last line before the field that closes the XML..how can i fix this?

<?php

// open to read and modify

$file = "test.xml";

$fh = fopen($file, 'r+');

$data = fread($fh, filesize($file));



$data = str_replace("asd:qw", "asdqw", $data);

fclose($fh);

// Open to write

$fh = fopen($file, 'r+');

fwrite($fh, $data);

fclose($fh);

// open to read and modify

$fh = fopen($file, 'r+');

$data2 = fread($fh, filesize($file));

$data2 = str_replace("asd:qa", "asdqa", $data2);

fclose($fh);

// Open to write

$fh = fopen($file, 'r+');

fwrite($fh, $data2);

fclose($fh);

?>

Weedpacket wrote:
So, you want to

Find each <ttt:toint> element;

get its text content;

use something like explode to separate that text into pieces using " - " as the separator

insert new elements; and

remove the old <ttt:toint> element.

Right?

Everything is right except in 3, the "-" is for negative coordinates, but it can be positive coordinates, the only thing dont change in the XML is the space between the two sets of numbers.
About 5, its a extra..it can stay in the XML, i wont use it.

nadabro

The "bug" on copying one of the lines of the XML to the end was resolved by changing "r+" to "w+" in the write function. One less thing to worry about 🙂

Remains the other issue, do you have a example that i can follow @Weedspacket?

Thanks

nadabro

Solved!😃

Thanks for pointing the functions required, specially the "explode" one.

Regards.