Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Código de um sistema de alerta:
> <?phpinclude "config.php";
header("Content-Type: text/html; charset=iso-8859-1");
$ip = $_SERVER["REMOTE_ADDR"];
$data = time();
?>
<?php
$sql = mysql_query("SELECT * FROM alerta WHERE data='$data'");
while($row=mysql_fetch_array($sql)){
$num = mysql_num_rows(mysql_query("SELECT * FROM alerta_mostrada WHERE alerta='$row[id]' AND ip='$ip'"));
if($num>0){
} else {
function strip_only($str, $tags) {
if(!is_array($tags)) {
$tags = (strpos($str, '>') !== false ? explode('>', str_replace('<', '', $tags)) : array($tags));
if(end($tags) == '') array_pop($tags);
}
foreach($tags as $tag) $str = preg_replace('#</?'.$tag.'[^>]*>#is', '', $str);
return $str;
}
$text = strip_only($row["texto"], array('p', 'em'));
?>
<script type="text/javascript" src="[http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js">](http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js)
<script type="text/javascript" src="[http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js">](http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js)
<link href="[http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css"](http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css) rel="stylesheet" type="text/css"/>
<script>
function fecha(id){
$("#alerta-"+id).fadeOut();
}
$(function(){
$(".alerta").draggable({ handle: '#cima' });
});
</script>
<div id="alerta-<?php echo $row["id"];?>" style="width:282px;position:fixed;z-index:999999" class="alerta">
<div id="cima" style="cursor:move;background:url(cim.png) no-repeat;width:282px;height:30px;">
<div id="fecha" onClick="fecha('<?php echo $row["id"];?>')" style="cursor:pointer;background:url(fechar.png) no-repeat;width:13px;height:14px;float:right;opacity:0.6;margin-top:6px;margin-right:10px;"></div>
</div>
<div id="meio_alerta" style="background:url(meio.png) repeat-y;width:282px;">
<div style="max-width:260px;word-wrap:break-word;font-family:arial;font-size:13px;color:#000;padding-left:10px;"><?php echo $text;?></div>
<div onClick="fecha('<?php echo $row["id"];?>')" onmouseover="this.style.opacity=1" onmouseout="this.style.opacity=0.5" id="ok" style="background:url(ok.gif) no-repeat;cursor:pointer;margin:0 auto;opacity:0.5;width:50px;height:22px;"></div>
</div>
<div id="fim" style="background:url(baixo.png) no-repeat;width:282px;height:16px;"></div>
</div>
<?
$dell = mysql_query("INSERT INTO alerta_mostrada(alerta, ip) VALUES ('$row[id]', '$ip')");
}
}
?>
Erro: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hitshab1/public_html/alrt/recebe_alerta.php on line 10
Não sei o que fazer me ajudem!
Carregando comentários...