function getDatafromtable(){ $this->pagiPage = ($this->pagiPage-1) * $this->limit; $sql = 'SELECT * FROM loging ORDER BY id DESC LIMIT '.$this->pagiPage.','.$this->limit; $tb = $this->db->connection->prepare($sql); $tb->execute(); $this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC); return $this->arrBest; } function getUserById($userid){ $sql = 'SELECT * FROM inner_users WHERE user_id = :user_id'; $tb = $this->db->connection->prepare($sql); $tb->execute(array(':user_id'=>$userid)); $this->arrBest = $tb->fetch(PDO::FETCH_ASSOC); return $this->arrBest; } } $getData = new mainpage_query($pagiPage,$limit); $getter = $getData ->getDatafromtable(); $counter = 0; foreach($getter as $arItMs){ $userLogin = $getData -> getUserById($arItMs['login_id']); if(!$getter[$counter]['ipuser']){$getter[$counter]['ipuser'] = '******';} $getter[$counter]['login_id'] = $userLogin['user_login']; $getter[$counter]['tmlog'] = date("d-m-y H:i:s", strtotime($arItMs['tmlog'])); $counter ++; } echo json_encode($getter); ?>