How to upload file with ci.

 

Before you coding with ci you have to create a direct folder to uploads store file. in ci root directory.

View :

<?php 

 echo form_open_multipart('items/add_new_item',array('name'=>'sentMessage','id'=>'contactForm')); ?>
    <div class="row">
        <div class="col-md-12">
            <div class="form-group" style="color: #fff;">

                   <input  name="image" type="file">                                        

           </div>
        </div>
        <div class="clearfix"></div>
        <div class="col-lg-12 text-center">
            <div id="success"></div>
            <button type="submit" class="btn btn-success">Save</button>
            <button type="submit" class="btn btn-danger">Cancel</button>
        </div>
    </div>
</form>

Controller :

class items extends CI_Controller {

    public function __construct()
    {
        parent::__construct();
       
        $this->load->model('items_model');
    }

 

    public function add_new_item()
    {
        //set preferences
        $config['upload_path'] = './uploads/'; // folder name
        $config['allowed_types'] = '*';
        $config['max_size'] = '10000000';
       
        //load library of file upload
        $this->load->library('upload', $config);
       
        //copy file into folder
        if(!$this->upload->do_upload('image')) // input type name
        {
            $file = "";
           
        }else{
           
            $upload_data = $this->upload->data();
            $file = $upload_data['file_name'];
           
        }
       
        $data = array(
             'image' => $file
        );
       
        //Save to db
        $this->items_model->add_new_item($data);
       
        redirect('items');

    }
 }

Model:

    public function add_new_item($data)
    {
        return $this->db->insert('tb_items', $data);
    }

How to insert one id into multi table with Codeigniter.

 

My SQL Database

Table Structure of tb_employee
            employee_id
            name
            phone
           ...........

Table Structure of tb_permission
         employee_id
         sales
         customers
         ................

Table Structure of tb_user
         employee_id
         user_name
         password
         ...............

Now let start coding:

Controler:

    public function add_employee()
    {
        $data['employees_data']=$this->employee_model->insert_employee();
        $latest_id=$this->employee_model->get_latest_id();
        $data['permissions_data']=$this->employee_model->insert_permission($latest_id);
        $data['users_data']=$this->employee_model->insert_user($latest_id);
   
        redirect('employees');
    }   

Model:

    function insert_employee()
    {
        //set preferences
        $config['upload_path'] = './uploads/users/';
        $config['allowed_types'] = '*';
        $config['max_size'] = '10000000';
       
        //load library of file upload
        $this->load->library('upload', $config);
       
        //copy file into folder
        if(!$this->upload->do_upload('files'))
        {
            $file = "";
           
        }else{
           
            $upload_data = $this->upload->data();
            $file = $upload_data['file_name'];
           
        }
       
        $data=array(
            'name' => $this->input->post('name'),
            'phone' => $this->input->post('phone'),
            'email' => $this->input->post('email'),
            'address' => $this->input->post('address'),
            'files' =>  $file,
            'message' => $this->input->post('message')
        );
        $this->db->insert('tb_employee',$data);
        //better return true on success
    }

    public function get_latest_id()
    {
        $sql=$this->db->query("SELECT MAX(employee_id) as id FROM tb_employee");
        return $sql->row_array();
    }
   
    function insert_permission($emp_id)
    {
        $data=array(
            'employee_id' => $emp_id['id'],
            'items' => $this->input->post('items'),
            'sales' => $this->input->post('sales'),
            'employees' =>   $this->input->post('employees'),
            'customers' =>   $this->input->post('customers'),
            'suppliers' =>   $this->input->post('suppliers'),
            'receivings' =>   $this->input->post('receivings'),
            'reports' =>   $this->input->post('reports'),
            'config' =>   $this->input->post('configuration')
        );
        $this->db->insert('tb_permissions',$data);
    }

  function insert_user($emp_id)
    {
        $data=array(
            'employee_id' => $emp_id['id'],
            'user_name' => $this->input->post('user_name'),
            'password' => $this->input->post('password')
        );
        $this->db->insert('tb_users',$data);
    }