I've been searching google a lot for this issue and really found nothing. People just keep copying MySQL documentation on last_insert_id and nothing else.

I've got an issue regarding last_insert_id, because for both situations (php & sql) it returns 0.

YES: I've set a PRIMARY & UNIQUE field with AUTO_INCREMENT value YES: i've done some inserting before NO: Making double query with INSERT AND SELECT LAST... doesn't work.

I've created a class Db for maintaining connection & query:

class Db
{
    public function connect() { 
    $db = new mysqli('','','','',''); ... return $db; }

    public function insert() { 
    $this->connect()->query("INSERT INTO bla bla..."); return $this->connect()->insert_id; }
}

And it doesn't work.