[Plugin: VideoGall] how to extract video caption from db?
-
Problem i want to show in homepage the name of the last 5 video inserted.
Before upgrade it worked, but now the table name changes and all data are stored in the option_value of optin_name:videogall_videos of table option .
Hi i use this querycode
foreach($results as $result) { //<? ogni ?riga? dell?array $results verr? assegnata all?array $resultif($v_count < 5){
?>- <?php echo $result[“option_value’] ?>
<?php }
$v_count ++;
} ?>
code
but now i display all the content –>
a:9:{i:0;a:7:{s:2:”id”;i:1;s:4:”name”;s:32:”l\’addestramento-i soliti ignoti”;s:3:”url”;s:40:”https://www.youtube.com/embed/eyxH9UGdZ7s”;s:9:”thumbnail”;s:49:”https://img.youtube.com/vi/eyxH9UGdZ7s/default.jpg”;s:8:”category”;s:10:”Formazione”;s:7:”caption”;s:19:”Formazione Insolita”;s:11:”description”;s:37:”Importanza Di Una Formazione Adeguata”;}i:1;a:7:{s:2:”id”;i:2;s:4:”name”;s:11:”Team work 3″;s:3:”url”;s:40:”https://www.youtube.com/embed/J-z6U1L8ol8″;s:9:”thumbnail”;s:49:”https://img.youtube.com/vi/J-z6U1L8ol8/default.jpg”;s:8:”category”;s:13:”Uncategorized”;s:7:”caption”;s:14:”Team è Meglio”;s:11:”description”;s:0:””;}i:2;a:7:{s:2:”id”;i:3;s:4:”name”;s:18:”gestione del tempo”;s:3:”url”;s:40:”https://www.youtube.com/embed/fMqIMe43GXM”;s:9:”thumbnail”;s:49:”https://img.youtube.com/vi/fMqIMe43GXM/default.jpg”;s:8:”category”;s:13:”Uncategorized”;s:7:”caption”;s:16:”Temporanea-mente”;s:11:”description”;s:46:”L’importanza Di Un’efficace Gestione Del Tempo”;}i:3;a:7:{s:2:”id”;i:4;s:4:”name”;s:18:”rompere uno schema”;s:3:”url”;s:40:”https://www.youtube.com/embed/hT089yJDmSY”;s:9:”thumbnail”;s:49:”https://img.youtube.com/vi/hT089yJDmSY/default.jpg”;s:8:”category”;s:13:”Uncategorized”;s:7:”caption”;s:18:”Rompere La Routine”;s:11:”description”;s:107:”è Importante E Di Valore Riuscire A Trovare Delle Risorse Per Rompere La Routine E Pensare Innovativamente”;} ……
how to show only the video name?
thanks
Maurizio
- The topic ‘[Plugin: VideoGall] how to extract video caption from db?’ is closed to new replies.