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 most popular PHP framework. CRUD is one of the primary functions of a Database Management System. CRUD stands for "Create, Read, Update and Delete". Creating CRUD grid is a very common thing of today. In SQL, it represents INSERT, SELECT, UPDATE and DELETE commands. In that[...]
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 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, you[...]
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 about auto complete search in PHP, Mysql, Json. Auto complete 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. Auto complete search means that when user enter any keyword in[...]
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[...]
