CodeIgniter Database Insert Record

by Online Tutorials Library July 14, 2022

CodeIgniter Database INSERT record

In this example, we will INSERT different values in database showing meaning of Indian names through CodeIgniter.

In application/controller, file baby_form.php is created.

  load->view(“baby_form_add”); } function savingdata() { //this array is used to get fetch data from the view page. $data = array( ‘name’     => $this->input->post(‘name’), ‘meaning’  => $this->input->post(‘meaning’), ‘gender’   => $this->input->post(‘gender’), ‘religion’ => $this->input->post(‘religion’) ); //insert data into database table. $this->db->insert(‘baby’,$data);  redirect(“baby_form/index”); } } ?>  

Look at the above snapshot, our table name is ‘baby’.

    <title>Baby Form Add</title>   
<form action="<?php%20echo%20site_url('baby_form/savingdata');%20?>" method="post">
<table>
<tr>
<td>Name:</td>
<td>:</td>
<td><input name="name" type="text"></td>
</tr>
<tr>
<td>Meaning:</td>
<td>:</td>
<td><input name="meaning" type="text"></td>
</tr>
<tr>
<td>Gender:</td>
<td>:</td>
<td><input name="gender" type="text"></td>
</tr>
<tr>
<td>Religion:</td>
<td>:</td>
<td><input name="religion" type="text"></td>
</tr>
<tr> <input name="submit" type="submit" value="Save"> </tr>
</table></form>
<p>    </p>

This is our view page which is being loaded in the controller’s page.

To run it on your browser, pass URL

http://localhost/insert/index.php/Baby_form/

Codeigniter Insert database record 3

By inserting various names in the above form we have created our table as shown below.

Codeigniter Insert database record 4

download this example

Next TopicCodeIgniter SELECT Database record

CodeIgniter Database Insert Record

CodeIgniter Database INSERT record

Aneka in Cloud Computing

TreeMap in Java

You may also like