why seo is important

why seo is important

Today we are going to learn why seo is important and why we need seo.I have already written article on Seo best practices 2016 and Best seo plugins for wordpress ,you can check them out.

So first of all we are going to know what is Seo.

What is Seo (Search Engine Optimisation )?

In short Seo means making your website/blog Search engine friendly.

Wikipedia’s Defination of Seo

Search engine optimization (SEO) is the process of affecting the visibility of a website or a web page in a web search engine’s unpaid results—often referred to as “natural”, “organic”, or “earned” results. In general, the earlier (or higher ranked on the search results page), and more frequently a site appears in the search results list, the more visitors it will receive from the search engine’s users, and these visitors can be converted into customers.

Now back to our topic why seo is important?

1. SEO brings your Business traffic.
2. SEO gives you unmatched insight into your customers.
3. SEO provides higher relevance and credibility for your business.
4. SEO has one of the best ROI’s (Return On Investment) in advertising.
5. SEO is the number one source of leads.
6. SEO is the most  profitable forms of marketing.
7. SEO is good for business visibility ,branding and digital presence.


Best seo plugins for wordpress

Best seo plugins for wordpress

I have previously shared Best Seo practices 2016. For today’s post, I have compiled a list of recommended Best Seo plugins for WordPress. All these SEO plugins helps you too boost your websiste Seo, so I would suggest choosing and using the ones that best suit your needs.

So here are the some Best seo plugins for wordpress:

1. WordPress SEO by Yoast(Top one of the best seo plugins for wordpress)


Yoast SEO (formerly known as WordPress SEO by Yoast) is the most complete WordPress SEO plugin that exists today for WordPress.org users. It incorporates everything from a snippet editor and real time page analysis functionality that helps you optimize your pages content, images titles, meta descriptions and more to XML sitemaps, and loads of optimization options in between.

Yoast SEO features:

  • Focus keyword and content analysis
  • Post titles and meta descriptions
  • Robots meta configuration
  • Readability check
  • Canonical
  • Breadcrumbs
  • Primary category
  • Permalink cleanup
  • XML sitemaps
  • RSS enhancements
  • Edit your robots.txt and .htaccess

2. All in One SEO Pack

If you’re looking for a WordPress SEO plugin, then you will likely come across All in One SEO Pack because it is one of the most popular WordPress plugins ever created (over 27 million downloads).

All in One SEO Pack features:

  • XML Sitemap support – submit your sitemap to Google and Bing and improve your SEO
  • Google Analytics support
  • Support for SEO on Custom Post Types
  • Advanced Canonical URLs
  • Automatically notifies search engines like Google and Bing about changes to your site
  • Built-in API so other plugins/themes can access and extend functionality
  • ONLY free plugin to provide SEO Integration for e-Commerce sites, including WooCommerce
  • Nonce Security built into All in One SEO Pack
  • Support for CMS-style WordPress installations
  • Automatically optimizes your titles for Google and other search engines
  • Generates META tags automatically
  • Avoids the typical duplicate content found on WordPress blogs
  • For beginners, you don’t even have to look at the options, it works out-of-the-box. Just install.
  • For advanced users, you can fine-tune everything to optimize your SEO
  • You can override any title and set any META description and any META keywords you want.
  • Compatibility with many other plugins
  • Translated into 57 languages
  • PHP 7 100% Compatible

3. Squirrly SEO


SEO Plugin By Squirrly is for the NON-SEO experts. Get Excellent SEO with Better Content, Ranking and Analytics.

You’ll get to improve your rankings, while providing your readers with great content. See Your SEO Stats, get a weekly SEO Audit and find the best keywords.

Squirrly SEO features:

  • Squirrly Snippet Tool
  • Squirrly Keyword Research
  • Squirrly Live Assistant
  • Squirrly Performance Analytics
  • Squirrly First Page Optimization
  • Squirrly Open Graph and Twitter Card
  • Squirrly Check for SEO errors
  • Squirrly Sitemap XML
  • Squirrly Favicon.ico
  • Squirrly Json-LD Structured Data
  • Squirrly Tracking Tools
  • Squirrly Settings for Posts and Pages
  • Squirrly Google Rank Option
  • Squirrly Robots.txt
  • Measure Your Success Option from Squirrly
  • Squirrly Site Audit
  • add multiple tags-keywords
  • Change the Post Permalink in WordPress

4. Broken Link Checker


This plugin will check your posts, comments and other content for broken links and missing images, and notify you if any are found.

Broken Link Checker features:

  • Monitors links in your posts, pages, comments, the blogroll, and custom fields (optional).
  • Detects links that don’t work, missing images and redirects.
  • Notifies you either via the Dashboard or by email.
  • Makes broken links display differently in posts (optional).
  • Prevents search engines from following broken links (optional).
  • You can search and filter links by URL, anchor text and so on.
  • Links can be edited directly from the plugin’s page, without manually updating each post.
  • Highly configurable.

5. Rel NoFollow Checkbox


This plugin  adds a checkbox in the insert/edit link popup for including rel=”nofollow”.

If you have no idea about the added link is good or bad from SEO sake then simply add a rel nofollow attribute for that link. Otherwise  when you linked an external URL, you’re passing link juice and authority from your site to the linked URL. Ignoring this point of view may cause you losing ranking.

6. SEO friendly Images

SEO friendly Images

SEO Friendly Images automatically adds alt and title attributes to all your images improving traffic from search engines.

SEO Friendly Images is a WordPress SEO plugin which automatically updates all images with proper ALT and TITLE attributes for SEO purposes. If your images do not have ALT and TITLE already set, SEO Friendly Images will add them according the options you set. Additionally this makes the post W3C/xHTML valid as well.

ALT attribute is important part of search engine optimization. It describes your images to search engine and when a user searches for a certain image this is a key determining factor for a match.

TITLE attribute play lesser role but is important for visitors as this text will automatically appear in the tooltip when mouse is over the image.

7. SEO Smart Link WordPress plugin

SEO Smart Links provides automatic SEO benefits for your site in addition to custom keyword lists, nofollow and much more.

SEO Smart Links can automatically link keywords and phrases in your posts and comments with corresponding posts, pages, categories and tags on your blog.

Further SEO Smart links allows you to set up your own keywords and set of matching URLs. Finally SEO Smart links allows you to set nofollow attribute and open links in new window.

It is a perfect solution to get your blog posts interlinked or add affiliate links to other sites.

8. W3 Total Cache


W3 Total Cache: Search Engine (SEO) & Performance Optimization (WPO) via caching. Integrated caching: CDN, Minify, Page, Object, Fragment, Database support.

W3 Total Cache improves the user experience of your site by increasing website performance, reducing download times via features like content delivery network (CDN) integration.

The only WordPress Performance Optimization (WPO) framework; designed to improve user experience and Search Engine Optimization (SEO). Recommended by countless web hosts.


9.WP Performance Score Booster


This plugin speed-up page load times and improve website scores in services like PageSpeed, YSlow, Pingdom and GTmetrix.

WP Performance Score Booster features:

  • Remove any query strings from static resources like CSS & JS files
  • Enable GZIP compression (compress text, html, javascript, css, xml and so on)
  • Add Vary: Accept-Encoding header, and
  • Set expires caching (leverage browser caching).

10.NextScripts: Social Networks Auto-Poster

NextScripts: Social Networks Auto-Poster

This plugin automatically publishes posts from your blog to your Social Network accounts such as Facebook, Twitter, Google+(Google Plus), Blogger, Tumblr, Flickr, LiveJournal, Flipboard, Instagram, Telegram, DreamWidth, Delicious, Diigo, Instapaper, Stumbleupon, LinkedIn, Pinterest, Plurk, VKontakte(VK.com), YouTube, App.net, Scoop.It, WordPress, XING etc.

The whole process is completely automated. Just write a new post and either entire post or it’s nicely formatted announcement with backlink will be published to all your configured social networks. You can reach the most audience and tell all your friends, readers and followers about your new post. Plugin works with profiles, business pages, community pages, groups, etc. Messages are 100% customizable and adopted for each network requirements.


Hope the above listed plugins helps you to boost your site traffic.I have tried to include the  best seo plugins for wordpress.

If you liked this post, then please share or comment  :).

Seo best practices 2016

Seo best practices 2016

Seo best practices 2016 guide which can boost the traffic of your site/blog.

The top Seo best practices 2016 are as follow:

Tip #1: Find the Best Keywords(Do keyword research)
Tip #2: Discover What Your Competitors are Doing
Tip #3:The text must contains minimum 133 words.
Tip #4: Optimize Your Url, Title and Meta Tags (Must contain your focus keyword)
Tip #5: Optimizing Your Headings and Subheadings.
Tip #6: Use Title (on anchor tag) and ALT Attributes (on images)
Tip #7:  Redirecting Duplicate Content
Tip #8: Optimizing Your Static Site Map
Tip #9: Share you content on social media.
Tip #10: Do guest blog posting on quality blogs.
Tip #11:The meta description should contains the focus keyword.
Tip #12:The Main image of you page/post should contain alt attributes with the focus keyword.

