Esempio n. 1
0
<?php

$useragent = $_SERVER['HTTP_USER_AGENT'];
if (preg_match('/(android|bb\\d+|meego).+mobile|avantgo|bada\\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i', $useragent) || preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\\-(n|u)|c55\\/|capi|ccwa|cdm\\-|cell|chtm|cldc|cmd\\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\\-s|devi|dica|dmob|do(c|p)o|ds(12|\\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\\-|_)|g1 u|g560|gene|gf\\-5|g\\-mo|go(\\.w|od)|gr(ad|un)|haie|hcit|hd\\-(m|p|t)|hei\\-|hi(pt|ta)|hp( i|ip)|hs\\-c|ht(c(\\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\\-(20|go|ma)|i230|iac( |\\-|\\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\\/)|klon|kpt |kwc\\-|kyo(c|k)|le(no|xi)|lg( g|\\/(k|l|u)|50|54|\\-[a-w])|libw|lynx|m1\\-w|m3ga|m50\\/|ma(te|ui|xo)|mc(01|21|ca)|m\\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\\-2|po(ck|rt|se)|prox|psio|pt\\-g|qa\\-a|qc(07|12|21|32|60|\\-[2-7]|i\\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\\-|oo|p\\-)|sdk\\/|se(c(\\-|0|1)|47|mc|nd|ri)|sgh\\-|shar|sie(\\-|m)|sk\\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\\-|v\\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\\-|tdg\\-|tel(i|m)|tim\\-|t\\-mo|to(pl|sh)|ts(70|m\\-|m3|m5)|tx\\-9|up(\\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\\-|your|zeto|zte\\-/i', substr($useragent, 0, 4))) {
    header('Location: mobile.php');
}
include "conexao_db.php";
$mysql = new conexao();
$listanoticia = $mysql->sql_query("SELECT * FROM noticia where status in (1,2) order by data desc");
$desconecta;
?>
<html lang="pt-br">
 <head>
 <title>Not&iacutecias</title>
 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
 <link rel="STYLESHEET" type="text/css" href="estilos.css">
 
 <script>
 function mostraOculta(quem){
   quem = quem.parentNode.getElementsByTagName('div')[0];
   if(quem.style.display=='none'){
	 quem.style.display='block';
   }else{
	 quem.style.display='none';
   }
 }
 </script>

 
 </head>
Esempio n. 2
0
    $status = $_POST['status'];
} else {
    $status = '';
}
$imagem = $_FILES["imagem"];
if ($imagem != NULL) {
    $nomeFinal = time() . '.jpg';
    if (move_uploaded_file($imagem['tmp_name'], $nomeFinal)) {
        $tamanhoImg = filesize($nomeFinal);
        $mysqlImg = addslashes(fread(fopen($nomeFinal, "r"), $tamanhoImg));
        unlink($nomeFinal);
    }
}
$mysql = new conexao();
$consulta = "SELECT count(*) existe\n   \t\t       FROM noticia n\n\t\t      WHERE n.titulo='" . $titulo . "'";
$listanoticia = $mysql->sql_query($consulta);
$desconecta;
$resultado = mysql_fetch_object($listanoticia);
if ($resultado->existe > 0) {
    if ($alterar == 'N') {
        header("Location: cpanel.php?erro=1&tit={$titulo}");
    } elseif ($alterar == 'S') {
        $alterar = "UPDATE noticia SET resumo = '" . $resumo . "', descricao = '" . $desc . "', imagem = '" . $mysqlImg . "', status = " . $status . " WHERE titulo = '" . $titulo . "'";
        $alteranoticia = $mysql->sql_query($alterar);
        header("Location: cpanel.php");
    }
} else {
    $inserir = "insert into noticia values('" . $titulo . "','" . $resumo . "','" . $desc . "','" . $mysqlImg . "'," . $status . ",sysdate())";
    $listanoticia = $mysql->sql_query($inserir);
    header("Location: cpanel.php?erro=2");
}
Esempio n. 3
0
$desconecta;
$erro = '';
$val_titulo = '';
$val_resumo = '';
$val_desc = '';
$alterar = 'N';
$val_status = '';
if (isset($_GET['erro'])) {
    if ($_GET['erro'] == '0') {
        $erro = "<label class='erro'>Favor informar todos os campos para criar uma nova Not&iacutecia!</label>";
    } elseif ($_GET['erro'] == '1') {
        $erro = "<label class='erro'>Not&iacutecia j&aacute Existe! Para alterar modifique as informa&ccedil;&atilde;es acima e clique em Gravar.</label>";
        $alterar = 'S';
        $tit = $_GET['tit'];
        $mysql = new conexao();
        $listainforma = $mysql->sql_query("SELECT n.titulo\n                                              ,n.resumo\n\t\t\t\t         \t\t  \t\t\t   ,n.descricao\n\t\t\t\t\t\t         \t\t\t   ,DATE_FORMAT(n.data,'%d/%m/%Y %H:%i:%s') data\n\t\t\t\t\t\t\t\t\t           ,case n.status\n\t\t\t\t\t\t\t\t\t              when 0 then 'Remover Notícia'\n\t\t\t\t\t\t\t\t\t              when 1 then 'Visivel no Site e Mobile'\n\t\t\t\t\t\t\t\t\t\t\t      when 2 then 'Visivel apenas no Site'\n\t\t\t\t\t\t\t\t\t\t\t      when 3 then 'Visivel apenas no Mobile'\n\t\t\t\t\t\t\t\t\t            end as status\n\t\t\t\t\t\t\t\t            FROM noticia n\n\t\t\t\t\t\t\t\t           WHERE n.titulo ='" . $tit . "'");
        $desconecta;
        while ($result = mysql_fetch_object($listainforma)) {
            $result->data;
            $val_titulo = $result->titulo;
            $val_resumo = $result->resumo;
            $val_desc = $result->descricao;
            $val_status = $result->status;
        }
    } elseif ($_GET['erro'] == '2') {
        $erro = "<label class='erro'>Not&iacutecia Cadastrada!</label>";
    }
}
?>
<html>
 <head>
Esempio n. 4
0
<?php

include "conexao_db.php";
$mysql = new conexao();
$titulo = $_GET["titulo"];
$lista = $mysql->sql_query("SELECT imagem FROM noticia where titulo = '" . $titulo . "'");
$resultado = mysql_fetch_object($lista);
$desconecta;
Header("Content-type: image/gif");
echo $resultado->imagem;