CODEWITHSUNDEEP
phpmysqlcodeigniter
Stacy J
Stacy J

Reputation: 2781

how to display content from database in codeigniter without calling controller from view?

I am new to codeigniter. I followed a video tutorial and successfully created a login registration system. After registration or login the users reach a page called members.php.

members.php is a view.

my controller is main.php and model is model-users.php.

I want members.php to show/have content from the database so that the users can read it once the login or register?

I followed a few resources on the web that said not to call controller from view. How can I accomplice the above without doing so?

Thanks

Upvotes: 2

Views: 49358

Answers (5)

Samir Jana
Samir Jana

Reputation: 1

At first connect the database in your project file and connect the model page in your view page and try this code. Go to the view page and try this code

View

20
21
<?php
	$get_data=$this->MyModel->get_table_data();
?>
<table class="table table-bordered">
	<thead>
		<tr>
			<th> Name </th>
			<th> Email </th>
			<th> Phone No </th>
		</tr>
	</thead>
	<tbody>
	<?php foreach($get_data as $val){ ?>
		<tr>
			<td><?php echo $val->name; ?></td>
			<td><?php echo $val->email; ?></td>
			<td><?php echo $val->phone; ?></td>
		</tr>
	<?php } ?>
	</tbody>
</table>

Model

public function get_table_data(){ $qry=$this->db->select('*')->from('Table Name')->get()->result(); return $qry; }

Upvotes: 0

Vince Osana
Vince Osana

Reputation: 417

here is the example of my codes:

views:

                <?php foreach($ecms as $i){ ?>
                    <tr>
                    <td><?php echo $i->accnum; ?></td>
                    <td><?php echo $i->crdnum; ?></td>
                    <td><?php echo $i->fname; ?></td>
                    <td><?php echo $i->bday; ?></td>
                </tr>
            <?php } ?>

model:

function masterHide()

{
    $sql =" select * from ecms";
    $query = $this->db->query($sql);
    return($query->num_rows() > 0) ? $query->result(): NULL;
}

controller:

    function search() {

//  $this->MasterListAccess();
    $this->load->model('navi_model');
    $query = $this->navi_model->masterHide();
    //check results or returned value of model
    //print_r($query);
    $data['ecms'] = $query;
    $data['main_content'] = 'search';
    $this->load->view('includes/template',$data);
}

Upvotes: 0

Tommy Adey
Tommy Adey

Reputation: 816

I think i know what you mean, this is definitely not the right way to go about this but if you really must you could call a model from a view like this.
In the view

<div>

    <?php 
    #You could load the model here or autoload it in config->autoload->models(i believe)
    $data = $this->model_name->model_function();?>
    foreach($data as $row): 
           echo '<pre>';
           print_r($row);
           echo '</pre>';
    endforeach; 
    ?>

</div>

Upvotes: 1

Jezen Thomas
Jezen Thomas

Reputation: 13800

I think the CodeIgniter documentation is actually very clear, and very easy to follow. Nevertheless, here's an example of how you might structure your app.

Controller:

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

class Members extends CI_Controller {
    function __construct() {
        parent::__construct();

        $this->load->model('members_model');
    }

    function index() {
        $data['members'] = $this->members_model->get_members();

        $this->load->view('header', $data);
        $this->load->view('members');
        $this->load->view('footer');
    }
}

Model:

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

class Members_model extends CI_Model {

    function get_members() {
        $query = $this->db->get('members');
        return $query->result_array();
    }
}

View:

<?php

print_r($members);

To access the above page, you would visit http://yoursite.com/index.php/members.

You can use a .htaccess file to remove the index.php segment from the URI. The index() method is automatically called when you run a controller.

Upvotes: 10

Erman Belegu
Erman Belegu

Reputation: 4079

I don't have any example of the code, but I write one simple example of HTML when you can show name and surname of members. Controller:

function members(){
  $members = $this->model-user->get_list(); //array of members
  $this->load->view('members.php', $members); // load members in view
}

View members.php

<html>
<body>
    <table>
      <tr>
        <th>Name</th>
        <th>Surname</th>
      </tr>
      <?php foreach($members as $m): ?>
      <tr>
        <tr><?php echo $m['name']; ?>
        <tr><?php echo $m['surname']; ?>
      </tr>
      <?php endforeach; ?>
    <table>
</body>
</html>

Model:

function get_list() {
   // query in database
   return $query = $this->db->get('members'); //table name members
}

This is the simple example in a short form. I hope that you will understand it.

Upvotes: 1

Related Questions