PHP - problem in uploading video files

Asked By karthick bheema rao jaganthan on 03-Aug-11 05:24 AM

Hi friends,

I have a problem in uploading video files...
i can upload all type of files expect video files..

I cant update the database too when i redirect to header : upload1.php..

if i include comment line to upload1.php..

it upload to database table all column of the table..

but if i upload video file it not update the values in the database table..

pls help me to complete the project..

this alone only remaining in my project...

I ll gave the coding below..
...........................................................
java.php:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<?php
//   session_start();
   include('library/config.php');
//   if($_SESSION['is_admin'] != 'true'){
//   header("location: ../../index.php");
//   exit();
//   }
//   confirm("hai");
   if(isset($_REQUEST['post_value']) && $_REQUEST['post_value'] == 'true'){
//>......................


      $type=$_REQUEST['type'];
      $path=$_REQUEST['path'];

      $ext=$_REQUEST['ext'];
      if($ext==""){
      $ext=$upload_path.$path;
      $is_process = true;
      }

      confirm($ext);

      $created_date=$_REQUEST['created_date'];
      $cfn=$_REQUEST['cfn'];
      $filename = $_REQUEST['filename'];
      $a_name=$_REQUEST['a_name'];
      $edition=$_REQUEST['edition'];
      $version= $_REQUEST['version'];

      $cat_view = 'view_'.$cfn;


      $scat_view = 'sview_'.$cfn;

      confirm($cat_view);

   $stype=$_REQUEST['stype'];
   $scfn=$_REQUEST['scfn'];

      confirm("hai");
      $ins_qry = "update temp set ext='$ext',display_date=now(), category='$cfn',type='$type',filename='$filename',a_name='$a_name',version='$version',edition='$edition',cat_view='$cat_view',scat_view='$scat_view',up_by='$name' where ID=2";
      $ins_rst = mysql_query($ins_qry);
confirm($ins_qry);


   header("location: upload1.php ");
   }
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Tag info solutions india pvt ltd</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="css/style.css" rel="stylesheet" type="text/css" media="screen" />
<link rel="shortcut icon" href="images/favicon.ico">
<script type="text/javascript">
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
</script>
</head>
<body>
<center>
<table width="820" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td><div id="header">
    <p><a href="../logout.php"style="text-decoration:none;">LogOut</a>   <a href="source_page.php" style="text-decoration:none;">Back</a></p>

    <div id="logo">

      <p><img src="../images/admin.png" width="100" height="100" /></p>
   </div>

</div></td>
</tr>

<tr>
    <td>
   <div id="wrapper">
   <div id="wrapper-bgtop">
      <div id="wrapper-bgbtm">
          <div id="page">
              <div id="content">
                  <div class="post">
                      <h2 class="title"><a href="#">Fill it to upload</a></h2>
                      <div class="entry">
              <?php
$current_file_name = basename($_SERVER['REQUEST_URI'],".php"); /* supposing filetype .php*/

// echo $current_file_name;

?>
              <center>
              <form action="" method="post" enctype="multipart/form-data" name="myForm" onsubmit="return validateForm()">
              <table width="547" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td height="25" width="100">File Name</td>
    <td width="5" align="center">:</td>
    <td width="285">
    <input name="filename" type="text" id="filename" /><strong style="color:#F00">*</strong></td>
</tr>
<tr>
    <td height="25">Author Name</td>
    <td align="center">:</td>
    <td><input name="a_name" type="text" /></td>
</tr>
<tr>
    <td height="25">Version</td>
    <td align="center">:</td>
    <td>
   <input type="text" name="version" id="version" /><strong style="color:#F00">*</strong></td>
</tr>
<tr>
    <td height="25">Edition</td>
    <td align="center">:</td>
    <td><input name="edition" type="text" /></td>
