CodeIgniter - 登录后登录系统在数据库中显示数据

Question

i made a login system in codeigniter, now i want to view the data from database after login user see for this i make one model but still confused what to do now, i m new in codeigniter.

This is model i make

<?php
Class Newsletter extends CI_Model
{
 function newsdata($name, $email, $city)
 {
   $this -> db -> select('id, name, email, city');
   $this -> db -> from('newsletter');
   $this -> db -> where('name', $name);
   $this -> db -> where('city', $city);
   $this -> db -> where('email', $email);
   $query = $this -> db -> get();

   foreach($query as $row)
{
print $row ->id;
print $row ->name;
print $row ->email;
print $row ->city;
print "<br>";
}

   }
 }
?>

and in view i make a file with name of home_view.php and there i use this

<?php $this->load->model('newsletter'); ?>

if any one guide me please how can i solve this.

Answer 1

Ok change your model name to newsletter_model. Now in your Controller:

<?php
Class Newsletter extends CI_Model
{
  function newsdata($name, $email, $city)
 {
    $this->load->model('newsletter_model');
    $data['result'] = $this->newsletter_model->getdetails($name, $email, $city);
    $this->load->view("home_view", $data);   
 }
}
?>

Now in your Model:

<?php 
    Class Newsletter_model extends CI_Model {

       function getdetails($name, $email, $city){
        $this -> db -> select('id, name, email, city');
        $this -> db -> from('newsletter');
        $this -> db -> where('name', $name);
        $this -> db -> where('city', $city);
        $this -> db -> where('email', $email);
        $query = $this -> db -> get();
        return $query->result();
    }
 }
 ?>

Now on your view page:

 <?php
    foreach($result as $row)
    {
      echo $row ->id;
      echo $row ->name;
      echo $row ->email;
      echo $row ->city;
      echo "<br>";
    }
 ?>