How to insert data in database - CodeIgniter framework
In this example we are going to show you how to insert data in database using CodeIgniter framework PHP.
For insert data in MySQL using CodeIgniter first we have to create a table in data base.
The INSERT INTO statement is used to insert new data to a MySQL table:
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)To learn more about SQL, please visit our SQL tutorial.
For creating table the SQL query is:
SQL Query
CREATE TABLE crud (
`id` int(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL
);
Here we using 3 files for insert data in MySQL:
- Crud.php Path: codeIgniter\application\controllers\Crud.php
- Crud_model.php Path: codeIgniter\application\models\Crud_model.php
- insert.php Path: codeIgniter\application\views\insert.php
Crud.php (Controller)
<?php
class Crud extends CI_Controller
{
public function __construct()
{
/*call CodeIgniter's default Constructor*/
parent::__construct();
/*load database libray manually*/
$this->load->database();
/*load Model*/
$this->load->model('Crud_model');
}
/*Insert*/
public function savedata()
{
/*load registration view form*/
$this->load->view('insert');
/*Check submit button */
if($this->input->post('save'))
{
$data['first_name']=$this->input->post('first_name');
$data['last_name']=$this->input->post('last_name');
$data['email']=$this->input->post('email');
$response=$this->Crud_model->saverecords($data);
if($response==true){
echo "Records Saved Successfully";
}
else{
echo "Insert error !";
}
}
}
}
?>
Crud_model.php (Model)
<?php
class Crud_model extends CI_Model
{
function saverecords($data)
{
$this->db->insert('crud',$data);
return true;
}
}
insert.php (View)
<!DOCTYPE html>
<html>
<head>
<title>Registration form</title>
</head>
<body>
<form method="post" action="<?= base_url() ?>Crud/savedata">
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr>
<td width="230">First Name </td>
<td width="329"><input type="text" name="first_name"/></td>
</tr>
<tr>
<td>Last Name </td>
<td><input type="text" name="last_name"/></td>
</tr>
<tr>
<td>Email ID </td>
<td><input type="email" name="email"/></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="save" value="Save Data"/></td>
</tr>
</table>
</form>
</body>
</html>
Run the program on your browser with URL:
http://localhost/codeIgniter/index.php/Crud/savedata
Comments
Post a Comment