Super Bundle of Free e-books for Web Designers and Developers

Sharing knowledge it’s a great way to help others, this great job you can find on Project Gutenberg which is the first producer of free ebooks. If you are a Designer or Developer than this list bring to you best free ebooks about CSS, HTML, Ajax, web programming, javascript, web design and more topics about web development and designing. As well best books you can buy from tutsplus ebooks. All eBooks are available in PDF , ePUB, Mobipocket formats,  or viewed as a web page (HTML).

Head first HTML with CSS & XHTML

A learner’s guide to creating standards-based Web pages.

How To Be Creative

MacLeod, an advertising executive and popular blogger with a flair for the creative, gives his 26 tried-and-true tips for being truly creative. Each point illustrated by a cartoon drawn by the author himself.

If you’ve ever felt the draw to do something creative but just haven’t been able to pull it together, you’ll love this manifesto.

Web Designers Success Guide (PDF)

Web Designer’s Success Guide is the definitive guide to starting your own freelance Web design business. In this book he gives designers step-by-step instructions on how to achieve the following:

  • Transition from full-time to self-employment
  • Freelance on the side to make additional income
  • Find new clients and keep them coming back for more
  • Market your freelance business
  • Manage your projects professionally
  • Price your services appropriately

Design Your Imagination

WebGuru is glad to offer an ebook named “Design Your Imagination”; a one stop resource for the beginners and learners of website design. Though this e-book is mainly targeted for the beginners of website design, it might prove helpful for the experienced web designers as well.

View As PDF | Download as Zip


From Simon Schoeters, the author: Yet another overview of the changes introduced by HTML5. How does it look like? What is sexy? What is sexy? This presentation, that’s what.


The definitive guide to HTML & XHTML.

JavaScript Programming for the Absolute Beginner

For the Absolute Beginner, No Experience Required

Pro Drupal Development

Learn how to use the content management framework to create powerful customized web sites.

Web design in a Nutshell

Completely revised for standards compliance, including CSS 2.1 and XHTML 1.0.


Molly Holzschlag has her finger on the pulse of what web developers need to know. And small wonder, she has been working in the trenches herself for years.


The Best Easy-to-Use Guide to Joomla!TM–The World’s #1 Open Source Content Management System If you want to build sophisticated websites that can be easily edited and updated, you need to master Joomla. Now there’s an easy-to-read, easy-to-use guide to Joomla! for every site manager, administrator, and developer. Leading Joomla! consultant Barrie North covers all you need to get results: installation, administration, site organization, template development, content updates, and a whole lot more. You’ll find tips, tricks, and troubleshooting solutions, as well as three start-to-finish case studies. New to Joomla? No problem! This book starts with the simplest design and system concepts and builds your expertise step-by-step. You’ll rapidly master Joomla!’s power, even if you have no content management, scripting, or CSS expertise. Experienced with Joomla!? You’ll turn to this book constantly for its authoritative, plain-English, example-rich Joomla! 1.5 reference content. Understand content management, what Joomla! does, and how its components fit together Build Joomla! sites from scratch and systematically customize them to your needs Organize content with sections, categories, blogs, and tables Create dynamic pages and effective navigation Work with Joomla! modules and components Learn how to optimize your Joomla! sites for search engines Follow three start-to-finish case studies: building a school website, a small business site, and a blog Identify the most valuable Joomla! extensions and add-ons: find them and use them About the Website The accompanying site,, provides five fully functional Joomla! sites with live follow-along examples from the book and up-to-date information on Joomla!.

Up to Speed on HTML 5 and CSS 3

A presentation to Refresh DC about the emerging HTML 5 and CSS 3 standards, namely about aspects that are beginning to become applicable to web design and development.

Faster, and More Secure Webfonts

Font embedding for the web is a great step in making the web look better and become more functional, but what about security and load times?
Bram Pitoyo’s slide deck takes the top layer off font embedding and shows us how things work, and ultimately how to improve performance and make it more secure.

20 Things I learned about Browsers and the Web

What’s a cookie? How do I protect myself on the web? And most importantly: What happens if a truck runs over my laptop?
For things you’ve always wanted to know about the web but were afraid to ask, read on.

Integrating Accessibility Throughout Design (HTML)

Accessibility is designing products so that people with disabilities can use them. Accessibility makes user interfaces perceivable, operable, and understandable by people with a wide range of abilities, and people in a wide range of circumstances, environments, and conditions. Thus accessibility also benefits people without disabilities, and organizations that develop accessible products.

Web Style Guide: 3rd Edition (HTML)

Basic Design Principles for Creating Web Sites

Type Classification eBook

This book has been made to help you learn the 10 broad classifications of type. These are the basic foundations of what you need to learn to learn typography and it is essential for any designer to know how to classify type.

Time Management for Creative People

It’s subtitled ‘Manage the Mundane – Create the Extraordinary’ as it’s designed to help you maintain your creative focus while dealing with your other commitments.

Forty’s Pocket Guide to SEO

Quick reference for SEO terms and phrases.

Taking Your Talent to the Web

Rated Five Stars at since the day it was published, “Taking Your Talent to the Web” is now a free downloadable book from

The Design Funnel: A Manifesto for Meaningful Design

