Mysql PDO Connection and Create Mysql Table With PDO

PDO stand for 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 bellows tutorial, I will show you how to connect to MySQL database using PDO class. Please follow bellows steps for connect a database using PDO. We just create bellows code for create database connection using PDO. [...]

Simple Mysql CRUD Operation in CodeIgniter with Example

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 example we saw the basics of how CodeIgniter works and the basics of the MVC pattern. Now I am going to demonstrate the basic installation of CodeIgniter, a PHP Framework, and a simple example of building a CRUD with it. [...]

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 MySQL database or fields within it. Follow given Various Data Types in MySQL and corresponding uses. [...]

Tips to write an efficient and fast Mysql Query

This tutorial will explain about to write an efficient and fast Mysql Query. These days there is big challenge for web developer or database administrator to speed up the Mysql query. If you do not write an efficient and fast Mysql Query, it will increase your query loading time. When you have more data in your table and you need to fetch data from that table then must use efficient query to speed up your query process time. [...]

Different type of Fetching Function in Mysql

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