PHP - Embedding A Youtube Video Within A Concatenated String

here i am again...

so i have this algorithm that computes the current academic year for our school..
it outputs the correct academic year on a browser..
but when i try to insert it into my database, the data inserted goes wrong..

it just keeps on inserting -1 instead of the string 2011-2012

here's my code:
Code: [Select]
<?php

 $year = date('Y');
 $currentyear = $year;
 $lastyear = $year - 1;
 $nextyear = $year + 1;
 
 if (date('m') < 6)
 {
 $current_ay = $lastyear."-".$currentyear;
 }
 else
 if (date('m') >= 6)
 {
 $current_ay = $currentyear."-".$nextyear;
 }
 
 echo $current_ay;
  $insertSQL = "INSERT INTO tbl_elections (election_id) values ($current_ay)";

  mysql_select_db($database_organizazone_db, $organizazone_db);
  $Result1 = mysql_query($insertSQL, $organizazone_db) or die(mysql_error());

?>

*the database column to be inserted into is of varchar data type

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 !!

Hi,

Thanks in advance, I want to update youtube videos. here is my code. let me tell you firstly, i am very new to php.

public function updateVideo($title,$description)
      {
         $title="Hello";
         $description="Updating video info";
         $result=$this->clientLoginAuth($this->username,$this->pass);
         //$fdata = file_get_contents($fullFilePath);   
         $tmpdata = '<?xml version="1.0"?>
            <entry xmlns="http://www.w3.org/2005/Atom" xmlns:media="http://search.yahoo.com/mrss/" xmlns:yt="http://gdata.youtube.com/schemas/2007">
            <media:group>
            <media:title type="plain">'.$title.'</media:title>
            <media:description type="plain">'.$description.'</media:description>
            <media:category scheme="http://gdata.youtube.com/schemas/2007/categories.cat">People</media:category><media:keywords>Breathe Parkour Magazine</media:keywords>
            </media:group>
            <yt:accessControl action="comment" permission="allowed"/>
              <yt:accessControl action="commentVote" permission="allowed"/>
              <yt:accessControl action="videoRespond" permission="allowed"/>
              <yt:accessControl action="rate" permission="allowed"/>
              <yt:accessControl action="list" permission="allowed"/>
              <yt:accessControl action="embed" permission="allowed"/>
              <yt:accessControl action="syndicate" permission="allowed"/>

            </entry>
            ';
         $url = 'http://gdata.youtube.com/feeds/api/users/breathparkour/uploads/6yStkCdeLEU';
         //echo $url;
         $data = '--f93dcbA3
          Content-Type: application/atom+xml; charset=UTF-8
         
         '.$tmpdata.'
         --f93dcbA3
         Content-Type: video/quicktime';
         
         //echo $data;
         return $this->make_update_request($url,$data);
      }

public function make_update_request($url,$data){
         
         //echo $url;

         $token = $this->accessToken;
         $developerKey = $this->developerKey;
         
         $ch = curl_init();
         curl_setopt($ch, CURLOPT_URL, $url);
         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
         
         if($this->authType == 'GoogleLogin')
            $curlheader[0] = "Authorization: ".$this->authType." auth=\"$token\"";
         else
            $curlheader[0] = "Authorization: ".$this->authType." token=\"$token\"";

         $curlheader[1] = "X-GData-Key: key=\"$developerKey\"";
         $curlheader[2] = "Host: gdata.youtube.com";
         $curlheader[3] = "Content-Type: application/atom+xml";
         $curlheader[4] = "Content-Length: ".strlen($data);
         $curlheader[5] = "GData-Version: 2";
         
         curl_setopt($ch, CURLOPT_HTTPHEADER, $curlheader);
         //curl_setopt($ch, CURLOPT_POST, 1);
         curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
         curl_setopt($ch, CURLOPT_PUT, true);
         
         
         $output = curl_exec($ch);
         curl_close($ch);
         
         print_r($output);
         
         $validresult = $this->checkErrors($output);
         
         print_r($validresult);
         
         //echo $output;
         if($validresult['is_error'] == 'No')
         {
            unset($validresult);
            return "Success";
         }
         else
         {
            $result = array();
            $result['is_error'] = $validresult['is_error'];
            $result['error'] = $validresult['error'];
            unset($validresult);
            return $result;

         }
      }


i am getting this error.

GDataParseExceptionPremature end of file

Please help me. i have spent almost 6 hours on this issue. Pleazzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz zzzzzzzzzzzzzzzzzzz

I can search for videos by keyword and can fetch videos list from youtube using its api in php. I can fetch video title, description, thumbnail etc. but how can i fetch video url not like this -> youtube.com/watch?id=xyz...     Example: ytpak[dot]com

Hello,

I embed some YouTube videos on my site. Sometimes a video is deleted from YouTube and I have no way of knowing. Does anyone know if there is some php script or by using their API you can check if a video has:

- video has been removed
- video is not embeddable any more

any ideas? Thanks
/df