Are you a professional designer? Would you like a process to create more consistently creative work which distinguishes itself from the work of your peers?
Would you like a process which would help translate the often vague, unclear wishes of your clients (and yourself, for that matter) into a clear and solid basis for your design? This manifesto will show you how.

The Elements of Typographic Style Applied to the Web (HTML)

A practical guide to web typography.

Design Patterns

Essential JavaScript And jQuery Design Patterns – A Free New Book

Why design?

The booklet is written to provide some core messages for which we can create a common chorus. It defines the power of Designing, a larger concept that includes strategy as well as artifacts across a variety of disciplines.

The Woork Handbook

The Woork Handbook is a free eBook about CSS, HTML, Ajax, web programming, Mootools, Scriptaculous and other topics about web design… directly from Woork.

A Concise Guide to Archiving for Designers

In 10 short chapters the guide provides designers with the proper ways to store and describe their collections.

Getting Real

Discover the smarter, faster, easier way to build a successful web-based application. A book by 37 signals.

Lateral Action

Freedom, Money, Time,Key to Creative Success

Scribd in HTML5

As fans of HTML5 and its possibilities for the web, it’s nice to see major sites like Scribd jump on board the train and push it forward. Your move, Slideshare.

Learning PHP 5

A pain free introduction to Building Interactive Web Sites.

HTML5 Quick Learning Guide

This guide introduces you to just the main elements of HTML5 that you’ll probably want to use right away. This guide is for those who want to get the basics figured out first, and worry about the finer details later on.

Eloquent JavaScript

Eloquent JavaScript is a book providing an introduction to the JavaScript programming language and programming in general.

Search User Interfaces

This book presents the state of the art of search interface design, based on both academic research and deployment in commercial systems.

Access by Design Online

A universal design approach to web usability.

Research-Based Web Design & Usability Guidelines

Throughout your Web design or redesign project, you should take advantage of what is already known about best practices for each step of the process. The Research-Based Web Design and Usability Guidelines, compiled through an extensive process of research and review, bring you those best practices.

Practical PHP Programming

Welcome to the new home of Practical PHP Programming – now updated for PHP 5.2. This is the definitive source for the book from now on, and you’ll be pleased to know the entire book is hosted on a super-fast server so you should never have access troubles again.


A Beginner’s Guide to HTML.

Knock Knock

Knock Knock is now available for you to read for free. It’s a short take on how to use the new online marketing tools to make any website work more effectively.

CSS Cookbook

Quick Solutions to Common CSS Problems.

Beginning CSS: Cascading Style Sheets for Web Design

Cascading style sheets (CSS) are the modern standard for website presentation. When combined with a structural markup language such as HTML, XHTML, or XML (though not limited to these), cascading style sheets provide Internet browsers with the information that enables them to present all the visual aspects of a web document.

Ajax Design Patterns

Creating Web 2.0 Sites with Programming and Usability Patterns.

Flash 8: Projects for Learning Animation and Interactivity

Projects for Learning Animation and Interactivity.

Ruby on Rails: Up and Running

Lighting Fast Web Development.

Essential ActionScript 3.0

Action Script 3.0 Programming Fundamentals.

Foundations of Ajax

The expert’s Voice in Web Development.

Building iPhone Apps with HTML, CSS, and JavaScript

If you know HTML, CSS, and JavaScript, you already have what you need to develop your own iPhone apps. With this book, you’ll learn how to use these open source web technologies to design and build apps for both the iPhone and iPod Touch.

UX Storytellers – Connecting the Dots

You can download several book formats from a public dropbox  folder:UX_Storytellers_v1.1.pdf and UX_Storytellers.epub and for our beloved plus U.jpg plus U.opf (remember: Kindle is the name of a hardware device you have to buy from Amazon but there are free Kindle reader apps foriPhoneiPadAndroid or even Blackberry).

Data Structures and Algorithms

This book written by Granville Barnett and Luca Del Tongo is part of an effort to provide all developers with a core understanding of algorithms that operate on various common, and uncommon data structures.

Building Android Apps with HTML, CSS, and JavaScript

Device-agnostic mobile apps are the wave of the future, and this book shows you how to create one product that can be used on several mobile operating systems. You’ll find guidelines for using the free PhoneGap framework to converty our product into a native Android app. And you’ll learn why releasing your product as a web app first helps you find, fix, and test bugs much faster than if you went straight to the Android Market with a product built with the official Android SDK.

Guerrilla Freelancing by Mike Smith

Guerrilla Freelancing | PDF

Premium Books for Web Designers and Developers

Rockstar WordPress Designer BUNDLE

Want to take your WordPress theme designs to the next level? Rockstar WordPress Designer 2 picks up where the original Rockstar WordPress Designer left off and teaches you the advanced tools for WordPress mastery! Rohan Mehta translates his extensive experience as a WordPress developer into a straight-forward, practical guide to advanced WordPress features like custom post types, widgets, and more.

How to be a Rockstar WordPress Designer 2

Mastering CSS for Web Developers

Many Web designers are reluctant to embrace the new technologies such as CSS3 or HTML5 because of the lack of full cross-browser support for these technologies. Many designers are complaining how this situation is holding them back and tying their hands.

Smashing eBook Super Bundle

Professional Workflow For Web Designers

Being a great Web designer or developer is one thing; running a successful freelance business is another. Whether you already have experience working for a company or have just graduated from design school, being self-employed entails a number of tasks that you most likely haven’t had to deal with so far. As a freelance Web designer, you’ll often have to do it all yourself, and sometimes all alone.

