PHP Json output formatting

Question

I am parsing Json using PHP. Here is a small part of my code

  $rootObj = array(
  'MainEvent' => $event_value['MainEvent'],
   'OutcomeDateTime' => $formatteddate->format('Y-m-d H:i:s'),                       
   'OutcomeDateTimeUTC' => gmdate('Y-m-d H:i:s', strtotime($event_value['OutcomeDateTime']))
                        );

  foreach($event_value['Competitors']['Competitors'] as $compKey => $compVal) {
  $countTeam++;
  $teamName = array_key_exists('Team',$compVal) ? $compVal['Team'] :  $compVal['Name'];
  $win = $compVal['Win'];

    //Insert to root object
    $rootObj["Team".$countTeam] = $teamName;
    $rootObj["Win".$countTeam] = $win;

My output is

"MainEvent": "West Perth v Swan Districts",
  "OutcomeDateTime": "2014-07-05 16:05:00",
   "OutcomeDateTimeUTC": "2014-07-05 06:05:00",

      "Team1": "West Perth",
      "Win1": "1.57",

      "Team2": "Swan Districts",
      "Win2": "2.35"


},
{
  "MainEvent": "East Fremantle v Perth",
  "OutcomeDateTime": "2014-07-05 16:05:00",
   "OutcomeDateTimeUTC": "2014-07-05 06:05:00",

      "Team1": "East Fremantle",
      "Win1": "1.22",

      "Team2": "Perth",
      "Win2": "4.15"
},
{
  "MainEvent": "East Perth v Peel Thunder",
  "OutcomeDateTime": "2014-07-05 16:05:00",
   "OutcomeDateTimeUTC": "2014-07-05 06:05:00",

      "Team1": "East Perth",
      "Win1": "1.12",

      "Team2": "Peel Thunder",
      "Win2": "6.00"
}

But instead of Team1 , Win 1, Team 2, Win2 i want Team A, Win A like that. I just want to use alphabets A, B rather than 1, 2.

"MainEvent": "West Perth v Swan Districts",
  "OutcomeDateTime": "2014-07-05 16:05:00",
   "OutcomeDateTimeUTC": "2014-07-05 06:05:00",

      "TeamA": "West Perth",
      "WinA": "1.57",

      "TeamB": "Swan Districts",
      "WinB": "2.35"


},
{
  "MainEvent": "East Fremantle v Perth",
  "OutcomeDateTime": "2014-07-05 16:05:00",
   "OutcomeDateTimeUTC": "2014-07-05 06:05:00",

      "TeamA": "East Fremantle",
      "WinA": "1.22",

      "TeamB": "Perth",
      "WinB": "4.15"
},
{
  "MainEvent": "East Perth v Peel Thunder",
  "OutcomeDateTime": "2014-07-05 16:05:00",
   "OutcomeDateTimeUTC": "2014-07-05 06:05:00",

      "TeamA": "East Perth",
      "WinA": "1.12",

      "TeamB": "Peel Thunder",
      "WinB": "6.00"
}

Can anyone tell me what i am missing??

Well make a 26 array object and replace with the index of values.But i can't categorized why you want this facility? — Just code
– Just code, Commented Jul 7, 2014 at 2:43

meda · Accepted Answer · 2014-07-08 03:48:17Z

1

Before you enter the for loop , initialize $countTeam to A:

$countTeam = "A";

and move $countTeam++; to the end of the for loop.

edited Jul 8, 2014 at 3:48

answered Jul 7, 2014 at 2:44

meda

45.5k14 gold badges96 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3754380 Over a year ago

actually I am getting TeamB,TeamC not TeamA, TeamB. Because counter is ++ so it is printing B,C. Is there anything like 0 in integers so that it prints 1,2

meda Over a year ago

@user3754380 oh you should move $countTeam++; to the last line of the loop

Collectives™ on Stack Overflow

PHP Json output formatting

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related