Latest Posts From Mysql

MongoDB Design and its architecture – a detailed explanation

MongoDB is an open-source database that uses a document-oriented data model and non-structured query languages to store a high volume of data. Instead of using tables and rows in the database, it makes the best use of collections and documents. The document consists of key-values that are essential for data[...]

11th Dec 2020 Priyanka Patke 0
Differences between SQL and NoSQL databases

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[...]

28th Jun 2020 Abhigyan Singh 0
Dynamic Dependent Select Box using jQuery, Ajax and PHP

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[...]

09th Oct 2016 Abhigyan Singh 0
Mysql PDO Connection and Create Mysql Table With PDO

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[...]

16th May 2016 Abhigyan Singh 0
Simple Mysql CRUD Operation in CodeIgniter with Example

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[...]

14th May 2016 Abhigyan Singh 0
Different types of MySQL Data Types

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[...]

13th Dec 2015 Abhigyan Singh 0
Tips to write an efficient and fast Mysql Query

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,[...]

14th Mar 2015 Abhigyan Singh 0
Download Pagination in PHP and MySql With Example

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[...]

06th Feb 2015 Abhigyan Singh 0
Download Mysql Table Data into Excel Sheet Format in PHP

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.[...]

05th Feb 2015 Abhigyan Singh 0
Autocomplete search in PHP, Mysql, Json with href Link Navigation

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[...]

30th Apr 2014 Abhigyan Singh 0