Upload Videos

[Salchester]

Hi Everyone,

How do I change the following code, to except .wmv files like it does images?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die('Could not connect: ' . mysql_error());
}

mysql_select_db("TS", $con);

      $sql="INSERT INTO Images (caption)
      VALUES
      ('$_POST[caption]')";  

if (($_FILES["file"]["type"] == "image/bmp")
|| ($_FILES["file"]["type"] == "image/jpeg")
&& ($_FILES["file"]["size"] < 90000))
{
  if ($_FILES["file"]["error"] > 0)
  {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
  }
  else
  {
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

    if (file_exists("upload/" . $_FILES["file"]["name"]))
    {
      echo $_FILES["file"]["name"] . " already exists. ";
    }
    else
    {
      $file = ("upload/" . $_FILES["file"]["name"]);
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
      
      mysql_query("INSERT INTO Videos (caption, path)
      VALUES('$_POST[caption]','$file')");


    }
  }
}
else
{
  echo "Invalid file";
}
?>

[Belisarius]

Well, what have you tried so far to get it to work?

[Salchester]

That works, but how do i allow .wmv files?

[Belisarius]

Well, what have you tried so far to get it to work with .wmv files?

[redhead]

I would suggest looking at your own bold lines there, and extend it to have wmv files aswell..
If you dont know what $_FILE['file']['type'] it is expressed as, then perhaps make a pseudo code which dosn't upload but only displays this info..
Fom there just alter your acceptance demands to fit what this variable holds.

Or perhaps I would swing by php.net and look up the $_FILE variable to see if it is mentioned anywhere, or perhaps take a look at move_uploaded_file() description there to see if anyone has been so kind to show a small example which takes videos...

Aaarrg, now I used up my salch-quota for this week helping you salchester, hope you can use some of the pointers given here, and next time think in that same direction as I've just described.