We use database in our every application whether it is web app or mobile app. Database is using in every application and in every industry to store and retrieve the database. Both database is having their own specialty in terms of storage and their storage engine. Now let's understand the[...]
There are many situation where you will need to dynamic dropdown like you have a dropdown which contains countries name and you have to find all state of that selected country in select box or drop down. Here we are going to tell you how to make dynamic select box[...]
PDO(PHP Data Objects) is a PHP extension to PHP's database connections. As we all know that in PHP 5.5 MySQL is deprecated. So we have to move new extensions (PDO) for database connection. In this below tutorial, I’ll show you how to connect to MySQL database using PDO class. Please[...]
CodeIgniter is one of the most popular PHP frameworks. CRUD is one of the primary functions of a Database Management System. CRUD stands for "Create, Read, Update and Delete". Creating a CRUD grid is a very common thing today. In SQL, it represents INSERT, SELECT, UPDATE, and DELETE commands. In[...]
This tutorial will show you different MySQL Data Types in mysql database. Understanding of mysql data types help us to optimize database. The MySQL uses 3 categories of data type for optimization of database. Developers are expected to be realistic in using data types and don't overuse anything inside the[...]
Note: I am updating this tutorial frequently when I see any new tips to speed up the MySQL query. So please bookmark this article for future use. These are the following tips given below: (1) Always use persistent database connection to avoid connection overhead. By using persistent database connection,[...]
This tutorial will explain about making Pagination in PHP and MySql. Pagination technique is very important in Web Application where users need to display more content on one page. So using this Pagination technique we will divide the content into multiple pages and display all those content pages wise. We[...]
This tutorial will explain about downloading the mysql data into excel sheet format using PHP mysql. Here we will select all the data as per our mysql query and generate a excel file according to that data and we can set a selected column name as the excel sheet header.[...]
This tutorial describes an auto-complete search in PHP, Mysql, JSON. Autocomplete search is very important in present Web Technology. This is very similar to Facebook or Google-like Autosuggestion box, autocomplete search box, or auto search box. Autocomplete search means that when users enter any keyword in the text field then[...]
All the fetching function is used to fetch data from mysql database. But its data representation and use can be different. No need to confuse while using this function. Programmer can used any of the fetching function below. For best understanding, refer this table Different type of fetching function is[...]
