SEOist's blog knowledge at first sight
Wednesday, October 03, 2007
Monday, September 17, 2007
Google grants PageRank to alternative URLs in adsense code?
Yeah, sounds weird, unbelievable, but yes that is true. Google grants PR to URLs in adsense code. Yesterday I checked the adsense alternative page of one of my sites and I noticed it had PR1!!!There are no backlinks to this page! The PageRank of home page is 4.
I will keep an eye on situation and will report how things are going after next TBPR update.
Wednesday, June 27, 2007
Inside AdSense: We go round and round
Google adsense blog announced a new shape of adsense borders beside the square one. There are two options: slightly rounded and very rounded. If you blend adsense ads in your sites this news is not news for you.Inside AdSense: We go round and round: "colors of your ad units; now, you can also customize the shape by selecting between square, slightly roun"
Tuesday, February 13, 2007
Google sitemap PHP Script
А simple PHP script for creating Google sitemaps<?
// Connecting, selecting database
$link = mysql_connect('localhost', 'db_username', 'db_pass')
//db_username is the database username; db_pass is the database password
or die('Could not connect: ' . mysql_error());
mysql_select_db('data_base_name') or die('Could not select database');
//data_base_name is the DB you connect to
// Performing SQL query
$query = 'SELECT item_id FROM db_table_name WHERE some_condition=1';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Printing results in HTML
header ("Content-type: application/xml");
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<urlset xmlns=\"http://www.google.com/schemas/sitemap/0.84\">\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
foreach ($line as $col_value)
{
echo "<url>\n";
echo "<loc>http://yoursite.com/url.php?id=$col_value</loc>\n";
echo "</url>";
}
}
echo "</urlset>\n";
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
?>
That is all. Now you have a perfect Google sitemap.
Friday, January 05, 2007
Some SEO tips for your site
Some SEO tips for your site
Every sites has to have more backward links to itself in order to have bigger PageRank™ and better place in SERP - Search Engine Results Pages.
Before you start to make your site popular make sure you follow these optimisation rules:
- First: The site has to be compliant to standarts of W3 consortium. Keeping these standarts will not only let more browsers inteprete your site's pages the "better way", but provide backward links with higher PageRank™. The more pages has your site, the more backward links
- The more backward link, the higher PageRank™
- Use descriptive alt attributes of img tags and descriptive title attributes of href tags. Search engines (especially Google) index the content of alt and title attributes. Sometimes alt attributes are the only way to describe a picture/foto.
- Meta tags are must! If you don't know how to construct them you can use a Metatag generator. Creating meta tags must not to be just to have them. There are some rules which are:
- relevance between the title tag of the page and its content meta tag;
- relevance between the description meta tag and the content of the page;
- relevance between the keywords meta tag and the content of the page;
In other words the title tag, keywords and description meta tags has to be relevant to page content. Do not use descriptions or titles like: "We are number one" or "The best of the best". Avoid keywords that do not present in page content. You can keep these rules by creating dynamic meta tags. You can use Metatag analyzer to check if everithing with your pages is OK. - Sometimes webmaters face the problem how to remove session ids like PHPSESSID= from their sites' URLs. Beside the security risk, session ids in URLs can lead to indexing the same page as many pages and search engines could treat this like duplicate content and punish your site. There are some methods to fix this:
1.If you have access to settings in php.ini set session.use_trans_sid = 0;
2.In php files like this: <? ini_set('session.use_trans_sid','0'); ?>, but that is not always possible and depends on the PHP version you use;
3.By using apache directives: php_value session.use_trans_sid 0;
If there are already indexed URLs containing PHPSESSID and your web server is Apache you can get rid of those URL's this way:
Options +FollowSymlinks
RewriteEngine On
RewriteCond %{QUERY_STRING} ^PHPSESSID=.*$
RewriteRule .* %{REQUEST_URI}? [R=301,L] - Include in your robots.txt the following line:
Disallow: /*PHPSESSID
Copyright © 2007 Plamen Tomov. Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts and no Back-Cover Texts. A copy of the license is included in the section entitled "GNU Free Documentation License".
Labels: seo