PHP User Defined Functions
A function is a block of code which we use to perform a specific task repeatedly in a program. Functions allow us to save the time without typing the same…
PHP Variables
In order to know PHP variables, we need to understand the variables in programming. What is a variable? A variable is a way of storing information in your computer. This…
PHP Conditional Statements
As a programmer, you often find situations to perform something based on certain type of conditions. PHP Conditional statements are the techniques we need to know to handle these situations. These…
SQL Joins
SQL joins are used to join database tables based on a common field There are different types of SQL joins INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER…
SQL Aggregate Functions
In this lesson we are working with the following tblproduct table It has following fields (ProductID, Category, BrandName, ProductName, Price) SQL Aggregate functions give a single value after processing data…
SQL BETWEEN Operator
SQL BETWEEN Operator is used to select data from a database table based on a given range. In this lesson we are working with the tblproduct table which includes the…
Data Filtering In SQL
In this lesson we are working with the student table which includes the following fields (studentID, FirstName, LastName, state, age) SQL SELECT Statement The select statement is used to fetch…
SQL LIKE Operator
In this lesson we are working with the following student table SQL LIKE Operator LIKE Operator finds data from a column based on a specified pattern Following example finds students’ first…
SQL UPDATE, DELETE Statements
UPDATE Statement Update statement is used to update records which are already in the database table In this lesson we are working with the course table which includes the following…
Fundamentals of HTML
What is HTML Stands for? HTML stands for Hyper Text Markup Language What is HTML? HTML is a markup language. Hypertext is text which includes links for other web pages…