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);
