.htaccess to index MySQL database entries for Google

Discussion in 'Blogging' started by davidbonting, Apr 11, 2012.

  1. #1
    Hello,
    I'm trying to start my own blog and I know everything I got to do. But I don't know how I can index the database entries.
    I know it has something to do with .htaccess but who, what and where?

    So do you know how to do it?
    Or do you have a link where I can learn working with .htaccess

    something like this must be indexed:
    testpage.com?blogid=24
    Example database:
    Blogid, titel, content
    entries:
    blogid = 24
    titel = Hello web developers
    content = Allot of text here and this should be indexed by Google so it shows up as a result on Google. Ending of the blog post, bye.
     
    davidbonting, Apr 11, 2012 IP
  2. e-abi

    e-abi Member

    Messages:
    122
    Likes Received:
    1
    Best Answers:
    3
    Trophy Points:
    38
    #2
    You need to create a sitemap:
    http ://en.wikipedia.org/wiki/Site_map
     
    e-abi, Apr 11, 2012 IP
  3. davidbonting

    davidbonting Greenhorn

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #3
    So I need this?
    
    <?xml version="1.0" encoding="UTF-8"?>
    <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">  
    <url>    <loc>http://www.example.com/?blogid=24</loc>    <lastmod>2009-09-22</lastmod>    <changefreq>monthly</changefreq>    <priority>0.8</priority>  </url>  
    <url>    <loc>http://www.example.com/?blogid=25</loc>    <lastmod>2009-09-22</lastmod>    <changefreq>monthly</changefreq>    <priority>0.5</priority>  </url>  
    <url>    <loc>http://www.example.com/?blogid=26</loc>    <lastmod>2009-09-22</lastmod>    <changefreq>monthly</changefreq>    <priority>0.5</priority>  </url>
    </urlset>
    HTML:
    and upload that file to the server?

    BUT WAIT I'M READING THIS NOW:
    "You can submit up to 500 Sitemap index files for each site in your account." - google

    but what if I have more than 500 blog posts, how do I index it by than?
     
    davidbonting, Apr 12, 2012 IP
  4. e-abi

    e-abi Member

    Messages:
    122
    Likes Received:
    1
    Best Answers:
    3
    Trophy Points:
    38
    #4
    One sitemap can include up to 50000 URL-s and multiply that amount with 500 sitemaps. I believe that amount is sufficient.
    And yes you have to upload it to the server.

    If you have Wordpress, then you could try some SEO packs:
    http://wordpress.org/extend/plugins/all-in-one-seo-pack/
     
    e-abi, Apr 12, 2012 IP
  5. davidbonting

    davidbonting Greenhorn

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #5
    Oow I'm sorry, it's 500 sitemaps I thought 500 links...
    Thanks!
     
    davidbonting, Apr 13, 2012 IP