duandai2178
2018-09-27 13:55
浏览 33
已采纳

CakePHP 3.6.11:将选定值从下拉列表存储到数据库

I have these 3 tables:

customers:

customerstable

services:

servicestable

customerservices:

customerservicestable

With this relation in CustomerservicesTable.php:

$this->belongsTo('Customers')
            ->setForeignKey('customerid');

$this->belongsTo('Services')
            ->setForeignKey('serviceid');

In Template\Customerservices\add.ctp I have a form with a dropdown and a numeric field :

<div class="customerservices form large-9 medium-8 columns content">
    <?= $this->Form->create($customerservice) ?>
    <fieldset>
        <legend><?= __('Add transaction') ?></legend>
        <?php
            echo $this->Form->input('Transaction type',array('options' => $servicesList));
            echo $this->Form->control('price');
        ?>
    </fieldset>
    <?= $this->Form->button(__('Submit')) ?>
    <?= $this->Form->end() ?>
</div>

in Controller\CustomerservicesController.php :

public function add($customerid = null)
    {

        $customerservice = $this->Customerservices->newEntity();
        if ($this->request->is('post')) {
            $customerservice->customerid = $customerid;
            $customerservice->serviceid = //get selection from dropdown
            if ($this->Customerservices->save($customerservice)) {
                $this->Flash->success(__('The customerservice has been saved.'));

                return $this->redirect(['action' => 'index']);
            }
            $this->Flash->error(__('The customerservice could not be saved. Please, try again.'));
        }
        $this->set(compact('customerservice'));

        $servicesList = TableRegistry::getTableLocator()->get('Services')->find('list');
        $this->set(compact('servicesList'));
    }

How can I replace the comment in order to save the serviceid which is selected in the dropdown control?

(secondary question is it possible to hide the price field depending on the dropdown selection?)

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • download12749 2018-09-27 14:43
    已采纳

    Just like I told you couple of minutes ago.

    Change the input like this:

    echo $this->Form->input('transaction_type',array('type'=>'select','options' => $servicesList));
    

    In your Controller:

    public function add($customerid = null)
    {
        …
        $customerservice->serviceid = $this->request->getData('transaction_type');
        …
    }
    

    Hiding the price field depending on the selection in the dropdown seems like a job for the client side, which can be done with JavaScript. For example in jQuery:

    $('#transaction_type').on('change', function() {
        // hide element with ID #price if value of select with ID #transaction_type is `holymoly`
        // and show element if value is anything else
        $('#price').toggle(this.value === 'holymoly');
    }); 
    
    已采纳该答案
    打赏 评论

相关推荐 更多相似问题