от носно качване на видео

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

Anonymous

Guest
Значи направих upload faila но освен видео се качват картинки . Проблема е, че картинки се качват в базата данни но не и папката порада това неми извежда и картинките в index.php как да го оправя ще ми помогнете ли

ето и upload.php
<?php
require "config.php";
require "functions.php";
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link rel="stylesheet" href="player.css" type="text/css" />
<table>
<form method="POST" action="" enctype="multipart/form-data">
<tr><td>Заглавие:</td><td><input type="text" name="title" /></td></tr>
<tr><td>Картинка:</td><td><input type="file" name="pic" /></td></tr>
<tr><td>Автор:</td><td><input type="text" name="avtor" /></td></tr>
<tr><td>Описание:</td><td><textarea name="opisanie" rows="5" cols="30"></textarea></td></tr>
<tr><td>Качи видео:</td><td><input type="file" name="file" /></td></tr>
<tr><td></td><td><input type="submit" name="do" value="Качи Видео"/></td></tr>
</form>

</table>
<?php
if($_POST['do'])
{
$file = $_FILES['file']["name"];
$pic = $_FILES['pic']["name"];
$end = end(explode(".", $file));
$end = end(explode(".", $pic));
if($end == "flv" || $end == "mpeg" || $end == "avi" || $end == "wmv" || $end == "jpg")
{
@move_uploaded_file($_FILES['file']["tmp_name"], "video/" . $_FILES['file']['name']);
$title = htmlspecialchars(addslashes($_POST['title']));
$opisanie = htmlspecialchars(addslashes($_POST['opisanie']));
$avtor = $_SESSION['username'];
$data = date("Y-m-d");
$ip = $_SERVER[REMOTE_ADDR];
$cat = $_POST['kategoriq'];
$add = mysql_query("INSERT INTO klipove (`avtor`,`title`,`pic`,`opisanie`,`klip`,`data`,`ip`,`kategoriq`) VALUES ('$avtor','$title','$pic','$opisanie','$file','$data','$ip','$cat')") or die (mysql_error());
echo 'Клипа е успешно качен';
}
else
{
echo 'Невалиден формат';
}
}
?>

а това е index.php
<?php
session_start();
require "config.php";
$username = $_SESSION['username'];
?>
<meta http-equiv rel="Content-Type" content="text/html" charset="windows-1251">
<?php
$result = mysql_query("SELECT * FROM klipove ORDER BY id DESC") or die (mysql_error());
$pic=1024;
while($data = mysql_fetch_assoc($result)) {
if($pic%1==0 && $pic!=0){
echo "<br />";
}
$title=$data['title'];
$pic=$data['pic'];
$avtor=$data['avtor'];
$opisanie=$data['opisanie'];
$klip=$data['file'];
echo "<img src='$pic' width='240px' height='320px' />
$title
$avtor
$opisnie
$klip";
$pic++;
}
?>
 
<?php
require "config.php";
require "functions.php";
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link rel="stylesheet" href="player.css" type="text/css" />
<table>
<form method="POST" action="" enctype="multipart/form-data">
<tr><td>Заглавие:</td><td><input type="text" name="title" /></td></tr>
<tr><td>Картинка:</td><td><input type="file" name="pic" /></td></tr>
<tr><td>Автор:</td><td><input type="text" name="avtor" /></td></tr>
<tr><td>Описание:</td><td><textarea name="opisanie" rows="5" cols="30"></textarea></td></tr>
<tr><td>Качи видео:</td><td><input type="file" name="file" /></td></tr>
<tr><td></td><td><input type="submit" name="do" value="Качи Видео"/></td></tr>
</form>

</table>
<?php
if($_POST['do'])
{
$file = $_FILES['file']["name"];
$pic = $_FILES['pic']["name"];
$end = end(explode(".", $file));
$end = end(explode(".", $pic));
if($end == "flv" || $end == "mpeg" || $end == "avi" || $end == "wmv" || $end == "jpg")
{
$upclip = move_uploaded_file($_FILES['file']["tmp_name"], "video/" . $_FILES['file']['name']);
$uppic = move_uploaded_file($_FILES['pic']["tmp_name"], "pictures/" . $_FILES['file']['name']);

$title = htmlspecialchars(addslashes($_POST['title']));
$opisanie = htmlspecialchars(addslashes($_POST['opisanie']));
$avtor = $_SESSION['username'];
$data = date("Y-m-d");
$ip = $_SERVER[REMOTE_ADDR];
$cat = $_POST['kategoriq'];
$add = mysql_query("INSERT INTO klipove (`avtor`,`title`,`pic`,`opisanie`,`klip`,`data`,`ip`,`kategoriq`) VALUES ('$avtor','$title','$pic','$opisanie','$file','$data','$ip','$cat')") or die (mysql_error());
echo 'Клипа е успешно качен';
}
else
{
echo 'Невалиден формат';
}
}
?>

така ще ти ги качва в папка pictures ако има проблеми пиши :)
 
Изписва ми ето това

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 's Talk About It (High Quality Video).flv','2010-06-27','127.0.0.1','')' at line 1
 
<?php
require "config.php";
require "functions.php";
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link rel="stylesheet" href="player.css" type="text/css" />
<table>
<form method="POST" action="" enctype="multipart/form-data">
<tr><td>Заглавие:</td><td><input type="text" name="title" /></td></tr>
<tr><td>Картинка:</td><td><input type="file" name="pic" /></td></tr>
<tr><td>Автор:</td><td><input type="text" name="avtor" /></td></tr>
<tr><td>Описание:</td><td><textarea name="opisanie" rows="5" cols="30"></textarea></td></tr>
<tr><td>Качи видео:</td><td><input type="file" name="file" /></td></tr>
<tr><td></td><td><input type="submit" name="do" value="Качи Видео"/></td></tr>
</form>

</table>
<?php
if($_POST['do'])
{
$file = $_FILES['file']["name"];
$pic = $_FILES['pic']["name"];
$end = end(explode(".", $file));
$end = end(explode(".", $pic));
if($end == "flv" || $end == "mpeg" || $end == "avi" || $end == "wmv" || $end == "jpg")
{
$upclip = move_uploaded_file($_FILES['file']["tmp_name"], "video/" . $_FILES['file']['name']);
$uppic = move_uploaded_file($_FILES['pic']["tmp_name"], "pictures/" . $_FILES['file']['name']);
$title = htmlspecialchars(addslashes($_POST['title']));
$opisanie = htmlspecialchars(addslashes($_POST['opisanie']));
$avtor = $_SESSION['username'];
$data = date("Y-m-d");
$ip = $_SERVER[REMOTE_ADDR];
$cat = $_POST['kategoriq'];
$add = mysql_query("INSERT INTO klipove (avtor, title, pic, opisanie, klip, data, ip, kategoriq) VALUES ('$avtor','$title','$pic','$opisanie','$file','$data','$ip','$cat')") or die (mysql_error());
echo 'Клипа е успешно качен';
}
else
{
echo 'Невалиден формат';
}
}
?>
 
мерси за помащта оправих са имаше само една грешка и тя е

беше
Код:
$uppic = move_uploaded_file($_FILES['pic']["tmp_name"], "pictures/" . $_FILES['files']['name']);
а трябва да е така
Код:
$uppic = move_uploaded_file($_FILES['pic']["tmp_name"], "pictures/" . $_FILES['pic']['name']);
 

Back
Горе