PHP - Embade Youtube Link Using Regexp

This is the first time Im trying to use REGEXP, but cant get it working. It gives no error, just nothing..Anyone got idea why, please? Thanks

<?php
                  include ('connectToDatabase.php');
                  
                  $getSearch = $_REQUEST['getSearch'];
                  
                  $keywordSearchQuery = "SELECT shoeName, shoeSize, colour, price, gender, description WHERE
                  shoeName REGEXP '.*($getSearch).*' ||
                  shoeSize REGEXP '.*($getSearch).*' ||
                  colour REGEXP '.*($getSearch).*' ||
                  price REGEXP '.*($getSearch).*' ||
                  gender REGEXP '.*($getSearch).*' ||
                  description REGEXP '.*($getSearch).*"
                  ;
                  
                  $keywordSearchQueryResult = mysql_query($keywordSearchQuery);
                  
                  echo "$keywordSearchQueryResult";
               ?>

Folks,

I am just trying to learn PHP.  For form input validation which is better - Regexp or PHP Filters?  Or do they have  completely different uses?  Where does preg fit in?

Thank you!
J.S.

Hi there, im looking for a little bit of help, could someone who knows how to use REXEXP properly tell me how i would select only the uppercase titles from title column and display them

Code: [Select]
+------------+-----------+
| id             | title        |
+------------+-----------+
| 1             | one        |
| 2             | TWO       |
| 3             | three      |
| 4             | FOUR      |
+------------+-----------+

Code: [Select]
<?php

$username="user";
$password="pw";
$database="db";


mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT title FROM template WHERE name REGEXP '^(A|B|C|D|E|F|G|H|I|J|K|L|M|N|O|P|Q|R|S|T|U|V|W|X|Y|Z)'";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo  "Custom Template Name : {$row['title']} <br><br>";
} 

mysql_close();
?>

This was an attempt i made but it did not work i got the following error:
Quote

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\ProgramData\xampp\htdocs\test.php on line 14


I did attempt to do a search on it but if im honest i didnt fully understand what they were saying.



Im using php 5.3.5 and mysql 5.5.8

Thanks for your help

Hi Guys

I am having trouble with a mysql regexp expression called through php.  I am not sure but I suspect its to do with the {} in the mysql code and PHP parsing them incorrectly.

Here is my code snippet:

