xml - Simplexml to database using php -
xml - Simplexml to database using php -
i using amazon api retrieve list of actors store in database. maintain getting duplicate entries , hoping help me out if possible.
here doing
$i = $result->items->item->itemattributes->actor; echo "actor :"; $alist = array(); foreach ($i $a) { $alist[] = $a; print_r($alist); }
and result.
array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) ) array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) [1] => simplexmlelement object ( [0] => john goodman ) ) array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) [1] => simplexmlelement object ( [0] => john goodman ) [2] => simplexmlelement object ( [0] => peter sarsgaard ) ) array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) [1] => simplexmlelement object ( [0] => john goodman ) [2] => simplexmlelement object ( [0] => peter sarsgaard ) [3] => simplexmlelement object ( [0] => kelly macdonald ) ) array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) [1] => simplexmlelement object ( [0] => john goodman ) [2] => simplexmlelement object ( [0] => peter sarsgaard ) [3] => simplexmlelement object ( [0] => kelly macdonald ) [4] => simplexmlelement object ( [0] => mary steenburgen ) )
any help appreciated.
cheers
move print_r() function outside of foreach loop
echo "actor :"; $alist = array(); foreach ($i $a) { $alist[] = $a; } print_r($alist);
your output grows each iteration
array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) ) array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) [1] => simplexmlelement object ( [0] => john goodman ) ) array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) [1] => simplexmlelement object ( [0] => john goodman ) [2] => simplexmlelement object ( [0] => peter sarsgaard ) ) array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) [1] => simplexmlelement object ( [0] => john goodman ) [2] => simplexmlelement object ( [0] => peter sarsgaard ) [3] => simplexmlelement object ( [0] => kelly macdonald ) ) array ( [0] => simplexmlelement object ( [0] => tommy lee jones ) [1] => simplexmlelement object ( [0] => john goodman ) [2] => simplexmlelement object ( [0] => peter sarsgaard ) [3] => simplexmlelement object ( [0] => kelly macdonald ) [4] => simplexmlelement object ( [0] => mary steenburgen ) )
you can find problems easier if format code/output better
php xml arrays amazon-web-services simplexml
Comments
Post a Comment