Click here to Skip to main content
15,883,825 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi everybody, pls i need help here. i ve a video player and i want to populate video on it from mysql database, here is my code.
HTML
<ul id="playlist1" style="display:none;">

               <li data-thumb-source="assets/img/ddd.jpg" data-video-source="assets/video/ddd.mp4" data-poster-source="assets/img/ddd.jpg" data-downloadable="yes">
                   <div data-video-short-description="">
                       <div>
                           <p class="minimalDarkThumbnailTitle">ddd</p>
                           <p class="minimalDarkThumbnailDesc">dddd.</p>

                       </div>
                   </div>
                   <div data-video-long-description="">
                       <div>
                           <p class="minimalDarkVideoTitleDesc">dddd</p>
                           <p class="minimalDarkVideoMainDesc">ddd</p>
                           <p>For more information about this please follow <a href="#" target="_blank">this link</a></p>
                       </div>
                   </div>
               </li>
           </ul>

and i ve mysql database like this

id | data-thumb-source | data-video-source | data-poster-source | minimalDarkThumbnailTitle | minimalDarkThumbnailDesc


and php code to get the data from mysql

PHP
<ul>
    <?php
    $sql = "SELECT * FROM `video`";
    foreach ($db->query($sql) as $row) {
        $li  = '<li> data-thumb-source="' .$row['data-thumb-source']. '"';
        $li .= ' class="playlistItem" data-type="local"';
        $li .= ' data-video-source="' .$row['data-video-source']. '"';
        $li .= ' minimalDarkThumbnailTitle="' .$row['minimalDarkThumbnailTitle']. '"';
        $li .= ' minimalDarkThumbnailDesc="' .$row['minimalDarkThumbnailDesc']. '"';
        echo $li;
    }
    $db = null;
?>
</ul>

and video list is still blank, no video to display, pls help me to get it work
Posted
Updated 8-Jul-15 1:33am
v2
Comments
Eng.Yahya92 8-Jul-15 7:57am    
you do not have closing tag </li>
try using indexes instead of column names, it worked for me once
plus, is it ok to have contents in li directly?
gabmedia 8-Jul-15 9:15am    
still not working, thank for ur resonds

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900