| | |
Movie Database
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
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.
Some of my work.
http://www.backroads-inc.com
http://www.pctradepost.net
http://www.movieboxes.net
[SIGPIC][/SIGPIC]
http://www.backroads-inc.com
http://www.pctradepost.net
http://www.movieboxes.net
[SIGPIC][/SIGPIC]
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)
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)
Failure is not an option It's included free, you don't have to do anything to get it
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it
Please mark solved problems, solved
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it
Please mark solved problems, solved
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.
Some of my work.
http://www.backroads-inc.com
http://www.pctradepost.net
http://www.movieboxes.net
[SIGPIC][/SIGPIC]
http://www.backroads-inc.com
http://www.pctradepost.net
http://www.movieboxes.net
[SIGPIC][/SIGPIC]
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
http://www.howtocreate.co.uk/php/moviedb.html
Failure is not an option It's included free, you don't have to do anything to get it
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it
Please mark solved problems, solved
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it
Please mark solved problems, solved
Thanks I will give it a look.
Some of my work.
http://www.backroads-inc.com
http://www.pctradepost.net
http://www.movieboxes.net
[SIGPIC][/SIGPIC]
http://www.backroads-inc.com
http://www.pctradepost.net
http://www.movieboxes.net
[SIGPIC][/SIGPIC]
![]() |
Similar Threads
- MySQL Database Help (PHP)
- Movie database Help (C++)
- Favourite Movies? (Geeks' Lounge)
- Retrieving Multiple Columns into Dropdown List (ASP.NET)
- Pascal database check (Pascal and Delphi)
- PHP Query, Make users login before accessing a movie? (PHP)
Other Threads in the Database Design Forum
- Previous Thread: Dictionary Database Design
- Next Thread: Recommendation on Database Design
| Thread Tools | Search this Thread |






