How to get ID of last inserted row?

PHPMaker General Discussion (PHPMaker)
1

Hello,I have added code on Row Inserting of Table A to add a corresponding entry in Table B. Insert query works well for Table B, but now I also need to have the ID of the row inserted in Table B. None of the Execute functions seem to return the ID of the last row inserted. I tried to execute the select query with Max(ID) on Table B, but somehow it is not returning the correct value.How to handle this situation? What’s the best way to get it done? I’m using PHPMaker 2021.Waiting for your valuable reply…Thanks!/r

2

Is the ID in table B an auto increment field?

3

Yes. It is Primary Key, Auto increment field in Table B.

4

You may search for lastInsertId keyword in this forum.

5

Great! You solved my problem. Thanks so much!!Just for the records, I added following two lines to my code after ExecuteUpdate function to get the index of last row inserted.


$conn = $this->getConnection();
$uid = $conn->lastInsertId();
6

I saw you mentioning ExecuteStatement function for Insert query. I checked it and I don’t find it in my 2021 version. Is this a new addition in 2022 version?

7

Read Migrating to v2022 → Database Abstraction Layer (DBAL 3).

8

Thanks for the migration guide. If in case I upgrade, the migration guide will surely help me.