</tr>
<tr>
    <td height="49">Type</td>
    <td align="center">:</td>
    <td>
   <?php

                                          function confirm($msg)
                                                  {
                                                  echo "<script langauge=\"javascript\">alert(\"".$msg."\");</script>";
                                                  }

                                          $sel_qry ="SELECT distinct(type) FROM setting ";
                                              // confirm($sel_qry);

                          $sel_rst = mysql_query($sel_qry);
                          if($sel_rst && mysql_num_rows($sel_rst) >0)
                                              {
                        ?>
                        






                         
                          <Select Name="cat" id="cat" onchange="t2()">
                          <option value="">--Select--</option>
                          <?php

                          while($row = mysql_fetch_array($sel_rst))
                                              {
                                              $ID = $row['type'];
                                              $typ = $row['type'];
                                              echo "<option value=$ID>$typ</option>";
                                              }
                                              }
                                              ?>
                                              </select>
                          <script language="javascript">
                                              function t2(){
   //                                                var ty=myform.cat.value;
                                                      //alert(ty);
//                                                    document.getElementById("stype").value = document.getElementById("cat").value

                                                      var ty=document.getElementById("cat").value;
//                                                    alert(ty);
                                                      document.getElementById("stype").value=ty;
                                                      document.getElementById("type").value=ty;
                                                      document.getElementById("scfn").value = document.getElementById("cfn").value

                                                  }

                                              </script>

      <input name="type" id="type" type="text" onchange="t1()" />

<input name="stype" id="stype" type="text" VALUE="<?php echo $_SESSION['stype']; ?>" />




</tr>
<tr>
    <td height="25"> <label for="file">Select a file</label> </td>
    <td align="center">:</td>
    <td> <input type="file" name="userfile" id="text1" onChange="transfer()"></td>
</tr>

   <tr>
    <td height="25"></td>
    <td></td>
    <td> <input type="hidden" name="path" id="text2" value=""/>
    <input type="hidden" name="ext" />
     <input type="text" name="cfn" id="cfn" value="<?php echo $current_file_name;?>" />
    
    </td>
</tr>
<tr>
    <td height="25"></td>
    <td></td>
    <td><input type="hidden" name="post_value" value="true"/>
              <input type="submit" name="Submit" value="Upload File"/>
    </td>
</tr>
</table>
   <script language="javascript">

</script>
    <script language="javascript">

function validateForm()
{
var w=document.forms["myForm"]["filename"].value
if (w==null || w=="")
{
alert("File Name must be filled out");
return false;
}
var x=document.forms["myForm"]["a_name"].value
if (x==null || x=="")
{
alert("Author name must be filled out");
return false;
}
var y=document.forms["myForm"]["version"].value
if (y==null || y=="")
{
alert("version must be filled out");
return false;
}
var z=document.forms["myForm"]["edition"].value
if (z==null || z=="")
{
alert("Edition must be filled out");
return false;
}
var t=document.forms["myForm"]["type"].value
if (t==null || t=="")
{
alert("Type must be filled out");
return false;
}

var t=document.forms["myForm"]["type"].value
if (t==null || t=="")
{
alert("Type must be Selected");
return false;
}
}
// End -->
</script>
              </form>
              </center>
                      </div>
                  </div>


              </div>
              </div>
          </div>
          
          <div style="clear: both;"> </div>
      </div>
   </div>

   </td>
</tr>
<tr>
    <td>
    <div id="footer-bgcontent">
   <div id="footer">
    <div id="footer2">
          <p>Copyright ©taginfosolutions.in<a href="http://validator.w3.org/check/referer" title="This page validates as XHTML 1.0 Transitional"><abbr title="eXtensible HyperText Markup Language"></abbr></a></p>
      </div>
      </div>
      </div>
   </td>
</tr>
</table>

</center>
</body>
</html>

........................................................................................
upload1.php

<?php session_start();
   include('library/config.php');
   if($_SESSION['is_admin'] != 'true'){
   header("location: ../../index.php");
   exit();
   }

   $cfn=$_REQUEST['cfn'];
   $type=$_REQUEST['type'];
   $ins_qry1 = "update temp set type='$type', category='$cfn' where ID=2";
   $ins_rst1 = mysql_query($ins_qry1);
   confirm($ins_qry1);


   $sel_qry1 ="SELECT name FROM temp WHERE ID=1";
                                          //    confirm($sel_qry);

                          $sel_rst1 = mysql_query($sel_qry1);
                          if($sel_rst1 && mysql_num_rows($sel_rst1) >0){
                                                  if($row1 = mysql_fetch_array($sel_rst1)){
                                                      $name=$row1['name'];
                                                  //   $pass=$row1['pass'];
                                                  //   confirm($name);
                                                  //   confirm($pass);
                                                      }
                                                      }

                                                      $sel_qry2 ="SELECT * FROM temp WHERE ID=2";
                                          //    confirm($sel_qry);

                          $sel_rst2 = mysql_query($sel_qry2);
                          if($sel_rst2 && mysql_num_rows($sel_rst2) >0){
                                                  if($row2 = mysql_fetch_array($sel_rst2)){
                                                  //
                                                  //   $pass=$row['pass'];
                                                  //   confirm($name);
                                                  //   confirm($pass);
                                                      }
                                                      }

?>

<?php

$cfn=$row2['category'];
$type=$row2['type'];

      $upload_path=$_REQUEST['$upload_path'];
      $f_name=$_REQUEST['f_name'];



      $ext=$_REQUEST['ext'];
      if($ext==""){
      $ext=$upload_path.$path;
      $is_process = true;
      }

   //   confirm($ext);





      $a_name=$row2['a_name'];


      $edition=$row2['edition'];


      $version= $row2['version'];



      $filename = $row2['filename'];

      $cat_view = $row2['cat_view'];
      $cat_view = 'view_'.$cfn;

      $scat_view = $row2['scat_view'];
      $scat_view = 'sview_'.$cfn;

// $cfn=$_REQUEST['cfn'];
// $type=$_REQUEST['type'];
$extn=$_REQUEST['extn'];
$allowed_filetypes=array();

confirm("cfn : ".$cfn);
confirm("type : ".$type);


//confirm("EXTN :". $extn);

                                              $i=0;
                                              //   $datearray;

                                                  $array2;
                                                  $sel_qry ="SELECT extn FROM setting WHERE type = '$type'";
                                                  confirm($sel_qry);
                          $sel_rst = mysql_query($sel_qry);

                                              $cnt=0;

                                              if($sel_rst && mysql_num_rows($sel_rst) >0){
//                                            while($row = mysql_fetch_array($sel_rst)){

                                                  while($row=mysql_fetch_array($sel_rst))
                                                  {
                                                      $allowed_filetypes[$i]=$row['extn'];
                                                      //echo $datearray[i];
//                                                       $array2[i]=$row['date'];
                                                      //echo $array2[i];
                                              //    confirm($allowed_filetypes[i].":   :".$row['extn']);
                                                      $i=$i+1;

                                                  }

                                              //   echo 'this is the size'.$i;

                                                  //echo $allowed_filetypes[0]."noth";

/*                                            for($j=0;$j<$i;$j++)
                                                  {
                                                      confirm($allowed_filetypes[$j]);
                                                      }*/
                                                  }




                                  //    if(type=='$type')
                                  //    {

                                  //    }


                      /*$e_type= $_REQUEST['<table><tr><td><?php echo $extn; ?></td></tr></table>'];*/

   //                confirm($e_type);
   // Configuration - Your Options
//    $allowed_filetypes = array('.jpg','.gif','.bmp','.png','.rar','.pdf','.doc','.docx','.flv','.txt','.mp3'); // These will be the types of file that will pass the validation.
//$allowed_filetypes = array('$e_type'); // These will be the types of file that will pass the validation.

// $allowed_filetypes = array('.doc','.docx','.ppt','.pptx','.xls','.xlsx'); // These will be the types of file that will pass the validation.
    $max_filesize = 52428800000000000000000000; // Maximum filesize in BYTES (currently 0.5MB).
//    $upload_path = './files/'; // The place the files will be uploaded to (currently a 'files' directory).

$upload_path = 'savefiles/'.$cfn.'/'; // The place the files will be uploaded to (currently a 'files' directory).
// $fileType = $_FILES['userfile']['type'];

                              /*for($j=0;$j<$i;$j++)
                              {
                              confirm($allowed_filetypes[$j]);

                              }
*/
confirm("Upload path : ".$upload_path);
// confirm();

$fl=1;
//confirm('file:'.$_FILES['userfile']);
   $filename = $_FILES["userfile"]["name"]; // Get the name of the file (including file extension).
confirm("filenme value:".$filename);

//$filename = $_FILES['userfile']['type']; // Get the name of the file (including file extension).
   $ext = substr($filename, strpos($filename,'.'), strlen($filename)-1); // Get the extension from the filename.

   // Check if the filetype is allowed, if not DIE and inform the user.
   if(!in_array($ext,$allowed_filetypes))
   {
   $fl=0;
   confirm('UPLOAD ONLY   *'.$type.'*   FILES');


//    die('UPLOAD ONLY DOCUMENT FILES');

   // header("location: $cfn.php");

// <a href="$cfn'.'.php" title="Back">Back</a>
   }

   // Now check the filesize, if it is too large then DIE and inform the user.

   if(filesize($_FILES['userfile']['tmp_name']) > $max_filesize)
    die('The file you attempted to upload is too large.');

   // Check if we can upload to the specified path, if not DIE and inform the user.
   if(!is_writable($upload_path))
    die('You cannot upload to the specified directory, please CHMOD it to 777.');

   // Upload the file to your specified path.
   if($fl==1){
   // $temp=$_FILES['userfile']['tmp_name'];
//    $temp=$_FILES['userfile'];
//    confirm($temp);
//     confirm($_FILES['userfile']['tmp_name']);
// if(move_uploaded_file($temp,$upload_path . $filename))
   if(move_uploaded_file($_FILES['userfile']['tmp_name'],$upload_path . $filename))
   {

      // echo 'Your file upload was successful, view the file <a href="' . $upload_path . $filename . '" title="Your File">here</a>'; // It worked.
      confirm('Your File Uploaded To the Local Drive Successfully' );
      // echo 'Your file upload was successful';

      // header("location: $cfn.php");
   }
    else
      {
      confirm('There was an error during the file upload. Please try again.');
      // echo 'There was an error during the file upload. Please try again.'; // It failed :(.

// header("location: $cfn.php");
}
   }


   $display_date = "";
   $created_date = "";
   $f_name = "";
   $category = "";
   $type = "";
   $path = "";
   $ext = "";
   $flag=1;
   $filename="";
   $a_name="";
   $version="";
   $edition="";
   $err_filename = "";
   $err_a_name = "";
   $err_version = "";
   $err_edition = "";
   $err;


   function confirm($msg)
      {
      echo "<script langauge=\"javascript\">alert(\"".$msg."\");</script>";
      }
   if(isset($_REQUEST['post_value']) && $_REQUEST['post_value'] == 'true' && $fl==1){
      $is_process = true;

      /*$upload_path=$_REQUEST['$upload_path'];
      $f_name=$_REQUEST['f_name'];
      $category=$_REQUEST['category'];
      $type=$_REQUEST['type'];
      $path=$_REQUEST['path'];

      $ext=$_REQUEST['ext'];
      if($ext==""){
      $ext=$upload_path.$path;
      $is_process = true;
      }

   //   confirm($ext);

      $created_date=$_REQUEST['created_date'];

      $cfn=$_REQUEST['cfn'];

      $a_name=$_REQUEST['a_name'];
      if($a_name == ""){
          $err_a_name = "Enter the Author Name";
          $is_process = false;
      }

      $edition=$_REQUEST['edition'];
      if($edition == ""){
          $err_edition = "Enter the edition";
          $is_process = false;
      }

      $version= $_REQUEST['version'];
      if($version == ""){
          $err_version = "Enter the version";
          $is_process = false;
      }


      $filename = $_REQUEST['filename'];
      if($filename == ""){
          $err_filename = "Enter the filename";
          $is_process = false;
      }

      $cat_view = $_REQUEST['cat_view'];
      $cat_view = 'view_'.$cfn;

      $scat_view = $_REQUEST['scat_view'];
      $scat_view = 'sview_'.$cfn;*/

   //   confirm($cat_view);

      if($filename==null)
      {
          $flag=0;
          confirm("Re Upload this FILE , error in Upload!!!!");
          }

      if($is_process && $flag==1){
          $ins_qry = "insert into exp(ext,display_date,category,type,filename,a_name,version,edition,cat_view,scat_view,up_by)
          values('$ext', now(),'$cfn','$type','$filename','$a_name','$version','$edition','$cat_view','$scat_view','$name')";
      $ins_rst = mysql_query($ins_qry);
          if($ins_rst){
              if(mysql_affected_rows()>0){
                  $err = "Upload Successfully In DataBase Too!";
                      $display_date = "";
   $created_date = "";
   $f_name = "";
   $category = "";
      $type = "";
   $flag=1;
   $filename="";
   $a_name="";
   $version="";
   $edition="";
   $err_filename = "";
   $err_a_name = "";
   $err_version = "";
   $err_edition = "";
   $err;
                  confirm($err);
//                $f_name = "";


   }
          }
      }
   }

   ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Tag info solutions india pvt ltd</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="../css/style.css" rel="stylesheet" type="text/css" media="screen" />
