Re: Re: Still can't fix it.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jan 19, 2008 12:34 PM, Apple7777 <applepro7777@xxxxxxxxx> wrote:

> Jochem Maas <jochem <at> iamjochem.com> writes:
> > what's you exact code? how [exactly] do you run the code?
>
> Did you ask me or Nathan? My current code is (modified little bit,
> because Gmane doesn't allow to use lines longer than 80 characters):


that looks like my bad; i thought you asked that, not jocheem :(

error_reporting(E_ALL);
> $conn = mysql_connect("localhost:3306", "login", "pass") or die('Could not
> connect: ' . mysql_error());
> mysql_select_db("geo", $conn);
> mysql_query("SET NAMES 'utf8'");
>
>
> $sql = "SELECT * FROM geo.video_temporary WHERE id = 1";
> $trResult = mysql_query($sql, $conn) or die('Query failed: ' .
> mysql_error());
> while ($trInfo = mysql_fetch_assoc($trResult)){
>        $mainStatus = $trInfo['status'];
> }
>
> if($mainStatus == 200){ exit; }
>
>
> $sql = "SELECT * FROM geo.video_temporary WHERE status = 0";
> $trResult = mysql_query($sql, $conn) or die('Query failed: ' .
> mysql_error());
> while ($trInfo = mysql_fetch_assoc($trResult)){
>        $videoId = $trInfo['id'];
>        $videoUserid = $trInfo['userid'];
> }
>
> $userPath = "/home/re/video/".$videoUserid."/";
>
>
> $sql = "UPDATE geo.video_temporary SET status = 200 WHERE id = 1";
> $trResult = mysql_query($sql, $conn) or die('Query failed: ' .
> mysql_error());
>
> $sql = "UPDATE geo.video_temporary SET status = 1 WHERE id = ".$videoId;
> $trResult = mysql_query($sql, $conn) or die('Query failed: ' .
> mysql_error());
>
> $inputFile = $userPath.$videoId."temp";
> $outputFile = $userPath.$videoId.".flv";
> print "input file: ".$inputFile."<br />";
> print "output file: ".$outputFile."<br />";
>
> $first = "/usr/local/bin/mencoder -really-quiet -vf
> scale=448:-3,expand=448:336
> -sws 9 -of lavf -ovc lavc -lavcopts
>
> vcodec=flv:vbitrate=250:trell:v4mv:mv0:mbd=2:cbp:aic:cmp=3:subcmp=3:vpass=1
>
> -frames 800 -ofps 24000/1001 -oac mp3lame -lameopts abr:br=64:mode=0
>  -channels 1 -srate 22050 -of lavf -lavfopts format=flv -o
>  ".$outputFile." /home/re/ff/logo7.avi ".$inputFile;
>
> $second = "/usr/local/bin/mencoder -really-quiet -vf
> scale=448:-3,expand=448:336
> -sws 9 -of lavf -ovc lavc -lavcopts
>
> vcodec=flv:vbitrate=250:trell:v4mv:mv0:mbd=2:cbp:aic:cmp=3:subcmp=3:vpass=2
>
> -frames 800 -ofps 24000/1001 -oac mp3lame -lameopts abr:br=64:mode=0
> -channels 1 -srate 22050 -of lavf -lavfopts format=flv -o
>  ".$outputFile." /home/re/ff/logo7.avi ".$inputFile;
>
> print "first: ".$first."<br />";
> print "second: ".$second."<br />";
>
> print system("cd /usr/local/bin/");
> print system($first);
> print system($second);


ya; you should def get a simple version working w/ just mencoder from the
cli.
then get that working from the browser.  then add in the mysql support after
thats finished.

-nathan

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux