Symfony - parse JSON to database

Question

So I return JSON data and now I need to parse data from image I provided so I can post it in my database.

I need to parse it so every letter-number combination (A1, A2, A3 etc.) can be in separate column row...

 public function generateSeats(SeatMap $seatMap)
{
    $layout = $seatMap->getSeatLayout();

    $layoutArray = json_decode($layout, true);

    foreach($layoutArray as $result)
    {
        dump($result);die;
        }

}

I don't know how to select every letter-number combination individually.

Sergej · Accepted Answer · 2018-10-17 13:48:41Z

2

It's not so complicated.

You need to do only two steps:

$result = 'A1A2A3_A4A5A6';

1) Remove the underscore sign _:

$result = str_replace('_', '', $result);
// Now $result is string 'A1A2A3A4A5A6'

2) Split the entire string by two characters long:

$result = str_split($result, 2);
// Now $result is array('A1', 'A2', 'A3', 'A4', 'A5', 'A6')

edited Oct 17, 2018 at 13:48

answered Oct 17, 2018 at 13:39

Sergej

2,2641 gold badge21 silver badges35 bronze badges

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

3 Comments

Jay Blanchard Over a year ago

While this code may answer the question, providing additional context regarding why and/or how this code answers the question improves its long-term value. A good answer will always have an explanation of what was done and why it was done in such a manner, not only for the OP but for future visitors to SO.

Sergej Over a year ago

Is it better now?

developsss Over a year ago

Thank you so much!

Nikhil Vartak · Accepted Answer · 2018-10-17 14:18:50Z

0

Sergej's answer definitely solves the problem and is useful. I have up-voted it too. However, it's still not capable of handling the following:

Invalid seat number pattern LetterNumber. Ex: 1A
Invalid sequence of seats. Ex: 1AA1A2A3A4A5A6AZ

If you go with simple regex and just consider the matched groups, you are saved from validating seat numbers further.

preg_match_all ('/[A-Za-z][0-9]/', '1AA1A2A3A4A5A6AZ', $matches);
print_r($matches); 
// output: Array([0]=>Array([0]=>A1[1]=>A2[2]=>A3[3]=> A4[4]=>A5[5]=>A6))

answered Oct 17, 2018 at 14:18

Nikhil Vartak

5,1473 gold badges29 silver badges36 bronze badges

3 Comments

developsss Over a year ago

So this definitely solves my problem. Thanks a lot! Just one question.. How can I make php to recognize second row to get B letter instead of A and so on?

Nikhil Vartak Over a year ago

you don't have to do that. Your API will return you the rows, thereafter it does not matter which row it is. Only the input (row seats) will change. Rest of it will be handled by regex. If I have not understood you, please show how API returns row wise data? Even if it returns A1A2B1B2, what's the problem?

developsss Over a year ago

I am satisfied with the solution you provided for me. Thank you.

Collectives™ on Stack Overflow

Symfony - parse JSON to database

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related