I need, after doing query on BD , to insert values returned in fields of a form, since I will use these fields to make a change in BD , the call to search is working correctly and is configured in this way, function BuscaDados passing the parameters Operacao and IdFase to the page pProcessoFase.php that returns the searched values but in return I am not able to assign the values in the fields of the form, I gave a console.log in return and it comes that's it:
[{"Descricao":"controle","Data":"2015-09-03","Hora":"17:36:00","IdTipoFase":1}]
function BuscaDados(IdFase) {
var params = {
Operacao: 'BuscaUnica',
IdFase: IdFase
};
$.post(
'pProcessoFase.php',
params,
function( json, textStatus, jQxhr ){
if (jQxhr.responseText != "[]") {
try {
if (jQxhr.readyState === 4) {
if (jQxhr.status === 200) {
var registro = JSON.parse(jQxhr.responseText);
console.log("RESPOSTA DA CONSULTA: " + jQxhr.responseText);
//Atribui valores aos campos
$('#sDescricao').val(registro[0].Descricao);
$('#dData').val(registro[0].Data);
$('#dHora').val(registro[0].Hora);
$('#IdTipoFas').val(registro[0].IdTipoFas);
} else {
var dialogInstance = BootstrapDialog.show({
title: 'ERRO',
type: BootstrapDialog.TYPE_DANGER,
message: 'Ocorreu um erro na requisição dos dados. Tente novamente.'
});
}
}
}
catch( e ) {
console.log(e);
var dialogInstance = BootstrapDialog.show({
title: 'ERRO',
type: BootstrapDialog.TYPE_DANGER,
message: 'Ocorreu um erro na requisição dos dados. Tente novamente.'
});
}
}
},
'json'
)
.fail(function( jqXhr, textStatus, errorThrown ){
try {
var json = $.parseJSON(jqXHR.responseText);
var dialogInstance = BootstrapDialog.show({
title: 'ERRO',
type: BootstrapDialog.TYPE_DANGER,
message: json.msg
});
} catch(e) {
var dialogInstance = BootstrapDialog.show({
title: 'ERRO',
type: BootstrapDialog.TYPE_DANGER,
message: json.msg
});
}
});
}
Search on pProcessoFase.php page:
if ($_POST["Operacao"] == 'BuscaUnica') {
$sql = "SELECT Descricao, Data, Hora, IdTipoFase FROM gerFaseContrato WHERE IdFase = '". $_POST['IdFase']."' ";
$stmt = $conn->prepare($sql);
if($stmt->execute()){
$data = array();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$data[] = $row;
}
header('Content-Type: application/json');
echo json_encode($data);
$stmt->close();
}else{
$aretorno["msg"] = "Ocorreu um erro na inclusão dos dados: " . $stmt->error . ". Verifique.";
$aretorno["status"] = "ERRO";
header('Content-Type: application/json');
echo json_encode($aretorno);
}
$conn->close();
exit;
}
The form where I am trying to enter information:
<body>
<form class="form-horizontal" id="frmDadosFase">
<fieldset>
<div class="form-group">
<label class="col-md-4 control-label" for="sDescricao">Descrição</label>
<div class="col-md-4">
<textarea class="form-control" id="sDescricao" name="sDescricao"></textarea>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="dData">Data</label>
<div class="col-md-4" id="sandbox-container">
<div class="input-group date">
<input name="dData" type="text" class="form-control" id="dData">
<span class="input-group-addon"><i class="glyphicon glyphicon-th"></i></span> </div>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="dHora">Hora</label>
<div class="col-md-4">
<input id="dHora" name="dHora" placeholder="" class="form-control input-md" type="time">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="IdTipoFase">Tipo Fase</label>
<div class="col-md-4">
<textarea class="form-control" id="IdTipoFase" name="IdTipoFase"></textarea>
</div>
</div>
</fieldset>
</form>
</body>