page breaks & a multiple page merged doc.

Hello all ,

I am querying a mysql db and able to get the records out. I can populate the tbs block OK but  I want each record to occur
*** ON A NEW PAGE ***. At the moment its coming out in the table going down as a list on 1 page.
Could anyone edit the code I've supplied to include the page break (section break?) whatever is needed so that the pref_name and the surname occur at the top of every page. ie if there is 10 records the following code needs to produce a 10page openoffice download.

Here is the OO template that lives on the server. I think the page break needs to go in here somewhere:



Here is the php code to produce the OpenOffice download (OO)



BTW is the way I have made the associative array $f[] the only way to get the fields out of the db?  Cant I get them out straight away since  $row[] is already an associative array? (ie is there the need to create $f[]?)

Thanks in advance
sam

Hello Sam,

There are 2 methods to make page-break in OO text document for each row.

1/ Define the start and the end of the block (explicit syntax) with a PAGE BREAK inside the block

[BlockName;block=begin]
[BlockName.data1] [BlockName.data2]
PAGE-BREAK
[BlockName;block=end]

The TBS tags for the block definition will be deleted during the merging.

When the OOo document will be merge, you'll get a new page for each row, but it still remain a blank page at the end.

2/ Create a table with one row and one colum in your document.
Fix the height of the row to be more than the half the page height

When the OOo document will be merge, you'll get a row on each page with no blank page at the end

3/ I have heard about an another method, I've to ask to Skrol who made it.

Olivier

BTW : You don't have to pass the result from the query fetch in a array, you can merge block directly from a SQL request

Thanks for replying Olivier.
I'm working through your suggestions.

Firstly No 1
-----------
The code I used is as yours:

But the PAGE-BREAK is coming up as text all on 1 page, rather than a page break:

1 Rosie Abel
PAGE-BREAK

2 Breeanna Adams
PAGE-BREAK

3 Dave Adams
PAGE-BREAK
etc

Am I being silly or did you mean I should actually put a page break in via OO's insert->manual break->page break
OR is PAGE-BREAK not correct?

thanks sam

Hello Sam,

As you said, you have to make a page break via insert->manual break->page break

Olivier

Weird things.
First it worked! Excellent I thought it was solved.
ie It worked OK for about 5 merges giving outputs on new pages. (only did limit 10 so 10page docs)

then the error:


I've tried it on another machine as well (both OpenOffice 2.0beta)

Now only the error occurs on both machines

sam

Hello Sam,

I sent to you a demo.sxw and a demo.php which show how to do this using OO sections.
Didn't you get them ?

No,
the only emails I have got are from the postings from this forum.
Please send again:
sam@rwb.com.au

Great stuff all is now working.
Ignore the read error from previous posting
I did the odt file from scratch and its working perfectly.
the code:
works nicely now.

The php code:
works with it.

Thanks for all your help indeed!
sam

BTW
I did read the class does not support dynamic images.
If my table has the location (relative) of the image of each person [BlockName.imagepath]
How can I get the image of each person on each page?

OK, I've tried but cannot do.
I have a mysql table with 5 school classes each with different number of students in each class.
Lets say:
class 1  has 15 students (fname,surname)
class 2  has 18 students (fname,surname)
class 3  has 22 students (fname,surname)
class 4  has 17 students (fname,surname)
class 5  has 20 students (fname,surname)

I'd like to merge them and put each class on a seperate page.
ie:
page 1 has class1 with a table of 15 rows down it
page 2 has class2 with a table of 18 rows down it
page 3 has class3 with a table of 22 rows down it
page 4 has class4 with a table of 17 rows down it
page 5 has class5 with a table of 20 rows down it

ie a 5 page openoffice doc.

I've tried using sublocks but still only get the one page (+1 page break as well=2page doc)


The main codin in the php file is:

Any help would be appreciated

Thanks sam

Je suis très interessé par les exemples en question.
Si c'est possible, merci de me les envoyer.

I post here the source of the content.xml subfile file for an ODT document which displays one rox per page using the section technique.
With this technique, the very first page is always blank. We can play to have the very last page blank instead.