aRo` automating your e-commerce

capture the encoding from the main XML file tag

To capture the encoding from the XML tag of the file. We need to read the first line, and pass it to the function to capture the encoding value.

The first line looks like this:

< ?xml version="1.0" encoding="utf-8"? >

The PHP code:

PLAIN TEXT

PHP:

1. function readfirstline($file){
2.    $fp = @fopen($file, "r");
3.    $firstline = fgets($fp);
4.    fclose($fp);
5.    return $firstline;
6. } 
7. function get_attr(  $line ,$attr) {
8.   $start = strpos($line,"$attr");
9.   $line =  substr($line,$start);
10.   $arr_enc = split("\"",$line);
11.  
12.   return $arr_enc [1];
13. }
14.  
15. $path = "home/user/feeds/id.xml";
16. $line= readfirstline($path);
17.        
18. echo get_attr(  $line ,"encoding");

Popularity: 4% [?]

writing the recursive path for all items that contain data in XML file

This little php functions shows how to write the recursive XMLpath for all nodes that contain values.

This is the result:

/movie/title
/movie/characters/character/name
/movie/characters/character/actor
/movie/characters/character/name
/movie/characters/character/actor
/movie/plot
/movie/rating[@thumbs]
/movie/rating[@stars]

Now you can use this code to map the XML fields against the database fields.

Popularity: 2% [?]