Category Archives: Web Development

SQL Query Interview Questions with Answers

Hi all, Today I share one important topic related to SQL. SQL query is very important. This article mainly focus sql query related to interview questions and answer. In this article, I am giving some examples of SQL queries with answer which is frequently asked when you go for a programming interview. The main advantages… Read More »

mysql_close() function:PHP

To close an open MySQl connection in php, the mysql_close()helps to perform this function. The mysql_close() function is not the necessary part in our program. In non-persistent open links are automatically closed at the end of the script’s execution. Syntax mysql_close(connection) Example Output : connected successfully at:26/07/10 : 09:31:14 disconnected successfully at:26/07/10 : 09:31:15 If… Read More »

Difference between HTTP and HTTPS

Hi Guys, Today we are discuss one important topic related to HTTP and HTTPS. Everyone heard this HTTP and HTTPS. Most address begins with http, means hyper text transfer protocol. Call address on address bar then the address http automatically redirect to https, nobody knows what happens there. HTTPS is secure protocol, our address bar… Read More »

Fetch MYSQL table data – PHP

Welcome to all, Here we discuss one useful topic related to MYSQL,fetch the data from data base in MySQL using PHP. From the MYSQL database the data can be fetched by executing SQL SELECT statement through PHP function mysql_query. The mysqli_fetch_array() or mysql_fetch_array() function is most frequently option. This function returns row as an associative… Read More »

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 »