<?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(); }
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'); }