AUTO INCREMENT IN SQL: How to Set Your Primary Key To Auto Increment

I often used an auto increment primary key in creating my table due to unavailable candidate for a primary key. With the use of the use of t...

PYRAMID IN PHP: Form an Upside Down Pyramid Using Numbers in PHP

I created another PHP Code to dsiplay a pyramid out of numbers. This program uses two (2) looping statement. In my example, I did used the w...

SQL SERVER MAX: Display the Maximum Number in Column

SQL Max  is used to find the maximum value in a certain column in a table. In my example, I have the SALES table below with records. Syntax ...

MULTIPLICATION TABLE: Display Multiplication Table using Loop in PHP

Hey guys! My new article is about displaying a multiplication table for the number 9. The $num contains 9 which will serve as our multiplica...

AREA OF ISOSCELES TRIANGLE: Solve for the Area of An Isosceles Triangle in PHP

An isosceles triangle is a triangle with two (2) equal sides. To be able to solve for the area of an isosceles triangle, you need to used th...

EQUILATERAL TRIANGLE AREA: Solve for the Area of An Equilateral Triangle

An equilateral triangle is a triangle with three (3) equal sides. The following is the illustration and formula on how to solve for the are...

PYRAMID IN PHP: Form a Pyramid Using Numbers in PHP

I created another PHP Code to dsiplay a pyramid out of numbers. This program uses two (2) looping statement. In my example, I did used the w...

GENERATE RANDOM CODE IN PHP: Create a Random Code From A-Z a-z 0-9

Hi there! Today I created by own version in generating random code in PHP from characters A-Z, a-z and 0-9. You can set how many characters ...

GENERATE RANDOM NUMBER IN JAVA: Display Random Numbers Using Java Language

I already posted the article about generating random numbers using PHP . This time, I converted it into Java language. The following code wi...

PHP RANDOM NUMBER: Generate Random Numbers in PHP

A random function rand()  is used to generate random integer numbers. I already done posting article about generating random numbers in Java...

JAVA CELSIUS TO FAHRENHEIT: Celsius to Fahrenheit Java Converter Code

Hi there! This article will create a simple temperature converter from  Fahrenheit  to  Celsius  and vice versa. We will be using the follow...

JAVA ODD OR EVEN: Display Numbers in a Loop and Identify if Odd or Even

This example uses Java looping statement specifically the  while loop  but you can also use the different looping statements. The example be...

JAVA RECTANGLE AREA: SOlve for the Area of a Rectangle

Area is the size of the surface of an object. In this article, we will discuss about the formula and  java code  in solving for the  area of...

JAVA ELLIPSE AREA: Solve for the Area of Ellipse

Ellipse is an oval shape quite similar with that of a circle but is elongated. I already posted articles related to solving for the  area of...

PHP ELLIPSE AREA: Solve for the Area of an Ellipse

Ellipse is an oval shape quite similar with that of a circle but is elongated. I already posted articles related to solving for the area of ...

SQL QUERY WILDCARD: Display Values Based on a String Pattern Using SQL Query Like and SQL Query Wildcard

We often search to find a certain data easily in our database. Such as searching for a friends name in facebook. And perhaps, searching for ...

SQL SELECT DISTINCT AND GROUP BY: Select Distinct Values in SQL and Group By

Select  is used to display all columns from a table. This includes records with redundancies. So if you want to display records without redu...

JAVA SQUARE AREA: Solve for the Area of a Square

Area is the size of the surface of an object. In this article, we will discuss about the formula and  java code  in solving for the  area of...

JAVA TRIANGLE AREA: Solve for the Area of a Triangle

Area is the size of the surface of an object. In this article, we will discuss about the formula and  java code  in solving for the  area of...

PHP CIRCLE AREA: Solve for the Area and Circumference of A Circle

Area is the size of the surface of an object. In this article, we will discuss about the formula and  php code  in solving for the  area of ...

PHP SQUARE AREA: Solve for the Area of a Square

Area is the size of the surface of an object. In this article, we will discuss about the formula and  php code  in solving for the  area of ...

FOR LOOP PHP: Display Numbers Using For Loop in PHP

For loop is used if you already know how many times your code will be executed. Syntax for(init;condition;increment/decrement) {  statement...

FOREACH LOOP PHP: Display Data from An Array Using Foreach Loop in PHP

An array  is a special variable that holds not just a single value, but multiple values. Let's say we have an array of names such as Rea...

PHP TRIANGLE AREA: Solve for the Area of a Triangle in PHP

This is a simple code to solve for the area of a triangle in php. Area is the surface of an object. The formula is A=hb/2 or height * base /...

FOR LOOP IN PHP: Display Numbers Using For Loop

PHP for loop  is used to repeat execution of statement until a certain condition is true . First thing to do in the for loop is to initializ...

PHP LOOP: Display Numbers Using Do While Loop

The Do While  loop executes the body of the loop before checking for the condition. Unlike the while loop wherein testing the condition is d...

PHP CELSIUS TO FAHRENHEIT: Celsius and Fahrenheit Converter Code

Hi there! This article will create a simple temperature converter from fahrenheit to celsius and vice versa. We will be using the followin...

PHP ODD OR EVEN: Display Numbers Using A Loop and Identify If Odd or Even

This example uses PHP looping statement specifically the while loop  but you can also use the different looping statements. The example belo...

WHILE LOOP IN PHP: Display Numbers Using While Loop in PHP

PHP while loop  is used to execute statement/s if the condition is true until a certain condition is false . Syntax for the while loop whil...

SQL SELECT GROUP BY: Display Sum of a Certain Column With Select Group By

On my previous post, we used the SUM function to calculate the TotalSales in a store. What if we want to display the TotalSales by PRODUCT...

AVERAGE IN SQL: Display The Average of A Column From Database

Another arithmetic function in SQL is the AVERAGE function used to solve for the average of a specified column in your table. I have two (2...

SQL COUNT *: Count The Number of Rows in a Certain Table

Another arithmetic function other than SUM is COUNT . The purpose of COUNT is to return the number of rows found in a certain column. For ex...

SUM IN SQL: Solve For The Sum of A Column From Database

Instead of solving for the sum of a certain column using PHP or other programming language, you can achieve it by using the SQL SUM function...

CALCULATOR IN PHP: Create A Simple Calculator

This example is just a simple PHP script to calculate two (2) values based on the selected operator. The sample output is posted below for i...

PHP MYSQL: Display Data in Tables From Database

STUDENT First you construct  your HTML code and insert the following code between your body code. HTML, PHP and MySQL Code <table>  &...