943,875 Members | Top Members by Rank

Ad:
Feb 22nd, 2009
0

Movie Database

Expand Post »
Ok, I love movies, and I am building a website to chronicle the movies in my collection. I have the layout, graphics and all of that. I can do all of that myself. I need to know what the best way to show the movie cover, synopsis and my own review without making a separate .html page for every one. I am pretty good at figuring things out so just a point in the right direction would be good. What I want to do is put up a list of the movies that I have reviewed and once clicked shows the cover, the synopsis and my review of the movie is there a shortcut to this without all of the html pages I have thousands of movies and its going to take long enough as it is.
Similar Threads
Reputation Points: 14
Solved Threads: 2
Light Poster
efaith77 is offline Offline
25 posts
since Sep 2006
Feb 22nd, 2009
0

Re: Movie Database

php and sql/mysql/mssql
an sql/mysql/mssql (depends on your host) database containing the name description actors review image(or link to the image) all the fields you need
the initial list page is generated from the database of names.
Click the link and it populates a php template with the contents of the database fields.

1 database
1 entry page
1 query page
1 template page
=
as many pages as you need, Search engine visible, etc
there may be a script available for download, even if you dont use the scripts they provide insite in how it works and makes the development easier
(there are many that scrape imdb to populate your database, a little nasty)
Reputation Points: 562
Solved Threads: 368
Posting Maven
almostbob is offline Offline
2,970 posts
since Jan 2009
Feb 22nd, 2009
0

Re: Movie Database

Thanks that is a great point in the right direction. I do not want to scrape another site. I am in it for the honest long haul, I am trying to be legal. I want my site to be useful to the visitors I will research some scripts and see what I can come up with. If you have a suggestion for free or paid version of a script that will work let me know. I am determined to do this myself.
Reputation Points: 14
Solved Threads: 2
Light Poster
efaith77 is offline Offline
25 posts
since Sep 2006
Feb 23rd, 2009
0

Re: Movie Database

no recommendations, this is the first reult of a google search for private movie rating php script
http://www.howtocreate.co.uk/php/moviedb.html
Reputation Points: 562
Solved Threads: 368
Posting Maven
almostbob is offline Offline
2,970 posts
since Jan 2009
Feb 23rd, 2009
0

Re: Movie Database

Thanks I will give it a look.
Reputation Points: 14
Solved Threads: 2
Light Poster
efaith77 is offline Offline
25 posts
since Sep 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: Dictionary Database Design
Next Thread in Database Design Forum Timeline: Recommendation on Database Design





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC