How to split string into three value using list?

Question

I have a query which concat the row value.

 GROUP_CONCAT(DISTINCT CONCAT(id, ' - ', name, ' - ', status) SEPARATOR ', ') AS id_name_status

I want to split it as id, name and status when in HTML. Sample code is as following

 @foreach($results as $r)
 <?php
 $id_name_status = explode(',',  $r->id_name_status);
 foreach ($id_name_status as $id) {
 // how can i split the string into 3 value and echo it?
 }
 ?>
 @endforeach

Why are you combining them if you're just going to split them? — Patrick Q
– Patrick Q, Commented Dec 13, 2017 at 15:00
So DONT concat them in the query, or leave the concat in the query BUT ADD the 3 seperate fields as well to your SELECT — RiggsFolly
– RiggsFolly, Commented Dec 13, 2017 at 15:03

Jerodev · Accepted Answer · 2017-12-13 15:19:08Z

2

You are concatenating the strings with - so you have to explode them with that character as well.

$id_name_status = explode(' - ',  $r->id_name_status);

Update:
You can also use the php list function to store the values directly into variables.

list($id, $name, $status) = explode(' - ',  $r->id_name_status);

edited Dec 13, 2017 at 15:19

answered Dec 13, 2017 at 15:00

Jerodev

33.3k11 gold badges96 silver badges114 bronze badges

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

3 Comments

RiggsFolly Over a year ago

Probably should be explode(' - ', $r->id_name_status); if you look closely

Crazy Over a year ago

i want store in list() instead of using explode to loop through the value?

Jerodev Over a year ago

You can do that, it's just a small update. I added an example.

Collectives™ on Stack Overflow

How to split string into three value using list?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related