Insert in to database using codeigniter

Question

HI

i want to insert data using form in CI but i am facing the problem Here is my model code

function add_form() {
    $this->load->database();
    $id = $this->input->post('id');
    $name = $this->input->post('name');
    $age = $this->input->post('age');       
    $data = array(
       'name' => $this->input->post('name'),
       'age' => $this->input->post('age'),
    );
    $this->db->insert('user',$data);
}

Here is my controller code

function simpleform() {
    $this->load->helper('form');
    $this->load->helper('html');
    $this->load->model('welcomedb_model');
    if( $this->input->post('submit') ) {
        $this->welcomedb_model->add_form();
    }
    $this->load->view('welcomedb_view');
}

and here is my view code

<?php echo form_open('welcomedb/submit'); ?>
   <? echo $name; ?>: 
   <? echo form_input('name'); ?>
   </br>
   <? echo $age; ?>: 
   <? echo form_input('age'); ?>
   </br>
   <?php echo form_submit('submit', 'Submit'); ?>
   <?php echo form_close(); ?>

Thanks for your help

View code :<?php echo form_open('welcomedb/submit'); ?> <? echo $name; ?>: <? echo form_input('name'); ?> </br> <? echo $age; ?>: <? echo form_input('age'); ?> </br> <?php echo form_submit('submit', 'Submit'); ?> <?php echo form_close(); ?> — webkul
– webkul, Commented Jun 23, 2010 at 14:02
Please re-edit your question and format the code accordingly. You were close, but missed on the first try. Also, your view code should be there, not in a comment. — MJB
– MJB, Commented Jun 23, 2010 at 14:24
problem is when i submit a form no data is inserted in to database only the Null values — webkul
– webkul, Commented Jun 24, 2010 at 6:53

bschaeffer · Accepted Answer · 2010-06-24 00:23:11Z

10

Your form is submitting to welcomedb/submit, but your controller appears to be at welcomedb/simpleform... maybe you need to change that.

Otherwise, there doesn't appear to be anything wrong.

answered Jun 24, 2010 at 0:23

bschaeffer

2,9042 gold badges30 silver badges60 bronze badges

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

1 Comment

webkul Over a year ago

Finally i found the solution it should be <?php echo form_open('welcomedb/simpleform'); ?> Thanks for help

GDP · Accepted Answer · 2012-08-02 15:32:17Z

2

Probably:

$data = array(
    'name' => $this->input->post('name'),
    'age' => $this->input->post('age'),
);

Remove comma from the last element (age) like this:

$data = array(
    'name' => $this->input->post('name'),
    'age' => $this->input->post('age')
);

and always dump error.

edited Aug 2, 2012 at 15:32

GDP

8,1636 gold badges48 silver badges84 bronze badges

answered Jun 26, 2010 at 20:10

Hamza Khan

1625 bronze badges

1 Comment

Junaid Qadir Shekhanzai Over a year ago

It's PHP not JS!! It's usually considered good practice to add a comma to the last array item.

user3121935 · Accepted Answer · 2014-02-06 08:46:35Z

Best way is to do these code ......
First conifg the autoload and database.
into autoload:$autoload['libraries'] = array('database'); 
              $autoload['helper'] = array('url','form','file');
Into controller

<?php
    class CDemo  extends CI_Controller
    {

        function index()
        {
            $this->load->view('VDemo');
        }
        function save()
        {
            $this->load->model('MDemo');

             if($this->input->post('submit'))
            {
                $this->MDemo->process();                
            }
            redirect('CDemo'); 
        }
    }
?>

Into Model
<?php
    class MDemo extends CI_Model
    {   
        function process()
        {
            $Id = $this->input->post('Id');
            $Name = $this->input->post('Name');
            $data = array(
                   'Id'=>$Id,
                    'Name'=>$Name                    
                    );
                    $this->db->insert('test',$data);    
            }
        }
?>

Into View
<html>
<head>
<title>DEMO</title>
</head>
<body>
    <h1>Form Biodata</h1>
    <?php
        echo form_open('CDemo/save', array('name' => 'VDemo'));    
    ?>
        <table>
            <tr>
                <td>Id :</td>
                <td><input type="text" name="Id"></input></td>
            </tr>
            <tr>
                <td>Name :</td>
                <td><input type="text" name="Name"></input></td>
            </tr>    
            <tr>
                <td><input type="submit" name="submit" value="submit"></input></td>
            </tr>        
        </table>
    <?php
        echo form_close();
    ?>
    <textarea rows="" cols="">Hello</textarea>
</body>
</html>

Collectives™ on Stack Overflow

Insert in to database using codeigniter

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related