Welcome Guest, Not a member yet? Register   Sign In
How to parse an XML file from a url and add its data in a database?
#1

[eluser]GeorgiosK[/eluser]
I can parse an .xml file from a url but there are some complications.
The output it's not formatted so it's hard to read it and I am having a hard time to put the data in my database. The code is below...
Code:
$url='http://website.com/api/item.xml?type_ids=34,35&key=123456';
        $xmlstr = simplexml_load_file($url);  
        $data['ore_market']=print_r($xmlstr);
        $this->load->view('ore_marketeerview',$data);

I know that 'xmlrpc' library can help me parse the xml file but I don't know what to put in method().

Code:
$url='http://website.com/api/item.xml?type_ids=34,35&key=123456';
$this->xmlrpc->server($url, 80);
$this->xmlrpc->method(???);

And since I pass the parameters I want in $url do I need to specify something in $request?
Code:
$request = array('My Photoblog', 'http://www.my-site.com/photoblog/');

$this->xmlrpc->request($request);

Is there a library to help me manipulate the xml output afterwards and help me insert its data in a database?


Messages In This Thread
How to parse an XML file from a url and add its data in a database? - by El Forum - 08-25-2010, 01:53 AM



Theme © iAndrew 2016 - Forum software by © MyBB