Pagination is simply a process of dividing your output contents in small modules and displaying them on different pages. For example,you can see Google search results where 10 to 15 search results are shown per page. Pagination make output more user friendly. Database Connectivity CODE <?php ob_start(); session_start(); $con=mysqli_connect(“localhost”,”root”,””) or die(mysqli_error()); mysqli_select_db($con,”practice”) or die(mysqli_error($con)); ?> […]
What is the Difference between GROUP and ORDER BY The GROUP and ORDER BY clauses are both used to organize data. But if we are talking about the difference between GROUP and ORDER BY clauses. So we can say : The ORDER BY clause’s use to sort the query result by specific columns. The GROUP […]
How to use of limit clause in mysql with php script We can retrieve limited rows from the mysql table using the LIMIT clause. I can be used in pagination where are forced to show only limited records like 10, 20, 30, 40 etc. You can use syntax of LIMIT into PHP function mysql_query().This function […]
We have already seen SQL SELECT command to fetch data from MySQL table. When you select rows, the MySQL server is free to return them in any order, If you want result in sort form you can sort a result set by adding an ORDER BY clause that names the column or columns you want […]
The SQL AND condition is used in a SQL query to create a SQL statement where records are fetching. It can be used in a SELECT statement, INSERT statement, UPDATE statement or DELETE statement. The SQL AND condition requires that both of conditions should be true. Let’s see the syntax of AND condition in select […]
The SQL OR condition is used in a SQL query to create a SQL statement where records are fetching. It can be used in a SELECT statement, INSERT statement, UPDATE statement or DELETE statement. The SQL OR condition requires that one of them conditions should be true. Let’s see the syntax of OR condition in […]
MySQL WHERE Clause We have seen SQL SELECT command to fetch data from MySQL table, UPDATE command for update data into mysql table, DELETE data from mysql table. We can use a conditional clause called WHERE clause to filter out results. Using WHERE clause, we can specify a selection criteria to select required records from […]
Difference between DROP and TRUNCATE statement When you use the drop statement it deletes the table’s row together with the table’s definition so all the relationships of that table with other tables will no longer be valid. When you drop a table: 1. Table structure will be dropped 2. Relationship will be dropped 3. Integrity […]
Difference between delete and truncate statements There is a slight difference b/w delete and truncate statement. The DELETE statement only deletes the rows from the table based on the condition defined by WHERE clause or delete all the rows from the table when condition is not specified. But it does not free the space containing […]
Free online tool to download Instagram videos, photos and save Instagram videos, photos to your device. It's free & easy to use.
Our real time currency converter calculator will convert your money based on current values from around the world. It's free & easy to use.
Create robots txt file that help search engines to crawling and indexing your site with help of our free online Robots.txt Generator tool.
Free online tool to minify or compress html code and reduce the size of html code in few clicks. It's free & easy to use.
Free online tool to minify or compress css code and reduce the size of css code in few clicks. It's free & easy to use.