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!!
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!
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?
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.
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?
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.
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.