Display database table in CodeIgniter

Question

I am trying to display a table using CodeIgniter. I made a function to select all data from one table and display it using a foreach loop when the button is clicked. I am getting this error:

Fatal error: Call to undefined method CI_DB_mysql_driver::result() in C:\Xampp\htdocs\Auction\application\models\bidding_model.php on line 47

This is my controller page:

public function viewauction()
{
    $this->load->model('bidding_model');
    $data['query'] = $this->bidding_model->viewauction();   
    $this->load->view('auction_view', $data);
}

This is the model:

function viewauction()
{
    $query =  $this->db->select('products'); 
    return $query->result();
}

This is the view:

<tbody>
<?php foreach($query as $row): ?>
<tr>   
    <td><?php echo $row->product_id; ?></td>
    <td><?php echo $row->auction_id; ?></td>
    <td><?php echo $row->start_time; ?></td>
    <td><?php echo $row->end_time; ?></td>
</tr>
<?php endforeach; ?>
</tbody>

Madan Sapkota · Accepted Answer · 2013-02-25 03:20:08Z

3

Just change your model method code to

function viewauction()
{
    $query = $this->db->select('*')->from('products')->get();
    return $query->result();
}

Hope this helps. Thanks!!

answered Feb 25, 2013 at 3:20

Madan Sapkota

26.2k11 gold badges116 silver badges118 bronze badges

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

Comments

tomexsans · Accepted Answer · 2013-02-25 00:53:18Z

0

you have to use get()

select() query builder is used for selecting the columns of the table and not the table

example

$query = $this->db->select(array('product_id','auction_id'))
                  ->get('products');
return $query->result();

if you want to select all you can use the get only,

read more at http://ellislab.com/codeigniter/user-guide/database/active_record.html#select

answered Feb 25, 2013 at 0:53

tomexsans

4,5374 gold badges37 silver badges49 bronze badges

Comments

xitas · Accepted Answer · 2014-05-09 11:18:53Z

0

Your problem is here:

$query =  $this->db->select('products'); 
return $query->result() ;

$query->result() is returning false probably because the products table does not exist. you have to use get instead of select.

Try:

$query =  $this->db->get('products'); 
return $query->result() ;

That could get your started

edited May 9, 2014 at 11:18

xitas

1,1623 gold badges23 silver badges49 bronze badges

answered Feb 25, 2013 at 5:20

Steward Godwin Jornsen

1,1791 gold badge7 silver badges13 bronze badges

Comments

joan16v · Accepted Answer · 2016-11-24 11:52:04Z

0

public function select($table, $field, $value)
{
    $this->db->select(*);
    $this->db->from('$table');
    $this->db->where($field, $value);
    $query = $this->db->get();

    return $query;
}

I hope the above code will help you.

edited Nov 24, 2016 at 11:52

joan16v

5,1374 gold badges51 silver badges50 bronze badges

answered Nov 24, 2016 at 11:31

sonu sharma

511 silver badge1 bronze badge

Comments

Viral · Accepted Answer · 2016-11-24 12:31:27Z

There is actually a simpler way available.

You should get most from the framework features it is providing,

Use, CodeIgniter's Table Library,

$this->load->library('table'); // Loading the Table Library 

$query = $this->db->get('table_name'); // the MySQL table name to generate HTML table

echo $this->table->generate($query); // Render of your HTML table

You can also modify the behavior of HTML generator if you want some custom things like class in table head or body or anything, which you will almost need.

$this->table->set_template($template); // passing an array

Use this line after loading the table library. Use keys from the documentation link below.

Reference: CodeIgniter 3 Table Library - Official Docs

Rakesh Kumar Sharma · Accepted Answer · 2017-11-13 10:07:05Z

0

function viewauction()
{
    $this->db->select('*'); 
    $this->db->from('tablename');
    $query = $this->db->get();
    return $query->result();
}

Above code will help you.

edited Nov 13, 2017 at 10:07

answered Nov 13, 2017 at 10:03

Rakesh Kumar Sharma

13 bronze badges

Collectives™ on Stack Overflow

Display database table in CodeIgniter

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related