如何在PHP条件下连接字符串？

Question

I wrote query in php file ,my query is:

$query = "SELECT cc.NAME complex_check_name,f.name server_name,
                sgk.NAME single_check_name,cc.operator 
          FROM complex_check cc, 
               lnksinglechecktocomplexcheck lk,
               single_checks sgk,
               functionalci f ,
               lnkconfigurationitemtosinglecheck lkcg 
           WHERE cc.id = lk.complex_check_id AND 
                 sgk.id = lk.single_check_id and 
                 sgk.id = lkcg.single_check_id AND 
                 lkcg.config_item_id = f.id ";

if ($result=mysqli_query($link,$query))
{
    while ($obj=mysqli_fetch_object($result))
    {
       $list= $obj->complex_check_name . 
              "@".
              $obj->server_name .
              ";". 
              $obj->single_check_name . 
              $obj-> operator;

        echo  $list .'<br>'; 
    }
 }

The result is :

test_com_check_sep01@INFRASEP01;cpu check sep01&
test_com_check_sep01@INFRASEP01;DB check sep01&
test_com_check_sep01@INFRASEP01;disk space check sep01&
test_com_check_sep02@INFRASEP02;cpu check sep02||
test_com_check_sep02@INFRASEP02;db check sep02||
test_com_check_sep02@INFRASEP02;disk space check sep02||

How can I concatenate the string as:

"test_com_check_sep01=INFRASEP01;cpu check sep01&INFRASEP01;DBcheck sep01&INFRASEP01;disk space check sep01"

"test_com_check_sep02=INFRASEP02;cpu check sep02||INFRASEP02;db check sep02||INFRASEP02;disk space check sep02"

Answer 1

You could store the values into an array and implode afterwards.

$check  =   array();
if($result = mysqli_query($link,$query)) {
        while($obj = mysqli_fetch_object($result)) {
            // If value is not stored in check array proceed
            if(!in_array($obj->complex_check_name,$check))
                $list[$obj->complex_check_name][]   =   $obj->complex_check_name."=";

            $list[$obj->complex_check_name][]   =   $obj->server_name.";".$obj->single_check_name.$obj->operator;

            // Store in check array
            $check[]    =   $obj->complex_check_name;
        }

    // Loop through stored rows and implode with break
    foreach($list as $array) {
            echo implode("<br />",$array);
        }
 }