在PHP中使用分页进行多个XML文件解析

Question

I have a folder on the server with almost 9,000 small XML files (NewsML) with varying numbers of news items in each - but usually from 1 - 10 items in each file.

I need to retrieve the items via PHP and then paginate the results. So there would be ten items per page and end up with hundreds of paginated pages of the results.

I can retrieve the multiple file names no problem using scandir but am having a hard time figuring out how I would return the results and paginate (in a performance friendly way as well).

Any ideas?

Answer 1

Better import them to your database, using LOAD DATA INFILE and start paginating from there. This makes retrieval easy in PHP.