how to stop storing null values in database every tie when user refresh the browser in codeigniter

Vote count: 0

i created one form in my application..so every time when user refreshes the browser..the form null values stored in database..and as well as mail also will send to particular person every time when refresh the browser..

Here is my view:

<form action="" id="form" method="post" >

<div class="form-group">

     <div class="form-group">
              <label>Select</label>
              <select class="form-control" name="selection">
                <option>Telephonic</option>
                <option>F2F</option>
                <option>HR</option>

              </select>
            </div>

     <div class="box-body pad">
            <label>Comments</label>
            <textarea class="textarea" name="comments"  id="Comments "placeholder="Place comments here" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>

        </div>


      <div class="box-body pad">
          <label>Results</label>
            <textarea class="textarea" name="results" placeholder="Place results here" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>

        </div>

           <div class="form-group">
            <label>
              <input type="radio" name="selection_process" value="1" class="flat-red" checked>Selected
             </label>

            <label>
              <input type="radio" name="selection_process" value="2" class="flat-red">Not Selected
            </label>

          </div>


     <div class="row">
    <div class="col-xs-8">
      <div class="checkbox icheck">

      </div>
    </div>

    <div class="col-xs-4">
      <button type="submit" name="submit" id="submit"class="btn btn-primary btn-block btn-flat">Submit</button>
    </div>

  </div>
</form>

This is my controller:

 public function add_selection()
   {
  $data=array(
      'selection'=>$this->input->post('selection'),
      'comments'=>$this->input->post('comments'),
      'results'=>$this->input->post('results'),
      'selection_process'=>$this->input->post('selection_process')

    );

   if($data['selection_process']==1)
   {
    $config = Array(
            'protocol' => 'smtp',
            'smtp_host' => 'ssl://md-in-42.webhostbox.net',
            'smtp_port' => 465,
            'smtp_user' => 'test3@clozloop.com',
            'smtp_pass' => 'test3'
        );
           $this->load->library('email',$config);
           $this->email->set_mailtype("html");
           $this->email->from('test3@clozloop.com', 'bharathi');
           $list=array('nalamalapu.bharathi@gmail.com','bharathi.nalamalapu@gmail.com');
           $this->email->to($list); 
           $this->email->subject('YOU ARE SELECTED');
           $link = 'Click on this link - <a href="http://localhost/job_portal/index.php/Login/signin">Click Here</a>';
           $this->email->message($link);
           $this->email->send();
   }
   else
   {
        $config = Array(
            'protocol' => 'smtp',
            'smtp_host' => 'ssl://md-in-42.webhostbox.net',
            'smtp_port' => 465,
            'smtp_user' => 'test3@clozloop.com',
            'smtp_pass' => 'test3'
        );
           $this->load->library('email',$config);
           $this->email->set_mailtype("html");
           $this->email->from('test3@clozloop.com', 'bharathi');
           $list=array('nalamalapu.bharathi@gmail.com','bharathi.nalamalapu@gmail.com','mounikavemula537@gmail.com');
           $this->email->to($list); 
           $this->email->subject('YOU ARE NOT SELECTED');
           $link = 'Click on this link - <a href="http://localhost/job_portal/index.php/Login/signin">Click Here</a>';
           $this->email->message($link);
           $this->email->send();
   }
 $this->SelectionModel->add_selection_details($data);
 $this->load->view('selection/selection_details',$data);

}

please help me how to do this.. Thank You..

asked 1 min ago

M5533

Let's block ads! (Why?)

how to stop storing null values in database every tie when user refresh the browser in codeigniter