PHP - Upload Videos

Can you upload videos to a mysql database? If so how would you go about doing it?

i know you get embed code from youtube videos.  How do i put the code into my website.  Do i store the code in mysql? and how do i get php to display it?

When i am uploading under 2 MB file, it is successfully uploaded but when i am trying to upload bigger file then its showing failed to upload issue... my code is following....please help me to get out of this situation...
Code: [Select]
<?php
function UploadOne($fname)
{
$uploaddir = 'uploadedfiles/';
if (is_uploaded_file($fname['tmp_name']))
{

$filname = basename($fname['name']);

$uploadfile = $uploaddir . basename($fname['name']);
if (move_uploaded_file ($fname['tmp_name'], $uploadfile))
$res = "File " . $filname . "was successfully uploaded and stored. Upload More<br>";

include ('../config.php');
mysql_query("INSERT INTO videos (id, path, name, title, content)
VALUES ('$_POST[id]', 'url/$filname', '$_POST[date]', '$_POST[title]' , '$_POST[content]')");
$data = mysql_query('SELECT * FROM videos ORDER BY id DESC LIMIT 1');
$info = mysql_fetch_array($data);

$res = "<strong>$info[title]</strong>," . "\n Sucessfully Uploaded. \n Upload more".  "<br>" . "<a href='../videos.php'>View Videos</a>";
}
else
$res = "File ".$fname['name']." failed to upload.";
return ($res);
}
?>

Thanks in advance...

I embed YouTube videos on my site.   The problem is, the videos often get deleted by the user, which means that the videos obviously become unavailable on my site.   This happens often, which means that I regularly have to look through my site, find unavailable videos and delete them.   I am looking for an automated way of doing this.   Here's what I've got so far:

<?php
    $con = mysql_connect("", "", "");
    mysql_select_db("");
    $qry = "SELECT video_id FROM `table`";
    $run = mysql_query($qry, $con);    
    while($row = mysql_fetch_assoc($run)) {    
        $headers = get_headers("http://gdata.youtube.com/feeds/api/videos/{$row['video_id']}");
        if(!strpos($headers[0], '200')) {
            echo "Unavailable: {$row['video_id']}<br />";
            return false;
        }
        else {
            echo "Available: {$row['video_id']}<br />";
        }
    }
?>

The code's very slow and doesn't work. It produces a list of available videos and then stops when it finds one that is unavailable. The problem is, the video that it says is unavailable is usually available, which means that it's getting it wrong.   Is there a faster, more accurate way of doing it?   Basically, I want a fast and accurate way of checking the availability of the thousands of videos in my database and I want to produce a list of the ones that are unavailable.

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=320518.0

Hi everyone,

I have a page that i use to upload images to my website, i got a bit fed up of uploading one at a time so i decided to add multiple file fields to the form to upload multiple images at the same time.

Im having a few problems, iv read up he http://www.php.net/manual/en/features.file-upload.multiple.php and it seems all i have to do is add [] to the form names to turn them into arrays. However when i come to upload the images, i keep getting the "$error[] = "Incorrect format!...." error from the code below. I cant seem to figure out what the problem is.

Could anybody please point me in the right direction?


<?php 
session_start();

$id = $_SESSION['id'];

$connect = mysql_connect("localhost","leemp5_admin","p7031521");
mysql_select_db("leemp5_database");

$query = mysql_query("SELECT * FROM users WHERE id='$id'");
$row = mysql_fetch_assoc($query);

$username = $row['username'];

$submit = $_POST['submit'];

$type = $_FILES['image']['type'];
$size = $_FILES['image']['size'];
$max_size = "1000"; 
$width = "100"; 
$height = "100";
 
$error = array();

function make_thumb($image_name,$filename,$new_width,$new_height) 
{

$ext=getExtension($image_name); 

if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext)) 

$source_image=imagecreatefromjpeg($image_name);   

if(!strcmp("png",$ext)) 

$source_image=imagecreatefrompng($image_name);

if(!strcmp("gif",$ext)) 

$source_image=imagecreatefromgif($image_name); 

$old_x=imageSX($source_image);

$old_y=imageSY($source_image);   

$ratio1=$old_x/$new_width; 

$ratio2=$old_y/$new_height; 

if($ratio1>$ratio2)

{ 

$thumb_width=$new_width; 

$thumb_height=$old_y/$ratio1; 

} 

else 

{ 

$thumb_height=$new_height;

$thumb_width=$old_x/$ratio2; 

} 
  

