PDO connection select last id from table

Question

I am trying to get the last id from my selected table. I know lastinsertid(); sould work but it keeps returning a 0. What am i doing wrong here?

   public function getlastadded()
{
    $Sql = 'SELECT * FROM agendaevent';
    $Stm = $this->getEntityManager()->getConnection()->prepare($Sql);
    $Stm->execute();

    return $this->getEntityManager()->getConnection()->lastInsertId('id');
}

ps i am working in symfony if that makes a difference.

lastinsertid() works after insert, not select. Why do you want it? — Your Common Sense, Jan 24 '17 at 13:44
i am adding a event but the events are linked 2 ways so i have to add the id to the event. tough i didnt know that it only works after inserts.@YourCommonSense — Laurence, Jan 24 '17 at 13:46
No, he means *you* are calling `lastInsertId()` after a select, not the INSERT. IIRC lastInsertId() works only for the connection on which an element was last created — Pekka, Jan 24 '17 at 13:48
@Pekka웃 okay i am a beginner i didnt know. is there a other way to do this? — Laurence, Jan 24 '17 at 13:56
**USE lastinsertid() RIGHT AFTER INSERT**. any other method will link anything but the proper id. — Your Common Sense, Jan 24 '17 at 14:04
@YourCommonSense i am using symfonys entitys to insert so i am not writing the query. i am using the standart: `$agenda = new Agendaevent(); $agenda->setName('blabla');` — Laurence, Jan 24 '17 at 14:07

score 2 · Accepted Answer · answered Jan 24 '17 at 14:02

2

Try this, friend:

 "SELECT * FROM agendaevent ORDER BY id DESC LIMIT 1"

answered Jan 24 '17 at 14:02

Henrique Giuliani

296
4
15

Thats what i needed. Thanks! – Laurence Jan 24 '17 at 14:04
I am no PHP expert, but i would like to know more about it, if you can sustain your comment. – Henrique Giuliani Jan 24 '17 at 14:07
@Laurence don't reward bad answers – Masivuye Cokile Jan 24 '17 at 14:08
@MasivuyeCokile i dont know whats wrong with the answer. I am a beginner my self i am still studying. Its doing what i asked for i would like to know whats wrong with it. – Laurence Jan 24 '17 at 14:10
I also don't know, Laurence. If someone can make a constructive comment, please do. – Henrique Giuliani Jan 24 '17 at 14:11
1

@Laurence this query will basically give you a random id, that could be unrelated to the entity you are working with. To get the actual id you should get it from the entity itself – Your Common Sense Jan 24 '17 at 14:12
@YourCommonSense the way they do it in the duplicate question u mean? – Laurence Jan 24 '17 at 14:13
@Laurence exactly – Your Common Sense Jan 24 '17 at 14:13
@YourCommonSense i will look into it like i said i dont know much yet i am working in symfony for like 3 months now. Thanks for the advice. – Laurence Jan 24 '17 at 14:14
1

Guys, i had no intention to make this a bad answer. As i said, i'm no PHP expert, so i was trying to solve using just a SQL statement. Laurence, hope they can help you better. – Henrique Giuliani Jan 24 '17 at 14:16
@HenriqueGiuliani dont worry your help is much appreciated. I sould have tagged this with doctrine instead i think i see now. – Laurence Jan 24 '17 at 14:18

PDO connection select last id from table

1 Answers1