Dynamic PHP, MySQL and SEO

zsawevv212 · 01-27-2011, 08:15 PM

I am trying to create a real estate website and for SEO reasons I would like to have a separate page for each (at least the popular) subdivision that gives details about each one. Each will have it's own url ("/april_sound_info.php") or whatever but to make things easier on me I would like to set this page up using php feeding from a mySQL database. Now, I know the spiders cannot follow ? and & but this instance would not have that. I would just copy the page, rename it and change one piece of code to automatically pull the info from the db. Does this sound like it is SEO-friendly? Any better suggestions?

Vince Smith · 01-27-2011, 08:23 PM

Will you be pulling listings or just information about the subdivision? How will you manage the information in the database?

It seems that you can benefit from using a platform that would give you the ability to set what will end up in the url, description, and title. Something like Wordpress can do this for you easily if you are not dealing with listings.

A little more information on the content you will be pulling will likely solicit more responses.

Thanks,

Vince

raviv · 01-28-2011, 12:02 AM

It depends on the CMS you are going to use to build the site. If you are using Joomla or Drupal for example, the URLs with query string parameters following the ? can be converted into search engine friendly URLs if you tweak the setting within the CMS.

Please note that search engines today are far more advanced and can read query string parameters. But do not put a session id in the URL as that can create huge amount of content duplication.

Best
Raviv

01-27-2011, 08:15 PM	#1
zsawevv212 Active Warrior Join Date: Dec 2010 Posts: 42 Thanks: 0 Thanked 0 Times in 0 Posts	Dynamic PHP, MySQL and SEO I am trying to create a real estate website and for SEO reasons I would like to have a separate page for each (at least the popular) subdivision that gives details about each one. Each will have it's own url ("/april_sound_info.php") or whatever but to make things easier on me I would like to set this page up using php feeding from a mySQL database. Now, I know the spiders cannot follow ? and & but this instance would not have that. I would just copy the page, rename it and change one piece of code to automatically pull the info from the db. Does this sound like it is SEO-friendly? Any better suggestions?

01-27-2011, 08:23 PM	#2
Vince Smith Vince Smith War Room Member Join Date: Aug 2009 Location: Atlanta, GA Posts: 174 Thanks: 4 Thanked 284 Times in 29 Posts Social Networking	Re: Dynamic PHP, MySQL and SEO Will you be pulling listings or just information about the subdivision? How will you manage the information in the database? It seems that you can benefit from using a platform that would give you the ability to set what will end up in the url, description, and title. Something like Wordpress can do this for you easily if you are not dealing with listings. A little more information on the content you will be pulling will likely solicit more responses. Thanks, Vince

01-28-2011, 12:02 AM	#3
raviv HyperActive Warrior War Room Member Join Date: Aug 2010 Posts: 264 Thanks: 66 Thanked 44 Times in 40 Posts	Re: Dynamic PHP, MySQL and SEO It depends on the CMS you are going to use to build the site. If you are using Joomla or Drupal for example, the URLs with query string parameters following the ? can be converted into search engine friendly URLs if you tweak the setting within the CMS. Please note that search engines today are far more advanced and can read query string parameters. But do not put a session id in the URL as that can create huge amount of content duplication. Best Raviv