Getting Good with JavaScript

Includes source files plus over 6 hours of screencasts!
JavaScript has become one of the most widely used programming languages in the world. This book will get acquainted with what JavaScript; what it is, where it came from, and most importantly – how to code it!

Successful Facebook Marketing 

This is information that Fortune 500 companies are paying social media consulting firms tens of thousands of dollars to share. You’ll learn all the strategies I used to co-ordinate a team to build and direct a network of 11 Facebook Pages with over 100,000 fans.

Professional Web Design Vol. 2

This eBook describes existing and upcoming trends and explains how the Web design might evolve in the coming months and years. It also touches on what Web designers should be ready for to keep abreast of new challenges and opportunities.

Freelance Confidential (Includes PDF, ePub + MOBI)

It also COMES IN ALL 3 DIGITAL FORMATS ! Buy the eBook and you get the PDF , ePub and MOBI (Kindle) versions as well!

• Full color charts with survey statistics from over 3200 participants of the 2010 Global Freelancers Survey, compared to the ground-breaking 2007 survey. Which means you will know trends before they effect your bottom line!

• Expert advice from seasoned entrepreneurs like James Chartrand, Ed Gandia, Linda Formichelli, Chris McConnell, Travis King, and more!

• Exclusive interview with Collis Ta’eed, co-founder of Envato, on the state of freelancing today and where things are headed. Hear how Collis would get started if he had to do it all over again!

• Rare advice and next steps: The realities of freelancing, debunking the biggest freelancing myths, advice for marketing, diversifying income, even getting support from friends and family!

Get Going with Google AdWords

In Get Going with Google AdWords, author Chandler Nguyen introduces you to the AdWords phenomenon, where you can bypass weeks or months of attempts to get your site to the top of Google search queries by bidding for keywords.

How to Take Great Photos

Learn the fundamental skills of what it takes to take great photos with whatever camera you got!
Whether you’ve got a simple point-and-shoot, or a professional camera, you’ll learn the basics of what every photographer needs to know to make their shots count!

How to Make Your First iPhone App

iPhone App Entrepreneur

If you’ve ever thought about developing an iPhone app (or even if you already have), this book will be a fascinating read. It will provide you with all the knowledge and technique you need to spot a great opportunity, get the most from the App Store, make smart decisions about development, craft a stunning interface, and promote your app successfully.

Theme Tumblr Like a Pro

In Theme Tumblr Like a Pro, Nettuts+ manager Jeffrey Way shows you just how much you can do with Tumblr, while still maintaining its core principle: simplicity.

Tumblr’s ease-of-use and streamlined approach has allowed its popularity to skyrocket, becoming one of the top blogging platforms around!

This book includes a completed Tumblr theme and all its asset files, so you can learn how to build the theme as you work your way through the book.

Photoshop to HTML

In “Photoshop to HTML ”, Nettuts+ editor Jeffrey Way takes you through the entire process of converting a design from Photoshop into a complete HTML /CSS website! But this is NOT just an eBook. It also comes packed with extras! You also get a directory of Photoshop, HTML and CSS files for you to use as you work through the book AND a series of 14 screencasts covering the whole project from beginning to end.

Gives users the ability to comment via Facebook, Twitter, Google or WordPress IDs.

WordPress is very strong platform to publish and promote your thinking by powering blog and Website on it. No one commenting on your blog posts? Get the conversation start giving the option to readers to comment with an account they’ve already set up, then you will be much more likely to get some interaction.

There are 3rd party commenting systems like eComments – easy commenting system, Disqus, IntenseDebate, Livefyre, Automatic Comments, Facebook Premium Client Application, along with others that work cross-platform regardless of what programming language or scripts your site is based on.

Today, I’m going to compile a list of the most commonly used (by bloggers and site owners) WordPress Plugins and 3rd party commenting and discussion systems, along with their key features and a couple of useful links for your reference.

Best 3rd Party Commenting Systems and WordPress Plugins

Comments Plus

Let your readers choose to comment via Facebook, Twitter, Google or regular old WordPress – developed for, now available for you!

Here are some cool features:

  • This plugin effectively allows you to combine comments from all these different services, rather than picking just one
  • If users choose Facebook or Twitter, comments are by default posted to their own accounts, extra exposure for you!
  • Fully integrated with subscribe by email with Facebook and Google
  • Works beautifully with any theme (and if you have any issues we’ll sort you right up!)

Useful Comments Plus Related Links:

Automatic Comments – Get the conversation started!

No one commenting on your blog posts? Get the conversation started with the Auto Comment plugin. Auto Comment automatically posts a comment on every new blog like: “Did anyone else see this?”, “Who has experience with this?”, “Has anyone tried this?”, etc.


Facebook Plugins, Comments & Dialogs for WordPress

This Facebook Plugins for WordPress is the ultimate and most advanced plugin to integrate Facebook Plugins, Dialogs and Facebook comments into your blog or website. It’s using WordPress shortcodes to make it very simple to add a Facebook plugin or dialog into any blog post or page. The plugins also comes with 4 widgets ready to be customized + a way to automatically add a Like button and/or the Facebook comment system into all your posts and pages.


  • 7 Facebook plugins that can be integrated with one line of code.
  • 2 dialogs using native Facebook popups.
  • Shortcode support for all the plugins and dialogs.
  • 4 widgets ready to be customized.
  • Automatically add a Like Button to all your posts or pages.
  • Automatically integrate Facebook comment to all posts and pages.
  • Easy way to customize the look and options of the plugins.
  • A way to disable the WordPress default comments.
  • Rich documentation and each shortcode option is documented.
  • Compatible with the Facebook WPress for WordPress.


Disqus (dis·cuss • dï-sküs’)

Disqus is the most used comment management system amongst bloggers and website owners. Integrating Disqus with your website and blog can be fairly simple. After signed up with Disqus, Under Admin, Click on Tools and go to the Import / Export section to find out more instructions on how to import your existing comments from various platforms (WordPress, Blogger, Movable Type, or other commenting systems) to Disqus.

Disqus mobile friendly:

Are you really attached to your phone? Our suite of mobile apps is the perfect fix if you’re looking to manage your community on the go. Moderate, reply, search, and manage straight from your iPhone, Android, or webOS phone!

Disqus features:

  • Compatible with search engines, in another word – SEO friendly.
  • Integrates with Akismet.
  • Allows commenters to post as guest, or login via OpenID or social networks IDs (Facebook, Twitter, Google and Yahoo).
  • Allows user to flag comments.
  • Easy comment moderation via admin panels.
  • Supports blacklist/ whitelist and word filtering.
  • Allows site owner to display Tweets and other reactions.

Disqus: Useful Links:


IntenseDebate is a feature-rich comment system for WordPress, Blogger, Tumblr and many other blogging/CMS platforms.  IntenseDebate is an Automattic product, the same guys who brought you WordPressPollDaddyAkismet and other cool web services.

 IntenseDebate features:

  • Supports numerous widgets to show off your comment stats, most recent comments, most popular comments and top commenters.
  • Allows users to login via OpenID, Twitter, Facebook or even ID.
  • Developers can take advantage of the Plugins API to make commenting and discussion even more interesting. E.g., adding PollDaddy polls, embedding YouTube Videos, etc.

IntenseDebate: Useful Links:


Livefyre is the first real-time comment platform built from the ground up for the social web. But what is it really about and what is it doing? Find the main features:


  • Connecting people and their friends to real-time discussions about topics they like.
  • Bringing comments up to speed with the rest of the web.
  • Having LIVE conversations about LIVE events.
  • Building community around the content you create.
  • Providing a platform where communities can engage in real-time across sites.
  • Interacting with our community and participating in the conversation.
  • Building the the newest innovative tools that connect you to the social web.
  • Listening to your feedback to give you the best experience possible.
  • Sharing the hot topics that the world is talking about.
  • Empowering our users to share their thoughtful opinions with the world.
  • The future of commenting and conversations on the Internet.

LiveFyre Related Links:

Janrain Engage

Janrain Engage increases site registrations and generates referral traffic to your site by allowing users to easily register and login via an existing account with Facebook, Google, Twitter, Yahoo!, LinkedIn and other social platforms. Users also can publish their comments or activities from your site to multiple social networks simultaneously.


References Useful Resources: 
Gigya Socialize WordPress Plugin – Facebook, Twitter, MySpace, Google, Yahoo, AOL
Top 3rd Party Commenting Systems – Reviewed
Authenticating Users With Facebook Connect and Google Friend Connect
 Stunning Facebook WordPress Plugins For Bloggers

Best Twitter Tips and Tutorials for WebSites Marketing

Just like Facebook, Twitter is one of the most popular social networking website. Although Twitter is not a new thing but this compiled list is for new bloggers as well business owners can get lot of information to boost their business online. All bloggers and website owners paying special attention on Twitter to promote and share stuffs with their friends.
In this list, Copyblogger have collected a fairly valuable links of killer resources along the way, which definitely help you to start marketing your business on Twitter.

Photo courtesy of ©
After reading the resources, hope you want to enhance the Twitter experience with your website specially if you website or blog running on WordPress. Following are the premium plugins which help you to get more traffic by using Twitter applications.

Twitter WPress Premium Plugin for WordPress

The Twitter WPress for WordPress enables you to use the power of the Twitter API , on your own WordPress blog. Integrate the Twitter connect, the signup process using Twitter. Store your users Twitter tokens and update their timeline later. Display Twitter widgets and buttons with powerfull shortcodes. Display Twitter friends and followers using the built-in widgets. Open you WordPress to the Twitter API !


  •  Enables users to connect with their Twitter account.
  •  Enables users to create a WordPress account using their Twitter credentials.
  •  Enables you to link a Twitter account to your WordPress first admin user.
  •  Store the Twitter users tokens into the database.
  •  Ability to post updates to your users Twitter timeline (even if they are logged out).
  •  4 widgets ready to be used (one for the Twitter connect, one to display Twitter friends, one to display the Twitter followers and one to display the last connected users).
  •  You can customize how many users are displayed in the widgets.
  •  Ability to display the Twitter connect button wherever you want in your theme(by adding a small PHP code provided in the documentation).
  •  Caching of Twitter API calls (set to 2 minutes).

Live preview | Detail

Twitter Mobile Web Application

