PHP 代码点火器插入删除更新与提交按钮


PHP Codeigniter insert delete update with submit buttons

需要有关PHP Codeigniter框架的帮助。

我有一个带有 3 个提交按钮的表单。我想使用这些按钮插入 - 更新 - 删除。我成功地使插入按钮工作。因此,当我单击"插入"时,数据存储在MySQL数据库表中。由于它们都是提交按钮,因此它们都在执行相同的操作。

当我更改类型时,输入类型="按钮"不起作用。

下面是我的PHP代码。

class Users_model extends CI_Model
{
   function get_All_Users(){
        $query = $this->db->get('users');
        if($query->num_rows() > 0){
            foreach($query->result() as $row) {
                $data[]=$row;
            }
        }
        return $data;
    }

    function insert_users($data){
        $query = $this->db->insert('users', $data);
        return;

    }
    function update_users($data){
        // update code...
    }
}

控制器

public function add_users(){
    $this->load->view('users_view');
}
    public function create_users(){
        $username = $this->input->post('username');
        $password = $this->input->post('password');

        $data = array(
            'username' => $username,
            'password' => $password,
        );
        $this->load->model('user_model');
        $this->users_model->insert_users($data);
        $this->load->view('users_view');
        redirect('users', 'refresh');
    }

视图

<form role="form" action="<?php echo base_url().'index.php/users/create_users'?>" method="post">
    <table class="table">
        <thead>
        </thead>
        <tbody>
        <tr>
            <td>
                <div class="form-group">
                    <label for="Username">Username</label>
                    <input type="textbox" id="username" name="username">
                </div>
            </td>
            <td>
                <div class="form-group">
                    <label for="Password">Password</label>
                    <input type="textbox" id="password" name="password">
                </div>
            </td>     
        </tr>
        <tr>
            <td>
                <input type="submit" value="Insert" />
                <input type="submit" value="Update" />
                <input type="submit" value="Delete" />
            </td>
        </tr>
        </tbody>
    </table>
    </form>

所以我希望当我单击更新按钮以运行功能更新时!

首先给

按钮命名

<input type="submit" name="insert" value="Insert" />
<input type="submit" name="update" value="Update" />
<input type="submit" name="delete" value="Delete" />

并尝试以下功能

public function create_users(){
    $this->load->model('user_model');
if($this->input->post('insert') != ''){
/*Perform insert operation here*/
    $username = $this->input->post('username');
    $password = $this->input->post('password');

    $data = array(
        'username' => $username,
        'password' => $password,
    );

    $this->users_model->insert_users($data);
}
else if($this->input->post('update') != ''){
     /*perform update operation here*/
}
else if($this->input->post('delete') != ''){
     /*perform delete operation here*/
}
    $this->load->view('users_view');
    redirect('users', 'refresh');
}
$this->load->model('user_model');

您没有在此处加载正确的模型。将其更改为$this->负载>模型("users_model");

you type wrong this code area
  wrong:
       $data = array(
        'username' => $username,
        'password' => $password,
    );
  right
      you can write one extra semicolon in password field
  $data = array(
        'username' => $username,
        'password' => $password
    );