Monthly Archives: September 2011

MySQL Tutorial – MySQL DELETE command

MySQL Tutorial – MySQL DELETE command

The DELETE command is used to delete records in a table. The syntax of DELETE command:

DELETE FROM table_name WHERE [conditions];

Note: The where clause in the delete command specifies which records should be deleted. If you exclude the where clause all the records in the table will be erased.

Example of DELETE command:

PHP Tutorial – The while loop

A loop is a block of code that enables you to repeat the same set of statements or commands over and over again; the actual number of repetitions may be dependent on a number you specify.

The while loop

The while loop will continue to execute a block of code as long as the specified condition is true and if the condition becomes false the code within the loop will not be executed.

Enable/Disable Task Manager using Group Policy Editor

Enable/Disable Task Manager using Group Policy Editor

In this tutorial, we are going to learn how to enable/disable Windows Task Manager using Group Policy Editor (gpedit.msc).

Group Policy Editor – This snap-in allows you to edit Group Policy Objects which can be linked to a Site, Domain, or Organizational Unit in the Active Directory or stored on a computer.

Here are the steps:

1. Click Start, Run, type gpedit.msc and click OK.

2. In the Group Policy Editor navigate to the following:
User Configuration -> Administrative Templates -> System -> Ctrl+Alt+Delete Options.

Enable/Disable Registry Editor using Group Policy Editor

Enable/Disable Registry Editor using Group Policy Editor

In this tutorial, we are going to learn how to enable/disable Registry Editor using Group Policy Editor (gpedit.msc).

Group Policy Editor – This snap-in allows you to edit Group Policy Objects which can be linked to a Site, Domain, or Organizational Unit in the Active Directory or stored on a computer.

Here are the steps:

1. Click Start, Run, type gpedit.msc and click OK.

2. In the Group Policy Editor navigate to the following:
User Configuration -> Administrative Templates -> System.

Automated Class Scheduling System in Visual Basic

This is a sample of an Automated Class Scheduling System developed in Visual Basic and MS Access.

Download the source code below.

System’s Mechanics

The following are the mechanics of the system with its corresponding description.
Log-in/out Menu – enables the users to access the system depending on the type of account the user has.

Log-out menu enables the users to exit or close the application.

Users Menu – allows the user to add, edit, update and delete certain username and password. This menu could only be access with an administrator account.

There are two (2) types of user accounts the user account and administrator account. The user account can log-in/out using the menu and can print all class schedules while the administrator account can access all menus in the system.

How to Manage Menus in Drupal

Manage Menus in Drupal

Menus are a collection of links used to navigate a website. The Menu module provides an interface to control and customize the powerful menu system that comes with Drupal.

Computerized Library System in Visual Basic 6.0

Computerized Library System using Visual Basic 6.0 as front-end and MS Access as the back-end

The system would provide basic set of features to add/update student’s information, add/update books information, search for books and manage check-in/check-out processes.

 System’s Mechanics:

The following are the mechanics of the system with its corresponding description.

Log-in/out Menu – In log-in option the system verifies the user account information and grant access to the application if the information such as username and password are correct. Log-out option is used to exit or close the application.

PHP if…else…if statement

PHP if…else…if statement

if…elseif….else statement – use this statement to select one of several blocks of code to be executed.

The if…elseif….else statement

This statement is used to select one of several blocks of code to be executed.

The if..else statement executes if a specified condition is true or false. It means in if..else we can mention one to two conditions. But in if..elseif..else,we can select number of blocks to be executed.

MySQL Tutorial – MySQL UPDATE Command

MySQL Tutorial MySQL UPDATE Command

This lesson will teach us how to update our records in the database. The UPDATE command is used to update records in the table. Here is the general form of UPDATE command:

UPDATE table_name SET
column_name1 = value1,
column_name2 = value2,
column_name3 = value3 …
WHERE [conditions];

Note: The where clause in the update command specifies which records should be updated. If you exclude the where clause all records will be updated.