Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    Regular Coder
    Join Date
    Jul 2007
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    should i use a database?

    I've got a website that contains 500 or so pages. All of them are in the same format. I'm wondering if it would be best to place the content in each page in a mysql database and then display the info on a page by using the URL (page.php?id=001, id=002, etc).
    The content in each page is basically lengthy summaries (1000 words or so) for TV shows, movies, etc. Right now I have each of those summaries on a separate page of its own. Should I stick to what I'm doing right now or use a database? I know that using a database would cut down the number of website pages of have, but is that the best way to go?

  • #2
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    Yes I would use a database. You would really only need one page format then use the id in the url to pull the appropriate information. The hardest part about the whole thing would be actually putting the data into the database.
    ||||If you are getting paid to do a job, don't ask for help on it!||||

  • #3
    New to the CF scene
    Join Date
    Feb 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Should i use Database..

    hi Bob,

    i saw your quote.i think there is currently you are not having the problems with the web site.if you want to reduce the Page of website you can go through the database.if you page think that your page will be increasing then could use database at that time.

    Thank you
    Dilip

  • #4
    Senior Coder CFMaBiSmAd's Avatar
    Join Date
    Oct 2006
    Location
    Denver, Colorado USA
    Posts
    3,048
    Thanks
    2
    Thanked 317 Times in 309 Posts
    Use a database. In addition to making the page format easier to change (there will only be one common page), it will make it easier to manage your site and to add new information.

    I would hate to see what your folder/file naming scheme is now and how much work it is to add a page and to manage the menus.

    By using a database, you can easily organize, search, and display content by categories, keywords, dates, ... and do things like search for and show related listings on one page.
    If you are learning PHP, developing PHP code, or debugging PHP code, do yourself a favor and check your web server log for errors and/or turn on full PHP error reporting in php.ini or in a .htaccess file to get PHP to help you.

  • #5
    New Coder
    Join Date
    Feb 2008
    Location
    NH, USA
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm a big fan of databases, but only when they are needed. How often do you add new pages to your site? And is it causing you a big hassle? Search engines work better with databases than they used to, but a static page is still the most friendly toward search engines.

    However, if you decide to change your site's format, having 500+ static pages would be a HUGE hassle (unless you use heavy CSS or are a super shell scripter).

    I really like WebTeacher's WebDataPro (http://www.webteacher.com) but it's kind of expensive unless your site is actively making money--it's $599 per installation. I run it on four sites and have done so for over five years without any problems at all--it is very user-friendly. Check it out, it has a 30 day trial period.

    I couldn't tell you about any other database options out there--when I look I never find anything that piques my interest that is under $1000, but you should look around--there may be a similar solution that is less expensive. If you find one, please follow up with details, I would be interested in a less expensive option.

    Cymy

  • #6
    Regular Coder
    Join Date
    Jul 2007
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Cymy View Post
    I'm a big fan of databases, but only when they are needed. How often do you add new pages to your site? And is it causing you a big hassle? Search engines work better with databases than they used to, but a static page is still the most friendly toward search engines.
    I add pages once a week; no it's not a hassle because I'm basically just saving the same page over and over again, and then editing the info.

    Quote Originally Posted by Cymy View Post
    However, if you decide to change your site's format, having 500+ static pages would be a HUGE hassle (unless you use heavy CSS or are a super shell scripter).
    Trust me, I know That's why I figured using a database would be the best way to go.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •