 <?php
 error_reporting(E_ERROR | E_WARNING | E_PARSE);
 function exml(){
 mysql_connect("localhost", "root", "") or die(mysql_error()); 
 mysql_select_db("print") or die(mysql_error());    

  $doc = new DOMDocument();
  $doc->formatOutput = true;
  $r = $doc->createElement( "products" );
  $doc->appendChild( $r );  
 
 $query_products = mysql_query("SELECT * FROM `print_aux`");

while($rows = mysql_fetch_array($query_products)){ 
$nr_rows=mysql_numrows($query_products);     
  $id=          $rows['index'];
  $tip=         $rows['tip'];
  $tip_imp=    $rows['tip_imp'];
  $tip_produs=  $rows['tip_produs'];
  $producator=  $rows['producator'];
  $cod_inter=   $rows['cod_intern'];
  $desciere=    $rows['desc'];
  $cod_oem=     $rows['cod_oem'];
  $pret=        $rows['pret'];
  $valuta=      $rows['valuta'];
  $keywords =  $tip_imp.', '.$desciere.', '.$producator;
  $details =   $tip_imp.', '.$desciere.', '.$producator;
   
  $product = array();

  $product[] = array(
  'id' => $id,
  'name' => $tip,
  'category' => $tip_produs,
  'model' => $tip_imp,
  'keywords' => $keywords,
  'price' => $pret,
  'available' => "1",
  'canBeOrderedOnline' => "0",
  'details' => $details,
  'pictures' => "picture",
  'currency' => $valuta,
  );                           

  
  $b = $doc->createElement( "product" );
  
  $id = $doc->createElement( "id" );
  $id->appendChild(
  $doc->createTextNode( $product['id'] )
  );
  $b->appendChild( $id );
  
  $name = $doc->createElement( "name" );
  $name->appendChild(
  $doc->createTextNode( $product['name'] )
  );
  $b->appendChild( $name );
  
  $category = $doc->createElement( "category" );
  $category->appendChild(
  $doc->createTextNode( $product['category'] )
  );
  $b->appendChild( $category );
  

  $model = $doc->createElement( "model" );
  $model->appendChild(
  $doc->createTextNode( $product['model'] )
  );
  $b->appendChild( $model );
  
  $keywords = $doc->createElement( "keywords" );
  $keywords->appendChild(
  $doc->createTextNode( $product['keywords'] )
  );
  $b->appendChild( $keywords );
  
  $price = $doc->createElement( "price" );
  $price->appendChild(
  $doc->createTextNode( $product['price'] )
  );
  $b->appendChild( $price );
  
  $available = $doc->createElement( "available" );
  $available->appendChild(
  $doc->createTextNode( $product['available'] )
  );
  $b->appendChild( $available );
  
  $canBeOrderedOnline = $doc->createElement( "canBeOrderedOnline" );
  $canBeOrderedOnline->appendChild(
  $doc->createTextNode( $product['canBeOrderedOnline'] )
  );
  $b->appendChild( $canBeOrderedOnline );  
  
  
  $details = $doc->createElement( "details" );
  $details->appendChild(
  $doc->createTextNode( $product['details'] )
  );
  $b->appendChild( $details );  


  $pictures = $doc->createElement( "pictures" );
  $pictures->appendChild(
  $doc->createTextNode( $product['pictures'] )
  );
  $b->appendChild( $pictures );   
  
  $currency = $doc->createElement( "currency" );
  $currency->appendChild(
  $doc->createTextNode( $product['currency'] )
  );
  $b->appendChild( $currency );  
 print_r($product);   
}   
    
  $r->appendChild( $b );


  //echo $doc->saveXML();
  $doc->saveXML('document.xml');
  }
  ?>