Press enter to see results or esc to cancel.

Simple PHP MySQL Pagination Script

Pagination is a frequent requirement part for listing large number records from the database. In this post we will see how to implement pagination for your web development projects.

Continue reading
Alternative for Common Table Expressions (CTE) using PHP & MySQL
  

Alternative for Common Table Expressions (CTE) using PHP & MySQL

In Relational database storing tree data is a common problem. Generally table represent as rows and columns. It is not suitable for represent tree data. Multiple solutions are available to store tree data in the database.  In this articles, we'll explore tree (hierarchical) data using Adjacency List Model approach in PHP & MySQL.

Continue reading
PHP MySQLi CRUD PART - 2
  

PHP MySQLi CRUD PART - 2

Hi all! In previous tutorial how to creating a connection, creating a database, creating a table. In this tutorial I have to share how to insert, read, update and delete a row from a table. Deleting a table and database.

Continue reading
PHP MySQLi CRUD PART - 1
  

PHP MySQLi CRUD PART - 1

Hi all, For dynamic website, web application MySQLi play an imporant role. The term MySQLi means MySQL Improved. MySQLi work with MySQL version 4.1.13 or newer and PHP version 5.0.0. Today I will share how to connect databases using PHP MySQLi.

Continue reading

50 Popular PHP Frameworks: Developing Website and Web Application

I've share 50 Popular PHP Framework for developing website and web application. They are 81.2% of websites using PHP as server-side programming languages. Because of, PHP is faster and easy develop a website and web application. The following diagram shows the position of PHP in terms of popular server-side programming languages.

Continue reading