// consultation: $result = $link->query($query) or die("Error in the consult.." . mysqli_error($link)); $row = mysqli_fetch_array($result, MYSQLI_ASSOC); $arr = array(); while ($row) { $arr[] = $row; $row = mysqli_fetch_array($result, MYSQLI_ASSOC); } $link->close(); return $arr; } private function queryUsers($query) { $users = self::queryArray($query); $result = array(); foreach ($users as $user) { $result[] = array('mobile' => $user['mobile'], 'web_ctime' => $user['web_ctime'], 'mobile_ctime' => $user['mobile_ctime'], 'mobile_client_last_login_time' => $user['mobile_client_last_login_time']); } return $result; } public function writeJson() { $data = self::queryArray($this->query1); self::writeToFile('user.json', json_encode($data)); } } // header ( "Content-Type: text/html; charset=utf-8" ); header('Content-type: application/json; charset=utf-8'); $sougou = new Sogou(); $sougou->writeJson();