$destination_image=ImageCreateTrueColor($thumb_width,$thumb_height);   

imagecopyresampled($destination_image,$source_image,0,0,0,0,$thumb_width,$thumb_height,$old_x,$old_y);   

if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))

{

imagejpeg($destination_image,$filename); 

}

if(!strcmp("png",$ext)) 

{

imagepng($destination_image,$filename); 

}

if(!strcmp("gif",$ext)) 

{

imagegif($destination_image,$filename); 

}

imagedestroy($destination_image); 

imagedestroy($source_image); 
}   


function getExtension($str)
{ 

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

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

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

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

return $ext; 
}   

if($submit) 
{ 

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

if ($image) 

{ 

$filename = stripslashes($_FILES['image']['name']);   

$extension = getExtension($filename); 

$extension = strtolower($extension); 

if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))

{ 

$error[] = "Incorrect format! Please make sure your image is a .jpg, .jpeg, .png or .gif file.";

} 

else

{ 

$size=getimagesize($_FILES['image']['tmp_name']); 

$sizekb=filesize($_FILES['image']['tmp_name']); 
  

if ($sizekb > $max_size*1024) 

{ 

$error[] = "Your image is too big! The maximum upload size is 1MB.";

}   

else

{

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

$newname="uploads/" . $username . "/images/".$image_name; $copied = copy($_FILES['image']['tmp_name'], $newname); 

if (!$copied) 

{ 

$error[] = "There was an error uploading your image. Please try again!";

} 

else 

{ 

$thumb_name='uploads/' . $username . '/images/thumbs/thumb_'.$image_name; 
 

$thumb=make_thumb($newname,$thumb_name,$width,$height); 

}

}

}

}

else

{

$error[] = "Please select an image to upload!";

}

if(empty($error))

{

echo "Upload Successfully!<br />"; 

echo '<img src="'.$thumb_name.'">';

mysql_query("INSERT INTO images VALUES ('','$username','$image_name','','','','','uploads/$username/images/$image_name','uploads/$username/images/thumbs/thumb_$image_name','$type','$size')");

}

else

{
    

echo implode($error);

}
}
?>
<form method="post" enctype="multipart/form-data" action="upload_images.php">
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="submit" name="submit" value="Upload">
</form>


Thanks

I have code written for image uploading, but it doesn't allow multiple images on a single upload, and doesn't re-size.

Anyone willing to share a good upload script that will do the following?:
-Allow multiple image uploads (10+ per submission),
-Re-size images on upload, and
-Rename images.

Thanks
Brett

Ok say i have a database with users who have a video url field for them to enter a video url to be submitted to the database, im trying to create a page where the videos will be displayed one at a time for example ' 1st video plays then it switches to the next random video from the database and so on' i want only to play so many seconds of the video before it switches as they will be presentations so i dont want viewers to watch them all in full, could anyone help me out with some code or feedback on this please?

I have approximately 2,300 videos embedded on my site, and I am constantly adding more. The videos are hosted by YouTube. When a video is deleted from YouTube, it becomes unavailable on my site.

Each video's ID is in my MySQL database. A video ID looks like this:

ZFOuxAx-dkc

I need a script that will do the following: select the IDs from my database check if the videos are still available on YouTube create a list of the videos that are unavailable. If possible, it would be great if the script could also tell me if any of the videos have been blocked in certain countries.

The script has to be fully commented so that I can understand it.

I want to run the script manually every few days. I don't want to have to change my database tables.

I've been told that you can use YouTube's API or YouTube's oEmbed interface. I've also been told that, because there are so many videos, you will have to use cURL multi handles.

If interested in this project, please PM me your price.   This is an urgent project. I have placed ads elsewhere.

files that upload during insert/submit form was gone , only files upload during the update remain , is the way query for update multiple files is wrong ?

$targetDir1= "folder/pda-semakan/ic/";
if(isset($_FILES['ic'])){
     $fileName1 = $_FILES['ic']['name'];
 $targetFilePath1 = $targetDir1 . $fileName1;
 //$main_tmp2 = $_FILES['ic']['tmp_name'];
$move2 =move_uploaded_file($_FILES["ic"]["tmp_name"], $targetFilePath1);
}

$targetDir2= "folder/pda-semakan/sijil_lahir/";
if(isset($_FILES['sijilkelahiran'])){
     $fileName2 = $_FILES['sijilkelahiran']['name'];
 $targetFilePath2 = $targetDir2 . $fileName2;
$move3 =move_uploaded_file($_FILES["sijilkelahiran"]["tmp_name"], $targetFilePath2);
}

