CodeIgniter form_dropdowns Database

Question

I dont know if my logic is incorrect but I cant get my form_dropdown (down down list) list to populate with data from my database.

The error i get is Undefined property: stdClass::$name.

Code bellow.

My Array in $appertisers when print_r($appertisers);

Array ( [0] => stdClass Object ( [product] => Marinated mixed olives ) [1] => stdClass Object ( [product] => Simons ) [2] => stdClass Object ( [product] => Test ) )

View

            $array = array();
            foreach($appertisers as $row ){
                    $array = $row->name;
            }
            echo form_dropdown('appetisers',  $array);

    ?>

Model

    class Get_data extends CI_Model{
    function getAppertisers(){
        $query = $this->db->query("SELECT product FROM products WHERE cat = 1");
        return $query->result();
    }
}

Controller

public function index()
{
    $this->load->helper('url');
    $data = array();

    $this->load->model("get_data");
    $data['appertisers']  = $this->get_data->getAppertisers();

    $this->load->view('header');
    $this->load->view('content_contact', $data);


}

SeanCannon · Accepted Answer · 2013-03-14 17:05:05Z

5

You need to add the row to the array, and reference the product property since there is no name property. You're currently just reassigning it:

foreach($appertisers as $row ){
    $array[] = $row->product;
}

edited Mar 14, 2013 at 17:05

answered Mar 14, 2013 at 16:59

SeanCannon

78.1k17 gold badges126 silver badges145 bronze badges

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

Comments

user3783388 · Accepted Answer · 2014-06-29 15:06:52Z

0

Your model should be:

class Get_data extends CI_Model
{
    function getAppertisers()
    {
        $this->db->where('cat', 1);
        $query = $this->db->get('products');
        if($query->num_rows() > 0)
        {
            foreach($query->result() as $row)
            {
                $data[] = $row->product;
            }
            return $data;
        }
    }
}

your view:

<?php echo form_dropdown('appertisers', '$appertisers', 'set_value('appetisers')'); ?>

answered Jun 29, 2014 at 15:06

user3783388

11 bronze badge

Collectives™ on Stack Overflow

CodeIgniter form_dropdowns Database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related