Is there a way after the ->save() call to get the last insert id?
Example Code:
$post_data = $_POST;
$user = ORM::factory('user');
$user->username = $post_data['username'];
$user->email = $post_data['email'];
$user->save();
Asked
Active
Viewed 6,293 times
2
12Bo
- 116
- 1
- 3
- 11
2 Answers
3
Of course, assuming your insert code looked like this:
$user = ORM::factory('user')->values($post)->save();
To get the last insert ID simply do this after the call to ->save()
echo $user->id;
In your case you would need to do $user->user_id as you've named your primary key user_id.
I would alternatively recommend biakaveron's advice to instead use $user->pk() as it will always return the value of the primary key regardless of the name given to it, provided that you specify the primary key name in your model with $_primary_key.
The model will be populated with the saved values ready for reuse if the insert worked.
Job done!
David Hancock
- 14,861
- 4
- 41
- 44
-
I updated my question... and $user->id gives me an error. **The id property does not exist in the Model_User class** . But I am able to get the last insert id by calling `$user->pk()`. – 12Bo Jan 14 '12 at 20:33
-
Does your user table have a primary key named `id`? – David Hancock Jan 14 '12 at 20:40
-
My Model User table: `Class Model_User extends ORM { protected $_primary_key = 'user_id'; }` – 12Bo Jan 14 '12 at 22:48
-
Thats why you should always use `->pk()` instead of `->id` – biakaveron Jan 15 '12 at 10:53
