Методы хранения XML в реляционных базах данных

                            $a['nodeRight'] = $counter; $counter = $counter + 1;

                            $my_record_final->push($a);  

              }

              function contents($parser, $data) {              

                            global $counter;

                            global $my_record;             

                            $a = $my_record->pop();

                            $a = $a['itemXML'];             

                            $a['nodeValue'] = $data;

                            $my_record->push($a);

              }

              while ($g=@$my_record_final->pop())

              {

                            $g = $g['itemXML'];                           

                            $attrs_str = "";

                            foreach ($g['attrs'] as $name=>$val){

                                          if ( $name != "")

                                          $attrs_str = $attrs_str.$name.'="'.$val.'" ';

                            }

                            $val =  $g['nodeValue'];

                            if ( !$result = $mysqli->query("insert into nodesXML values('0','$mid','{$g['nodeName']}','$val','{$g['nodeLeft']}','{$g['nodeRight']}','$attrs_str')"))

                            {

                                          printf("Error: %s<br>",$mysqli->error);

                                          exit;

                            }             

              }

              echo "</pre>";

?>

</body>

</html>

STACK2.CLASS.PHP

<?php

// LICENSE

//

// This program is free software; you can redistribute it and/or

// modify it under the terms of the GNU General Public License (GPL)

// as published by the Free Software Foundation; either version 2

// of the License, or (at your option) any later version.

//

// This program is distributed in the hope that it will be useful,

// but WITHOUT ANY WARRANTY; without even the implied warranty of

// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

// GNU General Public License for more details.

//

// To read the license please visit http://www.gnu.org/copyleft/gpl.html

// ----------------------------------------------------------------------

// Original Author of file: Carey R. Dayrit <carey.dayrit@gmail.com>

// Version 1.0

// ----------------------------------------------------------------------

/**

* A stack data structure. A stack is a LIFO (Last In First Out) data structure.

* This class uses a 2 dimensional array.

*

*Usage Example:

* $my_record=new STACK2('id','name');

* $my_record->push(235,'John');Insert to the top of stack

* $my_record->push(536,'Paul');

* $my_record->push(758,'Mary');

*

* $g=$my_record->pop(); Remove object from top of stack

* $size=$my_record->size();Returns number of rows

* $my_record->is_empty(); Checks to see if size is zero

* $g=$my_record->top();Look at object at top of stack, but don't remove

**/

class STACK2{

/*

Generic methods

stack::is_empty()

stack::push()

stack::size()

stack::top()

stack::pop();

*/

var $record;//The Stack data

var $colNames;//array defining column names

var $numCols;//number of columns

var $curStack;//Current Stack

var $nextStack;

//deconstructor for PHP 4 use register_shutdown_function()

//arguments will define the columns of the record

//columns must use associate arrays

function STACK2(){

  $this->curStack=-1;

  $this->nextStack=0;

  //get the number of arguments

  $this->numCols = func_num_args();

  $this->colNames=func_get_args();

  $found_err=0;

  foreach($this->colNames as $k){

   if(!is_string($k)){

    $found_err=1;

   }

  }

  $err_message='RECORD_STACK() argument must be string of data type.';

   if($found_err){

    return $this->err($err_message);

  }

}

function push(){

  //push data to the record assuming return error message if arguments are more than the specified column names

  //get the number of arguments

  $numargs = func_num_args();

  //echo $this->nextStack;

  if($numargs!=$this->numCols){

   $err_message='The number of columns does not match';

   return $this->err($err_message);

  }else{

   $arg_list = func_get_args();

   //make the colNames as que

   //if there is a better option please do tell me

   $name=$this->colNames;

   foreach($arg_list as $k){

     $d=array_shift($name);

              $this->record[$this->nextStack][$d]=$k;

    }             

   $this->curStack=$this->nextStack;

   $this->nextStack++;

   }

}

function pop(){

  //check if the stack is empty then pop

  //echo $this->is_empty();

  if($this->is_empty()){

   $this->curStack=0;

   $err_message='Cannot go further stack is empty';

  // $err_message='';

   return $this->err($err_message);

  }else{

   //save the record

   $return=$this->record[$this->curStack];

   //destroy pop array

  // $this->record[$this->curStack]=array();

   $pig=$this->colNames;

   foreach($pig as $d){

    array_pop($this->record[$this->curStack]);

   }

   $this->nextStack--;

   $this->curStack--;

   //decrement the pointer;

   return $return;

  }

}

function size(){

  return $this->curStack+1;

}

function top(){

  if(!$this->is_empty()){

   return $this->record[$this->curStack];

  }else{

   $err_message='Stack is empty';

   return $this->err($err_message);

  }

}

function is_empty(){

//get first column name

$dummy=$this->colNames;

//echo $this->record[$this->curStack][array_pop($dummy)];

if( $this->curStack == -1 && $this->record[$this->curStack][array_pop($dummy)]==''){

  return 1;

  }else{

  return 0;

  }

}

function err($message){

// echo "<B>ERROR:</b>".$message;

  exit;

}

}

