Теглене

  • Автор Автор Anonymous
  • Начална дата Начална дата
A

Anonymous

Guest
Немога да направя файла за теглене на видео
 
еми аз си правя сайт и незнам как да нпаравя файловете да си теглят от mysql baza danni
 
Това е кода с извеждането но видео но незнам как да направя и да си тегли

Код:
<?php
session_start();
require "config.php";
include_once '../common.php';
$username = $_SESSION['username'];
?>
<html>
<head><title>Филми</title>
<link rel="stylesheet" href="http://localhost/Maxell.bg/style/filmi.css" type="text/css" />
</head>
<body>
<img  class="logo"src="../logo.jpg"/>
<div class="login"><br/>
<a href="login/login.php">Влез</a><br/>
<a href="login/register.php">Регистрирай се</a>
<a  class="uplo" href="Upload/upload.php">Upload</a>
</div>
<div class="ezik">
<?php echo LANG_LANGUAGE; ?>
<a href='danni.php?lang=bg'><img src='bg_icon.gif' /></a>
<a href='danni.php?lang=en'><img src='en_icon.gif' /></a>
</div>
<div class="webfilm">
<div align="center">
<div class="movies">
<a href="ijasi.html"target="_blank" >Ужаси</a>
<a href="action.html"target="_blank" >Екшън</a>
<a href="trilur.html"target="_blank" >Трилър</a>
<a href="kriminalen.html" target="_blank">Криминален</a>
<a href="comedy.html" target="_blank">Комедия</a>
<a href="musicul.html" target="_blank">Мюзикъл</a>
<a href="fantastika.html" target="_blank">Фантастика</a>
<a href="fentusi.html" target="_blank">Фентъзи</a>
<a href="priklu4enski.html" target="_blank">Приключенски</a>
</div>
</div>
<div align="center">
<div class="movies1">
<a href="romantic.html" target="_blank">Романтичен</a>
<a href="parodia.html" target="_blank">Пародия</a>
<a href="animacia.html" target="_blank">Анимация</a>
<a href="erotic.html" target="_blank">Еротичен</a>
<a href="istoricheski.html" target="_blank">Исторически</a>
<a href="documentalen.html" target="_blank">Документален</a>
<a href="drama.html" target="_blank">Драма</a>
<a href="bulgarski.html" target="_blank">Български</a>
</div>
</div>
</div>
<div class="maxell">
<?php
include "search.php";
?>
</div>
<div class="padmenu">
<div class="text1" <label>От категория:</label></div>
<select name="selecter" size="1"/>
<optgroup label='Филми'><option selected value='14'>Филми/XviD</option>
<option value="optioner2">Филми/DVD-R</option>
<option value="optioner3">Филми/HDTV</option>
<option value="optioner4">Филми/x264</option>
<option value="optioner5">Филми/TV-episodes</option>
<option value="optioner6">Филми/TV-Boxset</option>
<option value="optioner7">Филми/Anime&Manga</option>
<option value="optioner8">Филми/Documentaries</option>
<option value="optioner9">Филми/Blu-ray</option>
<option value="optioner10">Weekend Cinema</option>
<optgroup label='Музика'><option selected value='14'>Музика/MP3</option>
<option value="music">Музика/FLAC</option>
<option value="music1">Музика/APE</option>
<option value="music2">Музика/DTS</option>
<option value="music3">Музика/WavPack</option>
<option value="music4">Музика/Video</option>
<option value="music5">Музика/DVD</option>
<option value="music6">Музика/OST</option>
<optgroup label='Software'><option selected value='14'>Software/PC-ISO</option>
<option value="Software1">Software/други</option>
<option value="Software2">Software/Tutorial</option>
<optgroup label='Игри'><option selected value='14'>Игри/PC-ISO</option>
<option value="games3">Игри/PC-RIP</option>
<option value="games4">Игри/PS2</option>
<option value="games5">Игри/PSP</option>
<option value="games">Игри/XBOX</option>
<option value="games6">Игри/XBOX-360</option>
<input type="submit" value="Търсене"/>
</div>
</div>
</form>

