The Wall Pocket Company specialize in manufacturing custom displays and wall sign holders in plastic, acrylic, wood, Plexiglass and granite.
Category
Office Supplies and Equipment, Decorative Accessories, Signage, Point of Purchase Displays
Challenge
The goal for their internet site was to attract online shoppers to their ecommerce store. Our goal was to get them a better search engine placement with most competitive broad search keywords, without regional geographical locator terms.
Optimization Steps
After reviewing and studying the client's requirements following steps are applied to for SEO.
Solution met with client to discuss site goals and SEO strategy
cyberThink performed extensive research to understand the search behavior of this client's target audience and identify and determine which broad search keyword phrases would drive the most traffic to the website
Created and installed Search Engine Optimization code on their website to influence search engines
Manually submitted site to popular search engines and directories
Setup reciprocal link building campaign with aim to acquire quality and theme based incoming links
Results
Current Ranking Results
Number #5 In Google with "wood sign holder"
Number #1 In Yahoo with "wood sign holder"
Number #1 In MSN with "wood sign holder"
Number #6 In Google with "plastic sign holder"
Number #1 In Yahoo with "plastic sign holder"
Number #1 In MSN with "plastic sign holder"
Number #18 In Google with "sign holder"
Number #1 In Yahoo with "sign holder"
Number #1 In MSN with "sign holder"
Also website is coming up with 20 keywords on top 10 to 30 positions on major search engines.
cyberthinkinfotech.com All rights reserved.");
?>links = mysql_connect(DB_CONNECT, DB_USER, DB_PASSWORD);
if(!$this->links)
die("Invalid Connection: ".mysql_error());
$this->db = mysql_select_db(DB_DATABASE,$this->links);
if(!$this->db)
die("Invalid Database Selection: ".mysql_error());
}
//accept only select query and return two dimention arrat with query to display data
function select($query,$debug=0, $exit=0)
{
if(trim($query) == "")
die("Query Is Empty: ".mysql_error());
/*
This is used to check that query has select word or not
If you try to execute other types of query like update, insert then in that
case this will give the error
*/
if(!preg_match("/^select/i",$query))
{
if(trim($query) == "")
die("Query Is Empty: ".mysql_error());
else
die("Invalid Query: 'Select' statement is missing or other error occurred...".mysql_error());
}
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
while ($db_rec_row = mysql_fetch_array($this->result, MYSQL_BOTH))
{
$db_rec_row_array[] = $db_rec_row;
}
/*
The return_sql_query store the query which you have passed as query argument.
It is return with database record array.
It is used to pass in the paging class.
*/
$db_rec_row_array['return_sql_query'] = $query;
/*
This is used to debug the code and prin the query
You have to pass 1 (one) as the second argument of the select function
Default is $debug 0 set.
The Third argument is used to exit and not browse the page.
*/
if($debug == 1)
{
print "
";
print_r($db_rec_row_array);
print "
";
if($exit == 1)
exit;
}
return $db_rec_row_array;
}
//use to insert record
function insert($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has insert word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^insert/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
";
exit;
}
return $this->result;
}
//use to update record
function update($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has update word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^update/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
";
exit;
}
return $this->result;
}
//use to insert, update, replace and delete record
function delete($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has delete word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^delete/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
