Seo Home blog

Not so cool.. lol.

http://www.cuil.com/search?q=gabs

Bigger better but not listed..

Can’t seem to find any of my site indexed… Ah well..  good luck and all that..

Over the last 2 weeks i’ve been working a lot on paging in php.

so… Pretty simple to get first last next and previous to work in php.

Looking at resources on the web I haven’t seen many paging php example including rewriting url for the search enignes so thought i’d put some code up here on my blog.. Hope it helps!

mysql_select_db($database, $con);

$query_prods = $query_list= “SELECT * FROM table”;
//echo $query_prods ;

$query_limit_prods = sprintf(”%s LIMIT %d, %d”, $query_prods, $startRow_prods, $maxRows_prods);
$prods = mysql_query($query_limit_prods, $con) or die(mysql_error());
$row_prods = mysql_fetch_assoc($prods);

The above code is a simple example of the php to create a recordset for the entire contents of “table”..

$maxRows_prods = 6;
$pageNum_prods = 0;

$all_prods = mysql_query($query_prods);
$totalRows_prods = mysql_num_rows($all_prods);
$totalPages_prods = ceil($totalRows_prods/$maxRows_prods)-1;

$queryString_prods = “”;
if (!empty($HTTP_SERVER_VARS[’QUERY_STRING’])) {
  $params = explode(”&”, $HTTP_SERVER_VARS[’QUERY_STRING’]);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, “pageNum_prods”) == false &&
        stristr($param, “totalRows_prods”) == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_prods = “&” . implode(”&”, $newParams);
  }
}

The above part of the php paging code creates variables to create a simple mod-rewrite php paging.

<?php

$currentPage  = “some-keyword/”

if ($pageNum_prods > 0) { // Show if not first page ?>
            <a href=”<?php echo $currentPage; ?>”><img src=”first.gif” border=”0″></a>
            <?php } // Show if not first page ?> </p>
        <?php if ($pageNum_prods > 1) { // Show if not first page ?>
            <a href=”<?php echo $currentPage.”/”.($pageNum_prods - 1); ?>”><img src=”prev.gif” border=”0″ align=”bottom”></a>
            <?php } // Show if not first page ?>
      <?php if ($pageNum_prods < $totalPages_prods) { // Show if not last page ?>
            <a href=”<?php echo $currentPage.”/”.($pageNum_prods + 1); ?>”><img src=”next.gif” border=”0″></a>
            <?php } // Show if not last page ?>
   <?php if ($pageNum_prods < $totalPages_prods) {?><a href=”<?php echo $currentPage.”/”.($totalPages_prods); ?>”><img src=”last.gif” border=”0″></a><?php }?>

The above code shows image for first, next, previous and last however you can of course slam in some keywords here either in the alt tags or as text.. I’ll explain how in a bit..

RewriteCond %{REQUEST_URI} ^/somekeyword/([0-9]+)
RewriteRule ^(.*) /page.php?pageNum_prods=%1  [L]

The above is the .htacess for paging a php page called page.php in the root of the site. Please note “somekeyword” can be changed to theme the paging for example if the query returned all products that are ”red” then the folder could be called “red” to give a little seo help..

The above coding will result in yoursite.com/somekeyword/1 for page 1 yoursite.com/somekeyword/2 for page 2 and so on..

The above is a very simple basic script which I hope helps however now you can start to take it up a gear in regards to seo..

So paging has always been a issuse with SE as page 1 will return the same title des and k/w as page 2 and so on … so how to fix the dup content?

Well always consider the user so look at the result on the page..  Look at them as a human.. What is on the page? How could you describe it ?  The above php limits to 6 results per page..  those 6 items each have a title.. Now depenant on your data the is the key!..

Lets assume your in the RED section of the site so the query retrun all red items.. In the first 6 you have what type of items ? These items are the content of the page along with what that page links to.. By extract the type of items your be able to add them to title and desriptions..

So again assuming RED items include pens,ink,paper,paint… collect this data in array.. Now the key so make sure its reads well to the user. So something like “page 1 red items” could be change to “Red pens, ink paper and paint from xyz”

Basically your giving the user the title + description to what is on the page.. as above if page 2 contained card, cloth,fabric,thick paper .. The title would change from something like “page 2 red items” to “Red card, cloth, fabric and thick paper from xyz”

Of course using “,” in titles and description isn’t a great idea thus its worth looking into this wording dependant on your niche..

Hope that helps someone a little

The bbc seem to think google has started phoographing area in the UK including london see quote:

Street View has already been launched in the US and includes photos of streets in major American cities. Photographing of areas in the UK, including London, is believed to have started this week.

The bbc go on to question about the UK privacy laws for using images and faces with consent..

You can read the full article here: http://news.bbc.co.uk/1/hi/technology/7488524.stm

But the real big question is has anymore seen the google van taking photos ???

I have seen any blogs about a google van as yet but will keep a look out and might pop to london if one is knocking about : )

OMG..

The goverment in the uk want to start a socail network:

Calling all social media experts - UKGov your ideas for new data mashups, and there’s GBP20,000 to support the best ideas:

Some of the things it will include

Mapping information from the Ordnance Survey

Medical information from NHS Choices

Neighbourhood statistics from the ONS

Pretty much all Offical Notices (bankruptcy, official appointments, etc) from the London Gazette

A carbon calculator from Defra

£20k prize for the best idea..

Find out more here: http://www.showusabetterway.com/

google are ending adsense Referrals

I did ok with them but hey good things can come to a end..

Thank you for participating in the AdSense Referrals program. We’re writing to let you know that we will be retiring the AdSense Referrals program during the last week of August

Google are now launching

www.google.com/ads/affiliatenetwork.

FOR the USA only

adsense Refferals did have uk affiliates but according to the email its only for the usa

Ah well..

http://www.google.com/adsense/support/bin/topic.py?topic=14882