Category Archives: PHP

SQL LIKE Operator

Good morning to all, Welcome to SQL commnands, queries, operators etc. Now we are discuss the SQL LIKE operator. The LIKE operators used to fetch the data from database foor specific pattern. The LIKE operator is used to search for a specified pattern in a column used in WHERE clause. There are two wildcards used… Read More »

Retype password Validation – Javascript

Hi Guys, Here I explain, how to check Password and Confirm Password validation for Password TextBox using pur javascript method with demo. The Password and Confirm password are in textboxes. And these are compared using JavaScript and if the values do not match an error message will occur like password must be same. If the… Read More »

Reset Auto-Increment – MySQL

Good morning to all, Here I going to demonstrate how to reset auto-increment value in MySql. Assign to auto-increment attributes to a column of a table, to generate unique identity for the new row. If new row is inserted it incrementsthe value one. Whenever you insert a new row into a table, MySQL automatically assigns… Read More »

SQL JOINS

Hi all, The SQL joins are used for combine rows from two or more table based on a common field between them.We are discuss this topic today. It fetch data from two or more tables and which is joined to appear as single set of data. Join Keyword is used in SQL queries for joining… Read More »

Truncate, Drop and Rename a Table- SQL

Hi all, Here I share some useful information in sql queries like truncate command, drop command alter command. These is more helpful in MYSQL operations. For delete complete data from an existing table using TRUNCATE command. And also delete the data inside the table. For delete a table using DROP command. It helps to remove… Read More »

Sorting Arrays – PHP

Welcome to all, Today we practise how to sort an array using php. We know this same problem solving using C, CPP or JAVA etc. But here I share how to solve this problem in php. To arrange the elements in an array in numerical order from highest to lowest values (descending order) or lowest… Read More »

AND and OR Operators – SQL

Hi Guys, Today we share our idea related to AND and OR operator with example. The AND and OR operators are the conditional operator in SQL. It is used to filter the data or records based on conditions. The main difference between AND and OR operators are: the AND operator displays a record if both… Read More »