How to save new created xml?

**lezinterracial** · 03-23-2017, 06:35 PM

Bump for you. Maybe somebody will know better than me.

I don't program much, but this might work. Or put you on the right track.

Maybe just declare the output file
$test-sorted = 'test-sorted.xml';

and instead of using echo use file_put_contents

file_put_contents ($test-sorted,$item->username . "<br/>" . $item->person->age . "<br/><br/>", FILE_APPEND | LOCK_EX);

**TitanWM** · 03-24-2017, 10:37 PM

Why not sort the output? Have you by the assorted xml a performance advantage?

I do not understand what you are doing but this code should work:

PHP Code:

<?php
/////////////////////////////sort xml////////////////////////////////////////////////////
$url = 'test.xml';

$sortXML = new cams();

$arr=$sortXML->load($url);

foreach($arr->element as $item) {
    $items[] = $item;
};
usort ($items, function($a, $b ) {
    return strcmp($a->person->age[0] , $b->person->age[0]);
});

// save array to xml
$sortXML->save('test.xml',$items);

///////////////////////////
// class
//
class cams {

    public function load($fname) {
        $doc = new DOMDocument();

        if($doc->load($fname)) {
            $res= simplexml_load_file($fname);
        } else {
            throw new Exception('error load XML');
        }

        return $res;
    }

    //save array to xml
    public function save($fname, $rows) {
        $doc = new DOMDocument('1.0','utf-8');
        $doc->formatOutput = true;

        $elements = $doc->appendChild($doc->createElement('root'));

        foreach($rows as $row){
            $element=$elements->appendChild($doc->createElement('element'));

            foreach($row as $field_name=>$field_value) {
                $f=$element->appendChild($doc->createElement($field_name));

                if($field_name=='about') {

                    foreach($field_value as $field_name=>$field_value) {
                        $description=$f->appendChild($doc->createElement($field_name));
                        $description->appendChild($doc->createTextNode($field_value));
                    }
                }

                elseif($field_name=='person') {
                    foreach($field_value as $field_name=>$field_value) {
                        $description=$f->appendChild($doc->createElement($field_name));
                        $description->appendChild($doc->createTextNode($field_value));
                    }
                } else {
                    $f->appendChild($doc->createTextNode($field_value));
                }
            }
        }

        file_put_contents($fname, $doc->saveXML());
    }
}
?>

The code would still be optimized

**k33n** · 03-25-2017, 09:31 AM

Thank you for the code,it is working great with test.xml but the original file has more elements than the test example:

Code:

<?xml version="1.0" encoding="utf-8"?>
<root>
  <element>
    <username>Username A</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      [COLOR="DarkOrange"]<another>
	<child1>this is child 1</child1>
	<child2>this is child 2</child2>
	<child3>this is child 3</child3>
      </another>[/COLOR]
    </about>
    [COLOR="DarkOrange"]<persons>
      <person>
      <gender>female</gender>
      <age>29</age>
      <status>single</status>
      <body>
	<build>petite</build>
	<hairLength>shoulder length</hairLength>
	<hairColor>brown</hairColor>
	<eyeColor>green</eyeColor>
     </body>
     <decorations>
	<decoration>tatoo</decoration>
	<decoration>tongue piercing</decoration>
	<decoration>belly button</decoration>
     </decorations>
     </person>
    </persons>[/COLOR]
    <profileImage>url to jpg</profileImage>
  </element>
  <element>
    <username>Username B</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	<child1>this is child 1</child1>
	<child2>this is child 2</child2>
	<child3>this is child 3</child3>
      </another>
    </about>
    <persons>
      <person>
      <gender>female</gender>
      <age>35</age>
      <status>single</status>
      <body>
	<build>petite</build>
	<hairLength>shoulder length</hairLength>
	<hairColor>brown</hairColor>
	<eyeColor>green</eyeColor>
     </body>
     <decorations>
	<decoration>tatoo</decoration>
	<decoration>tongue piercing</decoration>
	<decoration>belly button</decoration>
     </decorations>
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
  <element>
    <username>Username C</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	<child1>this is child 1</child1>
	<child2>this is child 2</child2>
	<child3>this is child 3</child3>
      </another>
    </about>
    <persons>
      <person>
      <gender>female</gender>
      <age>35</age>
      <status>single</status>
      <body>
	<build>petite</build>
	<hairLength>shoulder length</hairLength>
	<hairColor>brown</hairColor>
	<eyeColor>green</eyeColor>
     </body>
     <decorations>
	<decoration>tatoo</decoration>
	<decoration>tongue piercing</decoration>
	<decoration>belly button</decoration>
     </decorations>
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
  <element>
    <username>Username D</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	<child1>this is child 1</child1>
	<child2>this is child 2</child2>
	<child3>this is child 3</child3>
      </another>
    </about>
    <persons>
      <person>
      <gender>female</gender>
      <age>22</age>
      <status>single</status>
      <body>
	<build>petite</build>
	<hairLength>shoulder length</hairLength>
	<hairColor>brown</hairColor>
	<eyeColor>green</eyeColor>
     </body>
     <decorations>
	<decoration>tatoo</decoration>
	<decoration>tongue piercing</decoration>
	<decoration>belly button</decoration>
     </decorations>
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
  <element>
    <username>Username E</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	<child1>this is child 1</child1>
	<child2>this is child 2</child2>
	<child3>this is child 3</child3>
      </another>
    </about>
    <persons>
      <person>
      <gender>female</gender>
      <age>31</age>
      <status>single</status>
      <body>
	<build>petite</build>
	<hairLength>shoulder length</hairLength>
	<hairColor>brown</hairColor>
	<eyeColor>green</eyeColor>
     </body>
     <decorations>
	<decoration>tatoo</decoration>
	<decoration>tongue piercing</decoration>
	<decoration>belly button</decoration>
     </decorations>
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
</root>

The result is a sorted file but with missing elements:

Code:

<?xml version="1.0" encoding="utf-8"?>
<root>
  <element>
    <username>Username E</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	
	
	
      </another>
    </about>
    <persons>
      <person>
      
      
      
      
     
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
  <element>
    <username>Username D</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	
	
	
      </another>
    </about>
    <persons>
      <person>
      
      
      
      
     
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
  <element>
    <username>Username C</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	
	
	
      </another>
    </about>
    <persons>
      <person>
      
      
      
      
     
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
  <element>
    <username>Username B</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	
	
	
      </another>
    </about>
    <persons>
      <person>
      
      
      
      
     
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
  <element>
    <username>Username A</username>
    <about>
      <description>random description</description>
      <from>A place on earth</from>
      <since>1999</since>
      <another>
	
	
	
      </another>
    </about>
    <persons>
      <person>
      
      
      
      
     
     </person>
    </persons>
    <profileImage>url to jpg</profileImage>
  </element>
</root>

I tried to adapt the code but with no result.

Can you please give me a solution? Thank you!

Originally posted by TitanWM

Why not sort the output? Have you by the assorted xml a performance advantage?

I believe so.Maybe i am talking nonsense but if i sort the output,would be done every time the page loads.Instead i am sorting the xml file and save it for future use.

**sarettah** · 03-25-2017, 06:03 PM

Hardcoded the "root" and "element" tags in there, so it is working from the structure of your test file in that regard,

Code:

<?php
// mainline
 
echo "Start of run " . date("M d Y H:i:s", time()) . "<br>\n";
flush();

// define sorter object
$xmlobj=new hd_xml_sorter();

// input file - valid xml file or url to xml feed
$xmlobj->inputfile='test.xml';

// output file name - include path if not the current folder
$xmlobj->outputfile='new_sorted.xml';

// sort fields - order of fields to sort by , type n=numeric, s=string
$xmlobj->sortfields=[['name'=>'age','type'=>'n'],['name'=>'username','type'=>'s']];

// main sort order - first field is controlling field asc is ascending, des is descending. defaulkts ot ascending 
$xmlobj->sortorder='asc';

// call to main file process
$xmlobj->hd_sort_file();

echo "Finished " . date("M d Y H:i:s", time()) . "<br>\n";
if(!empty($xmlobj->error_message))
{
  echo "There were errors:<br>\n" . $xmlobj->error_message . "<br>\n";    
}
echo "Processed " . $xmlobj->process_count . " input records<br>\n";
echo "wrote " . $xmlobj->records_written . " output records<br>\n";

// end of mainline

class hd_xml_sorter
{
  public $inputfile='';
  public $outputfile='xml_output.xml';
  public $sortfields=[];
  public $sortorder='asc';
  public $records_written=0;
  public $process_count=0;
  public $error_message='';
    
  private $sortwork=[];
  private $sortvals=[];
  private $inrec='';
  
  public function hd_sort_file()
  {
    if(!empty($this->inputfile))
    {
      $this->hd_get_xml_file($this->inputfile);
      if($this->inrec)
      {
        $this->hd_process_xml($this->sortwork,$this->sortfields);
      }
      if(count($this->sortwork)>0)
      {
        $this->hd_sort_xml_file();
      }
      if(count($this->sortwork)>0)
      {
        $this->hd_write_xml_file();
      }
    }
    else
    {
      $this->error_message .="No input filename was given<br>\n";
    }
  }

  private function hd_get_xml_file()
  {
    $this->inrec=simplexml_load_file($this->inputfile);
    if(!$this->inrec)
    {
      $this->error_message .="Could not get xml feed: " . $this->inputfile . "<br>\n";
    }
  }
   
  private function hd_process_xml($xmlrec='')
  {
    $proc_cnt=0;
    foreach($this->inrec as $inrec)
    {
      $this->sortvals=array_fill(0,count($this->sortfields),'');
      $this->sortwork[]['sortkey']='';
      $outrec='';
      $outrec=$this->hd_iterate_xml($inrec, $outrec);
      for($i=0;$i<count($this->sortvals);$i++)
      {
        $this->sortwork[count($this->sortwork)-1]['sortkey'] .=$this->sortvals[$i] . "_";
      }      
      $this->sortwork[count($this->sortwork)-1]['body']=$outrec;
      $this->process_count++;
    }
  }

  private function hd_iterate_xml($inrec, $outrec='')
  {
    foreach($inrec as $key=>$value)
    {
      $key=str_replace("\n","",$key);
      if(count($value)>0)
      {
        $workrec='';
        $workrec .=$this->hd_iterate_xml($value, $workrec);
        $outrec .="<" . $key . ">" . $workrec . "</" . $key . ">\n";;
      }
      else
      {
        $outrec .="<" . $key . ">" .  trim($value) . "</" . $key . ">\n";
        $cntr=0;
        foreach($this->sortfields as $field)
        {
          if($field['type']=='s')
          {
            $val2use='';
          }
          else
          {
            $val2use='0';
          }
          //echo "field name=" . $field['name'] . " key=" . $key . "<br>\n";
          if($key==$field['name'])
          {        
            if($field['type']=='s')
            {
              $val2use=trim($value);
            }
            else
            {
              $val2use=trim(strval($value));
            }            
            $this->sortvals[$cntr]=$val2use;
          }
          $cntr++;
        }
      }
    }
    return $outrec;
  }

  private function hd_sort_xml_file()
  {
    foreach ($this->sortwork as $key => $row) 
    {
      $sortkey[]['key']  = $row['sortkey'];
    }
    if($this->sortorder=='des')
    {
      array_multisort($sortkey, SORT_DESC, $this->sortwork);
    }
    else
    {
      array_multisort($sortkey, SORT_ASC, $this->sortwork);
    }
  }

  private function hd_write_xml_file()
  {
    $outfile=fopen($this->outputfile,'w');
    fwrite($outfile,'<' . '?xml version="1.0" encoding="utf-8" ?' . ">\n");
    fwrite($outfile,"<root>\n");
    for($i=0;$i<count($this->sortwork);$i++)
    {
      fwrite($outfile,"<element>\n");
      fwrite($outfile,$this->sortwork[$i]['body']);
      fwrite($outfile,"</element>\n");
      $this->records_written++;        
    }  
    fwrite($outfile,"</root>\n");
    fclose($outfile);
  }  
}

?>

.

**k33n** · 03-26-2017, 04:42 AM

Hey Sarettah,

It works but the & in the url are copied as & and the new xml is not accessible neither with the script or browser.

Code:

http://domain.com/?aff=0000&amp;prg=rev&amp;profile=username

become

Code:

http://domain.com/?aff=0000&prg=rev&profile=username

So now i have the sorted file but can't use it.After some research i found that encoding="utf-8" should take care o this but...is not.Any ideas?
Thank you!

**sarettah** · 03-26-2017, 05:41 AM

Originally posted by k33n

Hey Sarettah,

It works but the & in the url are copied as & and the new xml is not accessible neither with the script or browser.

So now i have the sorted file but can't use it.After some research i found that encoding="utf-8" should take care o this but...is not.Any ideas?
Thank you!

You have lost me a little bit here.

Is that url in the xml file? Or ??

&amp is the html special character for &. I am not sure where you are seeing that.

.

**sarettah** · 03-26-2017, 05:55 AM

I just tested against my chaturbate xml feed url and it did NOT change urls in the file on me.

The iframes in the chaturbate feed all have the & in them in the original. They have them in there before the sort and after the sort.

The chat room urls do not have & in the original, they just have &. They appear the same way in the sort as in the original.

Iframe from the original:

Code:

<iframe src='https://chaturbate.com/affiliates/in/?tour=XXXX&amp;campaign=XXXXX&amp;track=embed&amp;room=killer__tits&amp;bgcolor=white' height=528 width=850 style='border: none;'></iframe>

From the sorted file:

Code:

<iframe src='https://chaturbate.com/affiliates/in/?tour=XXXX&amp;campaign=XXXXX&amp;track=embed&amp;room=killer__tits&amp;bgcolor=white' height=528 width=850 style='border: none;'></iframe>

Chat url from the original:

Code:

<chat_room_url>
https://chaturbate.com/affiliates/in/?tour=XXXX&campaign=XXXXX&track=default&room=killer__tits
</chat_room_url>

Chat url from the sorted file:

Code:

<chat_room_url>
https://chaturbate.com/affiliates/in/?tour=XXXX&campaign=XXXXX&track=default&room=killer__tits
</chat_room_url>

The code I put up should not be changing anything.

However, if you are looking at things in a browser then the & could show as & because that is what an html entity does. You might need to look at the source to see the actual data properly.

Anyway, let me know where you are seeing what you are seeing.

.

**sarettah** · 03-26-2017, 07:39 AM

I have checked all sorts of stuff and even re-written the sort to hanlde everything as xml object rather than an array but no luck. The test stuff you sent me still comes out wrong.

Here is a fix, it is not elegant at all. It addresses the issue you have explicitly and hopefully will work until we figure out wtf is happening:

Replace the hd_iterate_xml function with this:

Code:

  private function hd_iterate_xml($inrec, $outrec='')
  {
    foreach($inrec as $key=>$value)
    {
      $key=str_replace("\n","",$key);
      if(count($value)>0)
      {
        $workrec='';
        $workrec .=$this->hd_iterate_xml($value, $workrec);
        $outrec .="<" . $key . ">" . $workrec . "</" . $key . ">\n";;
      }
      else
      {
        // workaround for k33n issue
        if(trim($key)=='chatRoomUrl')
        {
          $value=htmlspecialchars($value);
        }
        $outrec .="<" . $key . ">" .  trim($value) . "</" . $key . ">\n";
        $cntr=0;
        foreach($this->sortfields as $field)
        {
          if($field['type']=='s')
          {
            $val2use='';
          }
          else
          {
            $val2use='0';
          }
          //echo "field name=" . $field['name'] . " key=" . $key . "<br>\n";
          if($key==$field['name'])
          {        
            if($field['type']=='s')
            {
              $val2use=trim($value);
            }
            else
            {
              $val2use=trim(strval($value));
            }            
            $this->sortvals[$cntr]=$val2use;
          }
          $cntr++;
        }
      }
    }
    return $outrec;
  }

**TitanWM** · 03-26-2017, 08:41 AM

Originally posted by sarettah

I have checked all sorts of stuff and even re-written the sort to hanlde everything as xml object rather than an array but no luck. The test stuff you sent me still comes out wrong.

Here is a fix, it is not elegant at all. It addresses the issue you have explicitly and hopefully will work until we figure out wtf is happening:

Your first code ist elegant

But to use for chaturbate xml-feed you must set in the element_name "iframe" the "height" and "width" values in single quotes:

str_replase " height=528 width=850 " with " height='528' width='850' "

**k33n** · 03-26-2017, 08:55 AM

Originally posted by sarettah

Here is a fix, it is not elegant at all.

Don't know about elegance but it does the trick.Thank you

How to save new created xml?

Tech How to save new created xml?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment