how can i put xml files into database and after this retrieve them

Question

I have a problem. Is any possibility to put my xml file into a database and access them from it. I have this function that get content from a xml file:

function getFeed()
{
    $content = file_get_contents('http://feeds.reuters.com/reuters/technologyNews');
    $x = new SimpleXmlElement($content);
    foreach($x->channel->item as $entry) {
        $feeds = array('title' => (string)$entry->title
                );
        $this->session->set_userdata($feeds);
        $this->load->model('membership_model');
        $this->membership_model->feeds();
    }

And a model who insert the titles into a database and after this get the titles as a link format. But i guess is not a good idea because is not working.

function feeds()
{   
    $this->db->empty_table('feeds');
    $this->db->set('title',$this->session->userdata('title'));
    $this->db->insert('feeds');
    $get_feed = $this->db->get('feeds');
    foreach ($get_feed->result() as $row){
        echo "<a href='$row->title'>".$row->title."</a><br/>";
        }

First i want to save the title, the content and if it's possible the URL's of titles or the hash? — user3313651, Feb 22 '14 at 14:14
so, you are going to save while xml file content in a column right? — Kumar V, Feb 22 '14 at 14:17
I'm asking that your are going to store whole file content in a table field? Or each xml tag is having columns in table? — Kumar V, Feb 22 '14 at 14:36

score 0 · Accepted Answer · answered Feb 22 '14 at 14:52

You can do with insert batch

First prepare the array for batch insertion.

function getFeed()
{
    $content = file_get_contents('http://feeds.reuters.com/reuters/technologyNews');
    $x = new SimpleXmlElement($content);
    foreach($x->channel->item as $entry) {
        $feeds[] = array(
                         'title' => (string)$entry->title,
                         'url'=> (string)$entry->url, // ad more fields if needed                        
                );

        $this->load->model('membership_model');
        $this->membership_model->feeds($feeds);
    }
 //load view with data. No need to get same data from db again.
 $this->load->view("feed_list",array("feeds"=>$feeds));
}

In model:

function feeds($feeds_data)
{   
    $this->db->empty_table('feeds');   
    $this->db->insert_batch('feeds', $feeds_data);    
}

In view

 foreach($feeds as $f)
{
   echo "<a href='".$f["url"]."'>".$f["title"]."</a><br/>";
}

the url does not work. In the view when i click on one link it not redirect me on the site. — user3313651, Feb 22 '14 at 15:06
kumar_v. is there on_duplicate_key_update function for codeigniter? i want to insert only the row is not exists yet. And if the row exists i want to update it. — user3313651, Feb 23 '14 at 14:27
try this : http://stackoverflow.com/questions/3361490/how-would-i-use-on-duplicate-key-update-in-my-codeigniter-model — Kumar V, Feb 23 '14 at 14:57

how can i put xml files into database and after this retrieve them

1 Answers1