# Rss into mysql

**URL:** <https://forum.kirupa.com/t/rss-into-mysql/253878>\
**Category:** Uncategorized\
**Created:** [March 6, 2008, 12:22am UTC](https://forum.kirupa.com/t/rss-into-mysql/253878 "2008-03-06T00:22:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![petermdenton](https://avatars.discourse-cdn.com/v4/letter/p/5daacb/32.png) [@petermdenton](https://forum.kirupa.com/u/petermdenton)\
**Post date:** [March 6, 2008, 12:22am UTC](https://forum.kirupa.com/t/rss-into-mysql/253878/1 "2008-03-06T00:22:54Z")

</div>

Hello, I am learning php/rss but am confused by this. When I just echo out the array, all of the data shows up on the page, but when I do a loop to insert each row into mysql, it only inserts the last item from the xml. Can someone explain this to me?

```auto

<?php
 $con = mysql_connect("someserver.net","username","password");
     if (!$con)
     {
         die('Could not connect: ' . mysql_error());
     }
 mysql_select_db("rss", $con);

 $feedURL = 'http://www.nytimes.com/services/xml/rss/nyt/Magazine.xml';
 $doc = new DOMDocument();
 $doc->load($feedURL);
 $arrFeeds = array();
 foreach ($doc->getElementsByTagName('item') as $node) {
  $itemRSS = array ( 
   'title' => $node->getElementsByTagName('title')->item(0)->nodeValue,
   'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue,
   'link' => $node->getElementsByTagName('link')->item(0)->nodeValue,
   'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue
   );
  array_push($arrFeeds, $itemRSS);
  //print_r($arrFeeds);
  foreach($arrFeeds as $arrItem) 
  {
   //echo $arrItem[title];
   //echo "<br />";
   //echo $arrItem[desc];
   //echo $arrItem[date];
   $sql="INSERT INTO address_book (email) VALUES ('$arrItem[title]')";
  }
 }
 
 if (!mysql_query($sql,$con))
 {
  die('Error: ' . mysql_error());
 }
     mysql_close($con);
?>

```