From 0718ff72472754e6116ad58f4ff6bc788f5c3d61 Mon Sep 17 00:00:00 2001 From: root Date: Wed, 26 Feb 2014 17:25:43 +0100 Subject: It works! --- www/youtube.php | 71 ++++++++++++++++------------------------------- www/youtube_functions.php | 13 ++++++--- 2 files changed, 33 insertions(+), 51 deletions(-) (limited to 'www') diff --git a/www/youtube.php b/www/youtube.php index 01db8d7..062456b 100644 --- a/www/youtube.php +++ b/www/youtube.php @@ -1,3 +1,7 @@ + + + + getVideoFeed($location); - printVideoFeed($videoFeed); + $videoID = printVideoFeed($videoFeed); + return $videoID; } function printVideoFeed($videoFeed) { - $count = 1; - foreach ($videoFeed as $videoEntry) { - echo "Entry # " . $count . "\n"; - printVideoEntry($videoEntry); - echo "\n"; - $count++; - } + + $res_quant = count($videoFeed); + + $video = mt_rand(1, $res_quant); + + $videoId = printVideoEntry($videoFeed[$video]); + + return $videoId; + } function printVideoEntry($videoEntry) { - // the videoEntry object contains many helper functions - // that access the underlying mediaGroup object - echo 'Video: ' . $videoEntry->getVideoTitle() . "\n
"; - /* echo 'Video ID: ' . $videoEntry->getVideoId() . "\n"; - echo 'Updated: ' . $videoEntry->getUpdated() . "\n"; - echo 'Description: ' . $videoEntry->getVideoDescription() . "\n"; - echo 'Category: ' . $videoEntry->getVideoCategory() . "\n"; - echo 'Tags: ' . implode(", ", $videoEntry->getVideoTags()) . "\n"; - echo 'Watch page: ' . $videoEntry->getVideoWatchPageUrl() . "\n"; - echo 'Flash Player Url: ' . $videoEntry->getFlashPlayerUrl() . "\n"; - echo 'Duration: ' . $videoEntry->getVideoDuration() . "\n"; - echo 'View count: ' . $videoEntry->getVideoViewCount() . "\n"; - echo 'Rating: ' . $videoEntry->getVideoRatingInfo() . "\n"; - echo 'Geo Location: ' . $videoEntry->getVideoGeoLocation() . "\n"; - echo 'Recorded on: ' . $videoEntry->getVideoRecorded() . "\n"; - */ - - // see the paragraph above this function for more information on the - // 'mediaGroup' object. in the following code, we use the mediaGroup - // object directly to retrieve its 'Mobile RSTP link' child - /* foreach ($videoEntry->mediaGroup->content as $content) { - if ($content->type === "video/3gpp") { - echo 'Mobile RTSP link: ' . $content->url . "\n"; - } - } - - echo "Thumbnails:\n"; - $videoThumbnails = $videoEntry->getVideoThumbnails(); - - foreach($videoThumbnails as $videoThumbnail) { - echo $videoThumbnail['time'] . ' - ' . $videoThumbnail['url']; - echo ' height=' . $videoThumbnail['height']; - echo ' width=' . $videoThumbnail['width'] . "\n"; - } - */ + $videoId = $videoEntry->getVideoId(); + return $videoId; } $searchstring = searchterm(); -//$location = Zend_Gdata_YouTube::VIDEO_URI; $location = $yt->newVideoQuery(); $location->setOrderBy('viewCount'); $location->setSafeSearch('none'); $location->setVideoQuery($searchstring); -getAndPrintVideoFeed($location, $yt); +$videoID = getAndPrintVideoFeed($location, $yt); + +echo "Your youtube Video with the search string: " . $searchstring . "

"; +?> -echo "
Searchstring: " . $searchstring; +

+Get another one! -// + diff --git a/www/youtube_functions.php b/www/youtube_functions.php index 15153ec..17a8964 100644 --- a/www/youtube_functions.php +++ b/www/youtube_functions.php @@ -23,13 +23,18 @@ function searchterm(){ $table_array = array("english", "german"); $table_count = count("$table_array"); - - $rows = $db->query("SELECT count(*) as count FROM german;"); + + $table=$table_array[0]; + + $rows = $db->query("SELECT count(*) as count FROM ". $table . ";"); $row = $rows->fetchArray(); $numRows = $row["count"]; - - $search_word = mt_rand(1,$numRows); + + $random = mt_rand(1,$numRows); + $search_word_db = $db->query("SELECT word FROM " . $table . " WHERE id=" . $random . ";"); + $search_word_ar = $search_word_db->fetchArray(); + $search_word = $search_word_ar["word"]; return $search_word; } -- cgit v1.2.3