php - 如何从表中选择和编辑codeIgniter中的信息

我正在使用Codeigniter构建一个应用程序，目前在该应用程序中，我可以搜索数据库表并在应用程序中生成一个显示结果的表。对我来说，下一步就是能够在应用程序搜索结果表中选择一行，然后将我重定向到可以编辑信息的表单。我想知道我该怎么做。下面，我将为您提供生成表的代码。如果需要更多代码或信息，请告诉我。

foreach ($query as $row){
    $this->table->add_row($row);

}
echo $this->table->generate();

更新资料

控制器

public function search(){
    $this->load->model('reg_model');

    $search_term = array(
    'firstName' => $this->input->post('firstName'),
    'lastName' => $this->input->post('lastName'),
    'street' => $this->input->post('street'),
    'dob' => $this->input->post('dob')
        );


    $data['query'] = $this->reg_model->search_voters($search_term);


    $this->load->view("reg_header");
    $this->load->view("reg_nav");
    $this->load->view("reg_search", $data);
}


public function add(){

    $this->load->view("reg_header");
    $this->load->view("reg_nav");
    $this->load->view("reg_form");
}

public function send(){

    $this->load->library("form_validation");

    $this->form_validation->set_rules("firstName", "First Name", "required");
    $this->form_validation->set_rules("lastName", "Last Name", "required");
    $this->form_validation->set_rules("homeNum", "Home Number", "required");
    $this->form_validation->set_rules("street", "Street", "required");
    $this->form_validation->set_rules("zip", "Zip Code", "required");
    $this->form_validation->set_rules("dob", "Date of Birth", 'trim|required|valid_date[d/m/y,/]');
    $this->form_validation->set_rules("district", "District", "required");

    //add to database
    if ($this->form_validation->run() == FALSE){
        $this->load->view("reg_header");
        $this->load->view("reg_nav");
        $this->load->view("reg_form");

    }
    else{



        $this->load->model('reg_model');
        $this->reg_model->add_voters();


        redirect(current_url());


    }

    }
    function edit_voterS($voterNum) {
    $voter = $this->reg_model->get_voter($voterNum);

    $this->data['title'] = 'Edit Voter';

    //validate form input
    $this->load->library("form_validation");

    $this->form_validation->set_rules("firstName", "First Name", "required");
    $this->form_validation->set_rules("lastName", "Last Name", "required");
    $this->form_validation->set_rules("homeNum", "Home Number", "required");
    $this->form_validation->set_rules("street", "Street", "required");
    $this->form_validation->set_rules("zip", "Zip Code", "required");
    $this->form_validation->set_rules("dob", "Date of Birth", 'trim|required|valid_date[d/m/y,/]');
    $this->form_validation->set_rules("district", "District", "required");

    if (isset($_POST) && !empty($_POST))
    {
        $data = array(
            'firstName' => $this->input->post('firstName'),
            'lastName' => $this->input->post('lastName'),
            'midInitial' => $this->input->post('midInitial'),
            'homeNum' => $this->input->post('homeNum'),
            'street' => $this->input->post('street'),
            'apt' => $this->input->post('apt'),
            'zip' => $this->input->post('zip'),
            'dob' => $this->input->post('dob'),
            'district' => $this->input->post('district')
        );

        if ($this->form_validation->run() === true)
        {
            $this->reg_model->update_voter($voterNum, $data);

            $this->session->set_flashdata('message', "<p>voter updated successfully.</p>");

            redirect(base_url().'reg/search/'.$voterNum);
        }
    }

    $this->data['message'] = (validation_errors() ? validation_errors() : $this->session->flashdata('message'));

    $this->data['voter'] = $voter;

    //display the edit product form
    $this->data['firstName'] = array(
        'name'      => 'firstName',
        'id'        => 'firstName',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('firstName', $voter['firstName'])
    );

    $this->data['lastName'] = array(
        'name'      => 'lastName',
        'id'        => 'lastName',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('lastName', $voter['lastName'])
    );

    $this->data['midInitial'] = array(
        'name'      => 'midInitial',
        'id'        => 'midInitial',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('midInitial', $voter['firstName'])
        );

    $this->data['homeNum'] = array(
        'name'      => 'homeNum',
        'id'        => 'homeNum',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('homeNum', $voter['homeNum'])
        );


    $this->data['street'] = array(
        'name'      => 'street',
        'id'        => 'street',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('street', $voter['street'])
    );

    $this->data['apt'] = array(
        'name'      => 'apt',
        'id'        => 'apt',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('apt', $voter['apt'])
    );

    $this->data['zip'] = array(
        'name'      => 'zip',
        'id'        => 'zip',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('zip', $voter['zip'])
    );

    $this->data['dob'] = array(
        'name'      => 'dob',
        'id'        => 'dob',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('dob', $voter['dob'])
    );

    $this->data['district'] = array(
        'name'      => 'district',
        'id'        => 'district',
        'type'      => 'text',
        'value'     => $this->form_validation->set_value('district', $voter['district'])
    );


    $this->load->view('edit_form', $this->data);
}
    function delete_voter($voterNum) {
    $this->reg_model->del_voter($voterNum);

    $this->session->set_flashdata('message', '<p>Product were successfully deleted!</p>');

    redirect('reg/search');
}

模型：

public function search_voters($search_term){
   $this->db->select('*');
   $this->db->from('voterinfo');
   $this->db->like('firstName', $search_term['firstName']);
   $this->db->like('lastName', $search_term['lastName']);
   $this->db->like('street', $search_term['street']);
   $this->db->like('dob', $search_term['dob']);
   $query = $this->db->get();
   return $query->result_array(); }

