if ($pesquisa != "") { $sql = "select * from ejbsm_usuario where permissao = 'usuario' and login like '%{$pesquisa}%' or nome like '{$pesquisa}%'"; } elseif (isset($_GET["inicio_consulta"])) { $inicio_consulta = $_GET["inicio_consulta"]; $sql = "select * from ejbsm_usuario where permissao = 'usuario' order by login limit 10 offset {$inicio_consulta}"; } else { $sql = "select * from ejbsm_usuario where permissao = 'usuario' order by login limit 10;"; } $qr = $link->query($sql) or die(mysqli_error($link)); $j = 0; while ($r = mysqli_fetch_object($qr)) { ?> <tr> <td> <?php Imagem($r->login, 80); ?> </td> <td><?php echo "{$r->nome}"; ?> </td> <td><?php echo "{$r->login}"; ?> </td> <td><?php echo "{$r->celular}"; ?> </td> <td><?php
</span></b></font> </span> </a> <ul> <li class='has-sub'> <a> <?php $sql_respostas = "select * from ejbsm_batepapo_resposta where id_mensagem = '{$r->id}' order by id asc limit 10;"; $qr_respostas = $link->query($sql_respostas); while ($resposta = mysqli_fetch_object($qr_respostas)) { ?> <table class="table"> <tr> <td rowspan='2' style="width: 40px"> <?php Imagem($resposta->login, 50); ?> </td> <td> dia <font color="green"><b><?php echo "{$resposta->data}"; ?> </b></font> </td> <td> as <font color="green"><b><?php echo "{$resposta->hora}"; ?> </b></font> </td> <?php
<br>Caso sua imagem não se altere, recarregue a página. <!-- Modal --> <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title" id="myModalLabel">Alterar imagem (max 2mb)</h4> </div> <div class="modal-body" style="margin-left: 20px"> <?php Imagem($user_login, 200); ?> <input type="file" class="form-control" name="arquivo" required> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Cancelar </button> <button type="submit" class="btn btn-success" value="Alterar imagem" name="opcao"> <span class="glyphicon glyphicon-camera"></span> Alterar imagem </button> </div> </div> </div> </div>
} $sql = "select * from ejbsm_usuario, ejbsm_integrante where permissao = 'bolsista' and status='Inativo' AND ejbsm_integrante.login=ejbsm_usuario.login ORDER by status;"; $qr = $link->query($sql); while ($bolsista = mysqli_fetch_object($qr)) { ?> <br><br> <div id='cssmenu' style='box-shadow: 1px 1px 5px 1px #c9302c;'> <ul> <li class='active has-sub'> <a> <span> <table> <tr> <td rowspan="3" style="width: 15%;" colspan="2"> <?php Imagem($bolsista->login, 80); ?> </td> <td style="width: 35%;"><b>Nome: </b><?php echo "{$bolsista->nome}"; ?> </td> <td style="width: 25%;"><b>Login: </b><?php echo "{$bolsista->login}"; ?> </td> <td style="width: 35%;"><b>E-mail: </b><?php echo "{$bolsista->email}"; ?> </td> </tr>
<?php } $result = $link->query($consulta); while ($topico = mysqli_fetch_object($result)) { $sql = "select nome from ejbsm_forum_area where id = {$topico->id_area}"; $pega_nome = mysqli_fetch_object($link->query($sql)); $nome_area = $pega_nome->nome; $sql = "select nome from ejbsm_forum_subarea where id = {$topico->id_subarea}"; $pega_nome = mysqli_fetch_object($link->query($sql)); $nome_subarea = $pega_nome->nome; ?> <div class="alert alert-info"> <div class="media-left"> <a href="#"> <?php Imagem($topico->login, 40); ?> </a> </div> <div class="media-body"> <h4 class="media-heading"><?php echo $topico->assunto; ?> </h4> <font color="green" style="margin-left: 10px;"><b> ID </b></font><?php echo $topico->id; ?> . <font color="green"><b>Por </b></font> <a href="forum_info.php?info=login&login=<?php
echo $login; ?> </h3> <div class="alert <?php if ($row->status == "Ativo") { } else { echo "alert-danger"; } ?> " role="alert"> <table> <tr> <td rowspan="7" style="width: 210px"> <?php Imagem($row->login, 100); ?> </td> <td> Nome: <?php echo $row->nome; ?> <br> </td> </tr> <tr> <td> Permissões: <?php echo $row->permissao; ?> <br>