Magento 2: How to get last inserted custom table Id without saving new item?

Question

I want to get the last inserted id to my block without adding new data into the table. I want to use this value to automatically filled in my phtml file. I tried getId and it's not working. I just need the last id. Can anyone help?

Answer 1

Try below code

protected $_resource;
public function __construct(
   ...
   \Magento\Framework\App\ResourceConnection $resource
   ...
   ) {
   $this->_resource = $resource;
}

$connection = $this->_resource->getConnection();
$yourLastAddedId = $connection->lastInsertId('your_table_name');

or use below

$objectManager = \Magento\Framework\App\ObjectManager::getInstance(); // Instance of object manager
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();
$tableName = $resource->getTableName('your_table_name');
$yourLastAddedId = $connection->lastInsertId($tableName);

hope its helps you:)

Answer 2

i got the answer by creating helper class

<?php
namespace vendor\module\Helper;

use vendor\module\Model\ResourceModel\Collection_Folder\CollectionFactory;
class Helper extends \Magento\Framework\Url\Helper\Data
{

    public function __construct(
        \Magento\Framework\App\Helper\Context $context,
        CollectionFactory $modelFactory
    ) {
        $this->modelFactory = $modelFactory;
        return parent::__construct($context);
    }
    public function getLatestid()
    {
        $model = $this->modelFactory->create(); 
        $data = $model->load();
        foreach ($data as $item) {
            $id = $item->getData('id');
        }
        return $id;
    }

}

This way we can get last inserted Id..

Answer 3

You can achieve this with a custom SQL statement

protected $resourceConnection;
public function __construct(
   ...
   \Magento\Framework\App\ResourceConnection $resourceConnection,
   ...
   ) {
   $this->resourceConnection = $resourceConnection;
}

 $connection = $this->resourceConnection->getConnection();
 $sql = "select id FROM customtable order by id desc limit 1";
 $latestIdResults= $connection->fetchAll($sql);
 
 $latestId = 0;

 foreach($latestIdResults as $id){
          $latestId = $id["id"];                        
 }

$latestId will be your lastest incremented id :) There are mysql functions for this but this is one way to do it if your keys and tables are heavily customized.

Answer 4

What about

$lastId = $this->resource->getConnection()->fetchOne(
                $this->resource->getConnection()
                    ->select()
                    ->from('my_table', ['id'])
                    ->order('id DESC')
            )