Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <script type="text/javascript" src="_js/jquery-1.4.2.min.js"></script>
- <script type="text/javascript" src="_js/jquery-ui-1.8.4.custom.min.js"></script>
- <script type="text/javascript">
- $(function() {
- $('#buscar_usuario').autocomplete({
- source: 'ajax.php',
- select: function (event, ui) {
- $('#resultados').slideUp('slow', function () {
- $('#resultado').html(
- '<h2>Detalhes</h2>' +
- '<strong>Matrícula: </strong>' + ui.item.value + '<br/>' +
- '<strong>Nome:</strong>' + ui.item.descricao + '<br/>' +
- '<strong>Tipo:</strong>' + ui.item.tipo + '<br/>' +
- '<strong>Data de Nascimento</strong>' + ui.item.nascimento + '<br/>' );
- $('#resultados').slideDown('slow');
- </script>
- <title>TESTANDO O AUTOCOMPLETE</title>
- </head>
- <body>
- <div id="buscar">
- <input type="text" id="buscar_usuario" name="buscar_usuario" />
- </div>
- <div id="resultados">
- </div>
- </body>
- </html>
- <?php
- include_once 'usuarios.class.php';
- $usuario = new Usuarios();
- echo implode("|",$dados);
- ?>
- <?php
- class Usuarios
- {
- public function __construct () {
- $dbhost = 'localhost';
- $dbuser = 'testes';
- $dbpass = 'testestestes';
- $dbname = 'testando';
- mysql_connect($dbhost, $dbuser, $dbpass);
- mysql_select_db ($dbname);
- }
- public function buscarMatricula ($numMatricula) {
- $dados = array ();
- $sql = "SELECT * FROM DBWEBCAD WHERE MATRIC LIKE '%$numMatricula%' OR DTADM LIKE '%$numMatricula%'";
- $resultado = mysql_query ($sql);
- while ($row = mysql_fetch_array($resultado, MYSQL_ASSOC)){
- $dados [] = array ("value" => $row ['MATRIC'] . ' '.
- $row ['DTADM'],
- "descricao" => $row ['NOMESOCDEP'],
- "tipo" => $row ['TIPOSOC'],
- "nascimento" => $row ['DTNASC']);
- }
- return;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement