Insert array in database |
HI i have this model :
Code: protected $allowedFields = ['id','id_categoria_lavorazione','nome','codice','menu_linea_implantare','scala_colori','numero_dente','quantita_elementi','prezzo_vendita_da_file','gg_lavorativi','created_at','updated_at','deleted_at']; scala_colori is type json in db this is the $post variable from form: Code: Array ( [id_categoria_lavorazione] => 32 [nome] => test [codice] => DM4CCSX [menu_linea_implantare] => SI [scala_colori] => Array ( [0] => 37 [1] => 39 [2] => 19 [3] => 3 ) [numero_dente] => 10 [quantita_elementi] => 15 [prezzo_vendita_da_file] => 20 [gg_lavorativi] => 1 ) i simpli do this is my error : $descrizione_lavorazione_model->save($post); Operand should contain 1 column(s) How can i insert the array into json field ? SOLVED: Code: $post['scala_colori'] = json_encode($post['scala_colori']); |
Messages In This Thread |
Insert array in database - by pippuccio76 - 09-03-2022, 08:09 AM
RE: Insert array in database - by InsiteFX - 09-04-2022, 12:46 AM
RE: Insert array in database - by pippuccio76 - 09-04-2022, 08:52 AM
RE: Insert array in database - by InsiteFX - 09-05-2022, 04:24 AM
RE: Insert array in database - by pippuccio76 - 09-05-2022, 04:59 AM
RE: Insert array in database - by InsiteFX - 09-06-2022, 12:20 AM
RE: Insert array in database - by pippuccio76 - 09-06-2022, 12:34 AM
|