This is a native Web Mobile Twitter application. It works like a Twitter client and contains all the Twitter connect functionalities. It enables the users to view their Twitter timeline, @Mentions, Tweets and favorite tweets. It also gives the ability to users to update their Twitter status without leaving the app.


  •  Powered by jQuery Mobile Framework.
  •  Uses AJAX to load the content, without reloading the page.
  •  Display user’s timeline, tweets, favorites and mentions.
  •  More button to dynamically load more tweets.
  •  Ability to update Twitter status.
  •  Status automatic counter.
  •  Works on major Mobile devices (including iPhone, iPad, Android).
  •  Setup in less than 2 minutes and you get your own Twitter Mobile app.

Live preview | Detail

Twitter Widget Pro – WordPress Premium Plugin

If you own just one twitter plugin for WordPress, let it be this one! The only premium twitter plugin out right now – with support for multiple twitter users and includes a ton of premium options. This is the last Twitter plugin you’ll ever need!

The Long Awaited Premium Twitter Plugin

  • Ready to use out of the box
  • The only premium Multiple User twitter plugin
  • Include twitter avatars, names, times, and more in the options page!
  • Automatically links hashtags, twitter users, and links
  • Caching support, both via wp_cache_set and via database options
  • Graceful crashing support in case, heaven forbig, twitter goes down
  • In Depth Screencast and Documentation included just to be safe!
  • Ridiculously easy to use – install it in mere minutes (and that’s being generous!

Live preview | Detail

Twitter Feed – iOS XCode Project

Twitter Feed is an iOS XCode project which illustrates the versatility of utilizing the built in URL request objects along with the XML parsing objects to perform GET transactions against the Twitter API in order to allow for retrieval of Tweets from a user’s timeline.

Live preview | Detail

Powerful Exchange System

This script is an powerful exchange system for Facebook, Twitter, Youtube, Google and Web Traffic and many features!

Live preview | Detail

TweetSearch – Twitter Search Plugin for WordPress

Premium WordPress plugin for displaying Twitter search results in your posts, pages and widgets.

Live preview | Detail

Twitter Statistics Suite

Twitter Statistics Suite lists exactly who has started following or unfollowing you, and who you have started following or unfollowing in the past 24 hours. Each user is displayed with their avatar and their username, with only 1 click away from their profile.

Live preview | Detail

Twitter Updates Widget for WordPress

With this widget, you can show your latest tweets on your website. Create your own widget with its great customizability.

Live preview | Detail

Sociology for WordPress: Twitter/Facebook Poster

Broadcast your posts to Twitter and Facebook directly from the WordPress post page.
– Automatically post to Twitter and Facebook when you publish your post.
– Checks for already-published status.
– Select which or both social networks to post to on the post page.
– support with custom credentials.
– Custom Twitter and Facebook credentials.


Send or Schedule Facebook & Twitter Status Updates

You will find in the package the WP integration package. Now you can use tuitting on WordPress, having the very same features, but completely integrated with your WordPress Theme and working with all the WordPress features!

What is tuitting?

tuitting is an extremely powerful tool, completely powered with AJAX and PHP . It gives to each member of your Website the possibility to immediately Send or Schedule Unlimited Status Updates for Unlimited Facebook Accounts, Facebook Pages and Twitter Accounts.

Live preview | Detail

Twitter Ultimate-Wordpress Plugin

Twitter Ultimate – A WordPress Plugin offer following features
Realtime Twitter Feed-Live Tweets
Shortcodes which helps to embed directly into page or post
Multiple instances
You can have multiple instances of twitter ultimate feed
Multiple Query/Username Options
You can display tweets from multiple queries or usernames
Two types of search
You can either display tweets from usernames or tweets mentioning a word
Autoplay On/Off
Realtime incoming tweets can be disabled/enabled on load
Live preview | Detail

Twitter Support Tickets

Twitter Support grabs incoming tweets to your account and organises them based their status, such as ‘Active’, ‘On Hold’, ‘Spam’ and ‘Closed.’ This app is primary for those who run a Twitter support account for their business and offers a simple method of management, so that it ensures everyone gets a speedy response. When you reply to a customer’s tweet it automatically marks it as been dealt with, so you won’t have to sift through masses of tweets to make sure you’ve replied to them all.


  • Secure, password protected single user log in
  • Active tweets are refreshed every 60 seconds in the background and are added to the list, so need to to manually refresh.
  • Counters displaying how many tweets are in each category
  • Settings control. Ability to edit admin username and password, Twitter username and password without editing configuration files.
  • Settings control to choose to ignore ReTweets (ie: RT @twittername)
  • Ability to post a custom status to Twitter (without it being a reply to a customer)
  • Automatic link generation – Displays click-able links in each tweet.
  • Logout feature

Live preview | Detail

The Ultimate Guide to Twitter Marketing

Most Important SQL queries for WordPress Beginners

Before taking any step make a backup of your current WordPress database. How to make a backup of your WP database? You can use different WordPress Plugins like Smart Backup and WP-DB_Backup, Alternatively you can use phpMyAdmin.
Smart Backup is a complete WordPress solution for database backup and restore operations. You can create backups of your complete WordPress installation, files only, or database only. Backups can be restored with one click.

Where to run WordPress SQL Queries

Hope you know where to run SQL Queries, If not follow these steps: Login to phpMyAdmin panel and select your WordPress database. After selecting your database, Click on the SQL tab which will bring you to a page with a SQL query box.

There are some plugins and script that will increase you SQL experience:

SQL Executionner plugin provides an easy-to-use interface that allows you to run SQL queries directly on your WordPress blog dashboard.

Super MySQL Terminal: Super MySQL Terminal is a php mysql shell emulator. You can work with your share-hosted remote mysql like your localhost.

SQL Comparer – Synchronize your database versions: Compare and synchronize two SQL database schemas and see the difference between them. A very helpful tool when dealing with different versions of a database.

SQL Document Generator: SQL Document Generator is a set of classes for creating documents in various formats based on SQL queries.

Enhanced SQL Web Console for MySQL: This script helps you helps you fire queries from database and export the resultset with a browser on the fly.


1). Drag-drop to use, no setup needed.
2). Smart bookmark feature, you can bookmark your favorite scripts and pickup them to use anytime.
3). Export the query resultset to CSV , Excel, XML , HTML formats.
4). Read-only mode avoiding writable scripts executing.
and more…

