Recherche avancée

Sur d’autres sites (7265)

• Merge remote-tracking branch ’dwbuiten/master’

  2 août 2012, par Michael Niedermayer

  Merge remote-tracking branch ’dwbuiten/master’

• How to count variable in for loop in power shell

  17 avril 2020, par ilham zacky

  I am using powershell and i have got a for loop running each time 3 variables get printed, for now, loop runs 5 times. I need to get the count like $i++

  



  This is a part of my code

  



  $file = "D:\edl\input\CPExport.xlsx"
$sheetName = "Sheet1"
$objExcel = New-Object -ComObject Excel.Application
$workbook = $objExcel.Workbooks.Open($file)
$sheet = $workbook.Worksheets.Item($sheetName)
$objExcel.Visible = $false
$rowMax = ($sheet.UsedRange.Rows).count
$nu = 0
$rowcount = 000 

for ($i = 0; $i -le $rowMax - 1; $i++) {
    $id = $sheet.Cells.Item($rowName + $i, $colName).text
    $name = $sheet.Cells.Item($rowAge + $i, $colAge).text
    $subtitle = $sheet.Cells.Item($rowCity + $i, $colCity).text
    $jpgId = "$id.jpg"
    $videoId = "$id.mp4"
    $audioId = "$id.m4a"
    $duration1 = if ((ffmpeg -i $audioId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };
    $duration2 = if ((ffmpeg -i $jpgId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };
    $duration = if ((ffmpeg -i $videoId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };

    $newduration = ("$duration").Replace(".", ":")
    $newduration1 = ("$duration1").Replace(".", ":")
    $newduration2 = ("$duration2").Replace(".", ":")

    $out1 = ""
    $out2 = ""
    $out = ""
    $nu++
    $rowcount++
    if ($newduration1) {

        if ($nu -eq 1) {
            $audioA = "00:00:00:00"
        }

        $audioB = Add-Frame -Base $newduration1 -Offset $audioA
        $out1 = "$rowcount" + "  " + "AX" + "   " + "AA" + "     " + "C" + "   " + "00:00:00:00" + " " + $newduration1 + "   " + $audioA 
    }

    if ($newduration2) {

        $imagecal = Add-Frame -Base $imageA -Offset "00:00:06:00"
        $imageB = $imagecal
        $out = "$rowcount" + "  " + "AX" + "   " + "V" + "      " + "C" + "   " + "02:00:05:15" + " " + $newduration2 + "   " + " " + $imageA 
    }


    if ($newduration) {

        $videoA = $imageB
        $videocal = Add-Frame -Base $newduration -Offset $videoA
        $videoB = $videocal
        $out2 = "$rowcount" + "  " + "AX" + "   " + "AA/V" + "   " + "C" + "   " + "00:00:00:00" + " " + $hh + "   " + " " + $videoA 
    }
    else {
        $videoB = ""
    }
    $gg = $out1 + "`n" + "`n" + $out + "`n" + "`n" + $out2 + "`n"
    echo $gg

    $gg | Out-File -FilePath d:\edl\input\output.txt -Append
}
#close excel file
$objExcel.quit()


  



  i have echo $gg
this is the output

  



  1 AX   AA     C   00:00:00:00 00:00:03:48   
1  AX   V      C   02:00:05:15 02:00:11:15
1  AX   AA/V   C   00:00:00:00 00:00:06:93 
2  AX   AA     C   00:00:00:00 00:00:03:46   
2  AX   V      C   02:00:05:15 02:00:11:15    
2  AX   AA     C   00:00:00:00 00:00:03:46  
3  AX   AA     C   00:00:00:00 00:00:03:52   
3  AX   V      C   02:00:05:15 02:00:11:15   
3  AX   AA/V   C   00:00:00:00 00:00:06:93    
4  AX   AA     C   00:00:00:00 00:00:03:21   
4  AX   V      C   02:00:05:15 02:00:11:15    
4  AX   AA     C   00:00:00:00 00:00:03:21   
5  AX   AA     C   00:00:00:00 00:00:03:05   
5  AX   V      C   02:00:05:15 02:00:11:15    
5  AX   AA/V   C   00:00:00:00 00:00:06:93    


  



  Output prints only 1-5 
I need it to be printed 1 - 15

  



  any suggestions ?

  



  thank you for reading

  


• How to add ffmpeg watermark text and trim videos to 60 seconds on this PHP video upload ?

  6 novembre 2017, par Brains Akd

  Below is the code for my video upload

  if (isset($_POST) and $_SERVER['REQUEST_METHOD'] == "POST") {
  
  
  
  
  
       if (isset($_GET['id']) && $_GET['id'] != "") {
  
           $id = $_GET['id'];
  
      }/* else {
  
          $id = $_SESSION['user_id'];
  
      }*/
  
     extract($_POST) ;
  
  
  
      $path = "video/answer_video/"; //set your folder path
  
      //set the valid file extensions 
  
     // $valid_formats = array("mp4", "jpg", "png", "gif", "bmp", "jpeg", "GIF", "JPG", "PNG", "doc", "txt", "docx", "pdf", "xls", "xlsx"); //add the formats you want to upload
  
   $valid_formats = array("mp4"); //add the formats you want to upload
  
  
  
      $name = $_FILES['answer_video']['name']; //get the name of the file
  
  
  
      $size = $_FILES['answer_video']['size']; //get the size of the file
  
  
  
      if (strlen($name)) { //check if the file is selected or cancelled after pressing the browse button.
  
          list($txt, $ext) = explode(".", $name); //extract the name and extension of the file
  
          if (in_array($ext, $valid_formats)) { //if the file is valid go on.
  
              if ($size ) { // check if the file size is more than 2 mb
  
                  $file_name = $_POST['filename']; //get the file name
  
                  $question_id = $_POST['question_id'];  
  
                  // $title = $_POST['title']; 
  
                  $title = strip_tags(trim($_POST['title']));
  
                  //get hashtag from message
  
                  $hashtag = gethashtags($title);
  
  
  
                  //$tags = $_POST['tags']; 
  
                  $category = $_POST['category']; 
  
  
  
                  $tmp = $_FILES['answer_video']['tmp_name'];
  
  
  
  
  
                  if (move_uploaded_file($tmp, $path . $name)) { //check if it the file move successfully.
  
                       $answer_video = $name;
  
                         $answer_type = "uploaded";
  
  
  
                      $video = $path . $name;
  
                      $length = 5;
  
  
  
  $randomletter = substr(str_shuffle("abcdefghijklmnopqrstuvwxyz"), 0, $length);
  
                     $rand = rand(1,10000000);
  
  $uniqueName = uniqid($rand);
  
  $thumbnail = "images/thumbnail_{$uniqueName}_{$randomletter}.jpg";
  
  
  
  // shell command [highly simplified, please don't run it plain on your script!]
  
  shell_exec("ffmpeg -i $video -deinterlace -an -ss 1 -t 00:00:01 -r 1 -y -vcodec mjpeg -f mjpeg $thumbnail 2>&1");
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
                      $msg = "Uploaded Successfully!";   
  
  
  
                       echo json_encode(array('msg'=>$msg,'res'=>$question_id));
  
                        $userid = $_SESSION['user_id'];

  How do I add top right watermark and trim the uploading videos to 30 seconds.? please do help

  I tried many times but it didn’t work..
  Your help is appreciated..
  Ffmpeg is working fine on the server and but didnt know how to do the above required