I am new to Codeigniter can any one help me how to insert data into mysql?

Question

I am learning Codeigniter i want to insert data into database. How can i perform such task? This is my Controller

<?php
  defined('BASEPATH') OR exit('No direct script access allowed');

 class PostJobs extends CI_Controller {
public function __construct() {
    parent::__construct();   
    $this->load->model('Post_Model');     
}

public function index(){        
    $this->load->helper(array('form', 'url', 'email'));
    $this->load->view('postjobs');          
}
public function post(){
    $this->load->library('form_validation');
    $this->form_validation->set_rules('email', 'Email', 'trim|required|valid_email',
        array(
            'required' => 'enter email id'));

    $this->form_validation->set_rules('JTitle', 'Job Title', 'trim|required|callback__check_length[6]',
        array(
            'required' => 'enter JOB TITLE'));

    $this->form_validation->set_rules('JType', 'Job Type', 'trim|required',
        array(
            'required' => 'select job type'));

    $this->form_validation->set_rules('Salary', 'Salary', 'trim|required',
        array(
            'required' => 'enter salary'));

    $this->form_validation->set_rules('Exp', 'Experience', 'trim|required',
        array(
            'required' => 'select Experience'));

    $this->form_validation->set_rules('Skills', 'Skills', 'trim|required',
        array(
            'required' => 'enter skills'));

    $this->form_validation->set_rules('EduReq', 'Education required', 'trim|required',
        array(
            'required' => 'enter EDUCATION'));

    $this->form_validation->set_rules('JLoc', 'Location', 'trim|required',
        array(
            'required' => 'enter LOCATION'));

    $this->form_validation->set_rules('CName', 'Company Name', 'trim|required',
        array(
            'required' => 'enter COMPANY NAME'));

    $this->form_validation->set_rules('CAdd', 'Company Address', 'trim|required',
        array(
            'required' => 'enter COMPANY ADDRESS'));

    $this->form_validation->set_rules('JDesc', 'Job Description', 'trim|required',
        array(
            'required' => 'enter JOB DESCRIPTION'));

    if($this->form_validation->run() ==FALSE){
        $this->load->view('postjobs');  
    }
    else{           
        $data = array(
            'email' => $this->input->post('email'),
            'JTitle' => $this->input->post('JTitle'),
            'JType' => $this->input->post('JType'),
            'Salary' => $this->input->post('Salary'),
            'Exp' => $this->input->post('Exp'),
            'Skills' => $this->input->post('Skills'),
            'EduReq' => $this->input->post('EduReq'), 
            'JLoc' => $this->input->post('JLoc'),
            'CName' => $this->input->post('CName'),
            'CWeb' => $this->input->post('CWeb'),
            'CAdd' => $this->input->post('CAdd'),
            'JDesc' => $this->input->post('JDesc')
        );
        $this->Post_Model->insert_postjob($data);
        $this->load->view('postjobs');
    }
}
function _check_length($input, $min){
    $length = strlen($input);

    if ($length >= $min){
        return TRUE;
    }
    elseif ($length < $min){
        $this->form_validation->set_message('_check_length', 'Minimum ' . $min. ' character required');
        return FALSE;        
    }    
}   
}

This is my Model:

<?php
   defined('BASEPATH') OR exit('No direct script access allowed');

   class Post_Model extends CI_Model {
public function __construct() {
    parent::__construct();        
}

public function insert_postjob($data){      
    $this->db->insert('jobs', $data);
}
}

jobs is table name

This my view

<div class="postjob">
           <div class="container">
              <h3>Post a Job</h3>
              <form class="form-horizontal" role="form" id="postjobs" role="form" method="POST" action="<?=site_url('PostJobs/post');?>">                     
                 <div class="form-group">
                    <div class="col-lg-12">
                       <label for="jobemail">Email</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block; text-transform:uppercase;"><?php echo form_error('email');?></span>
                       <input type="email" id="emailjob" name="email" class="input-job form-control" value="<?php echo set_value('email'); ?>" autofocus>
                    </div>
                 </div>
                 <div class="form-group">
                    <div class="col-lg-6">
                       <label for="jobtitle">Job Title</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('JTitle');?></span>
                       <input type="text" id="titlejob" name="JTitle" class="input-job form-control"  value="<?php echo set_value('JTitle'); ?>">
                    </div>
                    <div class="col-lg-6">
                       <label for="jobtype">Job Type</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('JType');?></span>
                       <select name="JType" class="input-job form-control" id="select" >
                          <option value="">SELECT</option>
                          <option value="Full Time">Full Time</option>
                          <option value="Part Time">Part Time</option>
                          <option value="Temporary">Temporary</option>
                          <option value="Internship">Internship</option>
                       </select>                          
                    </div>
                 </div>
                 <div class="form-group">
                    <div class="col-lg-6">
                       <label for="jobsalary">Salary</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('Salary');?></span>
                       <input type="text" name="Salary" id="salaryjob" class="input-job form-control"  value="<?php echo set_value('Salary');?>">                           
                    </div>
                    <div class="col-lg-6">
                       <label for="exp">Experience</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('Exp');?></span>
                       <select name="Exp" class="input-job form-control" id="exp" >
                          <option value="">SELECT</option>
                          <option value="Fresher">Fresher</option>
                          <option value="< 1"> &lt; 1</option>
                          <option value="1-2">1-2</option>
                          <option value="2-5">2-5</option>
                          <option value="5-8">5-8</option>
                          <option value="8-10">8-10</option>
                          <option value="10-12">10-12</option>
                          <option value="> 12">&gt; 12</option>
                       </select>                           
                    </div>
                 </div>
                 <div class="form-group">
                    <div class="col-lg-6">
                       <label for="skills">Skills(Seperate by Comma)</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('Skills');?></span>
                       <input type="text" name="Skills" id="skill" class="input-job form-control" value="<?php echo set_value('Skills');?>">
                    </div>
                    <div class="col-lg-6">
                       <label for="education">Education Requirement</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('EduReq');?></span>
                       <input type="text" name="EduReq" id="EduReq" class="input-job form-control" value="<?php echo set_value('EduReq');?>">                           
                    </div>
                 </div>
                 <div class="form-group">
                    <div class="col-lg-6">
                       <label for="joblocation">Job Location</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('JLocation');?></span>
                       <input type="text" name="JLocation" id="locationjob" value="<?php echo set_value('JLocation');?>" class="input-job form-control">                           
                    </div>
                    <div class="col-lg-6">
                       <label for="cname">Company Name</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('CName');?></span>
                       <input type="text" name="CName" id="cname" value="<?php echo set_value('CName');?>" class="input-job form-control">  
                    </div>
                 </div>
                 <div class="form-group">
                    <div class="col-lg-6">
                       <label for="cweb">Company Website(Optional)</label>
                       <input type="url" name="CWeb" id="cweb" value="<?php echo set_value('CWeb');?>" class="input-job form-control">
                    </div>
                    <div class="col-lg-6">
                       <label for="cadd">Company Address</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('CAdd');?></span>
                       <input type="text" class="input-job form-control" name="CAdd" value="<?php echo set_value('CAdd');?>">
                    </div>
                 </div>
                 <div class="form-group">
                    <div class="col-lg-12">
                       <label for="jobdesc">Job Description</label>
                       &nbsp;&nbsp;<span class="text-danger" style="display:inline-block;text-transform:uppercase;"><?php echo form_error('JDesc');?></span>
                       <textarea class="input-job form-control textarea" name="JDesc" rows="10" id="jdesc" placeholder="Description" style="resize:none;"><?php echo set_value('JDesc');?></textarea>
                    </div>
                 </div>
                 <div class="form-group text-center">
                    <input type="submit" name="btnpost" class="btn btn-green" value="POST JOBS"/>
                 </div>
              </form>
           </div>
        </div>

Can anyone help me where i am failing to insert data??

echo $this->db->last_query(); and know the columns name are correct or not — JYoThI, Jul 14 '16 at 11:37
$this->db->insert('jobs', $data); after this echo $this->db->last_query(); @RomilLodaya — JYoThI, Jul 14 '16 at 11:39
Make sure that you have Error Reporting turned on. To display all error messages set CI environment to development. http://stackoverflow.com/questions/7370391/how-to-configure-codeigniter-to-report-all-errors If you see any error messages in your system, post it here. — ash__939, Jul 14 '16 at 11:58

score 0 · Answer 1 · answered Jul 14 '16 at 11:29

0

Try to make your model without public:

$query = $this->db->insert('jobs', $data); if ($query) { return true; } else { return false; }
Check if the table column names match to what you are trying to insert to, they might be wrong...
Use $this->db->last_query(); to see your generate query, and try to insert it manually and run it, if it fails you will see why :)

answered Jul 14 '16 at 11:29

Mecanik

1,539
1
20
50

where should i use $this->db->last_query(); – romi Jul 14 '16 at 11:37
$this->db->insert('jobs', $data); after this echo $this->db->last_query(); @RomilLodaya – JYoThI Jul 14 '16 at 11:39
@jothi i added echo $this->db->last_query(); but nothing happend – romi Jul 14 '16 at 11:43
add echo $this->db->last_query(); exit(); or exit; after that and there showing your query @RomilLodaya – JYoThI Jul 14 '16 at 11:45
not working bro @jothi query is not displaying – romi Jul 14 '16 at 11:48
what showing there ? – JYoThI Jul 14 '16 at 11:50
If nothing is showing, then you are either not calling the model, or there is no connection with the database, please review carefully each step of the script. – Mecanik Jul 14 '16 at 11:57

score 0 · Answer 2 · answered Jul 14 '16 at 11:50

0

In your controller replace :

$this->Post_Model->insert_postjob($data);

with

$this->post_model->insert_postjob($data);  // lowercase

In your model add following to your construct function

$this->load->database(); // if not added in autoload

answered Jul 14 '16 at 11:50

Rijin

625
1
4
13

did you get any error? – Rijin Jul 14 '16 at 11:55
no error return back to same page with inserted data as i have used set_value() – romi Jul 14 '16 at 11:56
try to change action of your form tag like "http://domain.com/index.php/post_job/post" – Rijin Jul 14 '16 at 11:58
may be due to validation error, add to view page to display error – Rijin Jul 14 '16 at 12:07
where should i add – romi Jul 14 '16 at 12:10
on top of your view page, (html page) – Rijin Jul 14 '16 at 12:11
its displaying **enter Location** – romi Jul 14 '16 at 12:15
Message: Call to a member function insert_postjob() on null on line after updating Location – romi Jul 14 '16 at 12:19
add a field to enter a location or remove validation of location from your controller – Rijin Jul 14 '16 at 12:19
replace $this->load->model('Post_Model'); with $this->load->model('post_model'); – Rijin Jul 14 '16 at 12:21
thanks @rijin its working – romi Jul 14 '16 at 12:24

I am new to Codeigniter can any one help me how to insert data into mysql?

2 Answers2