MySQL Database Navigation and Pagination: If you are working with hosting MySQL databases, and pick up data from them frequently, this script may make your life easy working with them.

CreativeTable: CreativeTable it’s a php class that builds a table based on the data retrieved by an SQL query or an 2D Array. It has lots of options and it’s very, very configurable.

LogPress: This plugin will help you to debug and speedup development of wordpress plugins and themes. Besides logging PHP error it can log a bunch of other things to help you make your website better.

Most Important WordPress SQL Queries:

How to: Manually reset your WordPress password

What to do if you lost your WordPress password? The easier is to use PhpMyAdmin and execute a simple SQL query to update it. Here’s how to proceed.

UPDATE 'wp_users' SET 'user_pass' = MD5('PASSWORD') WHERE 'user_login' ='admin' LIMIT 1;

Source: How to manually reset your WordPress password

Change author attribution on all posts at once

Some bloggers makes the mistake to write their first posts under the name “admin”, until they realize that it’s absolutely not personal. But then, modifying author attribution on each post takes a lot of time. Happilly, here’s a recipe to batch modify author attribution.

UPDATE wp_posts SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID;


Delete post revisions and meta associated to those revisions

Post revisions are very useful, especially in the case of a multi author blog. However, the problem of post revisions is definitely the number of database records it creates.

define('WP_POST_REVISIONS', false);

You can also delete all post revisions by running this query in phpMyAdmin:

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

Source: How To Turn Off Post Revision

Batch delete spam comments

Best way install Akismet! if you want delete more than 6000 spam comments by using this command of line.

DELETE from wp_comments WHERE comment_approved = '0';

Source: How to batch deleting spam comments on a WordPress blog?

Identify Unused Tags

In a WordPress database, if you run a query to delete old posts manually from MySQL, the old tags will remain and appear in your tag cloud/listing. This query allows you to identify the unused tags.

SELECT * From wp_terms wt
INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0;

Source: Find unused tags

Find and Replace Data

This tip isn’t specific to WordPress and is a must know for anyone who’s working with MySQL databases.

UPDATE table_name SET field_name = replace( field_name, 'string_to_find', 'string_to_replace' ) ;

Source: MySQL Magic – Find and Replace Data

Get a list of your commentators emails

Over a period of time, your blog will have received many comments. These comments will include the email addresses left by the commenter. You can retrieve all these emails for your mailing list without any duplicate.

SELECT DISTINCT comment_author_email FROM wp_comments;

Source: Export all Comment Emails with no Duplicate

Disable all your plugins at once

Sometimes, for exemple when you have to upgrade your blog, you need to disable all your plugins. Depending to how much plugins you’re using, it can takes a lot of time and be kinda boring.

UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins';

Source: How to: Disable all your plugins in a second

SQL Query to delete all tags

This piece of code will remove all tags and relationships between tags and posts, while leaving categories and taxonomies intact.

DELETE a,b,c
	database.prefix_terms AS a
	LEFT JOIN database.prefix_term_taxonomy AS c ON a.term_id = c.term_id
	LEFT JOIN database.prefix_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
	c.taxonomy = 'post_tag' AND
	c.count = 0

Source : Query to delete all tags

List unused post meta

The following query will show you all the records in the postmeta table that doesn’t have corresponding records in the post table.

SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;

Source: SQL Query to delete orphans wp_postmeta

Disable comments on older posts

This code will automatically close comments on posts which are too old. This SQL query will close comments on all posts published before January 1, 2009.

UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2009-01-01' AND post_status = 'publish';

Source: Enable or Disable Comments and Pingbacks via SQL

Replace commentator url

This SQL query easily replace the old url by your new site url. Simply run this query and you’ll be done!

UPDATE wp_comments SET comment_author_url = REPLACE( comment_author_url, '', '' );

Source: WordPress link author comments home page

Replace commentator email adress

This query will replace the email adress provided in the comments field, by a new one.

UPDATE wp_comments SET comment_author_email = REPLACE( comment_author_email, '', '' );

Source : WordPress-tip-update-email-address-in-the-wordpress-database

Delete all comments with a specific url

The following query will delete all comments with a specific url. The “%” signs means that any url containing the string within the % signs will be deleted.

DELETE from wp_comments WHERE comment_author_url LIKE "%sitetobeDel%" ;

Source : mysql-magic-find-and-replace-data

Other Reference and Resources:

Digging Into WordPress
WordPress Plugin Development: Beginner’s Guide
WordPress 3 Plugin Development Essentials
7 Best Useful SQL Queries for WordPress
15 Best SQL Queries For WordPress Database Administrator
WordPress : 10+ life saving SQL queries
How to be a Rockstar WordPress Designer 2
15 Most Important WordPress SQL Queries: Highly Beneficial

Best Innovative Uses of WordPress to run Online Invoicing System

There are many ways to run online business. If you have plans to make some money online, WordPress so for a best platform for small business owners specially if you are a freelancer. The big edge of running a website on WordPress is that you can extend the functionality of WordPress to grow your business independently. So let us check the few important and innovative plugins of invoicing systtem to manage client and making money from your website.

Online Invoicing System Powered by WordPress

If you are a Freelancer, With WordPress powered website you can run a fully-featured invoicing system by enhancing WordPress functionality  that allows you to send itemized bills to your clients and integrate with payment gateways like Google Checkout, or PayPal. You can read all about Best Online Invoicing and Billing Tools for Web Designers on this link and I am compiling a list of the WordPress plugins for invoicing systems.

Friendly Manual Order Processing for WP E-Commerce

Friendly Manual Order Processing for WP E -Commerce provides an easy-to-use and flexible way for you or your client to process orders directly from the WordPress back end without having to go through the payment process necessary on the front end of the site.


WP-Invoice – Web Invoice and Billing

WP-Invoice is a plugin from TwinCitiesTech that lets you create invoices right in your WordPress Administration screen. WP-Invoice lets WordPress blog owners send itemized invoices to their clients. Ideal for web developers, SEO consultants, general contractors, or anyone with a WordPress blog and clients to bill. The plugin ties into WP’s user management database to keep track of your clients and their information.


WordPress 3 Invoices

Wp3i is a WordPress plugin to manage invoices for freelance web designers / developers.

  • Create and track your invoices and quotes
  • Send stylish invoices to clients via HTML email.
  • Create a custom php templates for invoices, quotes and HTML emails
  • invoice templates use native WordPress code to make life easy
  • See live statistics of your income
  • Well designed interface
  • Customise Currency, tax and more
  • Completely FREE!
  • Supports I18n
  • Pay online though PayPal



CollabPress adds project and task management functionality to WordPress. Easily create projects and assign tasks to users.

Features include:

  • Unlimited projects, task lists, tasks, and comments
  • Easily edit/delete projects, task lists, tasks, and comments
  • Front-end shortcode support
  • BuddyPress group integration
  • File upload on projects, task lists, task, and comments
  • Email notifications for new tasks and comments
  • Task due dates with a calendar view
  • Uses built-in WordPress user accounts
  • Activity log tracking all activity


Technical Support

If you’re a freelancer, a web design agency or simply a WordPress consultant, Technical Support for WordPress is a way to provide quality support to your clients. After setting up a WordPress powered website for your client, install the Technical Support plugin, which will enhance your client’s Dashboard with a new widget for submitting support tickets directly to your e-mail.


FV Testimonials

FV Testimonials brings you easy management of your testimonials.

  • Easy to use and configured straight out of the box
  • Takes extensive care on testimonials images, resizes them to correct user-defined size
  • Easy embedding of testimonials everywhere on site
  • Requires almost no installation (just copy and activate)
  • Doesn’t create database overage (just a single additional query on a page with testimonials)

Download now!

Advanced Client Portal

Advanced client portal allows you to centralize all of your interactions with clients by combining client management and invoice management.


  • Create multiple projects per client, upload documents, media, links, and post messages
  • Create professional invoices for clients.
  • Download PDF versions of invoices.
  • Messaging system allows general conversations, as well as conversations specific to a project, document, or invoice.
  • Inline media player via flowplayer.
  • Projects can be organized by phase.
  • Email notifications for account activity (messages, documents, invoices, etc)
  • Security via sophisticated authentication system that also protects files. No one will be able to access a document or file not associated with their account.
  • Create multiple administrators.
  • Comes with an easy to use installation wizard.
  • Built using an MVC architechture making it easily extensible.

Live preview | Detail


eInvoice is a invoice generate system, with html & pdf format. easy to email to client. Nice template with easy to print out. You can also create your own template. just use two line, you can create your own invoice.

Invoice Design Examples

Design by Chase holdsnowaterv

 Cameron McEfee



Veerle Pieters for Devia

Ole Martin Buene

 Impulse Studios

Sugar Rush Creative


I would love to hear feedback from people who rely on WordPress to run their business.

Other References and Resources:

20 Invoicing Tools for Web Designers
Freelancing with WordPress: The Future of Invoicing with WordPress
blog post about WP-FreeLance
Free WordPress Plugins and Themes that are Perfect for Freelancers
an easy Online Invoicing System or Invoicing Software Solution
Invoice Like A Pro: Examples and Best Practices

Video Tutorials To Learn WordPress Development, Designing and Blogging

If you think that visual learning is better than reading, this is the list of well explained video tutorials which help you to develop your WordPress skill. These tutorials are very helpful if you are a WordPress Theme Developer as well Bloggers those using WordPress.

WordPress theme development

Designing for WordPress

WordPress is a hugely popular CMS for blogging. The blog section of CSS-Tricks is run on WordPress and I am very happy with it. By popular request, we are going to walk through designing for WordPress. Also check out part 2 and part 3.

