ankitjain28may / openchat

src/SideBar.php

<?php
/**
 * Sidebar Class Doc Comment
 *
 * PHP version 5
 *
 * @category PHP
 * @package  OpenChat
 * @author   Ankit Jain <ankitjain28may77@gmail.com>
 * @license  The MIT License (MIT)
 * @link     https://github.com/ankitjain28may/openchat
 */
namespace ChatApp;

require_once dirname(__DIR__).'/vendor/autoload.php';
use ChatApp\Time;
use mysqli;
use Dotenv\Dotenv;
$dotenv = new Dotenv(dirname(__DIR__));
$dotenv->load();

/**
 * Fetching the sidebar results
 *
 * @category PHP
 * @package  OpenChat
 * @author   Ankit Jain <ankitjain28may77@gmail.com>
 * @license  The MIT License (MIT)
 * @link     https://github.com/ankitjain28may/openchat
 */
class SideBar
{
    /*
    |--------------------------------------------------------------------------
    | Time Class
    |--------------------------------------------------------------------------
    |
    | For Fetching the sidebar results.
    |
    */

    protected $obTime;
    protected $array;
    protected $connect;

    /**
     * Create a new class instance.
     *
     * @return void
     */
    public function __construct()

This method seems to be duplicated in your project.

    {
        $this->connect = new mysqli(
            getenv('DB_HOST'),
            getenv('DB_USER'),
            getenv('DB_PASSWORD'),
            getenv('DB_NAME')
        );
        $this->obTime = new Time();
        $this->array = array();
    }

    /**
     * Load Sidebar for the user containing all the names of the people
     *
     * @param int $userId To store session id of the user
     *
     * @return string
     */
    public function loadSideBar($userId)
    {
        if (!empty($userId)) {
            $query = "SELECT * FROM total_message WHERE user1 = '$userId'
                        or user2 = '$userId'  ORDER BY id DESC";
            if ($result = $this->connect->query($query)) {
                if ($result->num_rows > 0) {
                    while ($row = $result->fetch_assoc()) {
                        $identifier = $row['identifier'];
                        $substring = explode(":", $identifier);
                        if ($substring[0] != $userId) {
                            $this->data($substring[0], $row);
                        } else {
                            $this->data($substring[1], $row);
                        }
                    }
                    return json_encode($this->array);
                }
                return json_encode(null);
            }
            return "Query Failed";
        }
        return "Invalid Authentication";
    }

    /**
     * Fetch data form the DB for the Sidebar
     *
     * @param int   $userId To store session id of the user
     * @param array $row    To store data
     *
     * @return void
     */
    public function data($userId, $row)
    {
        $query = "SELECT username, name, login_status, login_id
                    from login where login_id = '$userId'";
        if ($result = $this->connect->query($query)) {
            if ($result->num_rows > 0) {
                $fetch = $result->fetch_assoc();
                $fetch['login_id'] = bin2hex(convert_uuencode($fetch['login_id']));
                $row['time'] = $this->obTime->timeConversion($row['time']);
                $fetch = array_merge($fetch, ['time' => $row['time']]);
                $this->array = array_merge($this->array, [$fetch]);
            }
        }
    }

}