User Model File in Codeigniter 3 in PHP

 <?php

defined("BASEPATH") or exit("No direct script access allowed");

class User_model extends CI_Model
{
    public function create($formArray)
    {
        $this->db->insert("users", $formArray); //INSERT INTO users(name,email) VALUES(?,?);
    }

    public function allRecords()
    {
        return $this->db->get("users")->result_array(); //SELECT * FROM users;
    }

    public function getUser($userId)
    {
        $this->db->where("user_id", $userId);
        return $this->db->get("users")->row_array(); //SELECT * FROM users WHERE user_id = ?
    }

    //UPDATE the record from Database
    public function updateUser($userId, $formArray)
    {
        $this->db->where("user_id", $userId);
        $this->db->update("users", $formArray); //UPDATE users SET name = ?, email = ? WHERE user_id = ?
    }

    //DELETE the record from Database
    public function deleteUser($userId)
    {
        $this->db->where("user_id", $userId);
        $this->db->delete("users"); //DELETE FROM users WHERE user_id = ?
    }
}








Comments