MySQL insert inside library with codeigniter

Question

I'm trying to insert a number into the database from within a library using,

   $data = array(
   'id' => $id,
   'so' => '1',
   'username' => $username
);

$this->db->insert('db', $data);

but whenever I run it, I get "Fatal error: Call to a member function insert() on a non-object in"

Anyone know why?

Thanks

this seems to concern $this->db. it appears its not what you think it is, and it doesnt have a member function called insert, and is not even an object at all — jon_darkstar
– jon_darkstar, Commented Mar 23, 2011 at 5:14

Christian · Accepted Answer · 2011-03-23 05:38:28Z

3

If you're doing this inside a library, you can't reference the $this object like you normally do in a model. Instead, you'll need to load an instance of CI like so:

$CI =& get_instance();

Then you should be able to insert a record into the database like this:

$CI->db->insert('db', $data);

Don't forget to load the database library as well if it's not in autoload.

answered Mar 23, 2011 at 5:38

Christian

19.8k3 gold badges57 silver badges70 bronze badges

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

1 Comment

Dwayne Charrington Over a year ago

Because Codeigniter has deprecated support for PHP4, and the requirement is PHP5 now, all variables are assigned by reference so you don't need the ampersand in there. You can just use $CI = get_instance();

Josnidhin · Accepted Answer · 2011-03-23 05:43:51Z

0

In a library "$this" refers to the class that you are coding (OOP concepts).

The DB object is part of the CI superobject. So in order to use db in your class you will have get a reference to the CI object like this

$CI =& get_instance();

And then rewrite your insert statments like this

$CI->db->insert('db', $data);

answered Mar 23, 2011 at 5:43

Josnidhin

12.5k9 gold badges45 silver badges62 bronze badges

Collectives™ on Stack Overflow

MySQL insert inside library with codeigniter

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related