Advertisement
Guest User

Untitled

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