Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. <form class="form-horizontal" action="cadastroAdm.php" method="post" name="clientForm">
  2.  
  3. <input type="text" name="clienteId" id="clienteId" autocomplete="off" placeholder="ID">
  4.  
  5. <div class="form-group">
  6. <div class="col-md-12">
  7. <label for="clienteNome" class="control-label">Nome do cliente</label>
  8. <input type="text" name="clienteNome" id="clientes" class="form-control" placeholder="Nome do cliente">
  9.  
  10. </div>
  11. </div>
  12. <input type="hidden" name="clienteId" id="clienteId" >
  13. </form>
  14.  
  15. $(document).ready(function() {
  16. // Captura o retorno do retornaCliente.php
  17. $.getJSON('php/retornar_cliente.php', function(data){
  18. var dados = [];
  19. // Armazena na array capturando somente o nome do EC
  20. $(data).each(function(key, value) {
  21. dados.push(value.clienteNome);
  22. });
  23. // Chamo o Auto complete do JQuery ui setando o id do input, array com os dados e o mínimo de caracteres para disparar o AutoComplete
  24. $('#clientes').autocomplete({ source: dados, minLength: 3});
  25. });
  26. });// JavaScript Document
  27.  
  28. <?php
  29. $hostname = "";
  30. $user = "";
  31. $pass = "";
  32. $basedados = "";
  33. $pdo = new PDO("mysql:host=localhost; dbname=adv; charset=utf8;",'root','');
  34. $dados = $pdo->prepare("SELECT clienteNome, clienteId FROM cliente ORDER BY clienteNome");
  35. $dados->execute();
  36. echo json_encode($dados->fetchAll(PDO::FETCH_ASSOC));
  37. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement