Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include_once 'usuarios.class.php';
- $usuario = new Usuarios();
- echo json_encode ($usuario->buscarMatric($_GET['term']));
- ?>
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <link type="text/css" rel="stylesheet" href="_css/jquery-ui-1.8.4.custom.css"/>
- <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 () {
- $ ('#resultados').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
- class Usuarios
- {
- public function __construct () {
- $dbhost = 'localhost';
- $dbuser = 'cnsmaxim_inezb';
- $dbpass = '514b2943';
- $dbname = 'cnsmaxim';
- 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