Convert array to implode value using ci

Question

I have been getting value array and convert implode value comma separate ?

Model:

$result = $db2->query('SELECT tests FROM dpr_save_labtest where appointment_id = "8618204"');
            $data = $result->result_array();
            $res = implode(',', $data); 
            return $data;

Controller:

public function investigation_print_data()
    {
        $data = $this->doctor_health_model->investigation_print_data();
        echo json_encode($data);
        

    }

Array value:

Array
(
    [0] => Array
        (
            [tests] => COMPLETE HAEMOGRAM
        )

    [1] => Array
        (
            [tests] => CRP QUANTITATIVE
        )

)

View json print value:

'+res2[0]['tests']+'

Result:

RHEUMATOID FACTOR

I need this value:

RHEUMATOID FACTOR,CREATININE

Markus Zeller · Accepted Answer · 2021-01-02 12:01:03Z

1

When there is only one field in the SELECT, an implode does nothing. You need to collect the data and then return the imploded data.

$result = $db2->query('SELECT tests FROM dpr_save_labtest where appointment_id = "8618204"');
$tests = [];
while($data = $result->result_array()) {
    $tests[] = $data['tests'];
}
return implode(',', $tests);

answered Jan 2, 2021 at 12:01

Markus Zeller

9,2432 gold badges34 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Convert array to implode value using ci

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related