Store data to other table and get the id

Question

I'm using a method to store information in another table. This is how I'm doing that:

public static function CreateMail($userid, $title, $state = 1)
{           
    $maildata['userid'] = $userid;
    $maildata['title']  = $title;
    $maildata['state']  = $state;               

    $row = JTable::getInstance('Mail','BestiaTable');
    $row->bind($maildata);
    $row->check();
    $storemessage = $row->store();

    return $storemessage;                       
}

This is working fine - but one problem remains: I would like to get the id of the saved data.

How can I do that?

Edit: The given answer worked on 3.4.48 but on 3.5 $row->id always returns NULL.

Answer 1

$row contains inserted data with PK. So $row->id is id of the saved data. So you can do

 public static function CreateMail($userid, $title, $state = 1)
    {           
        $maildata['userid']     =       $userid;
        $maildata['title']      =       $title;
        $maildata['state']      =       $state;             

        $row=JTable::getInstance('Mail','BestiaTable');
        $row->bind($maildata);
        $row->check();
        $storemessage = $row->store();

        return $row->id;                       
    }

Answer 2

To get the last insertId use:

$newID = $row->insertId();

Here is the documentation You have to call it just after

$store = $row->store(); 

Answer 3

The problem is solved. On Joomla 3.5 the PDO driver does not return an id.

This is discussed and will be solved: https://github.com/joomla/joomla-cms/issues/9534