current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Okay, so I'm writing an app that allows me to see steam data from a database of whoever registered.

I met a problem. Firstly, the steam API for multiple users is not standardized. (e.g. everytime you refresh this, the position of user changes (What kind of API does this?!)

Since steam does not standardize the API, I'll have to do it myself, so after doing a json_decode($url, true). It is not an assoc array.

I want to sort the assoc array by the steam ID (which is numeral) and match them against my own database of user (also contains steam ID, but can be sorted in the database), so how do I go about doing that?

E.g.

Array 1:

array(3) {
  [0]=>
  array(2) {
    ["steam_id32"]=>
    string(17) "76561198025035234"
    ["name"]=>
    string(7) "Mitsuki"
  }
  [1]=>
  array(2) {
    ["steam_id32"]=>
    string(17) "76561197968270056"
    ["name"]=>
    string(3) "nrn"
  }
  [2]=>
  array(2) {
    ["steam_id32"]=>
    string(17) "76561197982490298"
    ["name"]=>
    string(4) "Ximp"
  }
}

Array 2:

array(1) {
  ["response"]=>
  array(1) {
    ["players"]=>
    array(3) {
      [0]=>
      array(16) {
        ["steamid"]=>
        string(17) "76561197982490298"
        ["communityvisibilitystate"]=>
        int(3)
        ["profilestate"]=>
        int(1)
        ["personaname"]=>
        string(53) "……‮‮‮‮‮‮‮‮‮‮Ximp ……FUS RO DAH"
        ["lastlogoff"]=>
        int(1328569605)
        ["profileurl"]=>
        string(34) "http://steamcommunity.com/id/ximp/"
        ["avatar"]=>
        string(114) "http://media.steampowered.com/steamcommunity/public/images/avatars/f8/f8ee0cf00a2ec20417bf5b26b99fd6fb4dc176c1.jpg"
        ["avatarmedium"]=>
        string(121) "http://media.steampowered.com/steamcommunity/public/images/avatars/f8/f8ee0cf00a2ec20417bf5b26b99fd6fb4dc176c1_medium.jpg"
        ["avatarfull"]=>
        string(119) "http://media.steampowered.com/steamcommunity/public/images/avatars/f8/f8ee0cf00a2ec20417bf5b26b99fd6fb4dc176c1_full.jpg"
        ["personastate"]=>
        int(1)
        ["realname"]=>
        string(9) "I life in"
        ["primaryclanid"]=>
        string(18) "103582791430354400"
        ["timecreated"]=>
        int(1146939839)
        ["gameextrainfo"]=>
        string(20) "The Binding Of Isaac"
        ["gameid"]=>
        string(6) "113200"
        ["loccountrycode"]=>
        string(2) "DE"
      }
      [1]=>
      array(14) {
        ["steamid"]=>
        string(17) "76561197968270056"
        ["communityvisibilitystate"]=>
        int(3)
        ["profilestate"]=>
        int(1)
        ["personaname"]=>
        string(3) "nrn"
        ["lastlogoff"]=>
        int(1328618220)
        ["profileurl"]=>
        string(34) "http://steamcommunity.com/id/nrnx/"
        ["avatar"]=>
        string(114) "http://media.steampowered.com/steamcommunity/public/images/avatars/50/50b908e0aa2c730fa0f68ab0afc8b04fddb133f1.jpg"
        ["avatarmedium"]=>
        string(121) "http://media.steampowered.com/steamcommunity/public/images/avatars/50/50b908e0aa2c730fa0f68ab0afc8b04fddb133f1_medium.jpg"
        ["avatarfull"]=>
        string(119) "http://media.steampowered.com/steamcommunity/public/images/avatars/50/50b908e0aa2c730fa0f68ab0afc8b04fddb133f1_full.jpg"
        ["personastate"]=>
        int(1)
        ["realname"]=>
        string(9) "Nathaniel"
        ["primaryclanid"]=>
        string(18) "103582791432850562"
        ["timecreated"]=>
        int(1092771678)
        ["loccountrycode"]=>
        string(2) "US"
      }
      [2]=>
      array(14) {
        ["steamid"]=>
        string(17) "76561198025035234"
        ["communityvisibilitystate"]=>
        int(3)
        ["profilestate"]=>
        int(1)
        ["personaname"]=>
        string(23) "[ProudiA] Mitsuki Sakai"
        ["lastlogoff"]=>
        int(1328621807)
        ["commentpermission"]=>
        int(1)
        ["profileurl"]=>
        string(42) "http://steamcommunity.com/id/mitsukisakai/"
        ["avatar"]=>
        string(114) "http://media.steampowered.com/steamcommunity/public/images/avatars/9d/9d279f349422cbbed55adf1c8eabb0924ea0a719.jpg"
        ["avatarmedium"]=>
        string(121) "http://media.steampowered.com/steamcommunity/public/images/avatars/9d/9d279f349422cbbed55adf1c8eabb0924ea0a719_medium.jpg"
        ["avatarfull"]=>
        string(119) "http://media.steampowered.com/steamcommunity/public/images/avatars/9d/9d279f349422cbbed55adf1c8eabb0924ea0a719_full.jpg"
        ["personastate"]=>
        int(1)
        ["realname"]=>
        string(12) "酒井å‚è¼"
        ["primaryclanid"]=>
        string(18) "103582791432752089"
        ["timecreated"]=>
        int(1273714689)
      }
    }
  }
}
share|improve this question
    
"(What kind of API does this?!)" -- you're getting back an object, not an array. Objects in JSON are not inherently ordered. –  Interrobang Feb 7 '12 at 17:42
    
Ah I see, but shouldn't it at least be in order of how I called the API? –  Omfgitsasalmon Feb 7 '12 at 17:49
    
It's not clear what do you want to achieve: if you just want to compare/match the entries against the data in your DB - do it using the IDs - why does the order matter ? If it's for display purposes (and then the order is indeed important) - you can save the IDs into a data structure while you preform the matching/comparing of the info against your DB - then select all the relevant entries from your DB (with the saved IDs) and use "order by". –  alfasin Feb 7 '12 at 17:51

1 Answer 1

up vote -1 down vote

For sortig array you can find a list of all function that you need here

Update:

first you must create a 1d array from a 2d or 3d you can use this code to make an easy access array and sortable (this an example): 

<?php
$inArr;//This is the 2D array
$outArr = array();
for($i=0;$i<count($inArr);$i++){
   $outArr[$i] = $inArr[$i][0];
?>

then you can sort it with ksort() or krsort() function.and for adding an array to another :

<?php
  $stack = array("value1", "value2");
  array_push($stack, "value3", "value4");
  print_r($stack);
?>
share|improve this answer
    
He wants to sort the array by a key that is in an array in the element. This doesn't solve his problem. –  thenetimp Feb 7 '12 at 17:43
    
@thenetimp first read the php.net/manual/en/array.sorting.php exactly then give -1.pay more attention please –  bizzr3 Feb 7 '12 at 17:45
    
@thenetimp for example : http://www.php.net/manual/en/function.krsort.php or http://www.php.net/manual/en/function.ksort.php –  bizzr3 Feb 7 '12 at 17:49
    
Hi bizzare, I read through the array.sorting, but I ended up having a headache, could you please point me to which sorting I should use? Thanks! –  Omfgitsasalmon Feb 7 '12 at 17:49
    
@Omfgitsasalmon krsort() or ksort() –  bizzr3 Feb 7 '12 at 17:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.