Database content on SEO

Discussion in 'Search Engine Optimization' started by star2323, Dec 23, 2005.

  1. #1
    How does pulling content from a database effect SEO?

    I plan on having a .php file for each of my articles. But I'm going to put the articles in a database and then each .php file will look up the correct record and populate the file.

    Will this effect SEO? Or does this page simply look like a static page to the SE?

    What do I need to kind in mind when using a database and a plan of attack like this?

    Thanks!!
     
    star2323, Dec 23, 2005 IP
  2. ServerUnion

    ServerUnion Peon

    Messages:
    3,611
    Likes Received:
    296
    Best Answers:
    0
    Trophy Points:
    0
    #2
    what you can do is use a server function called mod_rewrite. This will allow you to have static URL's that are parsed at the server to pull out info in the URL to get a querystring for the server.

    Example: http://www.changafonts.com/graphic-design-articles/p0.html

    This page is seen at the server as something like /articles.php?page=0

    The forums and google will have a lot of info for you on mod_rewrite. Do a little research to see if it's for you and come back if you have specific questions for you application

    Good luck!
     
    ServerUnion, Dec 23, 2005 IP
  3. star2323

    star2323 Peon

    Messages:
    445
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I don't want to dynamically create pages. I will manually create a .php file. But the file will query a database to get the content which will be displayed no the page.

    So each article will have a .php file which I will create by hand. But it will get its data from a database record.

    Does that make sense?
     
    star2323, Dec 23, 2005 IP
  4. LGRComp

    LGRComp Well-Known Member

    Messages:
    516
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    195
    #4
    To answer your question it will look like a static page to the search engine.

    A plan of attack, I think ServerUnion gave you a good idea. Why create a php page for each query when you can use mod_rewrite and one php page to create all those pages that you will need here. That will save a great deal of work not to mention a great deal of copying and pasting. Not only will it create all the pages you need but your maintenance will be a lot less because you only have one page to deal with if you want to change something. It seems to me that by creating a php page for each query you will be making more work for yourself IMHO.

    Good Luck.
     
    LGRComp, Dec 23, 2005 IP
  5. BILZ

    BILZ Peon

    Messages:
    1,515
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If you are making each file by hand, why dont you just make it a static .html file? Why do you want to use the database?
     
    BILZ, Dec 23, 2005 IP
  6. star2323

    star2323 Peon

    Messages:
    445
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #6
    One reason I was going to create a php page for each one was so I had complete control over what the page looked like and I could tweak one page without having it effect all the other pages.

    But I see your point. I still have some planning to do.
     
    star2323, Dec 23, 2005 IP
  7. star2323

    star2323 Peon

    Messages:
    445
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Then I can use the database to keep track of the content. And search the content in the database. And I can make changes straight to the database without having to go and edit any of the files.
     
    star2323, Dec 23, 2005 IP