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. Consider a student profile database with three columns (Register Number, Name and Class). We will display only 10 records per page. The pre
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
In previous tutorial how to creating a connection, creating a database, creating a table using PHP MySQLi. Click here to view. In this tutorial, I have to share how to Inserting data Reading data Updating data Deleting data Deleting a table Deleting a database Inserting data Syntax for the insert data in to a table. $sql = " INSERT INTO table_name (
For dynamic website, web application MySQL play an important 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 create, read, update and delete (CRUD) data in database using PHP MySQLi. In this tutorial. How to,
I've share 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. PHP Framework can be used for most of the companies for developing website and web application.