php - 如何在codeigniter中实现代码

Question

我想在 codeigniter 中插入数据。

这是我的看法:

<input type="text" placeholder="Name" name="name[]">
<input type="text" placeholder="Work Name" name="work[]">

这是我的模型

public function add_work(){
$names = $_POST['name'];
$works = $_POST['work'];

foreach($names as $key => $name){
            $work = $works[$key];

            $insert = mysql_query("INSERT INTO work(name,work) values ( '$name','$work')");
   }
}

Codeigniter 拒绝使用 mysql 查询。如何解决这个问题。提前致谢

Answer 1

在你的 Controller 中

class CommonController extends CI_Controller {
  public function __construct() {
    parent::__construct();
      $this->load->model('common_model'); //load your model my model is "common model"
  }

 public function add_work(){
 $names = $_POST['name'];
 $works = $_POST['work'];

 foreach($names as $key => $name){
             $name= "your specified name";
             $insertdata = array();
             $insertdata['work'] = $works[$key];
             $insertdata['name'] = $name;
             $this->common_model->insert($insertdata);
        //$insert = mysql_query("INSERT INTO work(name,work) values ( '$name','$work')");
            }
  }
}

在你的模型“common_model.php”中

 class Common_model extends CI_Model {

/**
 * Constructor 
 *
 */
   public function __construct()
 {
     parent::__construct();

  }//Controller End
  public function insert($insertData=array()){
     $this->db->insert('work', $insertData);
  }


}