Divind text into pages - help!

[zonkd]

After hours of not much success ... I need the longer text in the mysql db field 'story' to appear in pages. This code (just the necessary part here) works for one field. But I think I really need to have several fields stated - although only 'story' has the text that needs splitting.

How should this code be adapted please to allow all the fields in each record to be displayed - I mean where would I put the field 'heading', and 'byline', and 'updated', p l e a s e Experts ....

Quote:

$id = $_GET['id'];
$a = @("SELECT
id,
story
FROM connex
WHERE id='$id'");
$a = mysql_fetch_array($a);
$b = $a['story'];

// If no page specified, default to the first page ($page = 0)
if (!isset($GET['page'])) {
$page = 0;
} else {
$page = $GET['page'];
}

// Split the text into an array of pages
$textarray = spliti('[PAGEBREAK]', $b);

// Select the page wanted
$b = $textarray[$page];

$PHP_SELF = $_SERVER['PHP_SELF'];

[bogu]

Now this is a very interesting problem, but I don’t think that someone is actually give u the algorithm for this....

So let me try to help u with an algorithm...

Try to split your algorithm into steps, something like:

1. First of all u need to determine how many rows one page can have
2. How many characters one row can have

After u determine this, u try creating the algorithm:

1. First of all u split your hole text by end of line and u know that those are definitely rows
2. Then u check how many characters your rows have
3. If your row is bigger then your maximum characters you increment your total rows number
4. When u determine the number of all the rows u got, u can find out how many pages u have
5. Now u split your text into pages

Is not easy to do all this but is an ideea.

Have fun codding. 😃

[zonkd]

bogu
Cheers. I follow you, but with spliti I choose where I want the text to split with the word [pagebreak]. This works fine.

But it seems to me that I should involve the other fields in the record.

Well, it's new to me, and perhaps I don't need to.

Ideally, I would have this on the php page that draws all the stories - and I would use your idea (with something like substring perhaps, and suggest so many characters in ... or every 9th sentence break) ... but, well, that would be after solving this simple arrangement.

[zonkd]

That's a very attractive website, bogu. All your own design?

[bogu]

Thanks man.

But I'm a php coder, so the design is not mine, but a friend of mine made it for me (and yes is all his own design); his site is writen in my site footer; I love it too, because is unic. 🙂

Right now I dont have time to work on my site, I want to make a tutorial part and I think your ideea is preaty interesting...

[zonkd]

Your designer has done you a great favour, bogu. It is really attractive, and very subtle. Yes, you must get busy on it, and getting a few tutorials on there is an excellent idea. (We aspiring coders need lots of help!)
PHP sites often tend to be subtle and sophisticated. Congratulations.

This is what I am trying to do. 'id=10' is the record with the pagebreaks. This doesn't work yet, but it seems I am not far away. If you can spot the fault(s), I'd be really very pleased.

if( isset($_GET['id']))  

				{
				$id = $_GET['id']; 	
				$result = mysql_query("SELECT 
									sub,
									head,
									pix, 
									intro,
									story,
									byline,
									link,
									DATE_FORMAT(updated, '%d/%m/%y %H%i') as ud
									FROM connex
									WHERE id=$id
											");
				$myrow = mysql_fetch_array($result);
				if ($_GET['id'] == 10)
				{
				$story = $result['story'];
				// If no page specified, default to the first page ($page = 0)
										if (!isset($_GET['page'])) {
										  $page = 0;
										} else {
										  $page = $_GET['page'];
										}
						// Split the text into an array of pages
										$textarray = spliti('\[PAGEBREAK]', $story);
						// Select the page we want
										$story = $textarray[$page];
						$PHP_SELF = $_SERVER['PHP_SELF'];
						if ($page != 0) {
						  $prevpage = $page - 1;
						  echo "<p><a href=\"$PHP_SELF?id=$id&amp;page=$prevpage\">".
							  'Previous Page</a></p>';
						}
						//echo "<p>$b</p>";
						//+ + + + + + + + + + + + id 10  +
				//these are the stories on the other pages 
				if ($myrow["sub"])	printf("<h6 class=\"guard\">%s\n</h6>", $myrow["sub"]);
				 // 11/3/06 if ($myrow["sub"])	printf("<div class=\"Subheads\">%s\n</div>", $myrow["sub"]);
				if ($myrow["intro"])printf("<div class=\"intro\">%s\n</div>", $myrow["intro"]);  						
				if ($myrow["head"])	printf("<h4>%s\n</h4>", $myrow["head"]);
				if ($myrow["pix"])  printf("<img src=\"images  %s", $myrow["pix"]);
						printf(" %s\n<br>", $myrow["story"]); 
						//+ + + + + + + + + + + + +
						if ($myrow["byline"])  printf("<div class=\"names2\">-  %s</div>", $myrow["byline"]); 
						printf("<div id=\"date2\"> Updated: %s</div><p>",$myrow["ud"]);
				//10/3/06  = = = = =    I N C L U D E S  F O R  L I N K S 
					echo '<p></p>';
					include "contact_expert.inc.php";
					include "work_chances.inc.php";
						if ($page < count($textarray) - 1) {
						  $nextpage = $page + 1;
						  echo "<p><a href=\"$PHP_SELF?id=$id&amp;page=$nextpage\">".
							  'Next Page</a></p>';
						}
				}
				}
				//==================================================
				elseif($_GET['id'] == 1) { 
etc etc (elseifs for other record IDs.)