CodeIgniter: Populate an input text in the view from data array grabbed from database

Question

This return of print_r($query->result()); would be:

Array ( [0] => stdClass Object ( [guest_name] => Test Name [guest_gender] => Male [guest_nic_pp_dl] => 123456789 ) )

What I need is to pass those values into input text boxes, radio buttons and dropdowns in the view respectilvely.

For example, I need 'guest_name' to be in an input, 'guest_gender' value to be selected on the view, and dropdown value corresponding to 'guest_nic_pp_dl' to be selected on a dropdown (HTML select).

Controller:

function get_customer_details() {
    $guest_name = $this->input->post('guest_name');
    $this->banquet_model->talk_to_new_guest_table($guest_name);
    $this->load->view('/main/banquet_view');
}

Model:

function talk_to_new_guest_table($guest_name) {
    $query = $this->db->query(" SELECT guest_name, guest_gender, guest_nic_pp_dl
                                FROM new_guest 
                                WHERE guest_name LIKE '$guest_name%'
                                LIMIT 1 ");
    if($query->num_rows()>0) {
        return $query->result();
    }
    else {
        return 0;
    }
}

View:

<div class="control-group">   
<label for="guest_name" class="control-label"><i class="icon-user"></i> Name: </label>
    <div class="controls">
        <div class="input-append">
        <input type="text" id="appendedInputButtons" class="span2" name="guest_name" value="<?php echo set_value('guest_name'); ?>">
        <input class="btn" type="submit" name="searchGuest" value="Search">
    </div>
<?php echo form_error('guest_name'); ?>
</div>

I haven't yet. I tried to echo in the view but it didn't work. I need to populate simple text boxes and they are not shown in the above code. For example, <input type="text" id="appendedInputButtons" class="span2" name="sth" > — Madhawa Ratnayake
– Madhawa Ratnayake, Commented Jul 12, 2013 at 4:38

Rajeev Ranjan · Accepted Answer · 2013-07-12 04:42:30Z

2

make some changes in

Controller :

$guest=$this->banquet_model->talk_to_new_guest_table($guest_name);
 //creating data array from returned result
 $data['guest_name']=$guest->guest_name;
 $data['guest_gender']=$guest->guest_gender;
 $data['guest_nic_pp_dl']=$guest->guest_nic_pp_dl;
 //loading view with data
 $this->load->view('/main/banquet_view',$data);

more important all these data array element will be available as variable on view page like

$data['guest_gender'] as $guest_gender

answered Jul 12, 2013 at 4:42

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

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

6 Comments

Madhawa Ratnayake Over a year ago

Oh, wait... Now it returns 3 "Trying to get property of non-object" messages

Rajeev Ranjan Over a year ago

@saucecord on where ? are you using like this <input type="text" id="appendedInputButtons" class="span2" name="guest_name" value="<?php echo $guest_name ?>">

Rajeev Ranjan Over a year ago

@saucecord what is returning 3 and where you are getting "Trying to get property of non-object"...

Madhawa Ratnayake Over a year ago

As soon as I submit, it returns backs to index(); (...which I expected) and gives the error.

Rajeev Ranjan Over a year ago

@saucecord cant help with this info .it is possible that result is returning nothing .

|

broswilli · Accepted Answer · 2013-07-12 11:30:22Z

1

The answers from Rajeev Ranjan and Prasanth are ok but on the line return $query->result(); you can do thisreturn $query->row(); the reason is because the result() returns an array of objects which needs to be iterated while the row() object returns a single object which you can reference without iterating with a loop. I hope this will help

answered Jul 12, 2013 at 11:30

broswilli

3172 silver badges5 bronze badges

Comments

Prasanth · Accepted Answer · 2013-07-12 04:41:56Z

Try something on the lines of:

Controller:

function get_customer_details() {
    $guest_name = $this->input->post('guest_name');
    $data = $this->banquet_model->talk_to_new_guest_table($guest_name);
    if ($data != 0) {
        $this->load->view('/main/banquet_view', $data);
    }
}

Model:

function talk_to_new_guest_table($guest_name) {
    $query = $this->db->query(" SELECT guest_name, guest_gender, guest_nic_pp_dl
                                FROM new_guest 
                                WHERE guest_name LIKE '$guest_name%'
                                LIMIT 1 ");
    if($query->num_rows()>0) {
        return $query->result();
    }
    else {
        return 0;
    }
}

View:

<div class="control-group">   
<label for="guest_name" class="control-label"><i class="icon-user"></i> Name: </label>
    <div class="controls">
        <div class="input-append">
        <input type="text" id="appendedInputButtons" class="span2" name="guest_name" value="<?php echo $guest_name; ?>">
        <input class="btn" type="submit" name="searchGuest" value="Search">
    </div>
<?php echo form_error('guest_name'); ?>
</div>

Collectives™ on Stack Overflow

CodeIgniter: Populate an input text in the view from data array grabbed from database

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest