How to display sql table fields in codeigniter

Question

I'm trying to display the content of the fields of my "projects" table on the index page but cant seem to get it working. What am I doing wrong here?

Model:

public function prodView() {
            $sql = 'SELECT * FROM projects';
            $query = $this->db->query($sql);
            return $query->result();
}

Controller:

public function index() {
         $this->load->model('main_model');
         $data ['query'] = $this->main_model->prodView(); 
         $this->load_view('/index', $data);
}

View:

<?php foreach($query as $row): ?>
  <tr> 
    <td><?php echo $row->project_name; ?></td>
  </tr>
<?php endforeach; ?>

What is going wrong? What happens when you run the above code? — DFriend
– DFriend, Commented Sep 15, 2016 at 17:55
Try this. Before the foreach line of code add this line var_dump($query); — DFriend
– DFriend, Commented Sep 15, 2016 at 18:01

Farhan · Accepted Answer · 2016-09-15 18:43:16Z

1

Model

public function prodView() {
  $result = array();
  $this->db->select("*")->from("projects");
  $query = $this->db->get();
  if($query->num_rows() > 0){
     $result = $query->result_array();
  }
  return $result;
}

Controller

public function index() {
   $this->load->model('main_model');
   $data ['query'] = $this->main_model->prodView(); 
   $this->load->view('missio/index', $data);
}

View

<?php foreach($query as $row): ?>
  <tr> 
    <td><?php echo $row['project_name']; ?></td>
  </tr>
<?php endforeach; ?>

edited Sep 15, 2016 at 18:43

answered Sep 15, 2016 at 18:00

Farhan

1,4832 gold badges15 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

18 Comments

Farhan Over a year ago

try to print_r($query) or var_dump($query) check is this is empty or not

DFriend Over a year ago

That syntax would OK be if you used return $query->result_array(); But you did not.

Farhan Over a year ago

also check view path $this->load_view('/index', $data); it should be $this->load_view('index', $data); or $this->load_view('FOLDER_NAME/index', $data);

Farhan Over a year ago

@DFriend you are correct my friend but if no result then foreach will not run

Tcmxc Over a year ago

var_dump($query) returned null

|

Collectives™ on Stack Overflow

How to display sql table fields in codeigniter

1 Answer 1

18 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

18 Comments

Your Answer

Sign up or log in

Post as a guest

Related