PHP, MYSQL Database and listing in google results

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
mudilik
Forum Newbie
Posts: 6
Joined: Fri Jan 06, 2006 2:48 pm

PHP, MYSQL Database and listing in google results

Post by mudilik »

Hiello everyone, I new to this forum. I have a question that I am unable to find an answer for anywhere online.

On our website potomacelectric.com we have a mysql database with parts that are available for sale, website uses PHP for searching of databese . Users can search for parts via multiple options. Also browse by clicking first letter of the manufacturers name. I was told that google would be able to use these links to cache all pages A..... to Z and this way to allow anyone on google to see what parts we have for sale. [/url] http://www.potomacelectric.com/repairs/parts.php [url] So far google have not cached any pages even though it alredy cached other pages created at the same time. It also cached forum which is also php.

I am looking for someone who can guide me in the right direction on what is not done right and help me get the google to cache all the pages. We will pay a reasonable fee for this help.

Thanks alot in advance

Mark
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

A couple things to note when I quickly looked at your site. First if it's parts you are trying to sell you really need to have a direct link to your search on the first page. (There may be one but I didn't see it) Secondly, you search using the form method POST. Google will not be able to cache these results; you need to switch to GET.

How long has this site been up? The best way (I have found) to get your site noticed by google is to have other sites link to you. You may want to try an ebay store.

my $.02
mudilik
Forum Newbie
Posts: 6
Joined: Fri Jan 06, 2006 2:48 pm

Post by mudilik »

Thank you for advice I will have it changed to GET, The site was up for past 2 months and seemed like everything got cached other than parts listing. So what you sugesting is to add listing for pages A... Z on our front page ? Sorry If I missunderstood you. The idea with Ebay store sounds very good, I will give that sugestion to our sales deparment.

I`ve read something on doing mod_rewrite to get these pages cached or this is not a right way to go ?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

Mod Rewrite is the best way to keep google bots happy, since they don't follow links with query strings.

Sitemaps are also a good idea in this case, a quick google gives you more information on this.
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Post by Roja »

Jcart wrote:Mod Rewrite is the best way to keep google bots happy, since they don't follow links with query strings.
That is no longer true - hasn't been for over a year now. Google follows links with query strings just fine.
mudilik
Forum Newbie
Posts: 6
Joined: Fri Jan 06, 2006 2:48 pm

Post by mudilik »

So what you guys are saying is once I change method from POST to GET google should start cashing all of the pages from A......Z.
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

Its hard to say, but it worth a try.
mudilik
Forum Newbie
Posts: 6
Joined: Fri Jan 06, 2006 2:48 pm

Post by mudilik »

Any more resources you can reference me to, or any other info to get this information listed. another method I was thinking to maybe create static .html pages for A..... Z that will be updated every day, I would think google should be able to cache those easily.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

You can always write a "map" and provide it to google... More info somewhere on the google website.. I'm pretty sure other search-engines have something similar...
User avatar
Maugrim_The_Reaper
DevNet Master
Posts: 2704
Joined: Tue Nov 02, 2004 5:43 am
Location: Ireland

Post by Maugrim_The_Reaper »

Google Sitemaps...;)

You can set up a sitemap and notify Google of any changes to your website.
mudilik
Forum Newbie
Posts: 6
Joined: Fri Jan 06, 2006 2:48 pm

Post by mudilik »

Great Info guys, I would like to thank everyone who provided the help.
Post Reply