Split into pages

toxic

How do I split a dokument into several pages when its stored in My MYSQL database?

Yours Faithfully
Jens Mikkelsen
Denmark

Traduim

Do you mean presenting the information in several pages, each one containg a determined amount of records?

If that's the point, I think you would appreciate the use of this class: http://www.web-studio.com.ar/proyectos/paginado/class.paginado.phps

Unfortunately, I think documentation is only available in Spanish:
http://www.web-studio.com.ar/proyectos/paginado/paginado_documentacion.htm

toxic

My problem is that my articles are very long... and it would look much nicer if I could split/divide the article into more pages.

Is there an easy way to do it? I had trouble understanding the link u sent me, Cant understand Spanish.

Traduim

Don't worry about my last posting, it was about a different thing. You're trying to split the record itself into pages and I was talking of posting several records in each page.
I'm afraid I can't help you 🙁

toxic

No problem I understand.

Jesteruk

If you're trying to split multiple result rows up into a pre-determined number on each of a set of result pages (like you see on google.com) i always use the Pager class which works with PEAR:😃B (pear.php.net).

If you're talking about splitting a single TEXT, BLOB field (or whatever) up into multiple pages, there's no real way to do this without changing your database design to support multiple pages for articles. 🙁

toxic

Too bad.. but its a new site im working on.. and the articles havent been posted yet. So it doenst matter if I have to change something in the database.

cahva

Originally posted by Jesteruk
If you're talking about splitting a single TEXT, BLOB field (or whatever) up into multiple pages, there's no real way to do this without changing your database design to support multiple pages for articles. 🙁

I have to disagree on that one. Maybe from Mysql side you cannot determine how it comes, but from PHP-side you can manipulate the article in many ways.

For example, you could use your own made custom tags, just like in this forum theres

and

 etc.

For example you could make a tag [PAGE1]. You could use it like this

[PAGE1]
text blablabla blablabal text blablabla blablabal
text blablabla blablabal text blablabla blablabal

And when you want to start a new page add

[PAGE2]
text blablabla blablabal text blablabla blablabal
text blablabla blablabal text blablabla blablabal

... and so on. With those it is very easy to navigate from page to page. Just add a link to next page like 'www.yoursite.com/article.php?page=2'.

Ofcourse you have to do a parser for this to work, but thats nothing more than a few lines of code...

See what I mean?

toxic

Yes im with you 🙂 I have heard that its possible to mae your own tags.. but I havent got a idea how to make my own 🙁

Can u give an example or something that can help me ?

toxic

Damn it 🙁 Why cant people help me!

cahva

Sorry cant read this forum 24/7. I have a life too you know! 🙂

Anyway, I made this one specially for you. Try it out and you get the hang of it in no time.

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php
$originaltext="[PAGE1]
Bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla
bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla
bla bla bla bla bla bla bla bla.

[PAGE2]
Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test
Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test.

[PAGE3]
Bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla
bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla bla
bla bla bla bla bla bla bla bla.";

$total=substr_count($originaltext,"[PAGE");

if ($_POST['page'] && $_POST['page']<$total+1)
{
	$i=$_POST['page'];
}
else { $i=1; }

// Next page
$k=$i+1;

$page="[PAGE".$i."]";
$nextpage="[PAGE".$k."]";
$start=strpos($originaltext,$page);
$start=$start+strlen($page);
$end=strpos($originaltext,$nextpage);
$lenght=$end-($start+$pagesize);

if ($i==$total)
{
	$text=substr($originaltext,$start);
}
else 
{ 
	$text=substr($originaltext,$start,$lenght); 
}

// Add <br> at the end of lines
$text=str_replace("\n","<br>\n",$text);

echo 'Page:'.$i.' of '.$total.'<br>';
echo $text;
?>
<form name="form1" method="post" action="position.php">
  Insert pagenumber: 
  <input size="3" name="page" type="text" id="page">
</form>
</body>
</html>

toxic

He he I understand.. 🙂 I will try the script.

Jesteruk

You could do that, but it's kind of a messy way to do it if you ask me.

Someone could put:

[PAGE

In the article by pure accident and cause problems. Of course, you cold filter this out on article submission, but I don't like things done the "hacky" way.

I'd redesign the database. Though, on my site the articles aren't stored in the database, they're stored in files. The database stores the title, number of pages, ratings etc etc but the actual bulk of the tutorial is in a file. It made it easier to split up into pages and I didn't have to create 20 TEXT columns just to ensure I could always have enough pages for any tutorial.

But it's a good solution you came up with mate 🙂

toxic

I have used the script from Cahva with some modifications and it works just fine 🙂

It was a good way to make your own tag, thx for the tip!

toxic

The script works just fine.. but it makes space 🙁

When I make the pages.
EG.

[PAGE1]
text text text text text text text text
text text text text text text text text
text text text text text text text text
[PAGE2
text text text text text text text text
text text text text text text text text
text text text text text text text text

But when i read the pages it looks like this:

Newsline
(space)
text text text text text text text text
text text text text text text text text
text text text text text text text text

How do I get rid of the space? I want it to look like this:

Newsline
text text text text text text text text
text text text text text text text text
text text text text text text text text

cahva

Hmm... I made the script in hurry. But adding 1 to the $start variable will do the trick. I forgot that it also makes a hidden \n after [PAGE*]...

$start=$start+strlen($page)+1;

toxic

In a hurry.. then your very good at PHP!

I will try the add u have made to the script.

toxic

Hmm.. I still see the space 🙂 after I have edit line to

$start=$start+strlen($page)+1;

watch for your self 🙂
http://v2.frostland.dk/artikler-gruppe1/testafmellemrum.php?side=1

toxic

Shouldn´t i remove \n","<br>\n", from the line ?

$text=str_replace("\n","<br>\n",$text);

$text=str_replace($text);

cahva

Hmm... Dont change the str_replace line, because then the text would not have line-breaks at all. However, you can try what it does when you comment that str_replace line.

If it still gives you space between the title and the story, then you have error somewhere else. I checked the HTML-source and I see theres 2 <br>:s at the start of your story table. You propably have put <br> before printing $text.

Let me see a portion of the code where you print the headline and the story. I will propably see whats wrong in it.

But I cannot answer you today, because Im heading home now 🙁