将php数组保存到mariadb动态列

Question

I have an array like this

   $test = array(
        'Subscription' => '1',
        'Streaming' => '1',
        'Download' =>  '0'
    )

so during updating to mariaDB

  $query = 'UPDATE table_1 set category_dynamic = COLUMN_CREATE(' . $test . ') where id = 1';
  $this->Model->query($query);

I want to save the array this way ('Subscription',1,'Streaming',1,'Download',0)

any suggestion ?

Answer 1

You can try this :

<?php

$test = array(
        'Subscription' => '1',
        'Streaming' => '1',
        'Download' =>  '0'
);

$data = '';
foreach($test as $key=>$value)
{
    $data .= '"'.$key.'"'.', '.$value.', ';
}

$data = rtrim($data,', ');

$query = 'UPDATE table_1 set category_dynamic = COLUMN_CREATE(' . $data . ') where id = 1';

Hope it will solve the problem.