Create a CSV file using PHP and MYSQL

csv

As we know that CSV files are one of the most used way to back-up mysql database and tables. However it is very simple to export or backup your mysql database table as CSV file if you have PhpMyAdmin interface installed on your server. Actually problem arises when we have to deal with a shared hosting. But by using PHP script, you can export complete mysql database table to csv files. Here in this post I have given you a [...]

Swapping Array Keys and Values

Swapping Array

In this article we discuss about Swapping Array Keys and Values. If you want interchange the keys and values of an associative array. It’s very easy, just use PHP’s array_flip() function which perform a very specialized task. It reverses the key-value relationship for all the elements of an associative array and returning a new array that is the mirror image of the original. <?php $opposite_key_value = array(“white” => “black”, “day” => “night”, “open” => “close”); print_r(array_flip($opposite_key_value)); ?>

Future of SEO – 20 Questions Asked By Webmasters

Future Of SEO

A campaign by Matt Cutts, the head of Google’s web-spam team for recording a video series for webmasters has received huge response from SEO enthusiasts around the world. Till date 1265 people have participated, 581 questions asked with a total of 13,531 votes . Webmasters and SEO practitioners have asked some interesting questions to Matt which may play an important role deciding the “Future Of SEO.” I have hand-picked and compiled 20 interesting questions for you, which may modify the [...]

SEO Friendly URL Structure for Higher ranking

SEO Friendly URL Structure for Higher ranking

Every content starts from a URL (Uniform Resource Locator). In fact, a blog post is an extension of a URL only. And, a SEO friendly URL structure plays an important role for higher ranking of your content in search engines. A good URL is as important as the “title” of the post. A pretty URL,which is easy to remember, catchy and not so long helps your blog post go viral, because it’s easy to share in the social media. On [...]

Php Interview Questions and Answers – Part 8

Php Interview Questions and Answers

Php Interview Questions and Answers – Part 8 1- Give the syntax of REVOKE commands? The generic syntax for revoke is as following REVOKE [rights] on [database] FROM [username@hostname] Now rights can be: a) ALL privileges b) Combination of CREATE, DROP, SELECT, INSERT, UPDATE and DELETE etc. We can grant rights on all database by using *.* or some specific database by database.* or a specific table by database.table_name. 2- What is the difference between CHAR and VARCHAR data types? [...]

Favorite SEO Tips for WordPress for Better Ranking

SEO-Tips-for-WordPress

Do you want to know my Favorite SEO Tips for WordPress to rank higher in search engines? I have compiled 20 of my best seo tips for WordPress, which I am using on my own blog MoneyCTL, not only to rank higher, but also to stay immune from Google Panda, Penguin and all sorts of SE algorithm changes. SEO is an Art + Science of fine tuning of your contents and your WordPress blog as a whole to be loved [...]

How to Avoid Duplicate Content Penalty

avoid-duplicate-content

Is it possible to publish some content from other sources or sites without any Google penalty Avoid Duplicate Content Penalty? With the introduction of Google Panda algorithm, more and more webmasters are fearing to publish content from other blogs or websites. Google Panda is meant to fight against low quality content, which also covers duplicate content. With every Panda update, more and more sites are being penalized. Recently, Matt Cutts, the head of Google’s web-spam team has released a new [...]

7 Best Twitter Plugins for WordPress

BEST WORDPRESS PLUGIN

Do you know – The best way to rule the Twitter World via your WordPress blog is what? Obviously a plugin, a twitter WordPress plugin! Twitter, and social media as a whole is going through the golden phase. As a blogger the best way to leverage the power of Twitter Plugins for WordPress. I have collected 7 Best Twitter plugins for WordPress, out of 100s, to rule the social media in 2012. So, let the collection begins… Best Tweeter Plugins [...]

Top 5 Ways To Get Good Quality Backlinks

good quality backlink

Finding good quality backlinks is difficult in this day and age. It may be tempting just to load up a cheap backlinking tool and let it plug away at linkbuilding, but any link that is easy to get probably isn’t worth its weight in salt. Similarly, if there was an algorithm update, chances are high that you may be affected from it negatively. Here are a few methods to finding the kind of backlinks you need. The first few are [...]

Natural Link Building with Content – 11 Great Tips

Natural Link Building

Using content for natural link building is the most preferred strategy by webmasters. But, getting links for content is not as simple as it sounds. It requires a strategic approach of content creation with natural link acquisition in mind. Links are the currency of the web. And, natural links carry the maximum value or weighted than editorial links, links from directories etc. So, building quality natural links require your content to be of great quality. Natural Link Building Tips 1. [...]