# Problem to parse XML from ma.gnolia API

**URL:** https://forum.kirupa.com/t/problem-to-parse-xml-from-ma-gnolia-api/232271
**Category:** programming
**Created:** [July 12, 2007, 8:30am UTC](https://forum.kirupa.com/t/problem-to-parse-xml-from-ma-gnolia-api/232271 "2007-07-12T08:30:51Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![ozskry](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ozskry/32/3890_2.png) [@ozskry](https://forum.kirupa.com/u/ozskry)
#### Post date: [July 12, 2007, 8:30am UTC](https://forum.kirupa.com/t/problem-to-parse-xml-from-ma-gnolia-api/232271/1 "2007-07-12T08:30:51Z")

</div>

Hello,

Based on [**this tutorial**](http://www.kirupa.com/web/xml_php_parse_beginner.htm) from **KIRUPA** , I’m currently trying to write an XML parser to parse an XML file created by the ma.gnolia API because I want to put the different values in a MySQL database.

Here is an example of the datas generated by the ma.gnolia API:

```auto

<bookmark private="false" created="2007-07-04T01:09:21-07:00" rating="0" updated="2007-07-04T01:08:46-07:00" id="yogusefu" owner="ozskry">
  <title>Writing Secure PHP Scripts</title>
  <url>http://www.dagondesign.com/articles/writing-secure-php-scripts-part-1/</url>
  <description>The most important element of any PHP script is security. In this article I will be discussing several methods of securing variables in PHP, with special regard to user input.</description>
  <screenshot>http://scst.srv.girafa.com/srv/i?i=sc010159&amp;r=dagondesign.com/articles/writing-secure-php-scripts-part-1&amp;s=6727eb4bc3bac6a2</screenshot>
  <tags>
    <tag name="tutorials"/>
    <tag name="php"/>
    <tag name="security"/>
  </tags>
</bookmark>

```

And here is my PHP script:

```php

<?php

function start_element($parser, $element_name, $element_attrs)
{
	global $array_number, $current_element;
	if($element_name == 'TITLE')
	{
		$array_number++;
	}
	$current_element = $element_name;
}

function character_data($parser, $data)
{
	global $current_data;
	$current_data = $data;
}

function end_element($parser, $element_name)
{
	global $array_number, $current_element, $current_data, $array_key, $magnolia;
	$magnolia[$array_number][$current_element]=$current_data;
    print_r ($magnolia);
}

$parser = xml_parser_create();
xml_set_element_handler($parser, 'start_element', 'end_element');
xml_set_character_data_handler($parser, 'character_data');
$fp = fopen('http://ma.gnolia.com/api/rest/1/bookmarks_find?api_key=4d7401f2f813fe95d51f60b879ed38f14866ebaa&person=ozskry', 'r') or die();

while ($data = fread($fp, 4096))
{
	xml_parse($parser, $data, feof($fp))
	or die(sprintf('', xml_error_string(xml_get_error_code($parser)), xml_get_current_line_number($parser)));
}

xml_parser_free($parser);

?>

```

All is working fine and my arrays are correctly created:

```auto

Array ( [1] => Array ( [TITLE] => Writing Secure PHP Scripts => http://www.dagondesign.com/articles/writing-secure-php-scripts-part-1/ [DESCRIPTION] => The most important element of any PHP script is security. In this article I will be discussing several methods of securing variables in PHP, with special regard to user input. [SCREENSHOT] => s=6727eb4bc3bac6a2 )

```

Except that the output I get from the SCREENSHOT value is truncated. I have just:

```auto
[SCREENSHOT] => s=6727eb4bc3bac6a2

```

In place of:

```auto
[SCREENSHOT] => http://scst.srv.girafa.com/srv/i?i=sc010159&amp;r=dagondesign.com/articles/writing-secure-php-scripts-part-1&amp;s=6727eb4bc3bac6a2

```

As you can see in the XML code above, the **ampersand** is correctly escaped with ‘ **&** ’.

So, what’s wrong?

Thanks,  
Cary