Advertisement
Guest User

Untitled

a guest
Apr 11th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.58 KB | None | 0 0
  1. <form class="form-horizontal" action="cadastrar.php" method="GET">
  2. <fieldset>
  3. <legend>DADOS CADASTRAIS</legend>
  4.  
  5. <input type="hidden" required id="cep" name="cep" value="<?php echo $cep; ?>">
  6.  
  7. <div class="row">
  8. <div class="col-md-3">
  9. <label for="cpf">CPF</label>
  10. <input type="text"
  11. class="form-control"
  12. required
  13. id="cpf"
  14. name="cpf"
  15. placeholder="SOMENTE NUMEROS">
  16. </div>
  17. </div>
  18. <div class="row">
  19. <div class="col-md-12">
  20. <label for="nome">NOME</label>
  21. <input type="text"
  22. style="text-transform:uppercase"
  23. class="form-control"
  24. required id="nome"
  25. name="nome"
  26. placeholder="NOME DO CLIENTE"
  27. required>
  28. </div>
  29. </div>
  30. <div class="row">
  31. <div class="col-md-4">
  32. <label for="end" >ENDERECO</label>
  33. <input type="text"
  34. style="text-transform:uppercase"
  35. class="form-control"
  36. required
  37. id="end"
  38. name="end"
  39. placeholder="DIGITE ENDERECO">
  40. </div>
  41. <div class="col-md-2">
  42. <label for="num">NUMERO</label>
  43. <input type="text"
  44. class="form-control"
  45. required
  46. id="num"
  47. name="num"
  48. placeholder="NUMERO">
  49. </div>
  50. <div class="col-md-2">
  51. <label for="comp">COMPLEMENTO</label>
  52. <input type="text"
  53. class="form-control"
  54. id="comp"
  55. name="comp"
  56. placeholder="COMPLEMENTO">
  57. </div>
  58. <div class="col-md-4">
  59. <label for="bairro">BAIRRO</label>
  60. <input type="text"
  61. style="text-transform:uppercase"
  62. class="form-control"
  63. required
  64. id="bairro"
  65. name="bairro"
  66. placeholder="BAIRRO DO CLIENTE">
  67. </div>
  68. </div>
  69. <div class="row">
  70. <div class="col-md-6">
  71. <label for="cidade">CIDADE</label>
  72. <input type="text"
  73. style="text-transform:uppercase"
  74. class="form-control"
  75. required
  76. id="cidade"
  77. name="cidade"
  78. placeholder="CIDADE DO CLIENTE">
  79. </div>
  80. <div class="col-md-6">
  81. <label for="telefone">TELEFONE</label>
  82. <input type="text"
  83. class="form-control"
  84. required
  85. id="telefone"
  86. name="telefone"
  87. placeholder="TELEFONE">
  88. </div>
  89. </div>
  90. <div class="row">
  91. <div class="col-md-6">
  92. <label for="rg">RG</label>
  93. <input type="text"
  94. class="form-control"
  95. required
  96. id="rg"
  97. name="rg"
  98. placeholder="SOMENTE NUMEROS">
  99. </div>
  100. <div class="col-md-6">
  101. <label for="email">E-MAIL</label>
  102. <input type="text"
  103. style="text-transform:uppercase"
  104. class="form-control"
  105. required
  106. id="email" n
  107. ame="email"
  108. placeholder="EMAIL DO CLIENTE">
  109. </div>
  110. </div>
  111. <div class="row">
  112. <div class="col-md-12">
  113. <br>
  114. <button type="submit" class="btn btn-primary">CADASTRAR</button>
  115. </div>
  116. </div>
  117. </fieldset>
  118. <!--FINAL FORMULARIO DE CADASTRO-->
  119. </form>
  120.  
  121. http://localhost:8080/sys/functions/functionCPF.php?cpf=11122233344
  122.  
  123. {"dados":{"cpf":"11122233344"}}
  124.  
  125. {"dados":{"cpf":0}}
  126.  
  127. $(document).keydown(function(){
  128. var cpf = $("#cpf");
  129. cpf.blur(function() {
  130. $.ajax({
  131. url: '../functions/functionCPF.php',
  132. type: 'GET',
  133. data:{"cpf" : cpf.val()},
  134. success: function(data) {
  135. console.log(data);
  136. data = $.parseJSON(data);
  137. $("#resposta").text(data.cpf);
  138. }
  139. });
  140. });
  141.  
  142.  
  143. });
  144.  
  145. <?php
  146. //database configuration
  147. $dbHost = '127.0.0.1';
  148. $dbUsername = 'root';
  149. $dbPassword = '';
  150. $dbName = 'master';
  151. #Verifica se tem um cpf para pesquisa
  152. if(isset($_GET['cpf'])){
  153. #Recebe o cpf Postado
  154. $VarCPF = $_GET['cpf'];
  155. #Conecta banco de dados
  156. $Mysqli = new mysqli($dbHost,$dbUsername,$dbPassword,$dbName);
  157. $sql = mysqli_query($Mysqli, "SELECT
  158. cli_cpf
  159. FROM
  160. big_clientes
  161. WHERE
  162. cli_cpf = '".$VarCPF."'") or print mysql_error();
  163. #Se o retorno for maior do que zero, diz que já existe um.
  164. if(mysqli_num_rows($sql)>0)
  165. echo json_encode(array('cpf' => 'CPF JÁ CADASTRADO!'));
  166. else
  167. echo json_encode(array('cpf' => 'CPF OK!' ));
  168. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement