How to implement the code in codeigniter

Question

I want to insert data in codeigniter.

Here is my view:

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

Here is my Model

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 refuse to use mysql query. How to fix that. Thanks in advance

Do you have more than one textboxes with name="name[]" and name="work[]"?? — Indrasinh Bihola
– Indrasinh Bihola, Commented Oct 17, 2015 at 5:32
Hey you need to connect mysql first if you use it like this. — Indrasinh Bihola
– Indrasinh Bihola, Commented Oct 17, 2015 at 5:36
Try this if you want to query in codeigniter $this->db->query('YOUR QUERY HERE'); for the reference check out this: ellislab.com/codeigniter/user-guide/database/queries.html — Indrasinh Bihola
– Indrasinh Bihola, Commented Oct 17, 2015 at 5:41

Syed mohamed aladeen · Accepted Answer · 2015-10-17 05:57:37Z

3

in your 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')");
            }
  }
}

and in your model "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);
  }


}

edited Oct 17, 2015 at 5:57

answered Oct 17, 2015 at 5:41

Syed mohamed aladeen

6,8134 gold badges37 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Russell Over a year ago

Getting Undefined variable: insertData

Russell Over a year ago

now getting You must use the "set" method to update an entry.

Syed mohamed aladeen Over a year ago

do you have any prefixes to the table name?

Syed mohamed aladeen Over a year ago

ok try this inside insert function in model. $this->db->set($insertData); $this->db->insert('work');

Collectives™ on Stack Overflow

How to implement the code in codeigniter

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related