EVE Technology Lab

I am trying to make a php script that pulls corp assets from API and lists them in location - item - type - quantity table format in html table. I got it to the point where it is working except the locationID is listed just once per location rather than per line. Just as it is in the XML pulled from API.

var_dump($assets) shows all XML data is in the array.

Please help to point me in the right direction, where did I go wrong? I think I may have messed up the foreach somehow but I cannot figure it out. I have been at it out for days, thanks a lot for your help in advance!

-VH

Current result:
locationID - itemId - typeID - quantity
xxx - xyx - yxx - xxy
------zxx - xzx - xxz
------yzx - xyz - zyx

yyy - yxz - xyx - yyx
------zzx - xxx - xzz
------yxz - yzz - zzz


Needed result:
locationID - itemId - typeID - quantity
xxx xyx yxx xxy
xxx zxx xzx xxz
xxx yzx xyz zyx

yyy yxz xyx yyx
yyy zzx xxx xzz
yyy yxz yzz zzz


Here is my PHP code:

// Request API from server and create array from returned XML

$keyID="some key";
$vcode="some vcode";
$characterID="some char id";
$url = "https://api.eveonline.com/corp/AssetList.xml.aspx?keyID=".$keyID."&vcode=".$vcode."&characterID=".$characterID."";
//echo ($url);

//Get all assets from API
$data = file_get_contents($url);
$xml = new SimpleXMLElement($data);
$result = $xml -> xpath ('//row[@*] | //rowset/row[@*]');
foreach ($result as $row) {

//Create assocciative array $assets
$assets[] = array ('locationID' => $row['locationID'],
'itemID' => $row['itemID'],
'typeID' => $row['typeID'],
'quantity' => $row['quantity'],
);
}

require_once ($_SERVER["DOCUMENT_ROOT"]."/assetlist_corpassets.html.php");


This is the require_once ($_SERVER["DOCUMENT_ROOT"]."/assetlist_corpassets.html.php"); from above edited to remove html and php tags for this post.

php echo "STATION ID"
php echo "ITEM ID"
php echo "ITEM NAME"
echo "QUANTITY"

foreach ($result as $row)
echo ($row['locationID'])
echo ($row['itemID'])
echo ($row['typeID'])
echo ($row['quantity'])
php endforeach

Work fine like this (ok ok it's a double loop, but work fine :) )

Using the libraries should not be depending on the isp, it's basically just php code.

If I may...need a bit more help. I am on the next part of the project now. This one is with Eve-Central. Here is the code below. I am stuck at the point where I cannot figure out how to join the type ids to the actual names to the individual type ids printed out in real names, if that makes sense lol. This code works except there are no real names of the types that print. array_merge did not seem to help as I was not able to iterate through $merged_array correctly.

@Steve. Your article was a starting point. Thanks, that was great!. https://www.fuzzwork.co.uk/2013/05/06/using-the-eve-central-api-with-php/

Thanks for any help guys and Merry Xmas!


$type = array(18, 19, 20, 21, 34, 35, 36, 37, 38, 39, 40,
1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232,
17425, 17426, 17428, 17429, 17432, 17433, 17436, 17437, 17440,
17441, 17444, 17445, 17448, 17449, 17452, 17453, 17455, 17456,
17459, 17460, 17463, 17464, 17466, 17467, 17470, 17471,
17865, 17866, 17867, 17868, 17869, 17870, 11396, 11399);


$url="http://api.eve-central.com/api/marketstat?regionlimit=10000032&typeid=".join('&typeid=',$type);
$data=file_get_contents($url);
$xml = simplexml_load_string($data);

foreach($xml->marketstat->type as $d) {
$prices[] = array (' 'sellavgap' => $d->sell->avg,
'sellmaxap' => $d->sell->max,
'sellminap' => $d->sell->min,
'buyavgap' => $d->buy->avg,
'buymaxap' => $d->buy->max,
'buyminap' => $d->buy->min,
);

foreach($d as $n) { //I realize this is wrong. I suppose this is where I got stuck from.
$names[] =array('Plagioclase' => $n['Plagioclase'],
'Spodumain' =>$n['Spodumaain'],
'Kernite' =>$n['Kernite'],
'Hedbergite' =>$n['Hedbergite'],
'Tritanium' =>$n['Tritanium'],);


echo "ORE NAME"
echo "SELL AVERAGE"
echo "SELL MAXIMUM"
echo "SELL MINIMUM"
echo "BUY AVERAGE"
echo "BUY MAXIMUM"
echo "BUY MINIMUM"

php foreach($prices as $k => $v):

echo ($names);
echo ($v['sellavgap'])
echo ($v['sellmaxap'])
echo ($v['sellminap'])
echo ($v['buyavgap'])
echo ($v['buymaxap'])
echo ($v['buyminap'])

php endforeach

Thanks! Got it working.
-VH