How to add item to mapping TABLE

Discuss MySQL Ajax Table Editor

How to add item to mapping TABLE

Postby Atara » Sun Dec 24, 2017 11:53 am

my TABLE myMap is mapping TABLE between cards and tags. it contains 3 rows:
    1. map_id (self index)
    2. card_id
    3. tag_id

I manage to display the needed items, using -

Code: Select all
      $tableColumns['map_tag_id'] = array(
         'display_text' => 'tag (ID->txt)',
         'perms' => 'ETVQSXO',
         'join' => array(
            'table' => 'tags',
            'column' => 'tag_id',
            'display_mask' => "concat(tags.tag_id, ' - ', tags.tag_title)",
            'type' => 'left',
         ),
         'input_info' => ' readonly="readonly" style="width: 30px; background-color: #cccccc;"' //,
      );


Now I want to "ADD", not just "View". suppose card_id is a parameter to the page. How can I add new row to myMap?

The prefered way is displaying all tag (tag_id + tag_title) , with checkbox.
The checkbox should be "selected" if there is a matched ROW in myMap TABLE.
can I do it using MATE?

Is there a better option to add rows to mapping TABLE?
Atara
 
Posts: 12
Joined: Wed Jul 26, 2017 9:01 am

Return to Open Discussion

Who is online

Users browsing this forum: Google [Bot] and 9 guests

cron