CODEWITHSUNDEEP
phpmysqlcodeigniter
RAJ
RAJ

Reputation: 229

Insert statement in codeigniter

This is my statement which I am using.

$sql = "INSERT INTO store (shop_id, shop_index, items) VALUES ('$shop_id','65535','4')";
$this->db->query($sql);
return shop_st;

shop_st is the primary key which is auto incremented and I want to return it. I want to know whether my query is correct or wrong . Please let me know if I am going wrong.

Upvotes: 0

Views: 1474

Answers (3)

Anand Somasekhar
Anand Somasekhar

Reputation: 596

Try this 

$data = array(
   'shop_st' => NULL,
   'shop_id' => $shop_id ,
   'shop_index' => '65535' ,
   'items' => '4'
);
function insertShop($data)
{
$res=$this->db->insert('store', $data)
if($res)
{
    return $res;
}
else
{
    return false;
}
}

Upvotes: 2

Albzi
Albzi

Reputation: 15609

In terms of codeigniter's syntax, if you enable the database helper, you can do something like this:

$data = array(
   'shop_st' => NULL,
   'shop_id' => $shop_id ,
   'shop_index' => '65535' ,
   'items' => '4'
);

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

I don't think there's anything more 'right' than your method, except you can do this.

return $this->db->insert_id(); //shop_st

which will get you your last inserted id.

This answer is just to raise make you aware of codeigniter's built in helpers.

The database helper can be found here.

Upvotes: 1

Raju Singh
Raju Singh

Reputation: 780

You will have to use the insert_id helper function (http://ellislab.com/codeigniter/user-guide/database/helpers.html)

$sql = "INSERT INTO store (shop_id, shop_index, items) VALUES ('$shop_id','65535','4')";
$this->db->query($sql);
return $this->db->insert_id();

Upvotes: 1

Related Questions