Databases
StackOverflow2013
Postsdbo
POyoutube api filtered search
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POyoutube api filtered search
    primarykey
    data
    text
    <p>I have a music site that use Youtube Api. I want to filter the videos by size. Because when there is a high quality video, concert shows etc. streaming can hobble at low speed internet connections. Also, i want to show pure music videos. I don't want show concert record, cover or remix etc. Which way do i fallow to filter original music records.</p> <p>By the way search codes i am using are</p> <pre><code> /* $params: string, artist_name - song returns an array &gt;&gt; video_id, video name, video length */ function youtube_find_video($params) { str_replace("'", "", $params); $q = preg_replace('/[[:space:]]/', '/', trim($params)); $q = utf8_decode(utf8_encode($q)); $replacements = array(',', '?', '!', '.'); $q = str_replace($replacements, "", $q); $feedURL = "http://gdata.youtube.com/feeds/api/videos/-/{$q}?orderby=relevance&amp;max-results=1"; $sxml = simplexml_load_file($feedURL); if(!$sxml) { return false; } else{ $entry = $sxml-&gt;entry; if(!$entry) { return false; } // get nodes in media: namespace for media information $media = $entry-&gt;children('http://search.yahoo.com/mrss/'); if($media) { // get video player URL $attrs = $media-&gt;group-&gt;player-&gt;attributes(); $url = $attrs['url']; if(!$url) { return false; break; } parse_str( parse_url( $url, PHP_URL_QUERY ), $my_array_of_vars ); $watch['id'] = $my_array_of_vars['v']; // get video name $watch['name'] = $media-&gt;group-&gt;title; // get &lt;yt:duration&gt; node for video length[minute] $yt = $media-&gt;children('http://gdata.youtube.com/schemas/2007'); $attrs = $yt-&gt;duration-&gt;attributes(); $watch['length'] = sprintf("%0.2f", $attrs['seconds']/60); $watch = simplexml_kurtul($watch); return $watch; } else { return false; } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USTahtakafa
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWelcome to SO. What is your question, what doesn't work?
      singulars
      1. POyoutube api filtered search
      1. USPekka 웃
    2. COThanks :) That code works fine but i want to improve it. Which way do i fallow to filter original music videos? Not, concert, cover or remix. Just original pure music videos.
      singulars
      1. POyoutube api filtered search
      1. USTahtakafa
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload