Multiple Page Article Reader?

generik99

Hey, I'm working on a small article system that pulls them from a mysql database.

So far it's working (knock on wood) but I'd like to allow writers to add in a tag of some sort (eg [nextpage] ) into the body of the article that tells the script to seperate the article into multiple pages, with next and prev links at the bottom.

Any way of going about this?

Cheers,
Generik99

amansabharwal

http://www.onlamp.com/pub/a/php/2000/11/02/next_previous.html

http://codewalkers.com/tutorials.php?show=4

or you can go to www.phpclasses.org and search for the class that you need there are lots of classes available for you
or
go to the following link
http://gremlins.mirrors.phpclasses.org/search.html?words=next+previous&go_search=1

jnuneznyc

If you decided to create this on your own then... the most efficient way to do this would be to process it once when the author submits the article.

First break up the db into two tables: articles and pages.
[THIS IS NOT Actual Code and the DB can be optimized or implemented in a better way]

Articles
-id : int
-title : varchar(255)
-author : varchat(255)
-description : varchar(255)

Pages
-id : int
-article_id : int
-page_number : int
-content : text

Then just search for
SELECT * FROM Pages where article_id = $articleID AND page_number = $pagenum

The Benefits:
Less data is being retrieved from MySQL and PHP doesn't need to parse the text for [nextpage] every time someone is viewing a page in a article.

Let me know if this helps.