function upload() { $username = "******"; $password = "******"; $database = "youbama"; $youtube_username = "******"; $youtube_password = "******"; $file_prefix = "/var/www/youbama/static/videos/"; $link = mysql_connect(localhost, $username, $password); @mysql_select_db($database, $link) or die("Unable to select database"); $phptube = new PHPTube($youtube_username, $youtube_password); # Find all videos that haven't been uploaded yet $query = "SELECT * FROM `main_upload`, `main_video` WHERE `uploaded`=false AND main_upload.video_id=main_video.id"; $result = mysql_query($query, $link); $numrows = mysql_num_rows($result); print "Processing uploads...\n"; for ($i = 0; $i < $numrows; $i++) { $id = mysql_result($result, $i, "main_video.id"); $file = mysql_result($result, $i, "file"); $title = mysql_result($result, $i, "title"); $description = mysql_result($result, $i, "description"); # Upload to YouTube $youtube_id = $phptube->upload($file_prefix . $file, $title, "www.youbama.com youbama barack obama", $description, 25, "EN"); print "Uploaded {$file} ({$youtube_id})\n"; # Mark file as uploaded $query2 = "UPDATE `main_upload`, `main_video` SET `main_video`.`youtube_id`='{$youtube_id}', `uploaded`=true WHERE `main_video`.`id`='{$id}'"; $result2 = mysql_query($query2, $link); } mysql_close($link); }
<?php include_once "phptube.php"; $username = "******"; $password = "******"; $database = "youbama"; $youtube_username = "******"; $youtube_password = "******"; $file_prefix = "/var/www/youbama/static/videos/"; $link = mysql_connect(localhost, $username, $password); @mysql_select_db($database, $link) or die("Unable to select database"); $phptube = new PHPTube($youtube_username, $youtube_password); $id = $argv[1]; $query = "SELECT * FROM `main_upload`, `main_video` WHERE main_upload.video_id=main_video.id AND main_video.id={$id}"; $result = mysql_query($query, $link); $numrows = mysql_num_rows($result); print "Found {$numrows} results\n"; $file = mysql_result($result, 0, "file"); $file = "/var/www/youbama/static/videos/" . $file; $title = mysql_result($result, 0, "title"); $description = mysql_result($result, 0, "description"); print "File: {$file}\nTitle: {$title}\nDesc: {$description}\n"; $youtube_id = $phptube->upload($file, $title, "www.youbama.com youbama barack obama", $description, 25, "EN"); print "Uploaded {$youtube_id}\n"; mysql_close($link);