gregorygarver.com Forum Index gregorygarver.com
San Francisco Real Estate Forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Do php pages that have sql code querying mysql tables to pro

 
Post new topic   Reply to topic    gregorygarver.com Forum Index -> The Google Search Engine
Author Message
miasophia



Joined: 19 Nov 2003
Posts: 6

PostPosted: Sat May 05, 2007 4:52 am    Post subject: Do php pages that have sql code querying mysql tables to pro Reply with quote

HiWhen you create a site based on pages that are created dynamically using php and mysql, do they get indexed by google, meaning can i create a sitemap and submit to google and other search engines?Because normally i guess you can submit individual pages that you update, how ill google know whats in my mysql database?thanks in advanceTovia S
Back to top
curmudgeon0816



Joined: 20 Aug 2007
Posts: 5

PostPosted: Sat May 12, 2007 12:45 am    Post subject: Do php pages that have sql code querying mysql tables to pro Reply with quote

yeah,ok,sure
Back to top
pugwashjw



Joined: 06 Jan 2007
Posts: 5

PostPosted: Fri May 18, 2007 8:37 pm    Post subject: Do php pages that have sql code querying mysql tables to pro Reply with quote

Yes it will get index but only if you have SEARCH ENGINE SAFE URL's. Search engines usually skip links that have ? in them. So, if you want to have your page indexed you will have to look at URL REWRITING. For that search on GOOGLE. You should find loads of stuff.
Back to top
Meg6083



Joined: 11 May 2005
Posts: 2

PostPosted: Fri May 25, 2007 4:29 pm    Post subject: Do php pages that have sql code querying mysql tables to pro Reply with quote

According to Google: "If you decide to use dynamic pages (i.e., the URL contains a "?" character), be aware that not every search engine spider crawls dynamic pages as well as static pages. It helps to keep the parameters short and the number of them few."
Back to top
ColinS2672



Joined: 22 Jan 2006
Posts: 6

PostPosted: Fri Jun 01, 2007 12:22 pm    Post subject: Do php pages that have sql code querying mysql tables to pro Reply with quote

There is a way to make your dynamic pages appear as HTML to search engines. This is helpful because the Google bot may not index links to other pages within your site that contain ? in the URL. For example, I have a shopping site, and the main page has several links to a common "store.php" page that retrieves dynamic contents from a mySQL database based on the Store ID and Department ID. The link for DVD MOVIES would be store.php?store=video&department=dvd This is not search engine friendly. The workaround I found is this : Modify the file .htaccess in the public_html folder - or create a file named .htaccess if it doesn't exist (yes, the file name starts with a period character) Add the following two lines :RewriteEngine onRewriteRule ^(store)_(.*)_(.*).html store.php?store=$2&dept=$3This tells the web server to rewrite any request for a page with a name store_{store name parameter}_{department name parameter}.html in the form store.php?store={store name parameter}&dept={department name parameter}I can now include a link to my DVD movies page as store_video_dvd.html which the search engines will index as static HTML pages.
Back to top
david_carringtonjr



Joined: 29 Jan 2006
Posts: 5

PostPosted: Fri Jun 08, 2007 8:14 am    Post subject: Do php pages that have sql code querying mysql tables to pro Reply with quote

Basically, what the other answerers have said is correct.So, in brief, no google cannot see your mysql databases, it can only see html, not server-side stuff.And it might not even look at your php/html pages, if they have ?s in them.Good Luck!
Back to top
Display posts from previous:   
Post new topic   Reply to topic    gregorygarver.com Forum Index -> The Google Search Engine All times are GMT
Page 1 of 1

 


Powered by phpBB © 2001, 2005 phpBB Group