Jump to content


Photo

Help with PHP/MySQL


  • Please log in to reply
1 reply to this topic

#1 kgpri2

kgpri2
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 17 April 2006 - 11:48 AM

Hi all,

I'm creating a website that will (primarily) have thousands of videos. Rather than using a template to create a new HTML page for each new video(i.e. to avoid having to create thousands of HTML pages), I want to use PHP so that clicking a particular video link will 1. open the (one and only) video player page and 2. get the relevant video file. I've configured PHP/MySQL/Apache/phpMyAdmin and have them running smoothly. I'm not sure if we need to create a database in MySQL to hold the videos(and/or their details) or whether PHP code alone will be sufficient.

Thanks guys

#2 Jewbilee

Jewbilee
  • Members
  • PipPipPip
  • Advanced Member
  • 33 posts

Posted 17 April 2006 - 02:55 PM

yea, basically, create a mysql database that you can hold the video source as well as the id number and any other info you want display..

then in the playvideo.php or whatever, have it called everything like title, source, or whatever.

to have it call a certain video create a link like this..

[a href=\"http://www.whatever.com/playvideo.php?id=5\" target=\"_blank\"]http://www.whatever.com/playvideo.php?id=5[/a]

then do
$id = $_GET['id']

use mysql to call all the video files with the id of 5

obviously only 1 of them should have 5 so then you just display all the information that it has.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users