String concat in php

Question

I have a php script that returns a resultset from mysql database like that:

nombre_musico apellidos_musico

Rafael Ruda
Antonio Manuel Rios
Alejandro Astola

The source code to concat string of musicians:

while($fila = mysqli_fetch_object($result)){
            $apellido = str_replace("\r","",$fila->apellidos_musico);;
            $nombre = str_replace("\r","",$fila->nombre_musico);
            $musicos .= $nombre . " " . $apellido .",";
        }

the sql query is:

    $sql = "select gr.nombre_grupo, gr.anyo_creacion, gr.descripcion, ms.nombre_musico, ms.apellidos_musico\n"
    . "from musico ms, canta_para cp, grupo gr\n"
    . "where ms.id_musico = cp.musico_id and gr.id_grupo = cp.grupo_id and gr.nombre_grupo = '".$name_group."'";

and the code to execute the query is:

$result = mysqli_query($mysqli, $sql);

I want to obtain result like this:

"musicos":"Rafael Ruda,Antonio Manuel Rios,Alejandro Astola"

but the result I obtain is:

"Rafael Ruda,Antonio Manuel Rios,"

What I must do to obtain te correct concatenated string. I wonder for a little help as soon as possible.

Is the problem that you only get two names? Or is the problem that you want to see "musicos" : "..." — tbddeveloper
– tbddeveloper, Commented Aug 1, 2014 at 20:59
the problem is that i got two names instead of three the "musicos":"..." is a json property that returns the php script — ncr07
– ncr07, Commented Aug 1, 2014 at 22:16

catalinetu · Accepted Answer · 2014-08-01 21:04:12Z

1

this will return exactly the format you entered:

SELECT CONCAT('\"musicos\":',gr.nombre_grupo,', ',gr.anyo_creacion,', ',gr.descripcion,', ',ms.nombre_musico,', ',ms.apellidos_musico)

answered Aug 1, 2014 at 21:04

catalinetu

6606 silver badges12 bronze badges

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

1 Comment

ncr07 Over a year ago

That is not what i want. I want to concat the three names and assign it to an json object property which name is "musicos"

Collectives™ on Stack Overflow

String concat in php

nombre_musico apellidos_musico

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

nombre_musico apellidos_musico

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related