Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Video Database Web Page Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
flyred
Newbie
Newbie
Avatar

Joined: October 28 2005
Location: United States
Online Status: Offline
Posts: 10
Posted: November 12 2005 at 10:01 | IP Logged Quote flyred
Hey folks,

Has anyone written any html/php etc. that can be used to update and display your video collection? I'd like to move what I have now into the database and display it back out for the family to use.

Thanks
Back to Top View flyred's Profile Search for other posts by flyred
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: November 14 2005 at 19:34 | IP Logged Quote TonyNo
Not I. Maybe Dave?
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: November 15 2005 at 21:05 | IP Logged Quote dhoward
Nothing is available yet. I havent even created a report for the video related stuff.

My intention was to allow the definition of jukebox DVD players with control similar to PowerHome's CD jukebox control. It will necessitate some database reorganizing that Ive been putting off until I get the latest batch of controllers and technology integrated.

However, that isn't to say that you couldnt use the existing video table with some PSP. Pasted below is a simple PSP page that will give you video data:

Code:
<html>
<head><title>Video Collection</title></head>
<body>
<%ph_rtne(ph_setvar_a(1,1,"") + ph_sqlselect(1,"select * from video order by 2"))%>
<%ph_rtne(ph_forloopwinc('ph_concatvar(1,1,"<p>< b>ID: </b>" + ph_getdata(1,ph_getvar_n(1,2),1) + "<br><b>Title: </b>" + ph_getdata(1,ph_getvar_n(1,2),2) + "<br><b>Summary: </b><br>" + ph_getdata(1,ph_getvar_n(1,2),10) + "</p>")',1,ph_getsqlrows(1),1,2))%>
<%ph_rtne(ph_sqldestroy(1))%>
<%ph_getvar_s(1,1)%>
</body>
</html>


Keep in mind that the above is very simple and can be dressed up quite a bit but gives you an idea of where to start.

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum