Code Igniter: 4.Saving data to the database

Easy Steps:

1. On your notepad++, edit the jobseeker_signup_view.php in C:\xampp\htdocs\application\views with the following code:

<html>

<head>

<title>Jobseeker Signup | BizjobFinder</title>

</head>

<body>

<div><h4>Free Signup</h4></div>

<hr>

<form method='post' action="<?php echo base_url()?>jobseeker-insert">

<div>

<?php if(isset($this->session->userdata['user'])){?>

<div>

<?php echo $this->session->userdata['user']['msg'];

$this->session->unset_userdata('user');

</div>

<?php } ?>

<span class='label'>Firstname:</span>

</div>

</div>

<span class='label'>Lastname:</span>

</div>

<span class='label'>Street/Barangay:</span>

</div>

</div>

<span class='label'>Province:</span>

</div>

</div>

</form>

</body>

</html>

2. On PHPMyAdmin, create a database table by executing this SQL Script below:

CREATE DATABASE bizjobfinder_db;

USE bizjobfinder_db;

CREATE TABLE jobseekers

(

id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,

firstname varchar(50),

mi varchar(2),

lastname varchar(50),

street_barangay varchar(50),

town_city varchar(50),

province varchar(50)

)

3. Edit database.php located on: C:\xampp\htdocs\application\config with the following code:

$active_group = 'default';

$active_record = TRUE;

$db['default']['hostname'] = 'localhost';

$db['default']['username'] = 'root';

$db['default']['password'] = '';

$db['default']['database'] = 'bizjobfinder_db';

$db['default']['dbdriver'] = 'mysql';

$db['default']['dbprefix'] = '';

$db['default']['pconnect'] = TRUE;

$db['default']['db_debug'] = TRUE;

$db['default']['cache_on'] = FALSE;

$db['default']['cachedir'] = '';

$db['default']['char_set'] = 'utf8';

$db['default']['dbcollat'] = 'utf8_general_ci';

$db['default']['swap_pre'] = '';

$db['default']['autoinit'] = TRUE;

$db['default']['stricton'] = FALSE;

4. Edit autoload.php located on: C:\xampp\htdocs\application\config with the following code:

$autoload['libraries'] = array('database','session');

5. Edit config.php located on: C:\xampp\htdocs\application\config with the following code:

$config['encryption_key'] = 'a-z 0-9~%.:_\-';

6. Edit jobseekers.php located on: C:\xampp\htdocs\application\controllers with the following:

<?php

*Filename:jobseekers.php

*Projectname:Bizjobfinder.com

*Date Created: April 02, 2012 @11:42pm

*Created by: Mario T. Silvano a.k.a strikermode

if( !defined('BASEPATH') ) exit ('No direct script access allowed');

class jobseekers extends CI_Controller{

function __construct(){

parent::__construct();

$this->load->model('jobseeker_model','jobseeker');

}

function signup(){

$this->load->view('jobseeker_signup_view');

}

function insert(){

$data=$this->input->post();

$result=$this->jobseeker->insert($data);

if($result)

$msg="Successfully Save...";

else

$msg="Save Failed...";

$data=array('msg' => $msg);

$this->session->set_userdata('user',$data);

redirect(base_url().'jobseeker-signup');

}

End of file jobseekers.php

Location:./application/controllers/jobseekers.php

7. Edit routes.php located on: C:\xampp\htdocs\application\config with the following code:

$route['jobseeker-insert']="jobseekers/insert";

8. Create a new file named jobseeker_model.php, save it to: C:\xampp\htdocs\application\models and type the following code:

<?php

*Filename:jobseeker_model.php

*Projectname:Bizjobfinder.com

*Date Created: April 02, 2012 @11:42pm

*Created by: Mario T. Silvano a.k.a strikermode

class jobseeker_model extends CI_Model{

private $table;

function __construct(){

parent::__construct();

$this->table='jobseekers';

}

function insert($data){

$jobseeker = array(

'firstname' => $data['firstname'],

'mi' => $data['mi'],

'lastname' => $data['lastname'],

'street_barangay' => $data['street_barangay'],

'town_city' => $data['town_city'],

'province' => $data['province']

);

$result=$this->db->insert($this->table,$jobseeker);

if($result)return true;

else return false;

}

End of file jobseeker_model.php

Location:./application/controllers/jobseeker_model.php

9. Put your code to the test, nice jobJ

4.Saving data to the database

1 comment: