Need help to fetch data from database in php codeigntier

Question

I am trying to build a project in php codeigniter. But I'm stuck to fetch data from database.

I'm using mysql, codeigniter-3.1.10 & php-7.0.33.

Database config file:

    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => '221b',
    'database' => 'car',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

My model is

if (defined('BASEPATH') OR exit ('No direct script access allowed'));
    class Homepage_model extends CI_Model{
        public $result;
        public $rs;

        public function __construct(){
            parent::__construct();
            $this->load->database();

        }

        public function get_data($slug = FALSE){
            if ($slug === FALSE) {
                $query = $this->db->get('cars');
                return $query->result_array();
            }

            $query = $this->db->get_where('cars', array('status' => "Available"));
            return $query->row_array();
        }
    }

In model file I want to fetch all data from the table cars when the value of database field "status" is 'Available'. Controller file:

defined('BASEPATH') OR exit('No direct script access allowed');

class Homepage extends CI_Controller{
    public function __construct(){
        parent::__construct();
    }
    public function index(){
        $this->load->model('Homepage_model');
        $rs = $this->Homepage_model->get_data();
        $this->load->view('homepage_view', $rs);

    }
}

and my view portion where I'm going to show the data is:

                foreach($rs as $rws){
                    //echo $rws['car_id'];

            ?>
                <li>
                    <?php echo $rws['car_id'];?>
                    <a href="book_car.php?id=<?php echo $rws['car_id'] ?>">
                        <img class="thumb" src="cars/<?php echo $rws['image'];?>" width="300" height="200">
                    </a>
                    <span class="price"><?php echo 'Kshs.'.$rws['hire_cost'];?></span>
                    <div class="property_details">
                        <h1>
                            <a href="book_car.php?id=<?php echo $rws['car_id'] ?>"><?php echo 'Car Make>'.$rws['car_type'];?></a>
                        </h1>
                        <h2>Car Name/Model: <span class="property_size"><?php echo $rws['car_name'];?></span></h2>
                    </div>
                </li>
            <?php
                }
            ?>

I've done this. But when I browse the webpage none of this data is show.Please help to solve this.

in get_data you are not passing slug param, so second result will return and that result is an row_array` so you cant use it in foreach so return result_array() instead of row_array() — Devsi Odedra
– Devsi Odedra, Commented Jun 10, 2019 at 4:30
I've changed the row_array() as result_array(), but nothing happened. — Sharif
– Sharif, Commented Jun 10, 2019 at 4:39

M Ikram Zafar · Accepted Answer · 2019-06-10 07:14:13Z

1

In Your Controller Function pass $data Variable like $this->load->view('homepage_view', $data);

public function index(){
    $this->load->model('Homepage_model');
    $result = $this->Homepage_model->get_data();
    $data['rs'] =  $result; 
    $this->load->view('homepage_view', $data);
}

answered Jun 10, 2019 at 7:14

M Ikram Zafar

1501 gold badge3 silver badges13 bronze badges

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

1 Comment

M Ikram Zafar Over a year ago

Now the $rs variable will be available on view file

Ghanshyam Nakiya · Accepted Answer · 2019-06-10 04:39:18Z

0

Here is changed in query

$query = $this->db->get_where('cars', array('status' => "Available"))->result_array();
return $query;

answered Jun 10, 2019 at 4:39

Ghanshyam Nakiya

1,71221 silver badges24 bronze badges

Comments

Danish Ali · Accepted Answer · 2019-06-10 04:51:38Z

0

Just change $row_array() with $result_array()

return $this->db->get_where('cars', array('status' => "Available"))->result_array();

row_array() is used to fetch only one while $result_array() all records in the form of an associative array

Read more about row array and result array

answered Jun 10, 2019 at 4:51

Danish Ali

2,3513 gold badges18 silver badges26 bronze badges

Comments

halfer · Accepted Answer · 2019-06-16 17:33:09Z

0

In Model

public function get_data($slug = FALSE){
    if ($slug === FALSE) {
        $query = $this->db->get('cars');
        return $query->result_array();
    }

    $query = $this->db->get_where('cars', array('status' => "Available"));
    $result = $query->result_array(); # change
    return $result; # change
}

In Controller

public function index(){
    $this->load->model('Homepage_model');
    $result = $this->Homepage_model->get_data();
    $data['rs'] =  $result; # or  $data['rs']  = $this->Homepage_model->get_data(); assign directly 
    $this->load->view('homepage_view', $rs);
}

And In View foreach($rs as $rws){ will works

Make sure the table is not empty.

edited Jun 16, 2019 at 17:33

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Jun 10, 2019 at 4:50

Abdulla Nilam

39.6k18 gold badges85 silver badges114 bronze badges

4 Comments

Sharif Over a year ago

in controller if I write this $this->load->view('homepage_view', $rs); this gives me an error "Undefined variable: rs" and if I write this $this->load->view('homepage_view', $data['rs']); this is shown nothing.

Abdulla Nilam Over a year ago

@Sharif use as i posted $result = $this->Homepage_model->get_data(); $data['rs'] = $result;

Sharif Over a year ago

I did as you said. But this happens "Message: Undefined variable: rs"

halfer Over a year ago

Abdulla, please try to refrain from using quote/citation formatting, unless the material you are presenting is a quote. Thanks!

Collectives™ on Stack Overflow

Need help to fetch data from database in php codeigntier

4 Answers 4

1 Comment

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related