How to do SEO with a MySQL/PHP Backend

Hi there all,

I'm about to develop a site with a DB backend & I want to know how one goes about doing organic SEO if most of the site is DB driven.

There will be some text on the page, but certain things that are pulled from the DB, won't actually be in html/xhtml on the site.

Any help is appreciated.

Thanks & have a great wknd.


Michelle

 

There are some differences, but its quite hard to explain that easily. A website in php and mysql can be the same as any other, as long as the pages that are read by search engines, are okay.

To keep my message a little bit short, I give you an example; download Mambo (www.mamboserver.com)
At first it is Search Engine unfriendly. The URLs look like this:
website.com/page.php?ID=144 (well longer, but did you notice the question mark, and ID? The URL looks dynamic.

Once you set the pages to be SE friendly (in the admin) it looks like this:
website.com/content/144/
This looks static. It makes directories. Thats fine for a SE to index. SEs somehow dont like question marks, and session IDs.

There are some tricks on how to do that. I am sure you can figure that out if you download and tried Mambo?

 

Ahh yes, I remember this from my time trying out Mambo & I couldn't stand Mambo in the end & went back to DW.

Thanks for reminding me though


Michelle

 

DW? Another open source CMS? Its not mambo Id like to promote (the backend can be horrible, and its really user and sitedepending to see if mambo is a good choice or not, so maybe not), but its an easy way to try to explain something rather difficult.

 

google said it can read .PHP file now.

 

Sorry, I just assumes everyone knows that DW stands for Dreamweaver.

I'm glad I'm not the only one that can't stand Mambo.

The editor sucked soooo bad & then I got locked out of my acct. when I changed the p/w that the other guy had created.

Good for Google LOL, but I'm not sure that helps me w/ a totally DB driven website. I'm still trying to wrap my head around the whole concept

Have a great Sat. everyone !


Michelle

 

Hello,

I used mod_rewrite to change the URL's from
mysite.com/band.php?band=1234
to
mysite.com/the-name-of-the-band

I also use queries to create dynamic titles for the pages.
i.e.
<title>Mysite presents <?php echo "$bandName" ?></title>

HTH

 

t/y, I've listed in my notes & will see if the next programmer who comes along knows all of this


Michelle

 

Mixposure.... how did you do that?

Can i see the mod_rewrite bit for the band name in the URL pleasE?

 

Hi,

This is somewhat of an epic thread and I recommend you read it all the way through because the resolution is not until the end:
http://www.sitepoint.com/forums/showthread.php?t=263553&page=1&pp=25

Good luck, HTH.