codeigniter populate form from database

Question

In the controller, I have...

function update($id = null)
{
    $this->load->database();

    // more code

    $data = array();
    $data = $this->db->get_where(
            'users',
            array(
            'id' => $id
            )
        );
    $data = $data->result_array();
    $data = $data[0];

    // more code

    $this->load->view('update', $data);
}

In the view, I have...

<h5>Username</h5>
<input type="text" name="username" value="<?php echo set_value('username'); ?>" size="50" />

<h5>Email</h5>
<input type="text" name="email" value="<?php echo set_value('email'); ?>" size="50" />

<h5>Email Confirmation</h5>
<input type="text" name="emailconf" value="<?php echo set_value('emailconf'); ?>" size="50" />

<h5>Password</h5>
<input type="text" name="password" value="<?php echo set_value('password'); ?>" size="50" />

<h5>Password Confirmation</h5>
<input type="text" name="passconf" value="<?php echo set_value('passconf'); ?>" size="50" />

set_value() isn't reading $data

search for value=""

at http://codeigniter.com/forums/viewthread/103837/

The poster uses only the set_value() function between "" in value="".

I'm wondering how to do the same, but I can't get it to work. Help?

Why are you pulling data in the controller instead of the model? — eyelidlessness
– eyelidlessness, Commented Nov 29, 2009 at 20:39

user137621 · Accepted Answer · 2010-04-06 17:10:49Z

21

set_value requires 2 parameters. field name AND value.

You need:

value="<?php echo set_value('username', $username); ?>"

assuming that you are passing $data['username'] etc.

answered Apr 6, 2010 at 17:10

user137621

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

2 Comments

Stewie Over a year ago

This is the correct answer. It takes care of the case of prepopulating the form from the database + populating form validation user input

UserBSS1 Over a year ago

Its correct, but one more thing will save you tons of time if you replace your System/helpers/set_value code like suggested here codeigniter.com/forums/viewthread/159535/#775628 to avoid problems when repopulating form again when rule doesnt exist.

hydrogen · Accepted Answer · 2012-12-18 00:42:07Z

4

I think you are not passing the value correctly to the view.

In the Controller put:

$data = $this->db->get_where(
        'users',
        array(
        'id' => $id
        )
    );
$data = $data->result_array();

$data['result'] = $data[0];

then inside the view:

<h5>Password Confirmation</h5> <input type="text" name="passconf" value="<?php echo $result['passconf']; ?>" size="50" />

edited Dec 18, 2012 at 0:42

hydrogen

2,87622 silver badges20 bronze badges

answered May 26, 2009 at 23:00

Pedro

2,9277 gold badges34 silver badges47 bronze badges

Comments

user106197 · Accepted Answer · 2009-05-28 08:14:39Z

3

Try this:

Controller:

$data = array();
$data = $this->db->get_where(
        'users',
        array(
        'id' => $id
        )
    );
$data = $data->result_array();
$data['view_username'] = $data['username'];

Instead of using $date[0], I use the column name, but that's your decision

View:

<h5>Username</h5> <input type="text" name="username" value="<?=$view_username?>" size="50"/>

<?= => is PHP short tag, read about it in the codeigniter user guide

Regards,

Sylvio

answered May 28, 2009 at 8:14

user106197

Comments

markd · Accepted Answer · 2011-01-20 07:23:59Z

1

set_value() is designed to work with CI form validation.

When the form is first loaded, set_value() can fill the field with a default value using its second parameter. After the form is submitted, you can display the form again and the field will be filled with the value that was submitted providing it was checked for validation.

See also http://codeigniter.com/forums/viewthread/96617/ - there are a few gotchas with set_value() that the docs don't clarify.

Applicable up to CI 1.7.3 so far.

answered Jan 20, 2011 at 7:23

markd

1,52614 silver badges14 bronze badges

Comments

stealthyninja · Accepted Answer · 2012-02-04 14:38:05Z

-1

Try to assign default values to $_POST variable in your controller, e.g. $_POST['email'] = 'email';

edited Feb 4, 2012 at 14:38

stealthyninja

10.4k11 gold badges57 silver badges61 bronze badges

answered Mar 8, 2011 at 17:40

fcai

11

1 Comment

Rid Iculous Over a year ago

You can't set any $_POST values.

Collectives™ on Stack Overflow

codeigniter populate form from database

5 Answers 5

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related