Simple login and account management module using PHP & MySQL. Using this module we have to perform login with session management, adding new user, edit & delete user. click here to download source code 1. Creating Database & Table Create a database in MySQL. For example, I’ve create database “account” for more details for creating […]

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 requirements for Pagination […]

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. Adjacency list […]

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 ( column_name1, […]

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, Opening Database Connection Closing […]

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. Here I’ve list 50 […]