Monthly Archives: October 2011

MySQL Tutorial – The GROUP BY clause

The GROUP BY clause

The GROUP BY clause is used to group similar data specified by a certain field in your table.

The GROUP BY clause syntax:

SELECT column_name(s)
FROM table_name
GROUP BY column_name;

Managing Plugins in WordPress

WordPress: Managing Plugins

Plugins are tools to extend the functionality of WordPress.

Manage plugins:

1.      Login to your WordPress site using the administrator account.

2.      Click Plugins in the Plugins tab in your dashboard to go to the Plugins administration form.

How to modify site information in Drupal

Drupal: Site Information

In this lesson we are going to learn how to change our site details information such as site name, email and slogan.

Updating site information:

1.      Login to your Drupal site using the administrator account.

How to make your Drupal site Offline

Drupal: Site Maintenance

In this lesson we are going to learn how to turn the site in offline mode.

Whenever you perform maintenance or upgrading your site sometimes you need to turn your site offline. You can display message to your visitors that site is in maintenance mode.

PHP Tutorial – PHP Forms

In this tutorial we are going to learn how to take data entered by the user in an HTML form and process it into PHP script and display the output.

We need two pages here namely the process.php and the test.php or test.html.

On our test.html we are going to create a form to collect some data. Here is the code:

WordPress Tutorial – Managing Widgets

Managing Widgets in WordPress

In this tutorial you will learn how to manage and customize your widgets in WordPress.

A widget is a small box of content, dynamic or not, that shows up somewhere on a widget-enabled site. Often, that location is in the sidebar of a blog. A widget area can be anywhere a theme developer wants it to be. Widgets provide a method of displaying your WordPress links, ads, text and other information in your sidebar. They provide a graphical interface with drag and drop capabilities.

How to Manage Blocks in Drupal

Drupal: Manage Blocks

In this lesson we are going to learn how to create and manage blocks in Drupal.

Blocks are the boxes of content that can be displayed in regions (such as footer or sidebar) on your site.

Creating Blocks:

1. Login to your Drupal site using the administrator account.

2. Click Structure in the toolbar.

3. Click the Blocks link.

WordPress Tutorial – Managing Themes

WordPress: Managing Themes

Themes are also called Templates of layout of your site. It gives your site the look, style and design. WordPress allows you to change the style of your site without knowing how to code in HTML and CSS. In this lesson we are going to learn how to manage themes in WordPress.

Manage Themes:

1. Login to your WordPress site using the administrator account.

2. Click Themes in the Apperance tab in your dashboard to go to the Themes administration form.

Joomla Tutorial – Joomla Users

In this lesson we are going to learn what the different classifications of users in Joomla are.

In Joomla there are two classifications of user groups:

Back-end user groups consist of Manager, Administrator, and Super Administrator. Back-end users can create, edit and update content in your site by logging into the administration control panel of your Joomla site.

  • Managers: they have the privilege to access the content in the Backend. They can manage articles, sections and categories but they do not have access to user management and other components of Joomla like installing a component or modules.
  • Administrator: they have access to most of the functions of Joomla except that they can’t modify the site template and global configuration. They can manage users except for the Super Administrator.
  • Super Administrator: all of the functions in Joomla are given to this user group. Only another Super Administrator can modify a Super Administrator user account

MySQL Tutorial –MySQL AND & OR Operators

MySQL TutorialMySQL AND & OR Operators

AND operator is used to display records if both the first and second condition is TRUE. It can be used in SQL statement such as SELECT, UPDATE, DELETE.

AND operator syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name=condition1 AND column_name=condition2;