Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
How to save new created xml? Tech How to save new created xml?
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 03-23-2017, 09:26 AM   #1
k33n
Confirmed User
 
Join Date: Feb 2009
Posts: 201
How to save new created xml?
Need some help here.I am stuck

I have a XML file test.xml :
Code:
<?xml version="1.0" encoding="UTF-8"?>
<root>
	<element>
		<username>A</username>
		<about>
			<description>random description</description>
			<from>A place on earth</from>
			<since>1999</since>
		</about>
		<person>
			<gender>female</gender>
			<age>29</age>
			<status>single</status>
		</person>
		<profileImage>url to jpg</profileImage>
	</element>
	<element>
		<username>B</username>
		<about>
			<description>random description</description>
			<from>A place on earth</from>
			<since>1999</since>
		</about>
		<person>
			<gender>female</gender>
			<age>35</age>
			<status>single</status>
		</person>
		<profileImage>url to jpg</profileImage>
	</element>
	<element>
		<username>C</username>
		<about>
			<description>random description</description>
			<from>A place on earth</from>
			<since>1999</since>
		</about>
		<person>
			<gender>female</gender>
			<age>18</age>
			<status>single</status>
		</person>
		<profileImage>url to jpg</profileImage>
	</element>
	<element>
		<username>D</username>
		<about>
			<description>random description</description>
			<from>A place on earth</from>
			<since>1999</since>
		</about>
		<person>
			<gender>female</gender>
			<age>22</age>
			<status>single</status>
		</person>
		<profileImage>url to jpg</profileImage>
	</element>
	<element>
		<username>E</username>
		<about>
			<description>random description</description>
			<from>A place on earth</from>
			<since>1999</since>
		</about>
		<person>
			<gender>female</gender>
			<age>31</age>
			<status>single</status>
		</person>
		<profileImage>url to jpg</profileImage>
	</element>
</root>
My problem with this xml is that usernames are in alphabetical order and i want to sort them by,age for example.I use this code:
Code:
<?php


/////////////////////////////sort xml////////////////////////////////////////////////////

$url = 'test.xml';
$xml = simplexml_load_file($url);

$items = array();
foreach($xml->element as $item) {
    $items[] = $item;
};
// Custom sort on the names of the items:
usort ($items, function($a, $b ) {
    return strcmp($a->person->age[0] , $b->person->age[0]);
});

foreach ($items as $item) {
    echo $item->username . "<br/>" . $item->person->age . "<br/><br/>";
}

?>
The output:
Quote:
C
18

D
22

A
29

E
31

B
35
As you can see the elements are now sorted,but how do i save it to a new xml file,test-sorted.xml?I 've tried so many times with so many possible codes and i can't figure it out.I am lost...
k33n is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-23-2017, 07:35 PM   #2
lezinterracial
Confirmed User
 
Industry Role:
Join Date: Jul 2012
Posts: 2,920
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);
lezinterracial is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-24-2017, 11:37 PM   #3
TitanWM
Confirmed User
 
TitanWM's Avatar
 
Industry Role:
Join Date: Dec 2015
Posts: 111
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
__________________
CamSoda invite link - promote an unsatisfied cam site!
TitanWM is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-25-2017, 10:31 AM   #4
k33n
Confirmed User
 
Join Date: Feb 2009
Posts: 201
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>
      <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>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>
    <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!
Quote:
Originally Posted by TitanWM View Post
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.
k33n is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-25-2017, 07:03 PM   #5
sarettah
l8r
 
Industry Role:
Join Date: Oct 2002
Posts: 13,488
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);
  }  
}

?>
.
sarettah is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-26-2017, 05:42 AM   #6
k33n
Confirmed User
 
Join Date: Feb 2009
Posts: 201
Hey Sarettah,

It works but the &amp; 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!
k33n is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-26-2017, 06:41 AM   #7
sarettah
l8r
 
Industry Role:
Join Date: Oct 2002
Posts: 13,488
Quote:
Originally Posted by k33n View Post
Hey Sarettah,

It works but the &amp; 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 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-26-2017, 06:55 AM   #8
sarettah
l8r
 
Industry Role:
Join Date: Oct 2002
Posts: 13,488
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 &amp; in them in the original. They have them in there before the sort and after the sort.

The chat room urls do not have &amp; 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 &amp; 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 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-26-2017, 08:39 AM   #9
sarettah
l8r
 
Industry Role:
Join Date: Oct 2002
Posts: 13,488
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;
  }
sarettah is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-26-2017, 09:41 AM   #10
TitanWM
Confirmed User
 
TitanWM's Avatar
 
Industry Role:
Join Date: Dec 2015
Posts: 111
Quote:
Originally Posted by sarettah View Post
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' "
__________________
CamSoda invite link - promote an unsatisfied cam site!
TitanWM is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-26-2017, 09:55 AM   #11
k33n
Confirmed User
 
Join Date: Feb 2009
Posts: 201
Quote:
Originally Posted by sarettah View Post
Here is a fix, it is not elegant at all.
Don't know about elegance but it does the trick.Thank you
k33n is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
How to save new created xml? Tech How to save new created xml?
« Previous Thread | Next Thread »

Bookmarks

Tags
female, earth, random, description, single, jpg, url, xml, sort, $item, $items, save, foreach, $b-person-age[0];, echo, $item-username, figure, function$a, usort, lost, $item-person-age, strcmp$a-person-age[0], return, out.i, codes



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.