HOW TO SOLVE MYSQL GROUP BY ISSUE ?

HOW TO SOLVE MYSQL GROUP BY ISSUE ?

If you face this kind of problem..Mysql Error 1055.. How to solve this

I solved this issue in two ways –

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

Answer: First access in your database with mysql root user. Then run the following query-

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Solution 2: Updating the Mysql query

Answer: To solve this issue permanently you have to update your query.

Update all group column by primary key of a table and Set multiple group by if there is any column which is not functionally dependent on columns in GROUP BY clause

->group_by('b.product_info_id')
->group_by('c.product_title_id')
->group_by('e.id')

Easy Codeigniter Installer – Install Made Easy

Easy Codeigniter Installer – Install Made Easy

Easy Code-igniter Installer is the really wonderful solution to install Code-igniter Application, Using Easy Code-igniter  installer you can install any types of code igniter application without any hassle.You do not need to look at coding but easy to install. This is compatible with code igniter Version 2.x and 3.x . You can complete all installation process within 1/2 minutes.

Please Look at Online Documentation

Documentation

Main Features:

  1. 4 easy steps to install application
  2. Check server requirements, directories permissions
  3. Automatically creating database
  4. Secure from XSS, CSRF and SQL Injection
  5. PSR Standard Coding
  6. Code-igniter Version 2.x & 3.x Supported
  7. Fresh and Clean Code
  8. Well Documentation
  9. Initial Login information setup
  10. Modern and Responsive Design

How to remove index.php from Codeigniter Url

Do you want to remove index.php from codeigniter url?

I am telling you the way how can you do it..

Open config.php and do following replaces

$config['index_page'] = "index.php"

to

$config['index_page'] = ""

In some cases the default setting for uri_protocol does not work properly. Just replace

$config['uri_protocol'] ="AUTO"

by

$config['uri_protocol'] = "REQUEST_URI"

.htaccess

Please update your .htaccess file-

RewriteEngine on
RewriteCond $1 !^(index\.php|resources|robots\.txt)
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L,QSA] 

How to count data from multiple table in a single query

As a developer, We need to count rows  from multiple table in a single query.

In this tutorial, I will show you how can you do that –

I am writing it Codeigniter format, but you can use this query in procedural way.


$query = "SELECT (SELECT COUNT(id) FROM table1) AS num1,
(SELECT COUNT(id) FROM table2) AS num2,
(SELECT COUNT(id) FROM table3) AS num3";
$result = $this>db->query($query)->row();

You can also use where condition here to get more necessary info..