Divide text to pages?

[ameenov]

How can I divide text from database into pages?

Like what some websites do to split articles into pages!

can anybody show me the way to do it?

[devinemke]

you didn't mention which RDBMS you are using but most all of them have string fucntions that can split data up into parts. for example, look at mySQL's String Functions, specifically SUBSTRING.

[ameenov]

What do you mean of "RDBMS"?

I hope that I can find some tutorials about that 🙂

Thanks in advance

[devinemke]

ameenov wrote:

What do you mean of "RDBMS"?

RDBMS

[ameenov]

I didn't know the short cut

Im using "MySQL"

[Vegeta01]

Maybe using wordwrap .. and inserting HTML with the break parameter?!

[ameenov]

Thank you Vegeta01 for the suggestion 🙂

I will try it ..

But look to the code I made 🙂
I used (strlen & substr)

---

It cuts the words from the middle sometimes...

for example:
If the santace like that

We will go to the beach.

and I specified 5 characters to be display in each page ..
It will show like that ..

We wi

and in the next page it will show the next 5 characters

---

The code:

<?php
if(!isset($_GET['page'])){ 
    $page = 1; 
} else { 
    $page = $_GET['page']; 
} 

// Define the number of results per page 
$max_results = 10; 

// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 

// Perform MySQL query on only the current page number's results 


////////////////////////////////////////////////

$text = "I need to make a pagination to this text without cutting the words but cutting from the spaces";
// give var


////////////////////////// END text cut function 2 /////////////////////// 

echo substr($text, $from,$max_results); 
/////////////////////////
// Figure out the total number of results in DB: 
$total_results = strlen ($text);

// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 

// Build Page Number Hyperlinks 
echo "<center>Select a Page<br />"; 

// Build Previous Link 
if($page > 1){ 
    $prev = ($page - 1); 
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a> "; 
} 

for($i = 1; $i <= $total_pages; $i++){ 
    if(($page) == $i){ 
        echo "$i "; 
        } else { 
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; 
    } 
} 

// Build Next Link 
if($page < $total_pages){ 
    $next = ($page + 1); 
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>"; 
} 
echo "</center>";
?>

[ameenov]

up ^_

[cedricm]

I have a system like perhaps you want in my site, I have inserted in my text where I want to cut IT a specific content like: <!--pagebreak--> and then using an explode.

$desc_fr = txt file content
$contentpage = explode( "<!--pagebreak-->", $desc_fr );

$pageno = count($contentpage);
    if ( $page=="" || $page < 1 )
	$page = 1;
    if ( $page > $pageno )
	$page = $pageno;
    $arrayelement = (int)$page;
    $arrayelement --;

echo "$contentpage[$arrayelement]";
  if($page >= $pageno) {
	  $next_page = "";
    } else {
	$next_pagenumber = $page + 1;
	if ($page != 1) {
	    $next_page .= "";
	}
$next_page .="<br><a href=\"page.php?page=$next_pagenumber\">Suite ($next_pagenumber/$pageno)</a>";
    }

if($page <= 1) {
	$previous_page = "";
    } else {
	$previous_pagenumber = $page - 1;
	$previous_page = "<br><a href=\page.php?page=$previous_pagenumber\">Page précédente ($previous_pagenumber/$pageno)</a>";
    }
echo"$previous_page $next_page";

[ameenov]

cedricm ^_

Great Code
Thank you
It's helpful

[btree]

Also you can use some exist tools to split and concatenate any text , you will find a great one here :

http://www.smartvi.com

Thanks