$q = mysql_real_escape_string($_POST['keyword']);
$limit = 10;  //limit number of responses from dictionary            
$remainder = 11 - strlen($q);
if ($q)
{
$qy = "SELECT * FROM dict_list WHERE UCASE(word) <> UCASE('$q') AND (word REGEXP '^$q.{$remainder}') LIMIT $limit";
$query = mysql_query($qy);
 
...

What I want to do is this:

a user types in a word.  I then want to query a dictionary table called dict_list for all matches of the this word up to 11 characters max.

Example:

if $q was the word aero then the response would be all words beginning with aero and up to a max of 11 characters.  That is why IU thought I could calculate length of $q and from this get the $remainder = 11 - strlen($q) then in the REGEXP use .{$remainder} but when testing if I echo out the query $qy the curly braces will not show on screen.

Any help would be greatly appreciated.

I hope this is posted in correct location. Apologies if not.

Thanks,

Fergal.

I have this function:
    function bbcode($input){
        $input = strip_tags($input);
        $input = htmlentities($input);
        
        $search = array(
                    '/\[b\](.*?)\[\/b\]/is',
                    '/\[i\](.*?)\[\/i\]/is',
                    '/\[u\](.*?)\[\/u\]/is',
                    '/\[img\](.*?)\[\/img\]/is',
                    '/\[url=http://(.*?)\](.*?)\[\/url\]/is',
                    '/\[color=(.*?)\](.*?)\[\/color\]/is',
                    '/\[yt\](.*?)\[\/yt\]/is',
        );
        
        $replace = array(
                    '<b>$1</b>',
                    '<i>$1</i>',
                    '<u>$1</u>',
                    '<img src="$1" style="border:0">',
                    '<a href="$1">$2</a>',
                    '<font style="color:$1">$2</font>',
                    '<object width="660" height="405">
                    <param name="movie" value="'.str_replace("watch?v=", "v/", $1).'" />
                    <param name="allowFullScreen" value="true" />
                    <param name="allowscriptaccess" value="always" /><embed type="application/x-shockwave-flash" width="660" height="405" src="'.str_replace("watch?v=", "v/", $1).'" allowscriptaccess="always" allowfullscreen="true"></embed>
                    </object>',
        );
        
        return nl2br(preg_replace($search,$replace,$input));
    }
There is an error on code:
<param name="movie" value="'.str_replace("watch?v=", "v/", $1).'" />
and on:
<param name="allowscriptaccess" value="always" /><embed type="application/x-shockwave-flash" width="660" height="405" src="'.str_replace("watch?v=", "v/", $1).'" allowscriptaccess="always" allowfullscreen="true">
How can i use str_replace in this situation ? :S

Hi,

I'm working with the YouTube API to echo a feed based on a user's query.

My current code is below.  With this code, a whole list of videos is retrieved.

However, in order to present the feed as I wish to... I need to return each video in the feed individually. 

I am unsure how to do this and any advice would be really appreciated.

Code: [Select]
$feedURL = "http://gdata.youtube.com/feeds/api/videos/-/$youtubeQuery?orderby=viewCount&max-results=10";
               
          // read feed into SimpleXML object
          $sxml = simplexml_load_file($feedURL);
 
          // iterate over entries in resultset
          // print each entry's details

          foreach ($sxml->entry as $entry) {
          // get nodes in media: namespace for media information
          $media = $entry->children('http://search.yahoo.com/mrss/');
                 
          // get video player URL
          $attrs = $media->group->player->attributes();
          $watch = $attrs['url'];
                 
          // get video thumbnail
          $attrs = $media->group->thumbnail[0]->attributes();
          $thumbnail = $attrs['url'];
                 
          // get <yt:duration> node for video length
          $yt = $media->children('http://gdata.youtube.com/schemas/2007');
          $attrs = $yt->duration->attributes();
          $length = $attrs['seconds'];

          // get video title
          $title = $media->group->title;
                 
          // get <gd:rating> node for video ratings
          $gd = $entry->children('http://schemas.google.com/g/2005');
          if ($gd->rating) {
          $attrs = $gd->rating->attributes();
          $rating = $attrs['average'];
          } else {
          $rating = 0;
          }
           
          }
          ?>

The application that I want to build is quite simple. Here is a bit of the background of the work flow:

In my company, we create video for our client profile. After the video is done, we upload the video to our website and to youtube. It is done automatically.

After a period of time, the client can delete the video. Of course, it will delete the video in our system as well as the video in youtube. For now, the video in our system is deleted automatically. However, youtube video is deleted manually.

Our company has grown to have quite a lot of clients. It's hard for us to keep track clients that requested to delete their videos. We want to be able to have an application that will delete youtube video automatically.

I already tried to play around with youtube authentication in http://code.google.com/apis/youtube/2.0/developers_guide_php.html#Authentication but I have no luck with the authentication.

I want the application to be able to delete the video under my youtube account without having me to login to youtube. In my case right now, every time the application wants to delete the video, I have to send the request to youtube and ask for verification (i.e. I have to do application verification every time).

Here is what I have done so far:


ini_set('display_errors', 1);
ini_set('log_errors', 1);
ini_set('error_log', dirname(__FILE__) . '/error_log.txt');
error_reporting(E_ALL);


require_once('db_class.php');
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata_YouTube');
Zend_Loader::loadClass('Zend_Gdata_AuthSub');
Zend_Loader::loadClass('Zend_Gdata_App_Exception');

session_start();
setLogging('on');
$_SESSION['developerKey'] = 'AI39si5H3hL9tcKOMl80IqzoC6nb87ka1QLgHxLp9nFi1l44dLa987_Gi0rbofLePQdFEWf1lrSB8KGs4lXIrcF8TR6PhUcO3Q';

function getAuthSubRequestUrl()
{
    $next = 'http://example.com/youtube_delete_video.php';
    $scope = 'http://gdata.youtube.com';
    $secure = false;
    $session = true;
    return Zend_Gdata_AuthSub::getAuthSubTokenUri($next, $scope, $secure, $session);
}

function updateAuthSubToken($singleUseToken)
{
    try {
        $sessionToken = Zend_Gdata_AuthSub::getAuthSubSessionToken($singleUseToken);
    } catch (Zend_Gdata_App_Exception $e) {
        print 'ERROR - Token upgrade for ' . $singleUseToken
            . ' failed : ' . $e->getMessage();
        return;
    }

    $_SESSION['sessionToken'] = $sessionToken;
        
    generateUrlInformation();
    
    header('Location: ' . $_SESSION['homeUrl']);
}

function getAuthSubHttpClient()
{
    try {
        $httpClient = Zend_Gdata_AuthSub::getHttpClient($_SESSION['sessionToken']);
    } catch (Zend_Gdata_App_Exception $e) {
        print 'ERROR - Could not obtain authenticated Http client object. '
            . $e->getMessage();
        return;
    }
    $httpClient->setHeaders('X-GData-Key', 'key='. $_SESSION['developerKey']);
    return $httpClient;
}

function generateUrlInformation()
{
    if (!isset($_SESSION['operationsUrl']) || !isset($_SESSION['homeUrl'])) {
        $_SESSION['operationsUrl'] = 'http://'. $_SERVER['HTTP_HOST']
                                   . $_SERVER['PHP_SELF'];
        $path = explode('/', $_SERVER['PHP_SELF']);
        $path[count($path)-1] = 'index.php';
        $_SESSION['homeUrl'] = 'http://'. $_SERVER['HTTP_HOST']
                             . implode('/', $path);
    }
}

function loggingEnabled()
{
    if ($_SESSION['logging'] == 'on') {
        return true;
    }
}

function setLogging($loggingOption, $maxLogItems = 10)
{
    switch ($loggingOption) {
        case 'on' :
            $_SESSION['logging'] = 'on';
            $_SESSION['log_currentCounter'] = 0;
            $_SESSION['log_maxLogEntries'] = $maxLogItems;
            break;

        case 'off':
            $_SESSION['logging'] = 'off';
            break;
    }
}

function logMessage($message, $messageType)
{
    if (!isset($_SESSION['log_maxLogEntries'])) {
        $_SESSION['log_maxLogEntries'] = 20;
    }

    if (!isset($_SESSION['log_currentCounter'])) {
        $_SESSION['log_currentCounter'] = 0;
    }

    $currentCounter = $_SESSION['log_currentCounter'];
    $currentCounter++;

    if ($currentCounter > $_SESSION['log_maxLogEntries']) {
        $_SESSION['log_currentCounter'] = 0;
    }

    $logLocation = 'log_entry_'. $currentCounter . '_' . $messageType;
    $_SESSION[$logLocation] = $message;
    $_SESSION['log_currentCounter'] = $currentCounter;
}

function printCacheWarning()
{
    return '<p class="note">'
         . 'Please note that the change may not be reflected in the API '
         . 'immediately due to caching.<br/>'
         . 'Please refer to the API documentation for more details.</p>';
}


function editVideoData($videoId)
{
    $httpClient = getAuthSubHttpClient();
    $youTubeService = new Zend_Gdata_YouTube($httpClient);
   $videoEntryToUpdate = $youTubeService->getFullVideoEntry($videoId);

    if (!$videoEntryToUpdate instanceof Zend_Gdata_YouTube_VideoEntry) {
        print 'ERROR - Could not find a video entry with id ' . $videoId
            . '<br />' . printCacheWarning();
        return;
    }

    try {
        $putUrl = $videoEntryToUpdate->getEditLink()->getHref();
    } catch (Zend_Gdata_App_Exception $e) {
        print 'ERROR - Could not obtain video entry\'s edit link: '
            . $e->getMessage() . '<br />';
        return;
    }

    $videoEntryToUpdate->setVideoTitle("My Test Movie - Private 10000012");
    $videoEntryToUpdate->setVideoDescription("My Test Movie - Private 10000012");
    $videoEntryToUpdate->setVideoPrivate();

    try {
        $updatedEntry = $youTubeService->updateEntry($videoEntryToUpdate, $putUrl);
        if (loggingEnabled()) {
            logMessage($httpClient->getLastRequest(), 'request');
            logMessage($httpClient->getLastResponse()->getBody(), 'response');
        }
    } catch (Zend_Gdata_App_HttpException $httpException) {
        print 'ERROR ' . $httpException->getMessage()
            . ' HTTP details<br /><textarea cols="100" rows="20">'
            . $httpException->getRawResponseBody()
            . '</textarea><br />'
            . '<a href="session_details.php">'
            . 'click here to view details of last request</a><br />';
        return;
    } catch (Zend_Gdata_App_Exception $e) {
        print 'ERROR - Could not post video meta-data: ' . $e->getMessage();
        return;
    }
        print 'Entry updated successfully.<br /><a href="#" onclick="'
            . 'ytVideoApp.presentFeed(\'search_owner\', 5, 0, \'none\'); '
            . 'ytVideoApp.refreshSearchResults();" >'
            . '(refresh your video listing)</a><br />'
            . printCacheWarning();
}


if (!isset($_GET['token'])) {

$returnURL = getAuthSubRequestUrl();
echo "<a href=".$returnURL.">Link To Google</a>";

} else {
$singleUseToken = $_GET['token'];
updateAuthSubToken($singleUseToken);

/* editVideoData('mJDRXXaFVGw'); */
}



This is how I call the function: http://example.com/youtube_delete_video.php

So, what I need basically is to know
1. how can I store the authentication after I verify it from youtube?
2. What function to populate after I store the authentication? <- I couldn't figure where this part is in the documentation.

PS: example.com is not a real url. It's just for the sake of writing the post he )

Has anyone had any success doing this?

I'm not sure if I should try to write this myself or use some kind of framework. I found the Zend Gdata framework (http://framework.zend.com/manual/en/zend.gdata.html) and tried it out but I kept getting error: Warning: include_once() [function.include]: Failed opening '1' for inclusion (include_path='.:/usr/share/pear')

I'm assuming it needs to find PEAR which I don't have installed but no where in the Zend docs does it say that it requires PEAR so I'm a little confused. I've never used any of the Zend frameworks so I have no idea if it needs PEAR or not.

Anyone have any other methods for doing this?

thanks.

Before you say about trying to use curl and fsockopen...I have tried those already but my host does not allow it due to their settings on their php.ini file.

I am wondering if there is a way (other than those above) to grab the latest videos from a specific user on youtube, and be able to display them on a website, such as grabbing information about the video, as well as displaying it.

If this is at all possible, and you can help...thanks in advance.

hello,
I am trying to figure out how I can take only the v= in the youtube urls

http://www.youtube.com/watch?v=nGawAhRjtoA&feature=topvideos

i just want php to take v=nGawAhRjtoA and ignore everything else

any ideas guys/gals?

thanks

Youtube has an advanced api to deliver xml; but when I try to parse its xml, it is not well-defined. I want to get "average rating" for a given video, but simple xml load disregard this section:
$xml = simplexml_load_file('http://gdata.youtube.com/feeds/mobile/videos/wZ252E282go');
print_r($xml);

How can I put the value of "average rating" into an string to echo?

Code: [Select]
$txt = preg_replace( "#\[yt\]http://www.youtube.com/watch?v=(.+?)\[/yt\]#is", '<embed src="http://www.youtube.com/v/\\1" type="application/x-shockwave-flash" wmode="transparent" width="512" height="313" allowfullscreen="true" />', $txt );

Okay this is my code just for inserting it into HTML, the problem is whenever I try to use:

Code: [Select]
[yt]http://www.youtube.com/watch?v=l1G7TJD6Xu0[/yt]
On my form to enter it does not work?  But if I use

Code: [Select]
$txt = preg_replace( "#\[yt\](.+?)\[/yt\]#is", '<embed src="http://www.youtube.com/v/\\1" type="application/x-shockwave-flash" wmode="transparent" width="512" height="313" allowfullscreen="true" />', $txt );
Code: [Select]
[yt]l1G7TJD6Xu0[/yt]
It works.


But I want to use the full URL of the youtube, so I don't want my users to copy/paste just the "l1G7TJD6Xu0" Code , any help? Thank you

Does anyone know of a json or php method of authenticating a youtube user without using zend?

Code: [Select]
<?php
$id = NULL;
$username = 'myYouTubeAccount'; 
$url = 'http://gdata.youtube.com/feeds/api/users/%s/uploads?orderby=updated&max-results=8';
$xml = simplexml_load_file(sprintf($url, $username));

foreach ($xml->entry as $entry) :

    $kids = $entry->children('http://search.yahoo.com/mrss/');
    $attributes = $kids->group->content[0]->attributes();
    $flv = $attributes['url'];
    $attributes = $kids->group->player->attributes();
    $link = $attributes['url']; 

    $querystring = parse_url($link,PHP_URL_QUERY);
    parse_str($querystring, $id_temp);
    $id = $id_temp['v'];
?>

<a href="<?=$link?>"> <img src="http://i4.ytimg.com/vi/<?=$id?>/default.jpg"  /> </a>

<?php endforeach; ?>

hello guys i am a newbie want help with how to upload a youtube in your script and in database i know about the $_files thing but how do i give a link

please help me out !!

Basically what the title says, I want to detect a upload and post a notification, how would i do this?