/** * 从MySQL中,查询未以此为标准抓取关注者的用户 * * @param int $limit 获取记录数量 * @return mixed */ private function _get_sql_users($limit = 20) { if (empty($limit)) { return FALSE; } $sql = "SELECT `username` FROM `user` WHERE `used`=0 LIMIT 20"; $result = CG_DB::query($sql); $res_arr = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $res_arr[] = $row['username']; } } $sql = "('" . implode($res_arr, "','") . "')"; //标记为已经抓去过信息 $sql = "UPDATE `user` SET `used`=1 WHERE `username` IN " . $sql; CG_DB::query($sql); // $result->free(); return $res_arr; }