Blog

Fix SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the GROUP BY behavior. So in this and future versions GROUP BY would not work in same way as it used to be before.

So to make GROUP BY feature working like before follow these details:

Note: First of all to follow these steps you must need to have root access to your server.

If you want to disable error sql_mode=only_full_group_by  […]

PHP: How to fix Image rotation issue in img tag because of EXIF

Photos captured by some smartphones especially iPhones are automatically rotated when we use it in <img> tag which is mostly not acceptable as we don’t need such unwanted rotation. This happens because of EXIF Data stored in that image. But we can easily fix it using PHP by following these steps:

Or you can also fix it with just one line […]

Best Websites to Learn Programming in Free

https://www.class-central.com
http://www.udacity.com
http://www.freecodeamp.com
https://codecademy.com
https://mva.microsoft.com/
https://github.com/open-source-society/computer-science
https://www.khanacademy.org
https://www.safaribooksonline.com/ ( One Month Free Trial )
http://edx.org
http://coursera.org
http://udemy.com
https://www.skillshare.com/
https://thenewboston.com/videos.php
https://angularfirebase.com/
http://w3schools.com
https://www.airpair.com/
https://egghead.io
http://tutsplus.com
https://www.pluralsight.com/browse/software-development ( 10 Days Free Trial )
https://hackr.io
https://academy.fossbytes.com/
https://www.codeschool.com
http://www.learnvern.com/
http://www.lynda.com (10 Days Free Trial)
https://www.datacamp.com
https://alison.com/
http://programming-motherfucker.com/become.html
https://itpro.tv/PAID

https://www.cbtnuggets.com
https://linuxacademy.comAWS (Amazon Web Services)
https://www.youtube.com/watch?v=BDBvHOaaKHo&list=PLv2a_5pNAko0Mijc6mnv04xeOut443Wnk
https://linuxacademy.com/ (AWS and other cloud solutions )
 […]

How to remove index.php from codeigniter in UBUNTU?

This tutorial will show you that how to remove index.php from codeigniter in UBUNTU or how to enable url rewriting.

Step 1 :

Add this in htaccess file

Step 2 :

Remove index.php in codeigniter config

Step 3 :

Allow overriding htaccess in Apache Configuration (Command)

and edit the file & change to

for www folder

Step 4 :

Enabled apache mod rewrite (Command)

Step 5 :

Restart Apache (Command)

Source […]

Angular.js How to remove hash from url?

Configuration:

.htaccess file in root directory:

In this mode you can use links without the # in HTML files

Link in Browser:

Source: http://stackoverflow.com/questions/16677528/location-switching-between-html5-and-hashbang-mode-link-rewriting […]

How to Change Bootstrap Carousel Slide Speed

The speed cannot be controlled by the API. Though you can modify CSS that is in charge of that. find in the bootstrap.css file:

and change 0.6s to the time you want. You also might want to edit time in the function call below:

.emulateTransitionEnd(2000)

at bootstrap.js in function Carousel.prototype.slide. That synchronize transition and prevent slide to disapear before transition ends.

Source: http://stackoverflow.com/questions/17332431/how-can-i-control-the-speed-that-bootstrap-carousel-slides-in-items/17332516#17332516 […]