Monthly Archives: November 2013

Introduction to HTML

iNetTutor.com will provide new sets of tutorials which includes HTML, CSS, Photoshop ,  Programming Languages such as Visual Basic, Visual Basic.net, Java, C#, etc. and we will try to upload video tutorials on the said topics. Keep on visiting for more updates.

Introduction to HTML

This set of lessons and tutorials will provide you the basic knowledge of HTML through examples the easy to follow instructions and explanations.

What is HTML?

  • HTML stands for Hypertext Markup Language; it is the main markup language for creating web pages and other information that can be displayed in a web browser.
  • HTML is a text formatting language.
  • In simplest term HTML is used to create websites.

PHP mail() function

PHP mail() function

In this lesson we are going to show you a sample PHP script on how to send email using the PHP mail() function.

PHP mail() function arguments

  1. The email address of your recipients
  2. Email subject line (ex. Meeting, Party)
  3. The body of the message
  4. List of email header fields like “From”, “Cc”
  5. Other parameters

Note: the email address and the body of the message is the most important one, the rest are optional.

Windows Calculator

Calculator is commonly used to solve basic mathematical operations such as multiplication, division, addition and subtraction. Calculator in Windows 7 offers lot of advance features such as programming, scientific and statistics.

How to open Calculator:

  1. Click Start > Run (Windows + R – shortcut for Run Dialog)
  2. Type calc and hit enter.

Or

  1. Click Start > All Programs > Accessories > Calculator

Restore MySQL database using PHPMyAdmin

phpMyAdmin is a free software tool written in PHP, it is a browser-based platform used to manage and administer MySQL database.

On the previous tutorial we have learned how to create a backup of our databases using the mysqldump command. Now we are going to reestablish or restore our database to its previous state.

Backup MySQL database on WAMP

Backup MySQL database on WAMP

In this tutorial we are going to learn how to back up our MySQL database in WAMP using the mysqldump command.

mysqldump command is used to export a database or all databases that resides on your MySQL Server. The exported file has an extension of .sql which commonly consists of SQL commands to create a database, create tables and insert records into tables.

Here’s how to create a backup file using the mysqldump command

  1. Click Start > Run then type cmd and hit enter.
  2. Syntax: C:\wamp\bin\mysql\[mysql version]\bin\mysqldump -u root -p [database_name] > [path where you want to put the file and the filename]
  3. Type this command: C:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump -u root -p dk> c:\dk.sql

MySQL ALTER Command

In this lesson we are going to learn how to use the MySQL alter command.

There are lots of Graphical User Interface (GUI) Tools to manage our MySQL databases as discussed on this page (link), through that modifying the structure of a database as well as the structure of tables, the field data types and much more depending on the capability of that tool. All of that comes in a handy way because these tools has a drag and drop capability. The users can easily change the data types of a certain field, rename a table, and add new columns. In this lesson we are not going to tolerate those manners (drag, drop and click).

Determine the PHP version on your server

Determine the PHP version on your server

In this lesson, we are going to learn how to determine the PHP version running on our server using codes.

Just follow these simple steps:

  1. Open any text editor (notepad, notepad ++, etc.).
  2. Type the following code or better copy and paste the code on your text editor:
    <?php echo phpversion(); ?>

MySQL SHOW Command

MySQL SHOW Command

SHOW command is used to learn more about the databases found in the server, tables found in a database, and specific information about the columns or fields within a table.

Let’s take a look on the uses and examples of the SHOW Command.

We want to know the databases that reside on our MySQL server, to do that issue the command:

mysql>show databases;
+----------+
| Database |
+----------+
| mysql    |
| sample   |
| test     |
+----------+
3 rows in set (0.14 sec)

Note: the results may vary depending on the stored databases on your system.

Drop Database and Table in MySQL

Dropping the Database

To delete an entire database, use the DROP DATABASE command. This command will delete the database and the tables inside it. Let’s try some example:

Syntax of DROP DATABASE command:

DROP DATABASE database_name;

Where: database_name is the name of the database you want to drop or delete.

Manage Start-up Programs in Windows

Manage Start-up Programs in Windows

Why should we manage the programs that run automatically when we turn on our computers?

The following reason explains why:

  • So many start-up programs may cause your computer run slow.
  • Spyware, Adware and other malicious program executes during the start-up.
  • Managing the start-up programs may speed up your computer system and it’s one way of optimizing the resources of your system by reducing the load during the start of your operating system.

We’ve explained the reasons why we should manage the start-up programs. Now, let us proceed on the process of doing that.