如何使用PHP和MySQL在数据库中插入视频并在页面上获取


How to insert video in databaes and fetch on page using PHP and MySQL

这是我在数据库或移动到文件夹中的uploading video的代码。在这个代码视频上传,但没有插入文件到数据库。。。。??

请帮助我如何使用PHP+MySQL在数据库中插入视频?

<html>
<head>
</head>
 <body>
  <form ACTION="test.php" method="post" enctype="multipart/form-data">
  <label for="file">Filename:</label><br>
   <input type="file" name="video"><br>
   <input type="submit" name="submit" value="Submit">
   </form>
</body>
</html>
  <?php
    if(isset($_FILES['video']))
     {     
        $name = $_FILES['video']['name'];
        $type = explode('.',$name);
        $type = end($type);
        $size= $_FILES['video']['size'];
        $random_name = rand();
        $tmp= $_FILES['video']['tmp_name'];

       if($type !='mp4' && $type !='MP4' && $type !='flv')
       {
       $message ="Video Format Not Supported";
        }
       else
        {
        move_uploaded_file($tmp, 'videos/'.$random_name.'.'.$type);
       mysql_query("INSERT INTO 'videos' VALUES ('', '$name',   
        'videos/$random_name.$type')");
        $message ="Successfully Uploaded";
        }
         echo "$message <br/> <br/>";
        }
       ?>

我从文件中复制了这段代码,希望这能解决您的问题。

$vdo=$_FILES['uf']['name'];     $target_path = "video/";
$target_path = $target_path . basename( $_FILES['uf']['name']);
$target_path . basename( $_FILES['uf']['name']);
if(move_uploaded_file($_FILES['uf']['tmp_name'], $target_path))
{  $host="mysqlbhost.com";
$username="me";
$password="me";
$db_name="db";
$tbl_name="video";
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db ("$db_name")or die("cannot select DB");
$sql="INSERT INTO $tbl_name(video)
VALUES('$vdo')";
$result=mysql_query($sql);
echo "<div id='rslt'>"; echo "Thanks! video has been sent to ";