How to build a table where columns are equal to categories?

Question

Yii

Hello.
there are tables:
cat_table
Id
name
obj_table
Id
catId
option
count
Maybe someone has met with such a task, you need to make a table to add records to the database, but the columns themselves must be categories, for which I can change the properties and save all records in obj_table.

catId1         | catId2         | catId3
---------------|----------------|---------------
option | count | option | count | option | count

It is not clear how to do this, if an option was selected and a quantity was entered, then when saving, exactly the desired category was sent with what I chose, and if nothing was selected for other categories, they are simply ignored ... well, if it is selected in each, then three records are created.

Answer 1

the usual form, it contains inputs and selects of the form

<select name="catId1[option]">
<option value="1">1</option>
<option value="2">2</option>
</select>
<input type="text" name="catId1[value]">

Accordingly, you have an array of type in the controller:

[
catId1 => [option=> 3, value='петя'],
catId2 => [option=> 2, value='Бумбум'],
catId3 => [option=> 1, value='19'],
]

therefore, you iterate through foreach, checking the option and forming a query in the database

Answer 2

crosstab will help you .