Jump to content

Recommended Posts

Hi

 

I have a list of youtube videos in a flat file database. I would like to print a thumbnail of these videos out to the end user in a table.

 

The results need to have pagination as well as a dynamic table so i can display say 3 rows and 3 columns per page.

 

The column amount will also need to be adjustable in case i wish to change the columns from 3 to 4 for example:



$video_file_data[];                 //This is the array in which all video info will be stored
$start = $_REQUEST['start'];        //pagination setting
$videos_per_page = 9;               //Show 9 Vids per page
$table_colums = 3;                  //Amount of columns needed to display results per page
$num = count ($video_file_data);    //Number of lines in data array
$max_pages = @ceil($num / $videos_per_page);   //Maximum number of Pages
$cur = @ceil($start / $videos_per_page)+1;
for($i=$start;$i<min($num,($start+$videos_per_page)+0);$i++)
 {
 list($date_added, $video_title, $youtube_url) = explode('|', trim($video_file_data[$i]));

    // <--- Table needs to go

}


The info stored in 

$video_file_data[]

would look something like this:


date 1."|".title 1."|".youtube url 1 
date 2."|".title 2."|".youtube url 2
date 3."|".title 3."|".youtube url 3
date 4."|".title 4."|".youtube url 4

Many thanks for the help :)

 

 

Link to comment
https://forums.phpfreaks.com/topic/281021-dynamic-table-with-pagination-flat-file/
Share on other sites

The logic is no different to pagination using a proper database.

 

Still stuck?

 

i really stuck lol, been tryin to work it out all night lol

 

I just dont even know where to start with the table and how to create the dynamic columns

 

If you could help id be very grateful, oh master lol  :)

The logic is no different to pagination using a proper database.

 

Still stuck?

 

Sorry but if by "proper database" you mean a SQL database, I have never worked with one so i have no idea about how they work

 

It is something I may look into in the future :)

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.