</head>

<body>

<?php $cfn=$_REQUEST['cfn'];
//confirm($cfn);
?>

<br /><br /><br /><br />
<center>
<a href="<?php echo $cfn=$_REQUEST['cfn'];?>.php" style="font-size:16px; text-decoration:none; font-weight:bolder;">$$--Click Here to Go Back--$$</a>
</center>

</body>
</html>
............................................................................

Ravi S replied to karthick bheema rao jaganthan on 03-Aug-11 05:32 AM

HI

try this

Open a blank page in a text editor, such as Notepad, or a Web-authoring application like Dreamweaver. If you use Dreamweaver or another WYSIWYG (what you see is what you get) type application, make sure to change the view to HTML.
2

Type in the code for the form that will be used as the user interface for uploading the video files. The HTML code for the form should look like this:

"<html>

<head>

<title>Video Upload Form</title>

</head>

<body>

Use this form to upload your video files.

<form action="uploadvideofile.php" method="post">

Video file directory path: <input type="file" name="uploadFile">

<input type="submit" value="Upload">

</form>

</body>

</html>"

This is just a basic form that calls on the PHP file "uploadvideofile.php" to handle the file you selected to upload. Save this document and open another blank document.
3

Type in the PHP code to handle the video upload. The challenge with uploading videos is the file size. You will need the PHP code to be able to handle large video files. The code should look like this:

"<?php

//This handles the maximum size for the video file in kbs

define ("MAX_SIZE","500");

//This function reads the extension of the file to ensure that it is an video file

function getExtension($str) {

$i = strrpos($str,".");

if (!$i) { return ""; }

$l = strlen($str) - $i;

$ext = substr($str,$i+1,$l);

return $ext;

}

//This variable handles an error and won't upload the file if there is a problem with it

$errors=0;

//checks if the form has been submitted

if(isset($_POST['Submit']))

{

//reads the name of the file the user submitted for uploading

$video=$_FILES['video']['name'];

//if it is not empty

if ($video)

{

//get the original name of the file from the clients machine

$video_filename = stripslashes($_FILES['video']['name']);

$video_extension = getExtension($filename);

$video_extension = strtolower($extension);

//if it is not a known extension, we will suppose it is an error and will not upload the file, otherwise we will do more tests

if (($video_extension != "mpeg") && ($video_extension != "avi") && ($video_extension != "flv") && ($video_extension != "mov"))

{

echo '<h1>Unknown extension!</h1>';

$errors=1;

}

else

{

//get the size of the video

$size=filesize($_FILES['video']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger

if ($size > MAX_SIZE*1024)

{

echo '<h1>You have exceeded the size limit!</h1>';

$errors=1;

}

//give the video a unique name in case a video already exists with the name on the server

$video_name=time().'.'.$extension;

//assign a folder to save the video to on your server

$newname="video/".$video_name;

//verify that the video has been loaded

$copied = copy($_FILES['video']['tmp_name'], $newname);

if (!$copied)

{

echo '<h1>Copy unsuccessful!</h1>';

$errors=1;

}}}}

//If no errors registered, print the success message

if(isset($_POST['Submit']) && !$errors)

{

echo "<h1>File Uploaded Successfully! Try again!</h1>";

}

?>"

Leave out the quotation marks on the first and last line. Save the file as "uploadvideofile.php" so that the form above uses this file to handle the uploading of the video. Upload both files to your Web server.

refer teh link also
http://php.about.com/od/advancedphp/ss/php_file_upload.htm
http://www.ehow.com/how_6938294_upload-php-video-files.html
http://www.htmlgoodies.com/beyond/php/article.php/3472551/PHP-Tutorial-Uploading-Files.htm

ODBC Drivers for QuickBooks, Salesforce, SAP, MSCRM, SharePoint … Free Trial!