XML Parsing – Xml to PHP array


<?php 
/** 
 * xml2array() will convert the given XML text to an array in the XML structure. 
 * Link: http://www.bin-co.com/php/scripts/xml2array/ 
 * Arguments : $contents – The XML text 
 *                $get_attributes – 1 or 0. If this is 1 the function will get the attributes as well as the tag values – this results in a different array structure in the return value.
 *                $priority – Can be ’tag’ or ’attribute’. This will change the way the resulting array sturcture. For ’tag’, the tags are given more importance.
 * Return: The parsed XML in an array form. Use print_r() to see the resulting array structure. 
 * Examples: $array =  xml2array(file_get_contents(‘feed.xml’)); 
 *              $array =  xml2array(file_get_contents(‘feed.xml’, 1, ’attribute’)); 
 */ 
function xml2array($contents$get_attributes=1$priority ‘tag’) { 
    if(!
$contents) return array(); 

    if(!function_exists(‘xml_parser_create’)) { 
        
//print “‘xml_parser_create()’ function not found!”; 
        
return array(); 
    } 

    //Get the XML parser of PHP – PHP must have this module for the parser to work 
    
$parser xml_parser_create(); 
    
xml_parser_set_option($parserXML_OPTION_TARGET_ENCODING“UTF-8”); # http://minutillo.com/steve/weblog/2004/6/17/php-xml-and-character-encodings-a-tale-of-sadness-rage-and-data-loss 
    
xml_parser_set_option($parserXML_OPTION_CASE_FOLDING0); 
    
xml_parser_set_option($parserXML_OPTION_SKIP_WHITE1); 
    
xml_parse_into_struct($parsertrim($contents), $xml_values); 
    
xml_parser_free($parser); 

    if(!$xml_values) return;//Hmm… 

    //Initializations 
    $xml_array = array(); 
    
$parents = array(); 
    
$opened_tags = array(); 
    
$arr = array(); 

    $current = &$xml_array//Refference 

    //Go through the tags. 
    $repeated_tag_index = array();//Multiple tags with same name will be turned into an array 
    
foreach($xml_values as $data) { 
        unset(
$attributes,$value);//Remove existing values, or there will be trouble 

        //This command will extract these variables into the foreach scope 
        // tag(string), type(string), level(int), attributes(array). 
        extract($data);//We could use the array by itself, but this cooler. 

        $result = array(); 
        
$attributes_data = array(); 
         
        if(isset(
$value)) { 
            if(
$priority == ‘tag’$result $value
            else 
$result[‘value’] = $value//Put the value in a assoc array if we are in the ’Attribute’ mode 
        

        //Set the attributes too. 
        
if(isset($attributes) and $get_attributes) { 
            foreach(
$attributes as $attr => $val) { 
                if(
$priority == ‘tag’$attributes_data[$attr] = $val
                else 
$result[‘attr’][$attr] = $val//Set all the attributes in a array called ’attr’ 
            

        } 

        //See tag status and do the needed. 
        
if($type == “open”) {//The starting of the tag ’<tag>’ 
            
$parent[$level1] = &$current
            if(!
is_array($current) or (!in_array($tagarray_keys($current)))) { //Insert New tag 
                
$current[$tag] = $result
                if(
$attributes_data$current[$tag’_attr’] = $attributes_data
                
$repeated_tag_index[$tag.‘_’.$level] = 1

                $current = &$current[$tag]; 

            } else { //There was another element with the same tag name 

                if(isset($current[$tag][0])) {//If there is a 0th element it is already an array 
                    
$current[$tag][$repeated_tag_index[$tag.‘_’.$level]] = $result
                    
$repeated_tag_index[$tag.‘_’.$level]++; 
                } else {
//This section will make the value an array if multiple tags with the same name appear together
                    
$current[$tag] = array($current[$tag],$result);//This will combine the existing item and the new item together to make an array
                    
$repeated_tag_index[$tag.‘_’.$level] = 2
                     
                    if(isset(
$current[$tag.’_attr’])) { //The attribute of the last(0th) tag must be moved as well
                        
$current[$tag][‘0_attr’] = $current[$tag.’_attr’]; 
                        unset(
$current[$tag.’_attr’]); 
                    } 

                } 
                $last_item_index $repeated_tag_index[$tag.‘_’.$level]-1
                
$current = &$current[$tag][$last_item_index]; 
            } 

        } elseif($type == “complete”) { //Tags that ends in 1 line ’<tag />’ 
            //See if the key is already taken. 
            
if(!isset($current[$tag])) { //New Key 
                
$current[$tag] = $result
                
$repeated_tag_index[$tag.‘_’.$level] = 1
                if(
$priority == ‘tag’ and $attributes_data$current[$tag’_attr’] = $attributes_data

            } else { //If taken, put all things inside a list(array) 
                
if(isset($current[$tag][0]) and is_array($current[$tag])) {//If it is already an array… 

                    // …push the new element into that array. 
                    $current[$tag][$repeated_tag_index[$tag.‘_’.$level]] = $result
                     
                    if(
$priority == ‘tag’ and $get_attributes and $attributes_data) { 
                        
$current[$tag][$repeated_tag_index[$tag.‘_’.$level] . ’_attr’] = $attributes_data
                    } 
                    
$repeated_tag_index[$tag.‘_’.$level]++; 

                } else { //If it is not an array… 
                    
$current[$tag] = array($current[$tag],$result); //…Make it an array using using the existing value and the new value
                    
$repeated_tag_index[$tag.‘_’.$level] = 1
                    if(
$priority == ‘tag’ and $get_attributes) { 
                        if(isset(
$current[$tag.’_attr’])) { //The attribute of the last(0th) tag must be moved as well
                             
                            
$current[$tag][‘0_attr’] = $current[$tag.’_attr’]; 
                            unset(
$current[$tag.’_attr’]); 
                        } 
                         
                        if(
$attributes_data) { 
                            
$current[$tag][$repeated_tag_index[$tag.‘_’.$level] . ’_attr’] = $attributes_data
                        } 
                    } 
                    
$repeated_tag_index[$tag.‘_’.$level]++; //0 and 1 index is already taken 
                

            } 

        } elseif($type == ‘close’) { //End of tag ’</tag>’ 
            
$current = &$parent[$level1]; 
        } 
    } 
     
    return(
$xml_array); 
}  

?>

USAGE

<?php

$feed = “http://webeteerprojects.com/lilly/wordpress/searchlilly.php?search=a&#8221;;

$contents = file_get_contents($feed);//Or however you what it

$result = xml2array($contents);

echo ‘<pre>’;

print_r($result);

echo ‘</pre>’;

?>

Advertisements

Watermark images using php


<?php 

// this script creates a watermarked image from an image file – can be a .jpg .gif or .png file 

// where watermark.gif is a mostly transparent gif image with the watermark – goes in the same directory as this script 

// where this script is named watermark.php 

// call this script with an image tag 

// <img src=”watermark.php?path=imagepath”> where path is a relative path such as subdirectory/image.jpg 

$imagesource =  $_GET[‘path’]; 

$filetype = substr($imagesource,strlen($imagesource)-4,4); 

$filetype = strtolower($filetype); 

if($filetype == “.gif”)  $image = @imagecreatefromgif($imagesource);  

if($filetype == “.jpg”)  $image = @imagecreatefromjpeg($imagesource);  

if($filetype == “.png”)  $image = @imagecreatefrompng($imagesource);  

if (!$image) die(); 

$watermark = @imagecreatefromgif(‘watermark.gif’); 

$imagewidth = imagesx($image); 

$imageheight = imagesy($image);  

$watermarkwidth =  imagesx($watermark); 

$watermarkheight =  imagesy($watermark); 

$startwidth = (($imagewidth – $watermarkwidth)/2); 

$startheight = (($imageheight – $watermarkheight)/2); 

imagecopy($image, $watermark,  $startwidth, $startheight, 0, 0, $watermarkwidth, $watermarkheight); 

imagejpeg($image); 

imagedestroy($image); 

imagedestroy($watermark); 

?>

The script centers the watermark, but can easily be modified to place it along any edge if you would prefer a different location.   For example removing the “/2” in the $startwidth and $startheight variable calculations will put the watermark in the lower right corner. 

You can then make the original images inaccessible if you put the following lines in a .htaccess file in the directory with the images: 

RewriteEngine On
RewriteCond %{REQUEST_URI} !error.gif$
RewriteRule .(gif|jpg|png)$ /error.gif [L] 

This will redirect any attempt to directly access an image in that directory to the error image specified.   Note that the error image is specified on two lines in the .htaccess file.   The first line allows the error image to bypass the rewrite.

SQL with ARRAYS


PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in type or user-defined type can be created. To illustrate their use, we create this table:

CREATE TABLE sal_emp (
    name            text,
    pay_by_quarter  integer[],
    schedule        text[][]
);

As shown, an array data type is named by appending square brackets ([]) to the data type name of the array elements. The above command will create a table namedsal_emp with columns including a text string (name), a one-dimensional array of type integer (pay_by_quarter), which represents the employee’s salary by quarter, and a two-dimensional array of text (schedule), which represents the employee’s weekly schedule.

Now we do some INSERTs. Observe that to write an array value, we enclose the element values within curly braces and separate them by commas. If you know C, this is not unlike the syntax for initializing structures. (More details appear below.)

INSERT INTO sal_emp
    VALUES ('Bill',
    '{10000, 10000, 10000, 10000}',
    '{{"meeting", "lunch"}, {}}');

INSERT INTO sal_emp
    VALUES ('Carol',
    '{20000, 25000, 25000, 25000}',
    '{{"talk", "consult"}, {"meeting"}}');

Now, we can run some queries on sal_emp. First, we show how to access a single element of an array at a time. This query retrieves the names of the employees whose pay changed in the second quarter:

SELECT name FROM sal_emp WHERE pay_by_quarter[1] <> pay_by_quarter[2];

 name
-------
 Carol
(1 row)

The array subscript numbers are written within square brackets. By default PostgreSQL uses the one-based numbering convention for arrays, that is, an array of nelements starts with array[1] and ends with array[n].

This query retrieves the third quarter pay of all employees:

SELECT pay_by_quarter[3] FROM sal_emp;

 pay_by_quarter
----------------
          10000
          25000
(2 rows)

We can also access arbitrary rectangular slices of an array, or subarrays. An array slice is denoted by writing lower-bound:upper-bound for one or more array dimensions. This query retrieves the first item on Bill’s schedule for the first two days of the week:

SELECT schedule[1:2][1:1] FROM sal_emp WHERE name = 'Bill';

      schedule
--------------------
 {{meeting},{""}}
(1 row)

We could also have written

SELECT schedule[1:2][1] FROM sal_emp WHERE name = 'Bill';

with the same result. An array subscripting operation is taken to represent an array slice if any of the subscripts are written in the form lower:upper. A lower bound of 1 is assumed for any subscript where only one value is specified.

An array value can be replaced completely:

UPDATE sal_emp SET pay_by_quarter = '{25000,25000,27000,27000}'
    WHERE name = 'Carol';

or updated at a single element:

UPDATE sal_emp SET pay_by_quarter[4] = 15000
    WHERE name = 'Bill';

or updated in a slice:

UPDATE sal_emp SET pay_by_quarter[1:2] = '{27000,27000}'
    WHERE name = 'Carol';

An array can be enlarged by assigning to an element adjacent to those already present, or by assigning to a slice that is adjacent to or overlaps the data already present. For example, if an array value currently has 4 elements, it will have five elements after an update that assigns to array[5]. Currently, enlargement in this fashion is only allowed for one-dimensional arrays, not multidimensional arrays.

Array slice assignment allows creation of arrays that do not use one-based subscripts. For example one might assign to array[-2:7] to create an array with subscript values running from -2 to 7.

The syntax for CREATE TABLE allows fixed-length arrays to be defined:

CREATE TABLE tictactoe (
    squares   integer[3][3]
);

However, the current implementation does not enforce the array size limits —- the behavior is the same as for arrays of unspecified length.

Actually, the current implementation does not enforce the declared number of dimensions either. Arrays of a particular element type are all considered to be of the same type, regardless of size or number of dimensions. So, declaring number of dimensions or sizes in CREATE TABLE is simply documentation, it does not affect runtime behavior.

The current dimensions of any array value can be retrieved with the array_dims function:

SELECT array_dims(schedule) FROM sal_emp WHERE name = 'Carol';

 array_dims
------------
 [1:2][1:1]
(1 row)

array_dims produces a text result, which is convenient for people to read but perhaps not so convenient for programs.

To search for a value in an array, you must check each value of the array. This can be done by hand (if you know the size of the array):

SELECT * FROM sal_emp WHERE pay_by_quarter[1] = 10000 OR
                            pay_by_quarter[2] = 10000 OR
                            pay_by_quarter[3] = 10000 OR
                            pay_by_quarter[4] = 10000;

However, this quickly becomes tedious for large arrays, and is not helpful if the size of the array is unknown. Although it is not part of the primary PostgreSQL distribution, there is an extension available that defines new functions and operators for iterating over array values. Using this, the above query could be:

SELECT * FROM sal_emp WHERE pay_by_quarter[1:4] *= 10000;

To search the entire array (not just specified columns), you could use:

SELECT * FROM sal_emp WHERE pay_by_quarter *= 10000;

In addition, you could find rows where the array had all values equal to 10 000 with:

SELECT * FROM sal_emp WHERE pay_by_quarter **= 10000;

To install this optional module, look in the contrib/array directory of the PostgreSQL source distribution.

Tip: Arrays are not sets; using arrays in the manner described in the previous paragraph is often a sign of database misdesign. The array field should generally be split off into a separate table. Tables can obviously be searched easily.

Note: A limitation of the present array implementation is that individual elements of an array cannot be SQL null values. The entire array can be set to null, but you can’t have an array with some elements null and some not. Fixing this is on the to-do list.

Array input and output syntax. The external representation of an array value consists of items that are interpreted according to the I/O conversion rules for the array’s element type, plus decoration that indicates the array structure. The decoration consists of curly braces ({ and }) around the array value plus delimiter characters between adjacent items. The delimiter character is usually a comma (,) but can be something else: it is determined by the typdelim setting for the array’s element type. (Among the standard data types provided in the PostgreSQL distribution, type box uses a semicolon (;) but all the others use comma.) In a multidimensional array, each dimension (row, plane, cube, etc.) gets its own level of curly braces, and delimiters must be written between adjacent curly-braced entities of the same level. You may write whitespace before a left brace, after a right brace, or before any individual item string. Whitespace after an item is not ignored, however: after skipping leading whitespace, everything up to the next right brace or delimiter is taken as the item value.

Quoting array elements. As shown above, when writing an array value you may write double quotes around any individual array element. You must do so if the element value would otherwise confuse the array-value parser. For example, elements containing curly braces, commas (or whatever the delimiter character is), double quotes, backslashes, or leading white space must be double-quoted. To put a double quote or backslash in an array element value, precede it with a backslash. Alternatively, you can use backslash-escaping to protect all data characters that would otherwise be taken as array syntax or ignorable white space.

The array output routine will put double quotes around element values if they are empty strings or contain curly braces, delimiter characters, double quotes, backslashes, or white space. Double quotes and backslashes embedded in element values will be backslash-escaped. For numeric data types it is safe to assume that double quotes will never appear, but for textual data types one should be prepared to cope with either presence or absence of quotes. (This is a change in behavior from pre-7.2 PostgreSQLreleases.)

Tip: Remember that what you write in an SQL command will first be interpreted as a string literal, and then as an array. This doubles the number of backslashes you need. For example, to insert a text array value containing a backslash and a double quote, you’d need to write

INSERT ... VALUES ('{"\\","\""}');

The string-literal processor removes one level of backslashes, so that what arrives at the array-value parser looks like {“\”,”"”}. In turn, the strings fed to the text data type’s input routine become  and ” respectively. (If we were working with a data type whose input routine also treated backslashes specially,bytea for example, we might need as many as eight backslashes in the command to get one backslash into the stored array element.)