$targetDir3= "folder/pda-semakan/sijil_spm/";
if(isset($_FILES['sijilspm'])){
     $fileName3 = $_FILES['sijilspm']['name'];
 $targetFilePath3 = $targetDir3 . $fileName3;
$move4 =move_uploaded_file($_FILES["sijilspm"]["tmp_name"], $targetFilePath3);
}



$query1=("UPDATE semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3' where email= '$stdEmail'");

 

Can someone Help me 
I made a code for uploading files to database.. but how can i retrieve it?
Is it possible to open the pdf file in browser?
Im using XAMPP MySql.. SOMEONE HELP ME PLS.

Hi there

We are hosting a web server that requires large files (100MB+) to be uploaded to it.  We are using PHP upload scripts, and it is working, but we are getting complaints that the uploads are unreliable (some files fail to upload, with no error messages).

I have been reading on various forums that FTP should rather be used for larger files, rather than HTTP.  But from what I can see, there are some limitations, and I was wondering if there are any ways around these:
-   Using cURL would mean that the files would first be uploaded to a temp folder on the web server via HTTP, and then only sent via FTP.  This defeats the purpose, because if it is already on the Web Server (which is hosted locally), then I might just as well move the file.
-   Using the built in FTP functionality of PHP, it appears that ones needs to know the full path of the source file.  The users who are uploading files are accessing the Web server via a form in a browser, which will not give the PHP script the full path of the file to be uploaded.

All we want is to have a reliable means for an end-user to access a site with a browser, fill in a form, choose a file to upload, and submit it.  Additional functionality, like a progress bar, the ability to select multiple files and a resume option for failed uploads, would all be very nice.  But the main concern is that the transfers be more reliable.

Thanks for any advice.

Mills

Hey Im trying to upload a pdf file into a blob in a database. This script worked to insert images and I made a few minor changes so that it could do the same for pdf files. Only when i run the script in a browser it says error unknown file format. I dont understand this because I do list pdf as a valid file format. The txt and the doc possible file uploads are just there to take up spots where jpeg and gif were in the picture script i have no intention of actually uploading those. The file i tested was yes a pdf so that cant be the issue. Heres the script.
Code: [Select]
<?php
$db_host = 'localhost'; // don't forget to change 
$db_user = 'root'; 
$db_pwd = 'dbpassword';
$database = 'mydbname';
$table = 'lit_gallery';
// use the same name as SQL table
$password = '123';
// simple upload restriction,
// to disallow uploading to everyone
if (!mysql_connect($db_host, $db_user, $db_pwd))    
die("Can't connect to database");
if (!mysql_select_db($database))    
die("Can't select database");
// This function makes usage of
// $_GET, $_POST, etc... variables
// completly safe in SQL queries
function sql_safe($s){    
if (get_magic_quotes_gpc())        $s = stripslashes($s);    
return mysql_real_escape_string($s);}
// If user pressed submit in one of the forms
if ($_SERVER['REQUEST_METHOD'] == 'POST'){    
// cleaning title field    
$title = trim(sql_safe($_POST['title']));
if ($title == '') 
// if title is not set        
$title = '(empty title)';
// use (empty title) string    
if ($_POST['password'] != $password)// cheking passwors        
$msg = 'Error: wrong upload password';
else    {        
if (isset($_FILES['book']))        {            @list(, , $ftype, ) = getimagesize($_FILES['book']['tmp_name']);            
// Get file type.
// We use @ to omit errors
if ($ftype == 3) 
// cheking image type
$ext="pdf";   
// to use it later in HTTP header
elseif ($ftype == 2)                $ext="txt";            
elseif ($imtype == 1)                $ext="doc";            
else                $msg = 'Error: unknown file format';            
if (!isset($msg)) 
// If there was no error
{                $data = file_get_contents($_FILES['book']['tmp_name']);
$data = mysql_real_escape_string($data);
// Preparing data to be used in MySQL query                
mysql_query("INSERT INTO {$table}                                SET ext='$ext', title='$title',                                    data='$data'");
$msg = 'Success: pdf uploaded';
}
}
elseif (isset($_GET['title']))      // isset(..title) needed
$msg = 'Error: file not loaded';
// to make sure we've using
// upload form, not form
// for deletion
if (isset($_POST['del'])) 
// If used selected some photo to delete        
{                         
// in 'uploaded images form'
$id = intval($_POST['del']);
mysql_query("DELETE FROM {$table} WHERE id=$id");
$msg = 'Book deleted';
}    
}
}
elseif (isset($_GET['show'])){    $id = intval($_GET['show']);
$result = mysql_query("SELECT ext, UNIX_TIMESTAMP(book_time), data                             FROM {$table}                            WHERE id=$id LIMIT 1");
if (mysql_num_rows($result) == 0)        die('no image');
    list($ext, $book_time, $data) = mysql_fetch_row($result);    $send_304 = false;    if (php_sapi_name() == 'apache') {
// if our web server is apache
// we get check HTTP        
// If-Modified-Since header
// and do not send image        
// if there is a cached version
$ar = apache_request_headers();
if (isset($ar['If-Modified-Since']) && 
// If-Modified-Since should exists            
($ar['If-Modified-Since'] != '') && 
// not empty            
(strtotime($ar['If-Modified-Since']) >= $book_time)) 
// and grater than            
$send_304 = true;                                     
// image_time    
}    
if ($send_304)    {        
// Sending 304 response to browser        
// "Browser, your cached version of image is OK        
// we're not sending anything new to you"        
header('Last-Modified: '.gmdate('D, d M Y H:i:s', $ts).' GMT', true, 304);        
exit(); 
// bye-bye    
}    
// outputing Last-Modified header    
header('Last-Modified: '.gmdate('D, d M Y H:i:s', $book_time).' GMT',            true, 200);    // Set expiration time +1 year    
// We do not have any photo re-uploading  
// so, browser may cache this photo for quite a long time    
header('Expires: '.gmdate('D, d M Y H:i:s',  $book_time + 86400*365).' GMT',            true, 200);    
// outputing HTTP headers    
header('Content-Length: '.strlen($data));    
header("Content-type: application/{$ext}");    
// outputing book    
echo $data;    
exit();
}
?>
<head>
<title>MySQL Blob Image Gallery Example</title>
<link rel="stylesheet" type="text/css" href="test.css"/>
</head>
<html>
<body>
<?php
if (isset($msg)) 
// this is special section for
// outputing message
{
?>
    <p style="font-weight: bold;"><?=$msg?><br><a href="<?=$PHP_SELF?>">reload page</a><!-- I've added reloading link, because     refreshing POST queries is not good idea --></p>
    <?php
    }