</body>
</html>
<link rel="stylesheet" href="http://localhost/Maxell.bg/style/player.css" type="text/css" />
<meta http-equiv rel="Content-Type" content="text/html" charset="windows-1251"/>
<iframe src=http://ads.zamunda.net/left-banner.php frameborder=0 scrolling=no width=120 height=490 align=middle style="padding: 0px;"></iframe>
<?php
$result = mysql_query("SELECT * FROM klipove ORDER BY id DESC") or die (mysql_error());
$pic=1024;
echo "<table align='center' width = '65%' style = 'margin-top: -400px;'><br />";
while($data = mysql_fetch_assoc($result)) {
$title=$data['title'];
$pic=$data['pic'];
$avtor=$data['avtor'];
$opisanie=$data['opisanie'];
$klip=$data['file'];
echo "<tr> 
<td style='border: 5px solid #999; background: #ccc; font-weight: bold;'>Заглавие: $data[title]</td>
</tr>
<tr>
<td style='border: 5px solid #999;'><img src='pictures/$pic' width='240px' height='320px' /></td>
</tr>
<tr>
<td style='border: 5px solid #999;'>Субтитри: <a href='dfdff.php'>$data[sub]</a></td>
</tr>
<tr>
<td><p>Описание:<hr width='200px' style=' border:5px solid red; margin-top:-10px; margin-left:-320px;' /><h3 style=' margin-left: 250px; margin-top:-5px;'>$data[opisanie]</h3></p></td>
</tr>
<tr>
<td align='right' style='border: 5px solid #999;'><a href='video/vij.php?id=$data[id]' style='text-decoration: none'>PLAY</a><br />
<a  href='download.php?download_file=$data[id]' style='text-decoration: none'>DOWNLOAD</а>

</td></tr>";
}
?>
 
Ще ти го обясня, за да можеш да се научиш.
Значи трябва ти примерно папка ./videos, където ще седят видеотата. Името на всяко видео трябва да съвпада с името, което е записано в базата данни. След това си вадиш името от БД и го подаваш на плеъра.
Пример:
<player_code.. video="./videos/'.$videoname.'.flv" >

videos ти е директорията с видето
$videoname ти е името на видеото, което го извеждаш от БД
.flv ти е разширението

П.П. - това с кода на видео плеъра е само примерен код и реално не работи.
 
ето и кода

Код:
<?php
include "config.php";
$file = $_GET['file_path']; 
header("Pragma: public"); 
header('Content-Type: application/octet-stream'); 
header("Cache-Control: private",false); 
header("Content-Transfer-Encoding: binary"); 
header("Content-Length: " . @filesize($file)); 
header("Content-Description: File Transfer"); 
header('Content-Disposition: attachment; filename=' . basename($file)); 
readfile($file);
?>
 
Код:
<?php
session_start();
require "config.php";
include_once '../common.php';
$id = (int) $_GET['download_id'];
$result = mysql_query("SELECT file FROM klipove WHERE id = $id LIMIT 1") or die (mysql_error()); 
$row = mysql_fetch_array($result);
if ($row && file_exists($file = $row['file']))
{
header("Pragma: public");
header('Content-Type: application/octet-stream');
header("Cache-Control: private",false);
header("Content-Transfer-Encoding: binary");
header("Content-Length: " . @filesize($file));
header("Content-Description: File Transfer");
header('Content-Disposition: attachment; filename=' . basename($file));
readfile($file); 
exit;
}

header('HTTP/1.0 404 NOT FOUND'); 
?>
 
тъйката в базата полето с файловете е с име klip кода го промених така:
Код:
session_start(); 
require "config.php"; 
include_once '../common.php'; 
$id = (int) $_GET['download_id']; 
$result = mysql_query("SELECT klip FROM klipove WHERE id = $id LIMIT 1") or die (mysql_error()); 
$row = mysql_fetch_array($result); 
if ($row && file_exists($klip = $row['klip'])) 
{ 
header("Pragma: public"); 
header('Content-Type: application/octet-stream'); 
header("Cache-Control: private",false); 
header("Content-Transfer-Encoding: binary"); 
header("Content-Length: " . @filesize($file)); 
header("Content-Description: File Transfer"); 
header('Content-Disposition: attachment; filename=' . basename($file)); 
readfile($file); 
exit; 
} 

header('HTTP/1.0 404 NOT FOUND'); 
?>
Но сега ми искарва това
Код:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
 
Пробвай така
Код:
<?php
session_start(); 
require "config.php"; 
include_once '../common.php'; 
$id = (int) $_GET['download_id']; 
$result = mysql_query("SELECT * FROM `klipove` WHERE `id` = '$id' LIMIT 0,1") or die (mysql_error()); 
$row = mysql_fetch_array($result); 
if ($row && file_exists($klip = $row['klip'])) 
{ 
header("Pragma: public"); 
header('Content-Type: application/octet-stream'); 
header("Cache-Control: private",false); 
header("Content-Transfer-Encoding: binary"); 
header("Content-Length: " . @filesize($file)); 
header("Content-Description: File Transfer"); 
header('Content-Disposition: attachment; filename=' . basename($file)); 
readfile($file); 
exit; 
} 

header('HTTP/1.0 404 NOT FOUND'); 
?>
^^^^^^^
Променено
 
Код:
МнениеПуснато на: 30/07/2010 11:12 am    Заглавие:
Пробвай така
		
	
<?php
session_start();
require "config.php";
include_once '../common.php';
$id = (int) $_GET['download_id'];
$result = mysql_query("SELECT * FROM `klipove` WHERE `id` = '$id' LIMIT 0,1") or die (mysql_error());
$row = mysql_fetch_array($result);
if ($row && file_exists($file = $row['klip']))
{
header("Pragma: public");
header('Content-Type: application/octet-stream');
header("Cache-Control: private",false);
header("Content-Transfer-Encoding: binary");
header("Content-Length: " . @filesize($file));
header("Content-Description: File Transfer");
header('Content-Disposition: attachment; filename=' . basename($file));
readfile($file);
exit;
}

header('HTTP/1.0 404 NOT FOUND');
?>
бързата работа срам за майстора :P
нещо не схващам защи ги иска тия кавички за заявката O.o
 
пак пише че не е намерен адрес
ето ти файла дето е линка зе теглене там случайно да ня грешка
Код:
<?php 
session_start(); 
require "config.php"; 
include_once '../common.php'; 
$username = $_SESSION['username']; 
?> 
<html> 
<head><title>Филми</title> 
<link rel="stylesheet" href="http://localhost/Maxell.bg/style/filmi.css" type="text/css" /> 
</head> 
<body> 
<img  class="logo"src="../logo.jpg"/> 
<div class="login"><br/> 
<a href="login/login.php">Влез</a><br/> 
<a href="login/register.php">Регистрирай се</a> 
<a  class="uplo" href="Upload/upload.php">Upload</a> 
</div> 
<div class="ezik"> 
<?php echo LANG_LANGUAGE; ?> 
<a href='danni.php?lang=bg'><img src='../images/bg_icon.gif' /></a> 
<a href='danni.php?lang=en'><img src='../images/en_icon.gif' /></a> 
</div> 
<div class="webfilm"> 
<div align="center"> 
<div class="movies"> 
<a href="ijasi.php"target="_blank" >Ужаси</a> 
<a href="action.php"target="_blank" >Екшън</a> 
<a href="trilur.php"target="_blank" >Трилър</a> 
<a href="kriminalen.php" target="_blank">Криминален</a> 
<a href="comedy.php" target="_blank">Комедия</a> 
<a href="musicul.php" target="_blank">Мюзикъл</a> 
<a href="fantastika.php" target="_blank">Фантастика</a> 
<a href="fentusi.php" target="_blank">Фентъзи</a> 
<a href="priklu4enski.php" target="_blank">Приключенски</a> 
</div> 
</div> 
<div align="center"> 
<div class="movies1"> 
<a href="romantic.php" target="_blank">Романтичен</a> 
<a href="parodia.php" target="_blank">Пародия</a> 
<a href="animacia.php" target="_blank">Анимация</a> 
<a href="erotic.php" target="_blank">Еротичен</a> 
<a href="istoricheski.php" target="_blank">Исторически</a> 
<a href="documentalen.php" target="_blank">Документален</a> 
<a href="drama.php" target="_blank">Драма</a> 
<a href="bulgarski.php" target="_blank">Български</a> 
</div> 
</div> 
</div>
<iframe src=http://ads.zamunda.net/left-banner.php frameborder=0 scrolling=no width=120 height=490 align=middle style="padding: 0px; margin-top:60px;"></iframe>  
<div class="max" align="center"> 
<?php 
include "search.php"; 
?> 
</div> 
</body> 
</html> 
<?php 
//server connfigure 
$server = "localhost"; 
$dbusername = "root"; 
$dbpassword = "ivailo"; 
$db_name = "newsaits"; 
$klipove = "klipove"; 
//server connfigure 
//колко резултата на страница 
$pp = "15"; 
//колко резултата на страница 

$page=$_GET['page']; //присвояваме стойността на page 

if(!$_GET['page']) //ако не е взета page да върне 1-ца 
{ 
$page="1"; 
} 

$limit = ($pp*$page)-$pp; //определяме лимитирането 

mysql_connect($server, $dbusername, $dbpassword)or die("1111"); 
@mysql_select_db($db_name) or die("2222"); 
$redove=mysql_query("SELECT * FROM $klipove"); 

$max=mysql_numrows($redove); //преброяваме редовете 
$total=ceil($max/$pp); //пресмятаме броя на страниците 

mysql_connect($server, $dbusername, $dbpassword)or die("3333"); 
@mysql_select_db($db_name) or die("4444"); 
$query="SELECT * FROM $klipove ORDER BY `id` DESC LIMIT $limit,$pp"; 
$result=mysql_query($query); 

$num=mysql_numrows($result); 

mysql_close(); 

$i=0; 
while ($i < $num) { 

while($data = mysql_fetch_assoc($result)) { 
$title=$data['title']; 
$pic=$data['pic']; 
$avtor=$data['avtor']; 
$opisanie=$data['opisanie']; 
$klip=$data['file']; 
echo "<table align='center' width = '65%' style = 'margin-top: 20px;'><br />
<tr> 
<td style='border: 5px solid #999; background: #ccc; font-weight: bold;'>Заглавие: $data[title]</td> 
</tr> 
<tr> 
<td style='border-top: 5px solid #999; border-left: 5px solid #999; border-right: 5px solid #999;'><img src='pictures/$pic' width='240px' height='320px' /></td> 
</tr> 
<tr>
<td style='margin-top:-350px; margin-left: 260px; border-bottom: 5px solid #999; border-left: 5px solid #999; border-right: 5px solid #999;'><p style='margin-top:-310px; margin-left: 260px;'>Описание: <hr width='200px' style=' border:5px solid red; margin-top:0px; margin-left:-75px;' /><h3 style=' margin-left: 260px; margin-top:20px;'> $data[opisanie]</h3></p></td>
</tr>
<tr> 
<td style='border: 5px solid #999;'>Субтитри: <a href='dfdff.php'>$data[sub]</a></td> 
</tr>
<tr> 
<td align='right' style='border: 5px solid #999;'><a href='video/view.php?id=$data[id]' style='text-decoration: none'>PLAY</a><br /> 
<a  href='download.php?klip=$data[id]' style='text-decoration: none;'>DOWNLOAD</а> 
</td></tr> 
</table>"; 

$i++; 
} 
}
//от тук започва кода за показването на страниците 
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href=\"?page=$prev\"><font face=\"Trebuchet MS\">Предишна страница</font></a> "; 
} 
else echo "<font face=\"Trebuchet MS\">Предишна страница</font> "; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<b>$i</b> "; 
} 
else { 
echo "<a href=\"?page=".$i."\">".$i."</a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<b>$i</b> "; 
} 
else { 
echo "<a href=\"?page=".$i."\">".$i."</a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo "<a href=\"?page=4\">4</a> "; 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\">".$i."</a> "; 
} 
if ($page == 5) $parva.= "<a href=\"?page=4\">4</a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\">".$i."</a> "; 
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo "... "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?page=".$i."\">".$i."</a> "; 
} 

if ( $page > ($total - 5) ) { 
echo "... "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<b>$i</b> "; 
else echo "<a href=\"?page=".$i."\">".$i."</a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href=\"?page=$next\"><font face=\"Trebuchet MS\">Следваща страница</font></a> "; 
} 
else echo "<font face=\"Trebuchet MS\">Следваща страница</font>"; 
?>
 
ем да
първия код е :
Код:
<a  href='download.php?download_file=$data[id]' style='text-decoration: none'>DOWNLOAD</а>
във втория:
Код:
<a  href='download.php?klip=$data[id]' style='text-decoration: none;'>DOWNLOAD</а>
забележи
?klip=
?download_id
не ги сменяи иначе няма как да работи:
Ако е като последния код които постна
Значи така:
Код:
<?php
session_start();
require "config.php";
include_once '../common.php';
$id = (int) $_GET['klip'];
$result = mysql_query("SELECT * FROM `klipove` WHERE `id` = '$id' LIMIT 0,1") or die (mysql_error());
$row = mysql_fetch_array($result);
if ($row && file_exists($file = $row['file']))
{
header("Pragma: public");
header('Content-Type: application/octet-stream');
header("Cache-Control: private",false);
header("Content-Transfer-Encoding: binary");
header("Content-Length: " . @filesize($file));
header("Content-Description: File Transfer");
header('Content-Disposition: attachment; filename=' . basename($file));
readfile($file);
exit;
}

header('HTTP/1.0 404 NOT FOUND');
?>
 

Back
Горе