Пример #1
0
<?php

//header( "Content-type: image/jpeg");
include 'sessao.php';
$db = Atalhos::getBanco();
if ($query = $db->prepare("SELECT imagem FROM tbImagem WHERE idUser = ?")) {
    $query->bind_param('i', $_GET["idUser"]);
    $query->execute();
    $query->bind_result($imagem);
    if ($query->fetch()) {
        echo $imagem;
    } else {
        echo file_get_contents("img/sem-imagem-avatar.jpg");
    }
    $query->close();
    $db->close();
}
Пример #2
0
 public static function excluirPubli()
 {
     $db = Atalhos::getBanco();
     if ($query = $db->prepare("DELETE FROM tbPublicacao WHERE idPubli = ?")) {
         $query->bind_param('i', $_POST['req1']);
         $query->execute();
         $query->close();
         $_SESSION['publiExc'] = 1;
     }
     shell_exec('cd publicacoes/ && rm ' . $_POST['req1'] . '.pdf');
 }