How can i grab the insert id after insert query ?
$query = $this->modelsManager->executeQuery("INSERT INTO CRM\Models\Services (name,text) VALUES (:name:, :text:) ", [
'name' => $this->request->getPost("name"),
'text' => $this->request->getPost("text"),
]);This way:
$result = $this->modelsManager->executeQuery("INSERT INTO CRM\Models\Services (name,text) VALUES (:name:, :text:) ", [
'name' => $this->request->getPost("name"),
'text' => $this->request->getPost("text"),
]);
if (!$result->success()) {
foreach ($result->getMessages() as $message) {
echo $message;
}
} else {
$model = $result->getModel(); // instance of CRM\Models\Services populated with inserted values
echo $model->getId(); //Access the id field
}It's returning boolean: false
Got it !
$model = $result->getModel();
$model->_ // where _ is my main id field