The Most Handy tools,that you must check out are :

1.Google Adwords
2.Google Adsense
3.Google Analytics
4.Google Webmasters
For more detais regarding the seo best practices you can follow the google official   Do you need an SEO? guidelines or check the Webmaster Guidelines

Here are some rules I follow  :

  • update site regularly
  • get good back links over time
  • use Google Keyword tool and Google trends to see what content is most relevant
  • make your site accessible
  • make your site light weight and use less http requests
  • link to great websites
  • use more content then HTML
  • use friendly URLs
  • use a domain that is up in years
  • link to page within your own site
  • provide a robots.txt and sitemap to Google Web Master tools
  • post quality over quantity
  • optimize your website for users not just search (kinda odd but true)
  • use web standards

Below are more detailed tips for creating a Google-friendly site.

Steps to a Google-friendly site:

  1. Give visitors the information they’re looking for
  2. Make sure that other sites link to yours
  3. Make your site easily accessible
  4. Make pages primarily for users, not for search engines.
  5. Don’t deceive your users.
  6. Think about what makes your website unique, valuable, or engaging.

You can check  my another post on Best seo plugins for wordpress ,which can help you to improve you Seo on wordpress.

MySQL Data Types

Mysql data types

MySQL Data Types-In brief

There are three main mysql data types : text, number, and Date/Time types.

Text types:

Data type Description
CHAR(size) Holds a fixed length string (can contain letters, numbers, and special characters). The fixed size is specified in parenthesis. Can store up to 255 characters
VARCHAR(size) Holds a variable length string (can contain letters, numbers, and special characters). The maximum size is specified in parenthesis. Can store up to 255 characters. Note: If you put a greater value than 255 it will be converted to a TEXT type
TINYTEXT Holds a string with a maximum length of 255 characters
TEXT Holds a string with a maximum length of 65,535 characters
BLOB For BLOBs (Binary Large OBjects). Holds up to 65,535 bytes of data
MEDIUMTEXT Holds a string with a maximum length of 16,777,215 characters
MEDIUMBLOB For BLOBs (Binary Large OBjects). Holds up to 16,777,215 bytes of data
LONGTEXT Holds a string with a maximum length of 4,294,967,295 characters
LONGBLOB For BLOBs (Binary Large OBjects). Holds up to 4,294,967,295 bytes of data
ENUM(x,y,z,etc.) Let you enter a list of possible values. You can list up to 65535 values in an ENUM list. If a value is inserted that is not in the list, a blank value will be inserted.Note: The values are sorted in the order you enter them.

You enter the possible values in this format: ENUM(‘X’,’Y’,’Z’)

SET Similar to ENUM except that SET may contain up to 64 list items and can store more than one choice

Number types:

Data type Description
TINYINT(size) -128 to 127 normal. 0 to 255 UNSIGNED*. The maximum number of digits may be specified in parenthesis
SMALLINT(size) -32768 to 32767 normal. 0 to 65535 UNSIGNED*. The maximum number of digits may be specified in parenthesis
MEDIUMINT(size) -8388608 to 8388607 normal. 0 to 16777215 UNSIGNED*. The maximum number of digits may be specified in parenthesis
INT(size) -2147483648 to 2147483647 normal. 0 to 4294967295 UNSIGNED*. The maximum number of digits may be specified in parenthesis
BIGINT(size) -9223372036854775808 to 9223372036854775807 normal. 0 to 18446744073709551615 UNSIGNED*. The maximum number of digits may be specified in parenthesis
FLOAT(size,d) A small number with a floating decimal point. The maximum number of digits may be specified in the size parameter. The maximum number of digits to the right of the decimal point is specified in the d parameter
DOUBLE(size,d) A large number with a floating decimal point. The maximum number of digits may be specified in the size parameter. The maximum number of digits to the right of the decimal point is specified in the d parameter
DECIMAL(size,d) A DOUBLE stored as a string , allowing for a fixed decimal point. The maximum number of digits may be specified in the size parameter. The maximum number of digits to the right of the decimal point is specified in the d parameter

