How to give each field in an array its own variable

Vote count:

0

i'm working on a small text based web game for a few friends to play (for nostalgia) but i'm having trouble with the very core of the game, the attacking/defending.

Each player has x amount of each troop type (more can be purchased and will be lost on atk/def) so far I have a table with troop types and stats and a table with troop qty linked with user id and troop id.

I'm using the user id to get the troop id and qty using;

// Get attacker troop quantities.

$i = 0;
$attacker_deets = $conn->prepare("SELECT * FROM troop_qty WHERE user_id= :attacker_id");
$attacker_deets->bindParam(':attacker_id', $attacker_id);
$attacker_deets->execute();

    $attacker_deets_results = $attacker_deets->fetchAll(PDO::FETCH_ASSOC);
        foreach($attacker_deets_results as $atk_key=>$atk_result) {
             echo "<pre>"; var_dump($atk_result); echo "</pre>";
        }

which outputs;

array (size=4)
    'troop_qty_id' => string '1' (length=1)
    'user_id' => string '2' (length=1)
    'troop_id' => string '1' (length=1)
    'qty' => string '100' (length=3)

array (size=4)
    'troop_qty_id' => string '2' (length=1)
    'user_id' => string '2' (length=1)
    'troop_id' => string '2' (length=1)
    'qty' => string '100' (length=3)

I'm then using the troop id to get the troop details;

// get attacker troop details.

    $attacker_troop_deets = $conn->prepare("SELECT * FROM troops WHERE troop_id= :atk_troop_id");
    $attacker_troop_deets->bindParam(':atk_troop_id', $attacker_deets_results[$i]['troop_id']);
    $attacker_troop_deets->execute();
    $returned_results = $attacker_troop_deets->fetchAll(PDO::FETCH_ASSOC);
        foreach($returned_results as $key=>$result) {
             echo "<pre>"; var_dump($result); echo "</pre>";                
        }
    ++$i;

which in total gives me;

array (size=4)
  'troop_qty_id' => string '1' (length=1)
  'user_id' => string '2' (length=1)
  'troop_id' => string '1' (length=1)
  'qty' => string '100' (length=3)

array (size=4)
  'troop_id' => string '1' (length=1)
  'troop_name' => string 'Fist Puncher' (length=12)
  'troop_atk' => string '1' (length=1)
  'troop_def' => string '1' (length=1)

array (size=4)
  'troop_qty_id' => string '2' (length=1)
  'user_id' => string '2' (length=1)
  'troop_id' => string '2' (length=1)
  'qty' => string '100' (length=3)

array (size=4)
  'troop_id' => string '2' (length=1)
  'troop_name' => string 'Stick Waver' (length=11)
  'troop_atk' => string '2' (length=1)
  'troop_def' => string '1' (length=1)

Now where i'm stuck is I need to be able to compare the troop_atk of First Puncher with the defence of Stick Waver which is gotten from a different set of duplicate query's getting the defenders details, i also need to be able to multiply and divide the atk and def variables.

so how would i go about achieving this? i would assume i would need to give each field in the array their own variable, but how? i have tried using ${"troop_name" . $i} = $attacker_deets_results[$i]['troop_name']; but it only ever outputs the last entered name.

any help would be amazing. thanks.

asked 2 mins ago

Rath Baloth

58

How to give each field in an array its own variable