Google SMTP Server – How to Send Emails for Free

To use Gmail’s SMTP server, you will need the following settings for your outgoing emails:

  • Outgoing Mail (SMTP) Server: smtp.gmail.com
  • Use Authentication: Yes
  • Use Secure Connection: Yes (TLS or SSL depending on your mail client/website SMTP plugin)
  • Username: your Gmail account (e.g. user@gmail.com)
  • Password: your Gmail password
  • Port: 465 (SSL required) or 587 (TLS required)
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 download whole folder from google drive

Do you want to download full folder from google drive? In this article, I will show you how to do that.

Just follow the step.

  1.   At first login to your google drive account.
  2. Just select your folder which you want to download, But don’t open it.
  3. As like the above photo, click your the more option from top menu
  4. You will find a download menu and click it..
  5. Then your files will be zipped and starting download automatically

How to download a shared file with my account?

  1. From your account sidebar, you will discover “Shared with me” menu.Click there and enter this menu.
  2. You will find all files and folder which is shared with you.
  3. Choose one and download it from more option as like above instruction

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

Don’t be afraid to say “no”

Saying no is hard, especially if you’re like me—you’re generous and want people to feel happy working with you. You don’t want to disappoint anyone, so you offer to help any way you can, not really considering the strenuous load it’ll put on you.

No matter what you do, you’ll disappoint someone. Whether it be the client because you’re unable to deliver halfway through the project, your family because you’re working long hours, or yourself because you’re so stressed with the work you’ve chosen to take on. So you must get comfortable with turning down work if it’s ultimately not for you or your availability. To help determine if you should take on a project, ask yourself these questions:

  • Do I specialize in the work that’s needed by this client?
  • Why am I taking this project on? Is it a commitment I should be making?
  • Why am I adding that project onto my plate?

The worst thing about taking on everything that comes your way is that your plate may end up full, but with all of the wrong commitments. You’re stressed, anxious, and the worst part, now you’re left with no room to take on that golden opportunity. You can’t say yes to your ideal client if you never say no to the wrong ones.

Next time you get a project, don’t just reply with a yes. Really consider the opportunity, ask yourself those questions above, and proceed with a conscious decision for your future and well being.