Easy simple pagination using php and mysql

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

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

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 […]

SQL ORDER BY Clause

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 […]

SQL AND condition

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 […]

SQL OR condition

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

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

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

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 […]

PHPKIDA Offering Free Tools:

INSTA DOWNLOADER

Free online tool to download Instagram videos, photos and save Instagram videos, photos to your device. It's free & easy to use.

Download Now

CURRENCY CONVERTER

Our real time currency converter calculator will convert your money based on current values from around the world. It's free & easy to use.

Convert Now

ROBOST.TXT GEN.

Create robots txt file that help search engines to crawling and indexing your site with help of our free online Robots.txt Generator tool.

Create Now

HTML MINIFIER

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.

Minify Now

CSS MINIFIER

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.

Minify Now

JAVASCRIPT MINIFIER

Free online tool to minify or compress javascript code and reduce the size of javascript code in few clicks. It's free & easy to use.

Minify Now

Sign up for weekly update

Milkshake is almost ready. If you're interested in testing it out, then sign up below to get exclusive access.