| Author |
Message |
miasophia
Joined: 19 Nov 2003 Posts: 6
|
Posted: Sat May 05, 2007 4:52 am Post subject: Do php pages that have sql code querying mysql tables to pro |
|
|
| 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
|
Posted: Sat May 12, 2007 12:45 am Post subject: Do php pages that have sql code querying mysql tables to pro |
|
|
| yeah,ok,sure |
|
| Back to top |
|
 |
pugwashjw
Joined: 06 Jan 2007 Posts: 5
|
Posted: Fri May 18, 2007 8:37 pm Post subject: Do php pages that have sql code querying mysql tables to pro |
|
|
| 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
|
Posted: Fri May 25, 2007 4:29 pm Post subject: Do php pages that have sql code querying mysql tables to pro |
|
|
| 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
|
Posted: Fri Jun 01, 2007 12:22 pm Post subject: Do php pages that have sql code querying mysql tables to pro |
|
|
| 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
|
Posted: Fri Jun 08, 2007 8:14 am Post subject: Do php pages that have sql code querying mysql tables to pro |
|
|
| 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 |
|
 |
|