function updpod() { include "../functions/db-connection.php"; include "../functions/cla-connection.php"; $conn = new cla_connection($hostname, $username, $password, $database); $id = $_REQUEST['idpod']; $sql = "DELETE FROM podcast WHERE id = {$id}"; $rs = $conn->query($sql, false); }
function populaGrid() { include "functions/db-connection.php"; include "functions/cla-connection.php"; $conn = new cla_connection($hostname, $username, $password, $database); $sql = "DELETE FROM podcast_temp;"; $rs = $conn->query($sql, false); $sql = "INSERT INTO podcast_temp (`id`,`descricao`,`nome_servidor`,`area`,`data`) (SELECT `id`,`descricao`,`nome_servidor`,`area`,`data` FROM podcast WHERE area IN (1) ORDER BY data DESC LIMIT 5 );"; $rs = $conn->query($sql, false); $sql = "INSERT INTO podcast_temp (`id`,`descricao`,`nome_servidor`,`area`,`data`) (SELECT `id`,`descricao`,`nome_servidor`,`area`,`data` FROM podcast WHERE area IN (2) ORDER BY data DESC LIMIT 5 );"; $rs = $conn->query($sql, false); $sql = "INSERT INTO podcast_temp (`id`,`descricao`,`nome_servidor`,`area`,`data`) (SELECT `id`,`descricao`,`nome_servidor`,`area`,`data` FROM podcast WHERE area IN (3) ORDER BY data DESC LIMIT 5 );"; $rs = $conn->query($sql, false); $sql = "SELECT `id`,`descricao`,`nome_servidor`,`area`,`data` FROM podcast_temp ORDER BY area, data DESC; "; $rs = $conn->query($sql, false); while ($dados = $conn->fetch_array($rs)) { $arrayRet[] = array("ID" => $dados['id'], "DESCRICAO" => utf8_encode($dados['descricao']), "ARQUIVO" => $dados['nome_servidor'], "DATA" => $dados['data'], "AREA" => $dados['area']); } print json_encode($arrayRet); }
<?php /** * @author Waldir Borba Junior * * 29/04/2008 - Waldir Borba Junior - Cointrole de contagem de download * **/ $podFile = $_REQUEST['file']; /* Contagem de download do Postcast //-----------------------------------------------------------------------------------*/ // Controle de quantas vezes foi feito download include "functions/db-connection.php"; include "functions/cla-connection.php"; $conn = new cla_connection($hostname, $username, $password, $database); $sql = "UPDATE podcast SET poddownload=(poddownload+1) WHERE nome_servidor = '" . $podFile . "'"; $rs = $conn->query($sql, false); // fim /* Dowbnload do Podcastg //-----------------------------------------------------------------------------------*/ // Download do Podcast $file = "podcast/" . $podFile; $type = "audio/mp3"; Header("Content-type: " . $type); Header("Content-Disposition: attachment; filename=" . $file); echo file_get_contents($file); // fim /* $file = "arquivo.exe"; header("Content-type: application/save"); header("Content-Length:".filesize($file)); header('Content-Disposition: attachment;