ModX Last insert ID?

330 Posts

meltingdog Reply #1, 11 years, 9 months ago

I am trying to get the last ID of a an SQL row just inserted.

Normally I would do this as such:

$modx->query($query);

$lastId = $modx->lastInsertId();

But I cannot get this to work.

Would anyone know what I should be doing?

Thanks!

http://radianweb.com.au

5,888 Posts

Bruno17 Reply #2, 11 years, 9 months ago

If you would use xpdo-objects and methods, this should work:

if ($object = $modx->newObject($classname)){
    $object->fromArray($values);
    if ($object->save()){
        $lastId = $object->get('id');
    }
}

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

289 Posts

ReSpawN Reply #3, 11 years, 9 months ago

I think your main focus should be figuring out why your lastInsertId isn't working, as it works with PDO::lastInsertId(). Is your table constructed out of multiple, custom primary keys, or is your table a simple xPDOSimpleObject?

@MarkGHErnst

Developer at Adwise Internetmarketing, the Netherlands.