?>
    <h1>Blob image gallery</h1>
    <h2>Uploaded images:</h2>
    <form action="<?=$PHP_SELF?>" method="post">
    <!-- This form is used for image deletion -->
    <?php
    $result = mysql_query("SELECT id, book_time, title FROM {$table} ORDER BY id DESC");
if (mysql_num_rows($result) == 0) 
// table is empty    
echo '<ul><li>No images loaded</li></ul>';
else{    
echo '<ul>';    
while(list($id, $book_time, $title) = mysql_fetch_row($result))    {        
// outputing list        
echo "<li><input type='radio' name='del' value='{$id}'>";        
echo "<a href='{$PHP_SELF}?show={$id}'>{$title}</a> &ndash; ";        
echo "<small>{$book_time}</small></li>";    
}    
echo '</ul>';    
echo '<label for="password">Password:</label><br>';    
echo '<input type="password" name="password" id="password"><br><br>';    
echo '<input type="submit" value="Delete selected">';
}
?>
    <html>
    <body>
    </form><h2>Upload new image:</h2><form action="<?=$PHP_SELF?>" method="POST" enctype="multipart/form-data">
    <label for="title">Title:</label><br><input type="text" name="title" id="title" size="64"><br>
    <br>
    <label for="book">Book:</label><br><input type="file" name="book" id="book"><br>
    <br>
    <label for="password">Password:</label><br><input type="password" name="password" id="password"><br>
    <br><input type="submit" value="upload"></form>
    </body>
    </html>

I have made this script to upload to an ftp server.
How do I get the script to try to restart the upload if it fails? (if if (ftp_put($conn_id, $remote_file, $file, FTP_ASCII)) returns false)

Code: [Select]
<?php
$file = 'file.wmv';
$remote_file = 'file.wmv';

// set up basic connection
$conn_id = ftp_connect('ftp.eu.filesonic.com');

$ftp_user_name='username';
$ftp_user_pass='password';

// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);

// upload a file
if (ftp_put($conn_id, $remote_file, $file, FTP_ASCII)) {
 echo "successfully uploaded $file\n";
} else {
 echo "There was a problem while uploading $file\n";
}

// close the connection
ftp_close($conn_id);
?>