*The integer types have an extra option called UNSIGNED. Normally, the integer goes from an negative to positive value. Adding the UNSIGNED attribute will move that range up so it starts at zero instead of a negative number.

Date types:

Data type Description
DATE() A date. Format: YYYY-MM-DDNote: The supported range is from ‘1000-01-01’ to ‘9999-12-31’
DATETIME() *A date and time combination. Format: YYYY-MM-DD HH:MI:SSNote: The supported range is from ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’
TIMESTAMP() *A timestamp. TIMESTAMP values are stored as the number of seconds since the Unix epoch (‘1970-01-01 00:00:00’ UTC). Format: YYYY-MM-DD HH:MI:SSNote: The supported range is from ‘1970-01-01 00:00:01’ UTC to ‘2038-01-09 03:14:07’ UTC
TIME() A time. Format: HH:MI:SSNote: The supported range is from ‘-838:59:59’ to ‘838:59:59’
YEAR() A year in two-digit or four-digit format.Note: Values allowed in four-digit format: 1901 to 2155. Values allowed in two-digit format: 70 to 69, representing years from 1970 to 2069

*Even if DATETIME and TIMESTAMP return the same format, they work very differently. In an INSERT or UPDATE query, the TIMESTAMP automatically set itself to the current date and time. TIMESTAMP also accepts various formats, like YYYYMMDDHHMISS, YYMMDDHHMISS, YYYYMMDD, or YYMMDD.

php interview questions and answers for freshers

Php interview questions and answers for freshers- Most common

What is PHP?

PHP: Hypertext Preprocessor is open source server-side scripting language that is widely used for web development. PHP scripts are executed on the server. PHP allows writing dynamically generated web pages efficiently and quickly. The syntax is mostly borrowed from C, Java and perl. PHP is free to download and use.

Who is the father of PHP ?

Rasmus Lerdorf is known as the father of PHP.

Difference between $message and $$message in PHP.

$message is a variable with a fixed name. $$message is a variable whose name is stored in $message.

If $message= “var”;

Then  $$message is the same as $var.

Explain how to submit form without a submit button.

We can achieve the above task by using JavaScript code linked to an event trigger of any form field and call the document.form.submit() function in JavaScript code.

What are default session time and path?

default session time in PHP is 1440 seconds or 24 minutes
Default session save path id temporary folder /tmp

What is the difference between the functions unlink and unset?

unlink() deletes the given file from the file system.
unset() makes a variable undefined.

How many ways can we get the value of current session id?

session_id() returns the session id for the current session.

What’s the special meaning of __sleep and __wakeup?

__sleep returns the array of all the variables than need to be saved, while __wakeup retrieves them.

Explain the importance of the function htmlentities.

The htmlentities() function converts characters to HTML entities.

Explain the different types of errors in PHP.

Notices, Warnings and Fatal errors are the types of errors in PHP


Notices represents non-critical errors, i.e. accessing a variable that has not yet been defined. By default, such errors are not displayed to the user at all but whenever required, you can change this default behavior.


Warnings are more serious errors but they do not result in script termination. i.e calling include() a file which does not exist. By default, these errors are displayed to the user.

Fatal errors:

Fatal errors are critical errors i.e. calling a non-existent function or class. These errors cause the immediate termination of the script.

How to include a file to a php page?

We can include a file using “include() ” or “require()” or “include_once()”or “require_once()”  function with file path as its parameter.

What’s the difference between include and require?

If the file is not found by require(), it will cause a fatal error and halt the execution of the script. If the file is not found by include(), a warning will be issued, but execution will continue.

require_once(), require(), include().What is difference between them?

require() includes and evaluates a specific file, while require_once() does that only if it has not been included before (on the same page). So, require_once() is recommended to use when you want to include a file where you have a lot of functions for example. This way you make sure you don’t include the file more times and you will not get the “function re-declared” error.

Differences between GET and POST methods ?

With a GET method, you are sending your data via the URL. While, with A POST method, data is embedded in the form object and sent directly from your browser to the server. POST is a bit more safe than GET because GET could be stored in the history.

What is use of in_array() function in php ?

in_array used to checks if a value exists in an array

What is numeric array?

Numeric array − An array with a numeric index. Values are stored and accessed in linear fashion.

What is associate array?

Associative array − An array with strings as index. This stores element values in association with key values rather than in a strict linear index order.

How will you concatenate two strings in PHP?

To concatenate two string variables together, use the dot (.) operator −

$string1=”Hello World”;
echo $string1 . ” ” . $string2;

