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 saveData()
{
include "../functions/db-connection.php";
include "../functions/cla-connection.php";
$conn = new cla_connection($hostname, $username, $password, $database);
$fileName = basename($_REQUEST['fileToUpload']);
$area = $_REQUEST['area'];
$descri = $_REQUEST['txDescri'];
$data = date("Y-m-d H:i:s");
// INSERT
$result = $conn->insert("podcast", array("descricao,arquivo,area,data"), array("'{$descri}','{$fileName}',{$area},'{$data}'"));
//echo $result;
//exit;
$arrayRet['msg'] = $result;
print json_encode($arrayRet);
}
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);
}
// Caminho de onde a imagem ficará
$file_dir = $config["diretorio"] . $file_name;
// Faz o upload da imagem
move_uploaded_file($arquivo["tmp_name"], $file_dir);
$file_path = $file_name;
} else {
echo "<h1>" . $erro[0] . "</h1>";
exit;
}
/*
echo "<br>";
echo "Original : " . $arquivo['name'] . "<br>";
echo "Servidor : " . $file_path . "<br>";
echo "Path ....: " . $file_dir . "<br>";
echo "EXT .....: " . $ext[1];
*/
include "../functions/db-connection.php";
include "../functions/cla-connection.php";
$conn = new cla_connection($hostname, $username, $password, $database);
$nome_original = $arquivo['name'];
$nome_servidor = $file_path;
$ext = $ext[1];
$area = $_REQUEST['area'];
$descri = $_REQUEST['txDescri'];
$data = date("Y-m-d H:i:s");
// INSERT
$result = $conn->insert("podcast", array("descricao,nome_servidor,nome_original,ext,area,data"), array("'{$descri}','{$nome_servidor}','{$nome_original}','{$ext}',{$area},'{$data}'"));
$ret = array();
$ret['RETORNO'] = $result;
print json_encode($ret);
}
<?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;
