Capture last INSERT value

Question

I am creating a news system where the user has the option to register the news and put the original link where the news was generated, so far so good, the problem is that I want the user to have the option to register the news with the very link of the news that will be generated, I’m doing it this way:

        $urlNoticia = "index.php?".PARAMETER_NAME_ACTION."=show&";
        $urlNoticia .= PARAMETER_NAME_FILE."=exibir_noticia";
        $urlNoticia .= "&noticia_id=".$model->getnoticia_id();

        if(isset($_POST['FLinkNoticia'])) {
            $error = $this->getConexao()->executeNonQuery($sql);            
            $sqll  = "UPDATE noticia SET not_link = '".URL.$urlNoticia."SELECT MAX(noticia_id) FROM noticia' ";
            $sqll .= "WHERE not_titulo = '".$model->getnot_titulo()."'";
            $error = $this->getConexao()->executeNonQuery($sqll);
        } else {
            $error = $this->getConexao()->executeNonQuery($sql);
        }

Flinknoticia is a checkbox.

At first $error he makes the Insert in the bank, and shortly after he must make a UPDATE, it until it realizes the UPDATE but does not bring the news ID, only the URL

Answer 1

Use the LAST_INSERT_ID() function of mysql that will return the last inserted id. Place this snippet just after your Sert after the $error variable

$ultimoId = $this->getConexao()->executeNonQuery('LAST_INSERT_ID()');