PHP Serialized Data output inside foreach loop

Question

I've been stuck on this for like 2 days, and I know it's much more simpler than I think it is..

I have a foreach loop that goes like this.

foreach($appointments as $appointment){
  
  $list = $appointment['techs']

}

The $appointment['techs']; comes out of the database like this.

a:2:{i:0;s:1:"1";i:1;s:2:"12";}

My question is, how to I get loop through appointments and then show the users that are assigned to each appointment...

The desired output should look like this,

{ resource : 1, event : 1},{ resource : 12, event : 1}

I've literally tried everything! Any help would be greatly appreciated.

So you have determined that you have a serialized string. Have you tried unserializing it and then using the array to get the output you want? — El_Vanja
– El_Vanja, Commented Mar 3, 2021 at 11:21
“I've literally tried everything!” - please STOP stating stuff like this. First of all, you obviously haven’t, and second, this is not helpful at all. Show us what exactly you tried, and give us a proper problem description along with it. — C3roe
– C3roe, Commented Mar 3, 2021 at 12:12
@CBroe I didn't want to clutter up my question with all my mistakes, are you saying that the StackOverflow Community would prefer I do that, or is it something that you personally prefer? — Brandon Broga
– Brandon Broga, Commented Mar 4, 2021 at 17:10
stackoverflow.com/help/how-to-ask: “Explain how you encountered the problem you're trying to solve, and any difficulties that have prevented you from solving it yourself.”, “Not all questions benefit from including code, but if your problem is with code you've written, you should include some.” — C3roe
– C3roe, Commented Mar 5, 2021 at 7:16

Mariano · Accepted Answer · 2021-03-03 11:58:42Z

1

$array = [];
$string = 'a:2:{i:0;s:1:"1";i:1;s:2:"12";}';
$arr = (unserialize($string));

foreach ($arr as $item){
    array_push($array, json_encode(['resource'=> $item, 'event'=>1]));
}

$i = 0;
$numItems = count($array);

foreach ($array as $item) {
    if (++$i === $numItems) {
        echo $item;
    }
    else{
        echo $item.',';
    }
}
// Output: {"resource":"1","event":1},{"resource":"12","event":1}

edited Mar 3, 2021 at 11:58

answered Mar 3, 2021 at 11:19

Mariano

4553 silver badges13 bronze badges

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

2 Comments

Brandon Broga Over a year ago

This is how it's coming out... ["{\"resource\":\"1\",\"event\":1}","{\"resource\":\"12\",\"event\":1}"]["{\"resource\":\"1\",\"event\":1}","{\"resource\":\"12\",\"event\":1}"]["{\"resource\":\"1\",\"event\":1}","{\"resource\":\"12\",\"event\":1}" how I can I get like this. { resource : 1, event : 1},{ resource : 12, event : 1},{ resource : 1, event : 1},{ resource : 12, event : 1},{ resource : 1, event : 1},{ resource : 12, event : 1},

Brandon Broga Over a year ago

So the output is actually inside the appointments loop. I'm getting this back "{\"resource\":\"1\",\"event\":1}","{\"resource\":\"12\",\"event\":1}"] for each appointment. How can I get it to output without the [] and the \ slashes?

Jimmy · Accepted Answer · 2021-03-03 11:26:56Z

0

The PHP command unserialize it's what you are looking for.

foreach($appointments as $appointment){
  
  $list = unserialize($appointment['techs']);

}

answered Mar 3, 2021 at 11:26

Jimmy

1,1841 gold badge10 silver badges21 bronze badges

1 Comment

Brandon Broga Over a year ago

Hi Jimmy, thank you for your reply, but I'm trying to foreach the serialized data inside of the foreach and output it like this..... { resource : 1, event : 1},{ resource : 12, event : 1}

Collectives™ on Stack Overflow

PHP Serialized Data output inside foreach loop

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related