如何在codeigniter中实现代码 - How to implement the code in codeigniter

How to implement the code in codeigniter

本文关键字：实现代码 codeigniter | 更新日期: 2023-09-27

我想在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查询。如何解决这个问题。提前感谢

在你的控制器

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);
  }

}