: How to do SEO for database driven web? Asp.net Hi to everyone and thanks in advance for your time reading this question. Im kinda new on this SEO stuff and there is something that I can't
Hi to everyone and thanks in advance for your time reading this question.
Im kinda new on this SEO stuff and there is something that I can't figure out how it works despite all the readings that I did.
I've developed a new website which allows users to add recommendations for every kind of bussiness, places, professionals, etc, so other people can see if travel to X place is worth it for example.
From what I've read so far (and from what I've understood, which are actually two different things haha) its important to make user and search engines friendly URLs and have proper keywords, title and h1 tags.
(I've read this post SEO for pages that load from database and a few more)
That's not a problem because I can do that on server-side code, but what I actually don't understand is how Google shows pages that collect info from databases on his search results.
Lets put an example just to detail this a little bit more.
If we go to Google and search for "abercruz paginas amarillas" google show us a link that send us to a page from "paginasamarillas.com" which has all the details about that store.
Instead if we go to Google and type, "abercruz yousug" (which is my page) nothing shows up. I know that it could take a few days to Google to index my page but I don't understand HOW could Google "search" into my database (or page, or whatever) to end with the correct URL which shows the details of that Commerce
If someone could explain me that or help me a little bit understanding how to rank content that is generated from a database I will very grateful.
Thanks again!
More posts by @Goswami781
1 Comments
Sorted by latest first Latest Oldest Best
I believe what you are asking is how will search engines find your content without it all being linked to from your home page, because your site is mainly search driven. The obvious and best answer would be an XML sitemap. Generate a sitemap from your database on regular intervals to keep Google up to date about all of your content.
Some more info about sitemaps: support.google.com/webmasters/answer/156184
I have a large site that I generate a sitemap for automatically (well actually several sitemaps in batches of 40k URLs at a time). Here is a basic version of a PHP sitemap generator I wrote:
<?php
/* Do some stuff */
/* Connect to mysql etc */
/* create a dom document with encoding utf8 */
$domtree = new DOMDocument('1.0', 'UTF-8');
/* create the root element of the xml tree */
$xmlRoot = $domtree->createElement("urlset");
$xmlRoot -> appendChild(new DomAttr('xmlns', 'http://www.sitemaps.org/schemas/sitemap/0.9'));
$xmlRoot -> appendChild(new DomAttr('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance'));
$xmlRoot -> appendChild(new DomAttr('xsi:schemaLocation', 'http://www.sitemaps.org/schemas/sitemap/0.9 www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd'));
/* append it to the document created */
$xmlRoot = $domtree->appendChild($xmlRoot);
/* Loop through our database results and create URL entries for each page */
while ($row = mysql_fetch_array($result)){
$currentTrack = $domtree->createElement("url");
$currentTrack = $xmlRoot->appendChild($currentTrack);
$currentTrack->appendChild($domtree->createElement('loc','https://mysite.com/viewer.php?file='.$row['filename']));
$currentTrack->appendChild($domtree->createElement('changefreq','weekly'));
$currentTrack->appendChild($domtree->createElement('priority','1.0'));
}
/* save the xml sitemap */
$domtree->formatOutput = true;
$domtree->preserveWhitespace = false;
$domtree->save('sitemap.xml');
Obviously you would need to customize this to work with your database/content/url structures but hopefully this will help you get started.
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.