Databases

MongoDB for PHP Developers – A Beginner’s Guide

Introduction If you want to create a website using MongoDB and PHP, this article will help you to: Connect to a MongoDB database Save documents in a collection Query documents in a collection Perform range queries Sort documents, update a document, delete one or more documents from a collection What…

Read More

March 15th, 2017 Amazon Linux, Articles, CentOS, Codeigniter, Databases, Linux, MongoDB, MySQL, PHP, Tutorials, Ubuntu

Things you must know before MySQL Interview

What are the HEAP tables in MySQL ? HEAP tables also known as  Memory tables are tables taht present in the memory. When creating a HEAP table in MySql, we needs to specify the TYPE of table as HEAP. These memory tables  have values without data type like “BLOB” or…

Read More

February 16th, 2017 Interview, MySQL, PHP, Tutorials

Installing a LAMP Web Server on Amazon Linux Web Server

To install and start the LAMP web server on Amazon Linux Connect to your instance. To ensure that all of your software packages are up to date, perform a quick software update on your instance. This process may take a few minutes, but it is important to make sure you…

Read More

January 25th, 2017 Amazon EC2, Amazon Linux, Articles, CentOS, Databases, Linux, MySQL, PHP, Tutorials, Ubuntu

Solved – Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the way GROUP BY behaved in order to be SQL99 compliant (where in previous versions it was not). There is a good overview of the changes here. Unfortunately, this affects some core queries that Craft uses when fetching elements. The good news is that this has been…

Read More

January 19th, 2017 Amazon EC2, Databases, Linux, MySQL, PHP, SolveIt, Tutorials, Ubuntu

The most useful and bestseller courses on Udemy you should consider

The Complete Web Developer Course 2.0 Learn By Doing – build 25 websites and real mobile apps using HTML, CSS, Javascript, PHP, Python, MySQL and a lot more. It’s most current, in-depth and exciting coding course—to date. Designed for you—no matter where you are in your coding journey—this next-generation web…

Read More

November 29th, 2016 Articles, Interview, Javascript, jQuery, Linux, MySQL, Node.js, PHP, SEO, Wordpress

How to use Database Transactions in Codeigniter ?

In order to use transactions in your database queries. You need to use Codeigniter’s transaction methods provided by db library of Codeigniter. The basic snippet is as follows: $this->db->trans_start(); # Starting Transaction //Do your Stuff Here i.e. Queries you wants to run on database $this->db->trans_complete(); # Completing transaction if($this->db->trans_status() ===…

Read More

August 4th, 2016 Codeigniter, Databases, Interview, PHP

Reset the MySQL Root Password to fix Access denied for user ‘root’@’localhost’

Stop the current MySQL server instance: sudo service mysql stop. Use dpkg to re-run the configuration process that MySQL goes through on first installation. You will again be asked to set a root password. sudo dpkg-reconfigure mysql-server-5.5 or whatever your mysql-server version. Then start MySQL: sudo service mysql start.

June 23rd, 2016 MySQL

World’s Countries, States and Cities database

There are many Database providers which are charging us for providing the Databases of various types. One of them is very important and useful database is for world’s all countries,State and Cities. Every time when we plan to create a website then we stuck on one point that is how…

Read More

March 26th, 2016 Codeigniter, Databases, MySQL, PHP, SEO

Simple and better ways to optimize MySQL query

MySQL  is very popular choice for database management systems. Which uses the SQL querying language to input and query data. Although SQL queries are simple commands that are very easy to learn and use, but not all queries and MySQL database functions operate with the same efficiency. This becomes very…

Read More

January 13th, 2016 MySQL, PHP

Array vs Object when returning data

Prefer Using Objects when returning large amount of data When returning large data, it can be obvious to use Arrays. But Arrays make poor object-to-object data transfer mechanisms in object-oriented programming. Objects are main focus of  Object-oriented programming and it should be. This means that each array should be converted…

Read More

January 4th, 2016 Codeigniter, Javascript, jQuery, MySQL, PHP

Methods of Fetching contents of a URL in PHP

If you want to retrieve the contents of a URL. For example, you want to include part of one site in another site’s content. PHP provides function file_get_contents() to get the contents through GET method from URL. $page = file_get_contents(‘http://www.example.com/robots.txt’); Or you can use the cURL extension: $c = curl_init(‘http://www.example.com/robots.txt’);…

Read More

December 18th, 2015 MySQL, PHP

Profiling Codeigniter website to get database queries count and optimize website speed

Clients often complains that their website speed is slow. One of the most common reason was a large number of database queries that get executed for every single page, sometimes more than thousand queries for a single page. In this article, I will explain how to figure out whether the…

Read More

December 16th, 2015 Codeigniter, MySQL, PHP