Preenchimento automático formulário PHP MY SQL
Boa tarde amigos,
Não sei se meu código está correto, pois não consigo fazer com que os campos se preencham automaticamente a partir do número da conta, se puderem me ajudar agradeço.
Testes feitos: existe conexão com o banco, valores são apresentados via GET, porém não autocompleta os demais campos no arquivo pagesaidaassociado.php
Formulário (pagesaidaassociado.php)
<form class="form-horizontal form-label-left input_mask" method="GET">
<div class="col-md-2 col-sm-2 col-xs-6 form-group has-feedback">
<input type="text" class="form-control has-feedback-left" id="conta" name="conta" placeholder="Conta">
<span class="fa fa-user form-control-feedback left" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control" id="inputSuccess3" id="nome" name="nome" placeholder="Nome">
<span class="fa fa-user form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="col-md-4 col-sm-6 col-xs-6 form-group has-feedback">
<input type="text" class="form-control has-feedback-left" id="cpf_cnpj" name="cpf_cnpj" placeholder="Cpf/Cnpj">
<span class="fa fa-envelope form-control-feedback left" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control" id="perfil" name="perfil" placeholder="Perfil">
<span class="fa fa-phone form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="date" class="form-control has-feedback-left" id="dt_assoc" name="dt_assoc" placeholder="Data da Associação">
<span class="fa fa-user form-control-feedback left" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="date" class="form-control" id="dt_encerr" name="dt_encerr" placeholder="Data de Encerramento">
<span class="fa fa-user form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="date" class="form-control has-feedback-left" id="dt_encerr_capital" name="dt_encerr_capital" placeholder="Data Encerr. Capital">
<span class="fa fa-envelope form-control-feedback left" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control" id="funcionario" name="funcionario" placeholder="Funcionário">
<span class="fa fa-phone form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control has-feedback-left" id="ano_base" name="ano_base" placeholder="Ano base Encerr.">
<span class="fa fa-user form-control-feedback left" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control" id="forma_pgto" name="forma_pgto" placeholder="Forma PGTO">
<span class="fa fa-user form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control has-feedback-left" id="banco" name="banco" placeholder="Banco">
<span class="fa fa-envelope form-control-feedback left" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control" id="agencia" name="agencia" placeholder="Agência">
<span class="fa fa-phone form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control has-feedback-left" id="tp_conta" name="tp_conta" placeholder="TP Conta">
<span class="fa fa-user form-control-feedback left" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control" id="conta_destino" name="conta_destino" placeholder="Nº Conta (Com dígito)">
<span class="fa fa-user form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control has-feedback-left" id="cpf_cnpj_destino" name="cpf_cnpj_destino" placeholder="Cpf/Cnpj">
<span class="fa fa-envelope form-control-feedback left" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control" id="nome_destino" name="nome_destino" placeholder="Nome Completo">
<span class="fa fa-phone form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="col-md-6 col-sm-6 col-xs-12 form-group has-feedback">
<input type="text" class="form-control" id="titularidade" name="titularidade" placeholder="Titularidade">
<span class="fa fa-phone form-control-feedback right" aria-hidden="true"></span>
</div>
<div class="ln_solid"></div>
<div class="form-group">
<div class="col-md-9 col-sm-9 col-xs-12 col-md-offset-3">
<button type="button" class="btn btn-primary">Cancel</button>
<button class="btn btn-primary" type="reset">Reset</button>
<button type="submit" class="btn btn-success">Submit</button>
</div>
</div>
</form>
Consulta com o BD (consulta_autopreenchimento.php)
<?php
$conta = $_GET['conta'];
//Conexão com o Banco de Dados
require_once 'bdconexao.php';
//Informa a quantidade de contas a serem exibidas com seus respectivos saldos
$sql = "SELECT * FROM saida_de_associados WHERE conta = '$conta'";
$res = mysql_query($sql, $id) or die (mysql_error());
$query = mysql_fetch_array($res);
echo $query['nome'];
?>
Javascript (preenchimento_auto.js)
$("#conta").blur(function () {
var conta = $(this).val();
$.ajax({
type: "GET",
url: "consulta_autopreenchimento.php",
data: "conta="+conta,
success: function(pessoa){
$("#nome").val(Pessoa);
}
});
});Discussão (3)
Carregando comentários...