php - 在 PHP CodeIgniter foreach 循环中从数据库中提取和更新数据

Question

我有一个 View ，其中包含通过 foreach 循环从数据库中显示的数据，我想要的是获取从 View 中编辑的数据并在数据库中逐个更新它，但问题是数据库如果有 where 子句，将被更新，但在我的情况下，我不知道如何从 View 获取 key (tid)到 Controller 这里是显示数据的 Controller 函数

public function bulk()
{

    $pid = '';
    if($this->input->post('pid'))
        $pid = $this->input->post('pid');


    $template['menu'] = $this->shared_model->get_flightmenus();

    if($pid == '')
    {
        if($this->uri->segment(3))
            $pid = $this->uri->segment(3);
        else
            $pid = $template['menu'][0]['tid'];
    }

    $template['pid'] = $pid;

    // echo $pid;
    // exit();

    $template['airline'] = $this->shared_model->get_records('eat_airline');
    $template['terminal'] = $this->shared_model->get_records('eat_terminal');

    $template['data'] = $this->shared_model->get_recordbyvalue('eat_flight','menu_tid = '.$pid);

    $template['main_content'] = $this->load->view('flight/flight_bulk_view', $template, true);
    $this->load->view('includes/template', $template);



}

这是风景

    <h4><?php echo anchor('login/logout', 'Logout'); ?></h4>
<?php echo anchor('/home', 'Home'); ?>/Flights
<h2>Flights</h2>
    <div>
    <?php echo form_open('/flight/') ?>
    <?php foreach($menu as $row){ $options[$row['tid']] = $row['m_name']; } ?>
    <?php $js = 'name="pid" id="pid" onChange="this.form.submit();"'; ?>
    <?php echo form_dropdown('pid', $options, $pid, $js); ?>
    <?php echo form_close(); ?>
    </div>
<?php echo anchor('/flight/display/1/0/'.$pid, 'Create'); ?>
<?php echo anchor('flight/bulk', 'Bulk Update'); ?>
<table>
    <tr>
        <td>
            Name
        </td>
        <td>
            Airline
        </td>
        <td>
            From
        </td>
        <td>
            Stopover
        </td>
        <td>
            Destination
        </td>
        <td>
            Price
        </td>
        <td>
            Unit
        </td>
        <td>
            Tax
        </td>
        <td>
            Protection
        </td>
        <td>
            Fare
        </td>
        <td>
            Week Offer
        </td>
        <td>
            Menu
        </td>
        <td>
            Sort
        </td>
        <td>
            Edit
        </td>
        <td>
            Delete
        </td>
    </tr>
    <?php foreach($data as $row){ ?>
    <tr>
        <td>
            <?php echo $row['f_name'] ?>
        </td>
        <td>
            <?php $options1[0] = ''; foreach($airline as $row1){ $options[$row1['tid']] = $row1['a_name']; } ?>
            <?php echo $options[$row['airline_tid']]; ?>
        </td>
        <td>
            <?php $options1[0] = ''; foreach($terminal as $row1){ $options[$row1['tid']] = $row1['t_name']; } ?>
            <?php echo $options[$row['terminal_from_tid']]; ?>
        </td>
        <td>
            <?php echo $row['t_stopover'] ?>
        </td>
        <td>
            <?php $options1[0] = ''; foreach($terminal as $row1){ $options[$row1['tid']] = $row1['t_name']; } ?>
            <?php echo $options[$row['terminal_destination_tid']]; ?>
        </td>

        <td>
            <?php echo $row['f_price'] ?>
        </td>
        <td>
            <?php echo $row['f_unit'] ?>
        </td>
        <td>
            <?php if($row['f_tax']>0) echo  'Yes'; else echo 'No'; ?>
        </td>
        <td>
            <?php echo $row['f_protection'] ?>
        </td>
        <td>
            <?php echo $row['f_fare'] ?>
        </td>
        <td>
            <?php if($row['f_weekoffer']>0) echo  'Yes'; else echo 'No'; ?>
        </td>
        <!--
        <td>
            <?php $options[0] = ''; foreach($menu as $row1){ $options[$row1['tid']] = $row1['m_name']; } ?>
            <?php echo $options[$row['menu_tid']]; ?>
        </td>
        -->
        <td>
            <?php echo $row['sortindex'] ?>
        </td>
        <td>
            <?php echo anchor('flight/display/2/'.$row['tid'].'/'.$pid, 'Edit'); ?>
        </td>
        <td>
            <?php echo anchor('flight/display/3/'.$row['tid'].'/'.$pid, 'Delete'); ?>
        </td>
    </tr>
    <?php } ?>
</table>

我无法想出如何完成它的逻辑

any help will be appreciated

Answer 1

我所看到的只是您想将数据从 View 传递到 Controller ，您可以通过将数据传递到 url 然后从 Controller 使用它以供将来使用。