Advertisement
Guest User

Untitled

a guest
Oct 21st, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.47 KB | None | 0 0
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  5. <script type="text/javascript" src="_js/jquery-1.4.2.min.js"></script>
  6. <script type="text/javascript" src="_js/jquery-ui-1.8.4.custom.min.js"></script>
  7. <script type="text/javascript">
  8. $(function() {
  9. $('#buscar_usuario').autocomplete({
  10. source: 'ajax.php',
  11. select: function (event, ui) {
  12. $('#resultados').slideUp('slow', function () {
  13. $('#resultado').html(
  14. '<h2>Detalhes</h2>' +
  15. '<strong>Matrícula: </strong>' + ui.item.value + '<br/>' +
  16. '<strong>Nome:</strong>' + ui.item.descricao + '<br/>' +
  17. '<strong>Tipo:</strong>' + ui.item.tipo + '<br/>' +
  18. '<strong>Data de Nascimento</strong>' + ui.item.nascimento + '<br/>' );
  19.  
  20. $('#resultados').slideDown('slow');
  21.  
  22.  
  23. </script>
  24. <title>TESTANDO O AUTOCOMPLETE</title>
  25. </head>
  26.  
  27. <body>
  28. <div id="buscar">
  29. <input type="text" id="buscar_usuario" name="buscar_usuario" />
  30. </div>
  31.  
  32. <div id="resultados">
  33.  
  34. </div>
  35.  
  36. </body>
  37. </html>
  38.  
  39. <?php
  40.  
  41. include_once 'usuarios.class.php';
  42.  
  43. $usuario = new Usuarios();
  44.  
  45. echo implode("|",$dados);
  46. ?>
  47.  
  48. <?php
  49. class Usuarios
  50. {
  51. public function __construct () {
  52. $dbhost = 'localhost';
  53. $dbuser = 'testes';
  54. $dbpass = 'testestestes';
  55. $dbname = 'testando';
  56.  
  57. mysql_connect($dbhost, $dbuser, $dbpass);
  58.  
  59. mysql_select_db ($dbname);
  60.  
  61. }
  62. public function buscarMatricula ($numMatricula) {
  63. $dados = array ();
  64.  
  65. $sql = "SELECT * FROM DBWEBCAD WHERE MATRIC LIKE '%$numMatricula%' OR DTADM LIKE '%$numMatricula%'";
  66.  
  67.  
  68. $resultado = mysql_query ($sql);
  69.  
  70. while ($row = mysql_fetch_array($resultado, MYSQL_ASSOC)){
  71. $dados [] = array ("value" => $row ['MATRIC'] . ' '.
  72. $row ['DTADM'],
  73. "descricao" => $row ['NOMESOCDEP'],
  74. "tipo" => $row ['TIPOSOC'],
  75. "nascimento" => $row ['DTNASC']);
  76. }
  77. return;
  78.  
  79. }
  80. }
  81. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement