1
I’m making a insert using a class but not being able to rescue the last id registered, need to save this id in a return variable json because I need it to make a new record, what I have is this:
require_once "../_classes/conexao_pdo.class.php";
require_once "../_classes/crud.class.php";
// Atribui uma conexão PDO
$pdo = Conexao::getInstance();
$crud = Crud::getInstance($pdo, 'dvsMalote');
// INSERT
$crud = $pdo->prepare("INSERT INTO dvsMalote ( NumeroBolsa, IdUnicoopRemetente, IdUnicoopDestinatario, DataHoraEnvio, IdUsuarioEnvio, Estado ) VALUES (?, ?, ?, ?, ?, ?)");
$crud->bindParam(1, $Bolsa, PDO::PARAM_INT);
$crud->bindParam(2, $UnicoopRemetente , PDO::PARAM_INT);
$crud->bindParam(3, $UnicoopDestinatario , PDO::PARAM_INT);
$crud->bindParam(4, $DataHoraEnvio , PDO::PARAM_STR);
$crud->bindParam(5, $Matricula , PDO::PARAM_INT);
$crud->bindParam(6, $Estado , PDO::PARAM_STR);
$retorno = $crud->execute();
// RECUPERANDO NumeroMalote
$mensId = $pdo->lastInsertId();
if ($retorno):
$retorno = array('codigo' => 1, 'mensagem' => ' Registro inserido com sucesso');
echo json_encode($retorno);
exit();
else:
$retorno = array('codigo' => 0, 'mensagem' => ' Erro ao inserir o registro' );
echo json_encode($retorno);
exit();
endif;
I can get the id, now don’t know how to send that value to the call page, the call page waiting for the return message is like this:
if (response.codigo == "1") {
$("#msgInsert").html('×AVISO! ' + response.mensagem + '');
} else {
$("#msgInsert").html('×ATENÇÃO! ' + response.mensagem + '');
}
How can I send this id recovered up to it and position the value in a variable?
In theory that’s it, you can put the method code
insert()? The id is auto increment certain?– rray
Hello @rray, thank you for giving me a touch on the Insert, I made an edit on my question, now I can redeem the ID but I need to send you the call page, ie in return.
– adventistapr
Remember that php only sends text to javascript, so turn it into a use object
var r = JSON.parse(response);Then you can do something likeconsole.log(r.mensagem);– rray