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;
