public function getUsers($user_id)
{
if (empty(self::$conn)) {
self::$conn = $this->connect_pdo();
}
$sql = "SELECT username,CONCAT_WS(' ',firstname,lastname) AS name,email FROM users WHERE user_id=?";
$stmt = self::$conn->prepare($sql);
$stmt->bindParam(1, $user_id);
$stmt->execute();
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$users = array(array());
$i = 0;
while ($row = $stmt->fetch()) {
$users[$i++] = $row;
}
$i--;
return $users;
}
