Getting latest inserted auto-incremented record id using fat-free-framework

Question

I need to get the id(AUTO-INCREMENTED) of latest inserted record in a table. I am using fat-free-framework.

I tried to get the latest id by using

$id = mysql_insert_id();

but it gave me this error

Access denied for user 'root'@'localhost' (using password: NO)

I am accessing database using fat-free-framework and not using traditional php functions. Can any one guide me how to accomplish this ?

score 11 · Accepted Answer · answered Feb 01 '14 at 07:39

11

Try this code after record inserted

$id = $db->lastInsertId();

answered Feb 01 '14 at 07:39

Kumar V

8,669
8
37
55

Thank You. That nailed it. – Umair Feb 01 '14 at 07:50

score 1 · Answer 2 · answered Feb 01 '14 at 08:24

1

Beside kumar_v's answer, F3 will automatically populate $db->_id after a successfull insert.

answered Feb 01 '14 at 08:24

sascha

4,591
3
34
51

1

A leading underscore usually indicates something "internal" or potentially "private", which implementation might change in the future. I'd better go with @kumar_v solution, even if it's probably not anything more than a wrapper around `$db->_id`. But since you never know... – Seether Sep 25 '15 at 09:29

score 1 · Answer 3 · answered Mar 26 '15 at 10:57

Note that if you have used the SQL Mapper to create the row in your table, you can just do

$object->id;

Example (using a table containing quotes):

$quote = new DB\SQL\Mapper($db, 'quotes');
if($_POST){
    //overwrite with values just submitted
    $quote->copyFrom('POST');
    $quote->save();
    die("new quote added with id:".$quote->id);
}

score 0 · Answer 4 · answered Jul 13 '17 at 10:20

0

$quote = new DB\SQL\Mapper($db, 'quotes');
$quote->get('_id');

which '_id' is the id auto increment id field of your table, replace '_id' with yours you can read the docs : https://fatfreeframework.com/3.6/sql-mapper#get

answered Jul 13 '17 at 10:20

samehanwar

1,739
2
9
18

Getting latest inserted auto-incremented record id using fat-free-framework

4 Answers4