public function get_voter($voterNum) {
    $this->db->select('*');
    $this->db->where('voterNum', $voterNum);
    $query = $this->db->get('voterinfo');

    return $query->row_array();
}

public function update_voter($voterNum, $data)
{
    $this->db->where('voterNum', $voterNum);
    $this->db->update('voter', $data);
}

public function del_voter($voterNum)
{
    $this->db->where('voterNum', $voterNum);
    $this->db->delete('voter');
}

搜索视图：

echo form_open("reg/search");

echo form_label("First Name: ", "firstName");

$data = array(
    "name" => "firstName",
    "id" => "firstName",
    "value" => set_value("firstName")
);
echo form_input($data);

echo form_label("Last Name: ", "lastName");

$data = array(
    "name" => "lastName",
    "id" => "lastName",
    "value" => set_value("lastName")
);
echo form_input($data);

echo form_label("Street: ", "street");

$data = array(
    "name" => "street",
    "id" => "street",
    "value" => set_value("street")
);
echo form_input($data);

echo form_label("Date of Birth: ", "dob");

$data = array(
    "name" => "dob",
    "id" => "dob",
    "value" => set_value("dob")
);
echo form_input($data);

echo form_submit("searchSubmit", "Search");

echo form_close();




$this->table->set_heading(array('', 'Voter Number', 'First Name', 'Last Name',
                                'Middle', 'Home #', 'Street',
                                'Apt', 'Zip', 'DOB',
                                'District', 'Edit'));

foreach ($query as $row){
    $this->table->add_row($row);

}
echo $this->table->generate();

编辑表单视图：

echo validation_errors();

回声form_open（“ reg / edit_voter”）;
echo form_label（“名字：”，“名字”）;

$data = array(
    "name" => "firstName",
    "id" => "firstName",
    "value" => $this->form_validation->set_value('firstName', $voter['firstName'])
);
echo form_input($data);


echo form_label("Last Name: ", "lastName");

$data = array(
    "name" => "lastName",
    "id" => "lastName",
    "value" => $this->form_validation->set_value('lastName', $voter['lastName'])
);
echo form_input($data);

echo form_label("Middle Initial: ", "midInitial");

$data = array(
    "name" => "midInitial",
    "id" => "midInitial",
    "value" => $this->form_validation->set_value('midInitial', $voter['midInitial'])
);
echo form_input($data);

echo form_label("Home Number: ", "homeNum");

$data = array(
    "name" => "homeNum",
    "id" => "homeNum",
    "value" => $this->form_validation->set_value('homeNum', $voter['homeNum'])
);
echo form_input($data);

echo form_label("Street: ", "street");

$data = array(
    "name" => "street",
    "id" => "street",
    "value" => $this->form_validation->set_value('street', $voter['street'])
);
echo form_input($data);

echo form_label("Apartment Number: ", "apt");

$data = array(
    "name" => "apt",
    "id" => "apt",
    "value" => $this->form_validation->set_value('apt', $voter['apt'])
);
echo form_input($data);

echo form_label("Zip Code: ", "zip");

$data = array(
    "name" => "zip",
    "id" => "zip",
    "value" => $this->form_validation->set_value('zip', $voter['zip'])
);
echo form_input($data);

echo form_label("Date of Birth: ", "dob");

$data = array(
    "name" => "dob",
    "id" => "dob",
    "value" => $this->form_validation->set_value('dob', $voter['dob'])
);
echo form_input($data);

echo form_label("District: ", "district");

$data = array(
    "name" => "district",
    "id" => "district",
    "value" => $this->form_validation->set_value('district', $voter['district'])
);
echo form_input($data);


echo form_submit("editSubmit", "edit");
echo form_close();

最佳答案

这需要两个步骤。


第一步是从结果中加载现有数据。
第二步是更新您编辑的数据


对于第一站，您要为每个$row创建一个带有结果id的链接/按钮，让它以id作为参数调用控制器中的函数（例如loadEdit($id)）。

让该函数调用您要处理其结果的模型，然后发送id
将其作为唯一参数：

public function loadEdit($id){
    $this->load->model('model_results');
    $id = $id;
    $editData = $this->model_results->loadEdit_results($id);
}

在模型的loadEdit_results函数中，您只想获得1个$row。与要编辑的结果的id对应的一个。
因此，您可以在该函数中编写类似以下查询的内容：

public function edit_page($id){
    $query = $this->db->get_where('pages', array('id' => $id));
}

这将得到一个对应的id结果。

现在该进行下一步了。更新部分：

我猜您知道如何在视图中显示结果，所以我不去讨论。
只需使用表单中的结果数据创建表单，然后将该表单提交到控制器中的编辑功能（例如postEdit($id)）（别忘了，使用id作为该功能的参数）

postEdit($id)函数将必须调用您的模型，并将所有数据发送到该模型：

public function edit_page_validation($id){
    $this->load->model('model_pages');
    $this->model_pages->edit_page_update($id);
}

然后在模型中创建一个函数，以使用相应的id更新结果。

public function edit_page_update($id){
$data = array(
    /*
    the array with the posted data from the form
    */
);

$query = $this->db->where('id', $id);
$query = $this->db->update('results', $data);
}

如果您以前从未做过这样的事情，那么这可能会花费很多。因此，这里有一些链接可以帮助您：

http://ellislab.com/codeigniter/user-guide/database/active_record.html

希望我对你有所帮助:)