How will you find the length of a string in PHP?

The strlen() function is used to find the length of a string. Let’s find the length of our string “Hello world!” −

echo strlen(“Hello world!”);

How will you locate a string within a string in PHP?

The strpos() function is used to search for a string or character within a string. If a match is found in the string, this function will return the position of the first match. If no match is found, it will return FALSE. Let’s see if we can find the string “world” in our string −

echo strpos(“Hello world!”,”world”);

How will you generate random numbers using PHP?

The PHP rand() function is used to generate a random number. This function can generate numbers with-in a given range. The random number generator should be seeded to prevent a regular pattern of numbers being generated. This is achieved using the srand() function that specifiies the seed number as its argument.

What is use of count() function in php ?

count() is used to count all elements in an array, or something in an object

What is the difference between Session and Cookie?

The main difference between sessions and cookies is that sessions are stored on the server, and cookies are stored on the user’s computers in the text file format. Cookies can not hold multiple variables,But Session can hold multiple variables.We can set expiry for a cookie,The session only remains active as long as the browser is open.Users do not have access to the data you stored in Session,Since it is stored in the server.Session is mainly used for login/logout purpose while cookies using for user activity tracking

How to set cookies in PHP?

setcookie(“your_cookie_key”, “your_cookie_value”, time()+3600);

How to Retrieve a Cookie Value?

eg : echo $_COOKIE[“your_cookie_key”];

How we can retrieve the data in the result set of MySQL using PHP?

1. mysqli_fetch_row
2. mysqli_fetch_array
3. mysqli_fetch_object
4. mysqli_fetch_assoc

What is the use of explode() function ?

Syntax : array explode ( string $delimiter , string $string [, int $limit ] );
This function breaks a string into an array. Each of the array elements is a substring of string formed by splitting it on boundaries formed by the string delimiter.

What is the difference between explode() and split() functions?

Split function splits string into array by regular expression. Explode splits a string into array by string.

What is the use of mysql_real_escape_string() function?

It is used to escapes special characters in a string for use in an SQL statement

How to strip whitespace (or other characters) from the beginning and end of a string ?

The trim() function removes whitespaces or other predefined characters from both sides of a string.

What is the use of header() function in php ?

The header() function sends a raw HTTP header to a client browser.Remember that this function must be called before sending the actual out put.For example, You do not print any HTML element before using this function.

How to redirect a page in php?

The following code can be used for it, header(“Location:index.php”);

What is the difference between mysql_fetch_array() and mysql_fetch_assoc() ?

mysql_fetch_assoc function Fetch a result row as an associative array, Whilemysql_fetch_array() fetches an associative array, a numeric array, or both

What is mean by an associative array?

Associative arrays are arrays that use string keys is called associative arrays.

What is the purpose of $GLOBALS variable in PHP?

$GLOBALS − Contains a reference to every variable which is currently available within the global scope of the script. The keys of this array are the names of the global variables.

What is the purpose of $_SERVER variable in PHP?

$_SERVER − This is an array containing information such as headers, paths, and script locations. The entries in this array are created by the web server. There is no guarantee that every web server will provide any of these. See next section for a complete list of all the SERVER variables.

How will you connect a MySql database using PHP?

PHP provides mysqli_connect function to open a database connection.

Syntax:  mysqli_connect(host,username,password,dbname,port,socket);

$con = mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection
if (mysqli_connect_errno())
  echo "Failed to connect to MySQL: " . mysqli_connect_error();


What are interfaces n PHP?

Interfaces are defined to provide a common function names to the implementors. Different implementors can implement those interfaces according to their requirements. You can say, interfaces are skeltons which are implemented by developers.

What is the use of final keyword?

PHP 5 introduces the final keyword, which prevents child classes from overriding a method by prefixing the definition with final. If the class itself is being defined final then it cannot be extended.

What is Multidimensional array?

Multidimensional array − An array containing one or more arrays and values are accessed using multiple indices.

Distinguish between urlencode and urldecode?

urlencode(string) — This PHP function is encodes a string to be used in a query part of a URL. URL encoding is used when placing text in a query string to avoid it being confused with the URL itself. It is normally used when the browser sends form data to a web server.

urldecode(string) — This PHP function is decodes the query part of a URL string. URL encoding is used when placing text in a query string to avoid it being confused with the URL itself. It is normally used when the browser sends form data to a web server.


Note: Above are the most common Php interview questions and answers for freshers.