First steps of newbie in CI.

CodeIgniter can do that, you need to use join for joining the tables.

If you show your code here users will be able to show you how to do it.

Thanks InsiteFX, Here I go to try to explain the case (it's very simple):

Here is my controller "Users.php":

Code:

<?php namespace App\Controllers;

use App\Models\ReferredsModel;              /* -->  Here I did include the other Model (ReferredsModel)    */
use App\Models\UsersModel;
use CodeIgniter\Controller;

class Users extends Controller
{
    public function index()
    {
        $model = new UsersModel();
       
        $data = [
            'users'  => $model->getUsers(),
            'title' => 'Lista de Usuarios',
        ];
       
        echo view('templates/header', $data);
        echo view('users/overview', $data);
        echo view('templates/footer', $data);
    }

    public function view($email_user = null)
    {
        $model = new UsersModel();
       
        $data['users'] = $model->getUsers($email_user);
       
        if (empty($data['users']))
        {
            throw new \CodeIgniter\Exceptions\PageNotFoundException('No se logro encontrar: '. $email_user);
        }
       
        $data['email_user'] = $data['users']['email_user'];
       
        echo view('templates/header', $data);
        echo view('users/view', $data);
        echo view('templates/footer', $data);
    }
   
    public function getReferreds($email_referred) /*  -->  Here I did create a function for get data of the other Model */
    {
        $this->load->ReferredsModel();
       
        //$model = new ReferredsModel();
       
        $data['referreds'] = $model->getReferreds($email_referred);
       
        if (empty($data['referreds']))
        {
            throw new \CodeIgniter\Exceptions\PageNotFoundException('No se logro encontrar: '. $email_referred);

        }

        $data['id_referred'] = $data['referreds']['id_referred'];
       
    }

    public function create()
    {
        /* --------------------------------------------------*/
        /*      Here I must to get the referred if exists... *//* --> And here I must to use the data of the other Model*/
        /* --------------------------------------------------*/
        $email_new_user =   $this->request->getPost('email_user');
        $referrred      =   getReferreds($email_new_user);
       
        if (empty($referred))
        {
            $id_ref     =   5;
        }
        else
            {
                $id_ref =   $referred['id_referred'];   
            }

        $model = new UsersModel();
       
        if ($this->request->getMethod() === 'post' && $this->validate([
            'name_user'     => 'required|min_length[3]|max_length[255]',
            'lastname_user' => 'required|min_length[3]|max_length[255]',
            'email_user'    => 'required|min_length[3]|max_length[255]',
            'city_user'     => 'required|min_length[3]|max_length[255]',
            'id_referred'   => 'required',
            'id_profile'    => 'required'
        ]))
        {
            $model->save([
                'name_user'     => $this->request->getPost('name_user'),
                'lastname_user' => $this->request->getPost('lastname_user'),
                'email_user'    => $this->request->getPost('email_user'),
                'phone_user'    => $this->request->getPost('phone_user'),
                'city_user'     => $this->request->getPost('city_user'),
                'payment_method'=> $this->request->getPost('payment_method'),
                'id_referred'   => $id_ref,
                'id_profile'    => $profile,
                'created_date'  => date("Y-m-d h:i:sa"),
                'created_user'  => $this->request->getPost('created_user'),
            ]);
           
            echo view('users/success');
           
        }
        else
        {
            echo view('templates/header', ['title' => 'Crear un nuevo Usuario']);
            echo view('users/create');
            echo view('templates/footer');
        }
    }
   
}

(I'm sorry for this elemental issue. I hope you can understand the point.)

Thanks for all,


JP