Problema com campo de pesquisar usuário dentro de tabs
Problema com campo de pesquisar usuário dentro de tabs
Note que no prin screen que eu fiz acontece um erro
do segundo usuário em diante ele da conflito.
Administração
<? include "dbconfig.php"; ?>
<? include "admin/includes/funcoes_importantes.php";?>
<html>
<head>
<title><?=@mysql_result(mysql_query("SELECT escritorio FROM configuracao"),0,escritorio)?></title>
<meta charset="UTF-8">
<link href="estilo.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="admin/css/demo.css">
<link rel="stylesheet" href="admin/css/font-awesome.css">
<link rel="stylesheet" href="admin/css/form_cadastro.css">
<link rel='stylesheet' type='text/css'href='admin/css/timepicki.css'/>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/2.2.3/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="js/jquery.mCustomScrollbar.css">
<script src="js/jquery.mCustomScrollbar.concat.min.js"></script>
<!-- use jssor.slider.mini.js (40KB) instead for release -->
<!-- jssor.slider.mini.js = (jssor.js + jssor.slider.js) -->
<script type="text/javascript" src="js/jssor.js"></script>
<script type="text/javascript" src="js/jssor.slider.js"></script>
</head>
<script language="JavaScript">
function AbreFecha(showHideDiv, switchImgTag) {
var ele = document.getElementById(showHideDiv);
var imageEle = document.getElementById(switchImgTag);
if(ele.style.display == "block") {
ele.style.display = "none";
imageEle.innerHTML = '<img src="imagens/fechado.png">';
}
else {
ele.style.display = "block";
imageEle.innerHTML = '<img src="imagens/aberto.png">';
}
}
</script>
<script language="JavaScript">
function pergunta()if (confirm('Confirma exclusão?')) { return true }
else { return false }
}
</script>
<link rel="stylesheet" href="css/jquery-ui.css">
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<style type="text/css"> margin: 0;
padding: 0;
}
#tabs {
font-size: 90%;
margin: 20px 0;
} float: left;
background: #fff;
width: 1000px;
padding-top: 10px;
} margin-right:3px;
list-style: none;
} list-style: none;
} display: inline;
} float: left;
}border-top:1px #5DBBFF solid;
background: #D5D5D5;
} color: #333333;
} background: #D5D5D5;
clear: both;
float:left;
min-height: 200px;
} margin-bottom: 12px;
} line-height: 150%;
} text-decoration: none;
padding: 8px;
color: #000;
font-weight: bold;
}
.thumbs {
float:left;
border:#000 solid 1px;
margin-bottom:20px;
margin-right:20px;
}</style>
<body class="bg-cyan">
<? include ("topo.php"); ?>
<div style="clear:both;"></div>
<div id="separador_centralizar">
<div id="titulo_pagina_pequena"><b>Buscar <b style="color:#F00;">Usuários</b> </div>
</div>
<div id="busca_fundo">
<div class="center">
<div id="busca_fundo_pesquisa">
<form method="get" action="administradores.php" style="background:transparent">
<input type="text" class="busca" id="busca" name="busca" value="" placeholder="Buscar Usuários" />
<input type="submit" class="botao_busca" value="" title="Pesquisar" />
</form>
<div style=" float:left;width:300px; margin-left:50px; margin-top:12px;"><?php echo 'Buscando Usuários: <b>'.$_GET['busca'].'</b>';?></div>
</div>
<div style="clear:both;"></div>
<?php
$Excluir = $_GET['Excluir'];
$id = $_GET['id'];
if ($Excluir == "ok") {
if ($superadmin != $_SESSION[nivel]) {
echo "<div class='no' align='center'>Espertinho você não tem permissão para <b>(EXCLUIR USUÁRIOS)</b></div>";
header('Refresh: 5; url= administradores.php');mysql_query("DELETE FROM administracao WHERE id_adm=$id");
echo "<div class='ok' align='center'>Usuário Excluido com Sucesso</b></div>";
header('Refresh: 5; url= administradores.php');
}
}
?>
<?php
$get = $_GET['busca'];
$pagina = $_GET['pagina'];
// DEFINA AQUI O LIMITE DE RESULTADOS POR PÁGINA
$inicio = 0;
$limite = 5;
if($get == ""){ $get == 'Select * From administracao';}
if($pagina != ''){ $inicio = ($pagina - 1) * $limite;}
$sqlContar = mysql_query("SELECT * FROM administracao
WHERE login LIKE '$get%'OR nome LIKE '%$get%'
OR email LIKE '%$get%'
OR telefone LIKE '%$get%'
OR celular LIKE '%$get%'
ORDER BY id_adm ASC") or die("Erro ao consultar");
$total = mysql_num_rows($sqlContar);
if($get != 'Æ'){
echo '<div class="info">Resultados: <b>'.$total.'</b> - Buscando Usuários: <b>'.$_GET['busca'].'</b> </div>';
}
$sql = mysql_query("SELECT * FROM administracao
WHERE login LIKE '$get%'OR nome LIKE '%$get%'
OR email LIKE '%$get%'
OR telefone LIKE '%$get%'
OR celular LIKE '%$get%'
ORDER BY id_adm ASC LIMIT $inicio, $limite") or die("Erro ao consultar");
while($res = mysql_fetch_array($sql)){
?>
<script>
$(function() {
$( "#tabs, #tabs2" ).tabs();
});
</script>
<div style="clear:both;"></div>
<div id="tabs">
<ul>
<li><a href="#tabs-Perfil">Perfil</a></li>
<li><a href="#tabs-Noticias">Noticias</a></li>
<li><a href="#tabs-Imagens">Imagens</a></li>
<li><a href="#tabs-Videos">Videos</a></li>
</ul>
<span style="float:left; margin-top:1px; padding:9px; width:1014px; background:#D5D5D5; border:1px solid #BFCCFF;">
<span style="font-size:14.5px"><span style="margin-right:10px;"><i title="Usuário" class="icon-prepend fa fa-user " style="font-size:14px;"></i><span style="color:#81A2E7;"><?php echo $res[login]?></span></span><span style="margin-right:10px;"> <i title="Nome" class="icon-prepend fa fa-info" style="font-size:14px;"></i><?php echo $res[nome]?></span> <i title="ID" class="icon-prepend fa fa-tags" style="font-size:14px;"></i><?php echo $res[id_adm]?> </span>
<?php if ($superadmin != $_SESSION[nivel]) {
echo ""/*Sem Permissão*/;
?>
<? }else{ ?>
<span style="float:right; width:20px; height:20px;">
<a href="?Excluir=ok&id=<?=$res[id_adm]?>" onClick="return pergunta();"> <i title="Excluir Usuário:<?=$res[nome]?> " class="icon-prepend fa fa-times" style="font-size:14px;color:#FF0000;"></i> </a>
</span>
<span style="float:right; width:20px; height:20px;">
<a href="conta_editar_adm.php?acao=Alterar&id=<?=$res[id_adm]?>"><i title="Editar Usuário:<?=$res[nome]?> " class="icon-prepend fa fa-pencil-square-o" style="font-size:14px;color:#0000FF;"></i></a>
</span>
<?php } ?>
</span>
<div id="tabs-Perfil">
<?php include "includes/tabs/perfil.php"; ?>
</div>
<div id="tabs-Noticias">
<?php include "includes/tabs/noticias.php"; ?>
</div>
<div id="tabs-Imagens">
<?php include "includes/tabs/imagens.php"; ?>
</div>
<div id="tabs-Videos">
<?php include "includes/tabs/videos.php"; ?>
</div>
</div>
<?php }?>
</div> </div>
<div style="clear:both;"></div>
<div id="paginacao_fundo">
<div id="paginacao_center">
<?php
$prox = $pagina + 1;
$ant = $pagina - 1;
$ultima_pag = ceil($total / $limite);
$penultima = $ultima_pag - 1;
$adjacentes = 2;
echo '<div class="paginacao" style="margin-bottom:20px;">';
if ($pagina>1)
{
$paginacao = '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$ant.'" style="margin-right:10px;background-color:#FF0004;"> « </a>';
}
if ($ultima_pag <= 5) for ($i=1; $i< $ultima_pag+1; $i++)
{
if ($i == $pagina)
{
$paginacao .= '<a class="atual" href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$i.'">'.$i.'</a>';
} else {
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$i.'">'.$i.'</a>';
}
}
}
if ($ultima_pag > 5) if ($i == $pagina)
{
$paginacao .= '<a class="atual" href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$i.'">'.$i.'</a>';
} else {
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$i.'">'.$i.'</a>';
}
}
$paginacao .= '...';
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$penultima.'">'.$penultima.'</a>';
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$ultima_pag.'">'.$ultima_pag.'</a>';
}
elseif($pagina > (2 * $adjacentes) && $pagina < $ultima_pag - 3)
{
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina=1">1</a>';
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina=2">2</a> ... ';
for ($i = $pagina-$adjacentes; $i<= $pagina + $adjacentes; $i++)
{
if ($i == $pagina)
{
$paginacao .= '<a class="atual" href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$i.'">'.$i.'</a>';
} else {
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$i.'">'.$i.'</a>';
}
}
$paginacao .= '...';
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$penultima.'">'.$penultima.'</a>';
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$ultima_pag.'">'.$ultima_pag.'</a>';
}
else {
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina=1">1</a>';
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina=2">2</a> ... ';
for ($i = $ultima_pag - (4 + (2 * adjacentes)); $i <= $ultima_pag; $i++)
{
if ($i == $pagina)
{
$paginacao .= '<a class="atual" href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$i.'">'.$i.'</a>';
} else {
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$i.'">'.$i.'</a>';
}
}
}
}
if ($prox <= $ultima_pag && $ultima_pag > 2)
{
$paginacao .= '<a href="'.$_SERVER['PHP_SELF'].'?busca='.$get.'&pagina='.$prox.'" style="margin-left:10px;background-color:#318C00;"> » </a>';
}
echo $paginacao;
echo '</div>';
?>
</div></div>
<div style="clear:both;"></div>
<? include ("admin/rodape_site.php"); ?>
</body>
</html>Notícias pasta Include Tabs
<?php
$id_adm = $res[id_adm];
$id_adm;
?>
<input id="id_dono" type="hidden" value="<?php echo $id_adm ?>">
<script>
$(document).ready(function(){
$('#pesquisar_noticias').keyup(function(){
var txt = $(this).val();
if(txt != '')
{
$.ajax({
url:"includes/tabs/res/noticias.php",
method:"post",
data:'search='+ $(this).val()+'&id_dono='+ $('#id_dono').val(),
dataType:"text",
success:function(data)
{
$('#noticias').html(data)
}
});
}
});
});
</script>
<style></style>
<input type="text" name="pesquisar_noticias" id="pesquisar_noticias" placeholder="Pesquisar Notícias" class="buscaMais"/>
<div id="noticias"><?php
include "dbconfigTabs.php";
$sqlNoti = "SELECT * FROM noticias WHERE id_dono=$res[id_adm]";
$resultadoNoti = mysqli_query($connectTabs,$sqlNoti);
?>
<code style="background:#F7F5EA; width:100%; padding:3px; margin-bottom:10px; float:left; font-size:12px ; ">
Total Notícias Encontradas: <span style="font-weight:bold; font-size:12px; color:#A28201;"><?php $notiTotal = mysqli_num_rows($resultadoNoti);
echo $notiTotal;?></span>
</code>
<?while($noti = mysqli_fetch_array($resultadoNoti))
{
?>
<span style="width:1000px; float:left;height:20px; margin-bottom:35px;">
<code style="float:left; width:50px; margin-left:10px;" title="<?php echo $noti[imagem];?>">
<a href="<? echo 'admin/'.$noti[imagem]?>" target="_blank"><i class="icon-prepend fa fa-file-image-o" title="Data"></i></a>
</code>
<code style="float:left; width:250px; color:#B94242; margin-left:10px; " title="<?php echo $noti[titulo];?>">
<i class="icon-prepend fa fa-map-o" title="Nome da Imagem"></i> <?php echo substr($noti[titulo],0,30).' ...';?>
</code>
<code style="float:left; height:20px; margin-left:15px; ">
<i class="icon-prepend fa fa-calendar-o" title="Data"></i> <? echo $noti[data]?>
</code>
<code style="float:left; height:20px; margin-left:15px; ">
<i class="icon-prepend fa fa-bullhorn" title="Link"></i><a href="<? echo $noti[fonte]?>" target="_blank" style="text-decoration:none; color:#1A00FB;"> LINK </a>
</code>
<code style="float:left; height:20px; margin-left:15px; ">
<a href="noticiasver.php?<? echo $noti[id_noticia];?>" target="_blank" style="text-decoration:none; color:#FB0000;"><i class="icon-prepend fa fa-remove" title="Excluir"></i> </a>
</code>
</span><?
}
}
else
{
echo 'Nenhuma Notícia';
}
?> </div>
<code style=" float:right;font-size:12px ; ">
Total Notícias: <span style="font-weight:bold; font-size:12px; color:#A28201;"><?php $notiTotal = mysqli_num_rows($resultadoNoti);
echo $notiTotal;?></span>
</code>Notícias dentro da pasta Include / Tabs / Res /
<? include "../../../dbconfigTabs.php"; ?>
<?php
$searchNoti = $_POST["search"];
$id_admo = $_POST["id_dono"];
$sqlNoti = "SELECT * FROM noticias WHERE id_dono=$id_admo and titulo LIKE '%$searchNoti%'";
$resultadoNoti = mysqli_query($connectTabs,$sqlNoti);
?>
<code style="background:#F7F5EA; width:100%; padding:3px; margin-bottom:10px; float:left; font-size:12px ; ">
Total Notícias Encontradas: <span style="font-weight:bold; font-size:12px; color:#A28201;margin-right:25px;"><?php $notiTotal = mysqli_num_rows($resultadoNoti);
echo $notiTotal;?></span> Buscando Por: <span style="font-weight:bold; font-size:12px; color:#A28201;margin-right:25px;"> <?php echo $_POST["search"]; ?> </span>
</code>
<?while($noti = mysqli_fetch_array($resultadoNoti))
{
?>
<span style="width:1000px; float:left;height:20px; margin-bottom:35px;">
<code style="float:left; width:50px; margin-left:10px;" title="<?php echo $noti[imagem];?>">
<a href="<? echo 'admin/'.$noti[imagem]?>" target="_blank"><i class="icon-prepend fa fa-file-image-o" title="Data"></i></a>
</code>
<code style="float:left; width:250px; color:#B94242; margin-left:10px; " title="<?php echo $noti[titulo];?>">
<i class="icon-prepend fa fa-map-o" title="Nome da Imagem"></i> <?php echo substr($noti[titulo],0,30).' ...';?>
</code>
<code style="float:left; height:20px; margin-left:15px; ">
<i class="icon-prepend fa fa-calendar-o" title="Data"></i> <? echo $noti[data]?>
</code>
<code style="float:left; height:20px; margin-left:15px; ">
<i class="icon-prepend fa fa-bullhorn" title="Link"></i><a href="<? echo $noti[fonte]?>" target="_blank" style="text-decoration:none; color:#1A00FB;"> LINK </a>
</code>
<code style="float:left; height:20px; margin-left:15px; ">
<a href="noticiasver.php?<? echo $noti[id_noticia];?>" target="_blank" style="text-decoration:none; color:#FB0000;"><i class="icon-prepend fa fa-remove" title="Excluir"></i> </a>
</code>
</span><?
}
}
else
{
echo "<center><span style='padding:30px; background-color:#FFE2C1; position:relative; top:120; '>"."Nenhuma Notícia Encontrada"."</span></center>";
}
?>Discussão (0)
Carregando comentários...