Jump to content


Extracting from database


4 replies to this topic

#1 b3nji

    Young Padawan

  • Members
  • Pip
  • 14 posts

Posted 30 June 2007 - 09:59 PM

Hey all.

i have made a personal website - note this has only been up for a few days and it aint finished.

But anyway i have a video page for e.g this page: www.ib3nji.com/video.php?c=music

I want to be able to add these YouTube videos into a mysql database. So eventually i can add the embeded code into the datbase through a php form.

At the moment i have to manually edit the HTML code. I want to do the database way like said. But how can i extract all of it and let the videos sort in a table but have a max of 4 columns?

So what i mean is say i got 8 videos in the database i want it so it will know to make 2 rows and 4 columns of videos.

I only know how to code it so it does 8 columns and 1 row.

thanks
b3nji

#2 rc69

    PHP Master PD

  • P2L Staff
  • PipPipPipPip
  • 3,827 posts
  • Gender:Male
  • Location:Here
  • Interests:Web Development

Posted 01 July 2007 - 02:09 AM

The answer to a part of your question can be found here: http://www.pixel2lif...showtopic=15327

Now you just have to work on the database part :whoosh[1]:

#3 fiv3isaliv3

    Young Padawan

  • Members
  • Pip
  • 258 posts
  • Gender:Male

Posted 01 July 2007 - 08:55 PM

View Postrc69, on Jul 1 2007, 03:09 AM, said:

The answer to a part of your question can be found here: http://www.pixel2lif...showtopic=15327

Now you just have to work on the database part :D

maybe I'm lazy but I've always used CSS for this. Create a container div and then stick the image, video whatever in another div with enough space so that only x of said image/video can display in that row. It might not be the most practical method but it doesn't require any processing server side.

#4 rc69

    PHP Master PD

  • P2L Staff
  • PipPipPipPip
  • 3,827 posts
  • Gender:Male
  • Location:Here
  • Interests:Web Development

Posted 01 July 2007 - 11:38 PM

Well, he said he wanted to database the videos. So either way you look at it, server-side stuff is going to have to be done. Of course, the script(s) in the link i posted can still be modified to use divs if he prefers that to tables (and can get it working).

#5 fiv3isaliv3

    Young Padawan

  • Members
  • Pip
  • 258 posts
  • Gender:Male

Posted 02 July 2007 - 08:24 AM

I think we both have different thought processes on this one.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users