<?php
/*
* Copyright (c) 2023 BitsHost
* All rights reserved.
* Permission is hereby granted, free of charge, to any person obtaining a copy
* of this software and associated documentation files (the "Software"), to deal
* in the Software without restriction, including without limitation the rights
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
* copies of the Software, and to permit persons to whom the Software is
* furnished to do so, subject to the following conditions:
* The above copyright notice and this permission notice shall be included in all
* copies or substantial portions of the Software.
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
* SOFTWARE.
*/
namespace MyApp\Models;
class UserModel extends BaseModel
{
protected $conn;
public function __construct()
{
parent::__construct();
}
public function addUser($name, $email)
{
$sql = "INSERT INTO users (name, email) VALUES (?, ?)";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("ss", $name, $email);
$stmt->execute();
$stmt->close();
}
public function getUsers()
{
$sql = "SELECT * FROM users";
$result = $this->conn->query($sql);
return $result->fetch_all(MYSQLI_ASSOC);
}
public function getUsersWithLimit($offset, $limit)
{
$sql = "SELECT * FROM users LIMIT ?, ?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("ii", $offset, $limit);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_all(MYSQLI_ASSOC);
}
public function getUserById($id)
{
$sql = "SELECT * FROM users WHERE id=?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
return $result->fetch_assoc();
}
public function updateUser($id, $name, $email)
{
$sql = "UPDATE users SET name=?, email=? WHERE id=?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("ssi", $name, $email, $id);
$stmt->execute();
$stmt->close();
}
public function deleteUser($id)
{
$sql = "DELETE FROM users WHERE id=?";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$stmt->close();
}
}
|
Download
