Recherche avancée

Sur d’autres sites (8016)

• Anomalie #4189 (Fermé) : extraire_multi mélange un /li /ul final avec le de langue ajouté p...

  8 mars 2021, par cedric -

  intégré par https://git.spip.net/spip/spip/commit/2731ba05209cf61588923a5cd8cc4442cad6878e alea jacta est

• PHP Foreach query only displays final result for slideshow ?

  22 janvier 2023, par ShaneRibz

  Using a query I pull the most liked video's on a localhosted stream webpage, and use FFMPEG to create a thumbnail if one isnt already existing and the video length.

  


  The query succesfully pulls the 4 most liked video's and displays them in a carousel. FFMPEG succesfully creates each thumbnail, and gets the length of each video.

  


  Somewhere, for whatever reason I cant figure out, only the final slide in the carousel displays the thumbnail as its background.

  


  Sorry if my code is messy, I'm learning how to better optimize.

  


  &lt;?php&#xA;                $sql = "use info";&#xA;                $pdo->exec($sql);&#xA;                $stmt = $pdo->query("SELECT * FROM `files` ORDER BY `like` DESC LIMIT 4");&#xA;                $filelist = $stmt->fetchAll(PDO::FETCH_ASSOC);&#xA;                    $h = 0;&#xA;                  foreach ($filelist as $row) {&#xA;                        if ($h &lt; 25){&#xA;                        $h&#x2B;&#x2B;;&#xA;                &#xA;                            $name = $row[&#x27;name&#x27;];&#xA;                            $location = $row[&#x27;location&#x27;];&#xA;                            $type = $row[&#x27;type&#x27;];&#xA;                            $uploadby = $row[&#x27;uploadby&#x27;];&#xA;                            $like = $row[&#x27;like&#x27;];&#xA;                            $id = $row[&#x27;fileid&#x27;];&#xA;                            $cat1 = $row[&#x27;Cat1&#x27;];&#xA;                            $cat2 = $row[&#x27;Cat2&#x27;];&#xA;            &#xA;                $ffmpeg = &#x27;F:\\xampp\ffmpeg.exe&#x27;;  &#xA;                $location = str_replace("/","\\", $location);&#xA;                $video = &#x27;F:\xampp\htdocs\\&#x27;. $location;  &#xA;                $bigloc = "F:\\xampp\htdocs\\thumb\big";&#xA;                $smallloc = "F:\\xampp\htdocs\\thumb\small";&#xA;                $image = $bigloc . "\\" . $name . ".jpg"; &#xA;                $image2 = $smallloc . "\\" . $name. ".jpg"; &#xA;                            &#xA;                if (file_exists($image) and (file_exists($image2))) {&#xA;                    &#xA;                } else {&#xA;                echo $image . " does not exist";&#xA;                $cmd="$ffmpeg -ss 00:25:00 -i ". "\"" . $video . "\"". " -s 1920x540 -vframes 1 ". "\"" .$image. "\"" . " -report";  &#xA;                $cmd2="$ffmpeg -ss 00:25:00 -i ". "\"" . $video . "\""." -s 270x370 -vframes 1 ". "\"" .$image2. "\"";&#xA;                echo "<br />". $cmd . "<br />".$cmd2."<br />";&#xA;                exec($cmd);&#xA;                exec($cmd2);&#xA;                }&#xA;                &#xA;                $file = "\"". $video. "\"";&#xA;                $result = shell_exec(&#x27;ffmpeg -i &#x27; . escapeshellcmd($file) . &#x27; 2>&amp;1&#x27;);&#xA;                preg_match(&#x27;/(?&lt;=Duration: )(\d{2}:\d{2}:\d{2})\.\d{2}/&#x27;, $result, $match);&#xA;                $time = $match[1];&#xA;                $image = "thumb/big/" . $name . ".jpg"; &#xA;                $image2 = "thumb/small/" . $name. ".jpg";&#xA;&#xA;            ?>&#xA;&#xA;            <div class="single-hero-slider-wrap single-animation-wrap slider-height-hm4 bg-image-hm4 slider-bg-color-black d-flex align-items-center slider-bg-position-1 bg-black" style="&amp;lt;?php echo &amp;#x27;background-image:url(&amp;#x27;. $image.&amp;#x27;);&amp;#x27;;?>">&#xA;                <div class="slider-content-hm4 slider-animated">&#xA;                    <h1 class="title animated">&lt;?php echo $name;?></h1>&#xA;                    <div class="sub-title-time-wrap">&#xA;                        <span class="sub-title animated">&lt;?php if ($cat2 != ""){ echo $cat1 .", ". $cat2; }else{ echo $cat1;}?></span>&#xA;                        <span class="time animated">&lt;?php echo $time;?></span>&#xA;                    </div>&#xA;                    <div class="slider-button">&#xA;                        <a href="http://stackoverflow.com/feeds/tag/movie-details.html" class="btn-style-hm4 animated">Watch Now</a>&#xA;                    </div>&#xA;                </div>&#xA;            </div>&#xA;&#xA;            &lt;?php    &#xA;                        }&#xA;                  }              &#xA;            ?>&#xA;

  


  When inspecting the source code on my web browser ;
"style="<?php echo 'background-image:url('. $image.');';?>"", this will only appear on the final slide. The first 3 slides wont have "background-image" at all.

  


  I feel as though I'm making a silly mistake and just cant see it.

  


  EDIT
I should note, the "$name" and "$time" for each displays properly, its just the background-image that does not.

  


  EDIT 2
Here is the source code :

  


  <div class="single-hero-slider-wrap single-animation-wrap slider-height-hm4 bg-image-hm4 slider-bg-color-black d-flex align-items-center slider-bg-position-1 bg-black" style="background-image: url(&amp;#x27;thumb/big/Alita Battle Angel.png&amp;#x27;);">&#xA;</div>

  


  The "background-image" shows in source, but during inspect element it does not. No errors populate either.

  


• FFMPEG remove codec x264 to final films

  23 septembre 2017, par HenrykVIII

  I am processing my movie in ffmpeg (file merging, stabilization). The resulting metadata file gets an x264 codec. What prevents it from being reprocessed ?

  I decided to remove the codec using the Internet.
  script :

      ffmpeg -i input.mp4 -c copy -map 0 -metadata creation_time="2017-09-18 13:30:04" output.mp4
  
  ffmpeg -i output.mp4 -vcodec copy -acodec copy -vbsf h264_changesps=removesei -map_metadata -1 out.mp4
  
  pause

  Unfortunately it does not work :

  Unknown bitstream filter h264_changesps

  What am I doing wrong ?