Controller:

public function test_email()
{
        $this->email->set_mailtype("html");
 $this->email->from('noreply@w3schools100.in', 'W3Schools100');
 $this->email->to('receiver@gmail.com');
 $this->email->subject('Subject');
     
 $mail_data['subject'] = 'Email Subject';
 $mail_data['description'] = "Email body contents..Here you can use HTML tables to format your data..And use \n to print date in a new line"

 $message = $this->load->view('email_page', $mail_data, true);
 $this->email->message($message);
 $this->email->send();
} 

View: -> email_page.php

<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet"></link>
  <style>
    /* Remove the navbar's default rounded borders and increase the bottom margin */ 
    .navbar {
      margin-bottom: 50px;
      border-radius: 0;
    }
    
    /* Remove the jumbotron's default bottom margin */ 
     .jumbotron {
      margin-bottom: 0;
    }
   
    /* Add a gray background color and some padding to the footer */
    footer {
    background-color: #37454D;
    color:#fff;
      padding: 10px;
    }
  </style>

  <div style="background-color:lightgrey" class="text-center">
  <!-- Give full URL -->
  <img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgx53RKF84Qif07L__NTVulVu26pHAP9ZSK4wrLupufXv_1rhtzzfjJOFA79ZiM-dLoe6HRtY2gFl9v5UkKJ9UlynyLJTwmRlGBG6PfyJH-O4qoYc2xlp5vCTFeUQoTrv2kYDuv6LXovUNZ/s1600/SB100+copy.png" class="img-responsive" alt="StudentsBlog100" title="Studentsblog100"/>
  </div>

<div class="container">    
  <div class="row">
    <div class="col-sm-12">
     <h3 style="font-weight:bold"><?php if(isset($subject)) { echo $subject; }?></h3>
     <p><?php if(isset($description)) { echo $description; }?></p>
    </div>
  </div>
</div>

<footer class="container-fluid text-center">
  © W3schools100
</footer>

codeigniter send email using html template

• codeigniter send email html format
• mail codeigniter 

public function search_items($search_keyword="") {
    $this->db->select('*');
    $this->db->from('items');
    $where = "type = 'Fruit' AND (name LIKE '%$search_keyword%' OR country LIKE '%$search_keyword%')";
    $this->db->where($where);
    $query = $this->db->get();
    if($query->num_rows() > 0) {
        return $query->result();
    }
    return false;
}

Try this and if you have any doubts or any alternative solutions, please comment below. Thank you - W3schools100 Team

Usually while developing any php applications using codeigniter framework, developers used to remove index.php from the codeigniter default url by using .htaccess file. And it will work perfectly in local machine. And after uploading all the codeigniter files in godaddy server, some times it wont work properly and it shows and error "No input file specified." To avoid this type of errors, we have added a htaccess file. Just check it and comment below.

Here we have a solution,

Step 1

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?/$1 [L]

Step 2

$config['index_page'] = '';
$config['uri_protocol'] = 'REQUEST_URI';

---

That's all, now your codeigniter application will run perfectly with godaddy hosting. If you have any queries, please comment below. We will help you as soon as possible.

---

Codeigniter table joining queries are used to join two database tables. Most of the php web developers know to join mysql database tables using core php but not by using codeigniter query builder. So, today we are going to discuss about joining two tables in codeigniter with examples.

Codeigniter table join

Consider two database tables 

1)  students_account - To store students details.

2)  school_list - To store school details.

function test_model($student_id)
{
     $this->db->select('students_account.*,school_list.school_name');
     $this->db->from("students_account");
     $this->db->join('school_list', 'students_account.school_id = school_list.id', 'left');
     $this->db->where("students_account.id",$student_id);
     $query=$this->db->get();
          if($query->num_rows() > 0)
          {
          return $query->result();
          }
     return false;
}

public function test_controller() 
{
     $student_id = 2;
  
     $query = $this->model_name->test_model($student_id);  
          if($query)
          {
               echo "<pre>";
               print_r($query);
               echo "</pre>";
          }
          else
          {
               echo "problem in getting student's details";
          }
 }