?>

BEAUTIFIER.PHP

<?php

/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */

/**

* LICENSE:

*

* Copyright (c) 2003-2008 Stephan Schmidt <schst@php.net>

* All rights reserved.

*

* Redistribution and use in source and binary forms, with or without

* modification, are permitted provided that the following conditions

* are met:

*

* Redistributions of source code must retain the above copyright

* notice, this list of conditions and the following disclaimer.

* Redistributions in binary form must reproduce the above copyright

* notice, this list of conditions and the following disclaimer in   the documentation and/or other materials provided with the distribution.

*    * The name of the author may not be used to endorse or promote products

*      derived from this software without specific prior written permission.

*

* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS

* IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,

* THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR

* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR

* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,

* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,

* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR

* PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY

* OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING

* NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS

* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

*

* @category  XML

* @package   XML_Beautifier

* @author    Stephan Schmidt <schst@php.net>

* @copyright 2003-2008 Stephan Schmidt <schst@php.net>

* @license   http://opensource.org/licenses/bsd-license New BSD License

* @version   CVS: $Id: Beautifier.php,v 1.15 2008/08/24 19:44:14 ashnazg Exp $

* @link      http://pear.php.net/package/XML_Beautifier

*/

/**

* define include path constant

*/

if (!defined('XML_BEAUTIFIER_INCLUDE_PATH')) {

    define('XML_BEAUTIFIER_INCLUDE_PATH', 'XML/Beautifier');

}

/**

* element is empty

*/

define('XML_BEAUTIFIER_EMPTY', 0);

/**

* CData

*/

define('XML_BEAUTIFIER_CDATA', 1);

/**

* XML element

*/

define('XML_BEAUTIFIER_ELEMENT', 2);

/**

* processing instruction

*/

define('XML_BEAUTIFIER_PI', 4);

/**

* entity

*/

define('XML_BEAUTIFIER_ENTITY', 8);

/**

* comment

*/

define('XML_BEAUTIFIER_COMMENT', 16);

/**

* XML declaration

*/

define('XML_BEAUTIFIER_XML_DECLARATION', 32);

/**

* doctype declaration

*/

define('XML_BEAUTIFIER_DT_DECLARATION', 64);

/**

* cdata section

*/

define('XML_BEAUTIFIER_CDATA_SECTION', 128);

/**

* default

*/

define('XML_BEAUTIFIER_DEFAULT', 256);

/**

* overwrite the original file

*/

define('XML_BEAUTIFIER_OVERWRITE', -1);

/**

* could not write to output file

*/

define('XML_BEAUTIFIER_ERROR_NO_OUTPUT_FILE', 151);

/**

* could not load renderer

*/

define('XML_BEAUTIFIER_ERROR_UNKNOWN_RENDERER', 152);

/**

* XML_Beautifier is a class that adds linebreaks and

* indentation to your XML files. It can be used on XML

* that looks ugly (e.g. any generated XML) to transform it

* to a nicely looking XML that can be read by humans.

*

* It removes unnecessary whitespace and adds indentation

* depending on the nesting level.

*

* It is able to treat tags, data, processing instructions

* comments, external entities and the XML prologue.

*

* XML_Beautifier is using XML_Beautifier_Tokenizer to parse an XML

* document with a SAX based parser and builds tokens of tags, comments,

* entities, data, etc.

* These tokens will be serialized and indented by a renderer

* with your indent string.

*

* Example 1: Formatting a file

* <code>

* require_once 'XML/Beautifier.php';

* $fmt = new XML_Beautifier();

* $result = $fmt->formatFileformatFile('oldFile.xml', 'newFile.xml');

* </code>

*

* Example 2: Formatting a string

* <code>

* require_once 'XML/Beautifier.php';

* $xml = '<root><foo   bar = "pear"/></root>';

* $fmt = new XML_Beautifier();

* $result = $fmt->formatString($xml);

* </code>

*

* @category  XML

* @package   XML_Beautifier

* @author    Stephan Schmidt <schst@php.net>

* @copyright 2003-2008 Stephan Schmidt <schst@php.net>

* @license   http://opensource.org/licenses/bsd-license New BSD License

* @version   Release: 1.2.0

* @link      http://pear.php.net/package/XML_Beautifier

*/

class XML_Beautifier

{

    /**

     * default options for the output format

     * @var    array

     * @access private

     */

     var $_defaultOptions = array(

         "removeLineBreaks"   => true,

         "removeLeadingSpace" => true,       // not implemented, yet

         "indent"             => "    ",

         "linebreak"          => "\n",

         "caseFolding"        => false,