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
Post a Comment