Tutorialswithtips: Codeigniter--Inserting data into database

After the Cross-site Scripting Application, Now we are going to learn about Inserting data into the database.

1. Rename your Codeigniter folder as "inserigniter".
2. Now configure your files.Go to C:\xampp\htdocs\insertigniter\application\config and select autoload.php and make changes as follows.

$autoload['libraries'] = array('database','xmlrpc');
$autoload['helper'] = array('url', 'file','form');

3. Here xmlrpc is a way for two computers to communicate over the internet using XML.
4. Next select database.php and make changes as follows.

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'company_db';
$db['default']['dbdriver'] = 'mysql';

5. Create a new file view.php in C:\xampp\htdocs\insertigniter\application\views.Here is the code. Just copy and paste it in your file.

view.php

<html>
<head>
<title>Inserting Data and Storing in Database</title>
<link rel="stylesheet" type="text/css" href="<?php echo base_url(); ?>css/styles.css" />
</head>
<body>
<div id="container">
<?php echo form_open('vcontroller'); ?>
<h1>
Insert Data Into Database</h1>
<hr/>
<?php if (isset($message)) { ?>
<center>
<h3 style="color:green;">
Data Successfully Inserted</h3>
</center>
<br>
<?php } ?
<?php echo form_label('Employee Name :'); ?> <?php echo form_error('ename'); ?><br />
<?php echo form_input(array('id' => 'ename', 'name' => 'ename')); ?><br />
<?php echo form_label('Employee Email :'); ?> <?php echo form_error('eemail'); ?><br />
<?php echo form_input(array('id' => 'demail', 'name' => 'eemail')); ?><br />
<?php echo form_label('Employee Mobile No. :'); ?> <?php echo form_error('emobile'); ?><br />
<?php echo form_input(array('id' => 'emobile', 'name' => 'emobile', 'placeholder' => 'Mobile No(10 digit).')); ?><br/>
<?php echo form_label('Employee Address :'); ?> <?php echo form_error('eaddress'); ?><br />
<?php echo form_input(array('id' => 'eaddress', 'name' => 'eaddress')); ?><br />
<?php echo form_submit(array('id' => 'submit', 'value' => 'Submit')); ?>
<?php echo form_close(); ?><br/>
</div>
</body>
</html>

6. Create a new file vcontroller.php in C:\xampp\htdocs\insertigniter\application\controllers.Here is the code. Just copy and paste it in your file.

vcontroller.php

<?php
class vcontroller extends CI_Controller 
{
function __construct() 
{
parent::__construct();
$this->load->model('model');
}
function index() 
{
$this->load->library('form_validation');
$this->form_validation->set_error_delimiters('<div class="error">
', '</div>
');
$this->form_validation->set_rules('ename', 'Username', 'required|min_length[5]|max_length[15]');
$this->form_validation->set_rules('eemail', 'Email', 'required|valid_email');
$this->form_validation->set_rules('emobile', 'Mobile No.', 'required|regex_match[/^[0-9]{10}$/]');
$this->form_validation->set_rules('eaddress', 'Address', 'required|min_length[10]|max_length[50]');
if($this->form_validation->run() == FALSE) 
{
$this->load->view('view');
} 
else
{
$data = array('Emp_Name' => $this->input->post('ename'),'Emp_Email' => $this->input->post('eemail'),'Emp_Mobile' => $this->input->post('emobile'),'Emp_Address' => $this->input->post('eaddress'));
$this->model->insert_form($data);
$data['message'] = 'Data Inserted Successfully';
$this->load->view('view', $data);
}
}
}
?>

7. Create a new file model.php in C:\xampp\htdocs\insertigniter\application\models.Here is the code. Just copy and paste it.

model.php

8.Create a css folder in C:\xampp\htdocs\insertigniter and create a file named styles.css. Just copy and paste the following code.

styles.css

9. For the database part, just copy and paste in your database.

10. Now redirect to http://localhost/insertigniter/index.php/vcontroller.
11. You should get the following screen.

That's it!,In the next tutorial,we will be learning about Captcha-generated Form.

Tutorialswithtips

Pages

Saturday, October 10, 2015

Codeigniter--Inserting data into database

No comments:

Post a Comment