Creating a WordPress Template

Here’s a tutorial series (also see part 2 and part 3) for creating a WP template using a variety of free tools such as MAMP (for local machine development) and TextWrangler(a text editor).

Hodgepodge of WordPress Tricks

It’s WordPress Week here at CSS-Tricks, so I wanted to so a WordPress-themed screencast and cover a lot of mini-tips that haven’t made it into previous WordPress screencasts.

WordPress as a CMS

Learn how to create a WordPress site that’s more of a fully-featured content management system (like Drupal or Joomla) rather than a blogging platform using a few tools at your disposal such as the SimplePie WordPress plugin.

How to Modify WordPress Theme

This video tutorial is showing how to work with some WordPress theme codes, that is how to add autoresponder code to the blog sidebar, how to put banner in the single post and similar things that can help you to modify the theme and blog to your needs.  You’ll learn about some Theme Template tags in WordPress.

Add a Twitter Field to Your Form

Instructional video on how to install and configure the wp-twitip-id plugin for WordPress blogs. 5 minutes and you can include a field for your commentators to add their twitter ID.

How to put a Custom Header in your WordPress Blog

WordPress Kubrick Theme, the default theme for WordPress blogs, has a very ugly header graphic. In this easy to follow video tutorial you’ll learn how to change it to a great custom image in just 3 minutes!

Create your first widget

This video tutorial shows you how to create a theme widget for WordPress.

How to make a WordPress plugin

Learn how to create a WordPress plugin that follows the WordPress plugin development guidelines.

WordPress Plugin Development Tutorial (Video & Reading)

WP Tutorial: Your First WP Plugin

Here it is, a video guide to creating your first WordPress plugin (in under 5 minutes!). The tutorial assumes you have some very basic PHP knowledge… syntax, function declarations, etc. Click here to watch

Writing a Plugin

WordPress Plugins allow easy modification, customization, and enhancement to a WordPress blog. Instead of changing the core programming of WordPress, you can add functionality with WordPress Plugins.

How to Write a WordPress Plugin – Introduction

For any WordPress user, plugins are essential. WordPress Plugins allow those with little to no programming skills to extend the functionality of their blog.

Create a Custom WordPress Plugin From Scratch

This tutorial will describe the implementation of a WordPress plugin starting from scratch. The plugin will connect to an external OSCommerce database and display random products on your WordPress site.

Anatomy of a WordPress Plugin

This tutorial will guide you through every step of building a simple, widgetized WordPress plugin with settings.

A Crash-Course in WordPress Plugin Development

Despite an extensive codex, many WordPress users remain unfamiliar with how to create their own custom plugins. In today’s screencast, we’ll start from scratch and build our first usable plugin.

WordPress Plugin Tutorial – Hello World

Learning to develop a WordPress plugin can be both fun and rewarding. In this Tutorial we will go over how to make a simple Hello World plugin that you can create.

The Ultimate Guide to Building a WordPress Plugin

There are often plugins created for basic extended functionality, but what happens when you can’t find the perfect plugin for your needs? It might be easier to just create the plugin yourself.

WorPress Plugin Development with PHP

Nice video tutorial on plugin development.

Tips to Speed Up WordPress Plugin Development

Anyone can create useful WordPress plugins without being a hacker.

Seven Reasons to Write a WordPress Plugin

Listed below are seven reasons why a WordPress user should consider writing a WordPress plugin.

WordPress Plugin Actions

An example of an action would be that you want a execute some code after a user has published a post or left a comment.

WordPress Plugin Filters

WordPress filters allow to you modify virtually any kind of text displayed and are extremely powerful.

Constructing a WordPress Plugin Admin Panel

This tutorial will go into what it takes to successfully create an admin panel for your plugin.

Constructing a WordPress Plugin User’s Panel

This tutorial will go over the steps to add in your own User’s Administration Panel.

Using JavaScript and CSS with your WordPress Plugin

This portion of the series will cover how to load JavaScript and CSS files for your plugin.

Using JavaScript and CSS with your WordPress Plugin

This portion of the series will cover how to load JavaScript and CSS files for your plugin.

Releasing and Promoting Your WordPress Plugin

After you have finished writing your awesome WordPress plugin, there are a few things to consider before releasing and promoting your WordPress plugin.

WP Screencasts WordPress Video Tutorials

The primary target audience is blog authors and editors using WordPress to manage their web-based content.

CSS-Tricks WordPress Video Tutorials

iThemes WordPress Video tutorials

Siteground WordPress Video Tutorials

KillerSites WordPress Video Tutorials

Likoma WordPress Video Tutorials

WordPress Training Video Tutorials

Weblog Tools Videos WordPress Tutorials

ScreenCastCentral WordPress Video Tutorials

Faq.WordPress.Com Screencasts

Youtube WordPress Video Tutorials

Other Tutorial Sites and Articles:

Free & Professional WordPress Security Service Free & Professional WordPress Security Service

We Love WordPress. WordPress Arena is a place for WordPress Developers and Designers, providing Tips, tricks, tools and resources to build a website or blog on WordPress. We also present The WordPress Showcase for all kind of WordPress Powered Websites.

Copyright © 2014 WP Arena All Rights Reserved

Divi WordPress Theme