Codeigniter inserting data ( with insert function )

Question

I have simple model, that needs to inset data to my table. All works fine when i use sql and query but when i try to use insert function i get an error that i need to use set ??

id in my database is auto increment and date is time stamp

class Article extends CI_Model {

private $id;
private $title;
private $text;
private $date;

public function __construct()
{
    $this->load->database();
}

public function save_article($title,$text)
{
    $this->title=$title;
    $this->text=$text;
    $this->id='';
    $this->load->helper('date');
    $this->date=now();
    print_r($this);
    //"INSERT INTO article VALUES ('','".$title."','".$text."',NOW())")
    $this->db->insert('articles',$this);
}
}

Article Object ( [id:Article:private] => [title:Article:private] => rrrrrrrrrrr [text:Article:private] => rrrrrrrrrrrrrrrrrr [date:Article:private] => 1351680951 )

A Database Error Occurred

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

Filename: C:\Program Files (x86)\EasyPHP-12.1\www\blog\system\database\DB_active_rec.php

Line Number: 1174

It might be that your id database field is unique, and there is already an id with the value ''. — Waleed Khan
– Waleed Khan, Commented Oct 31, 2012 at 11:16
my id in db is unique and AUTO_INCREMENT ! it does not need to insert that value , i tried without setting id but again i was getting same error — gogic1
– gogic1, Commented Oct 31, 2012 at 11:19
where is db defined? You use this but it is not in the constructor...try setting this->id = false — ka_lin
– ka_lin, Commented Oct 31, 2012 at 11:19
you must set the data using set() before insert the data into database — noelyahan
– noelyahan, Commented Mar 11, 2013 at 20:55

air4x · Accepted Answer · 2012-10-31 11:30:53Z

5

Your member variables in Article are private. The Active Record class cannot read them using get_object_vars.

private $id;
private $title;
private $text;
private $date;

Make them as public or pass in an array of key-value pairs to insert.

answered Oct 31, 2012 at 11:30

air4x

5,6831 gold badge26 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Codeigniter inserting data ( with insert function )

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related