[gentoo-user] Printing phpmyadmin output

[gentoo-user] Printing phpmyadmin output

[Peter Humphrey]

Hello list,

I've a weird one here. I'm rebuilding my local server on an Atom N270 box and 
I've reached the point of installing phpmyadmin on it to manage a MySQL database 
I'm developing.

Three different browsers have no trouble displaying table structures, data, the 
database design and the data dictionary, but when it comes to printing anything 
from phpmyadmin they all refuse to believe that more than one page exists. They 
will print other multi-page sites but not this one.

Can anyone throw any light on this? I've remerged apache, php and phpmyadmin 
with no effect.

-- 
Rgds
Peter

Re: [gentoo-user] Printing phpmyadmin output

[Mick]

On 12 April 2011 16:52, Peter Humphrey <peter@humphrey.ukfsn.org> wrote:
> Hello list,
>
> I've a weird one here. I'm rebuilding my local server on an Atom N270 box and
> I've reached the point of installing phpmyadmin on it to manage a MySQL database
> I'm developing.
>
> Three different browsers have no trouble displaying table structures, data, the
> database design and the data dictionary, but when it comes to printing anything
> from phpmyadmin they all refuse to believe that more than one page exists. They
> will print other multi-page sites but not this one.
>
> Can anyone throw any light on this? I've remerged apache, php and phpmyadmin
> with no effect.

I can't access a phpmydamin page at this moment to check, but what you
want is a suitable CSS sheet for printing.  I assume that the page
uses frames and the current print configuration (or lack of it) does
not include the frame that you wish to print.  You'll need to poke
around the phpmyadmin fs to find css files and see what is defined
where.  It may also be possible to hardcode it in the .php
configuration file of phpmyadmin.

-- 
Regards,
Mick

Re: [gentoo-user] Printing phpmyadmin output

[Peter Humphrey]

On Wednesday 13 April 2011 12:25:01 Mick wrote:

> I assume that the page uses frames and the current print configuration (or lack
> of it) does not include the frame that you wish to print.

Nice idea, but from the print preview it appears that part of the frame is 
included, but not its overflow onto succeeding pages.

> You'll need to poke around the phpmyadmin fs to find css files and see what is
> defined where.  It may also be possible to hardcode it in the .php configuration
> file of phpmyadmin.

OK. I'll have a poke around. Thanks for the idea.

-- 
Rgds
Peter

Re: [gentoo-user] Printing phpmyadmin output

[Mick]

On 13 April 2011 14:33, Peter Humphrey <peter@humphrey.ukfsn.org> wrote:
> On Wednesday 13 April 2011 12:25:01 Mick wrote:
>
>> I assume that the page uses frames and the current print configuration (or lack
>> of it) does not include the frame that you wish to print.
>
> Nice idea, but from the print preview it appears that part of the frame is
> included, but not its overflow onto succeeding pages.
>
>> You'll need to poke around the phpmyadmin fs to find css files and see what is
>> defined where.  It may also be possible to hardcode it in the .php configuration
>> file of phpmyadmin.
>
> OK. I'll have a poke around. Thanks for the idea.


I assume that you use the "Print view" button at the bottom of the tables.

I've just looked at this demo site using print preview in Firefox and Opera:

http://demo.phpmyadmin.net/STABLE/index.php

FF will only show the first page of a table - this to me translates to
a poorly written CSS for printing purposes, or lack of a print-CSS
altogether.

In Opera the first print preview page is blank.  If I click on the
print preview icon on the toolbar it will switch between successive
frames.  The 3rd frame contains the table across 3 pages, so it should
print the lot.  The CSS is not well written though because e.g. there
is a blank page between the 1st page which just contains a header and
the third page which starts right from the top (no margin) with the
table.

Now, Opera is not the best browser for printing, especially so over
the few previous versions, so YMMV.  I haven't tried with Konqueror,
which also has the Print Frame option and may be able to isolate the
frame with the tables.
-- 
Regards,
Mick

Re: [gentoo-user] Printing phpmyadmin output

[Peter Humphrey]

On Wednesday 13 April 2011 15:58:46 Mick wrote:

> I assume that you use the "Print view" button at the bottom of the tables.

Ah! I hadn't spotted it; that does work - it prints one table description per 
page.

> I've just looked at this demo site using print preview in Firefox and
> Opera:
> 
> http://demo.phpmyadmin.net/STABLE/index.php
> 
> FF will only show the first page of a table - this to me translates to
> a poorly written CSS for printing purposes, or lack of a print-CSS
> altogether.

I've filed a bug report; let's see what comes of it. It's phpmyadmin-
Bugs-3286026.

> In Opera the first print preview page is blank.  If I click on the
> print preview icon on the toolbar it will switch between successive
> frames.  The 3rd frame contains the table across 3 pages, so it should
> print the lot.  The CSS is not well written though because e.g. there
> is a blank page between the 1st page which just contains a header and
> the third page which starts right from the top (no margin) with the
> table.

I've tried Opera and Chrome; Chrome does the same as Firefox while Opera shows 
one line giving the phpMyAdmin location and version number.

-- 
Rgds
Peter

Re: [gentoo-user] Printing phpmyadmin output

[Mick]

[-- Attachment #1: Type: Text/Plain, Size: 1409 bytes --]

On Wednesday 13 April 2011 17:55:24 Peter Humphrey wrote:
> On Wednesday 13 April 2011 15:58:46 Mick wrote:
> > I assume that you use the "Print view" button at the bottom of the
> > tables.
> 
> Ah! I hadn't spotted it; that does work - it prints one table description
> per page.
> 
> > I've just looked at this demo site using print preview in Firefox and
> > Opera:
> > 
> > http://demo.phpmyadmin.net/STABLE/index.php
> > 
> > FF will only show the first page of a table - this to me translates to
> > a poorly written CSS for printing purposes, or lack of a print-CSS
> > altogether.
> 
> I've filed a bug report; let's see what comes of it. It's phpmyadmin-
> Bugs-3286026.
> 
> > In Opera the first print preview page is blank.  If I click on the
> > print preview icon on the toolbar it will switch between successive
> > frames.  The 3rd frame contains the table across 3 pages, so it should
> > print the lot.  The CSS is not well written though because e.g. there
> > is a blank page between the 1st page which just contains a header and
> > the third page which starts right from the top (no margin) with the
> > table.
> 
> I've tried Opera and Chrome; Chrome does the same as Firefox while Opera
> shows one line giving the phpMyAdmin location and version number.

Yes, Opera's printing is a bit buggy in general compared to other browsers.
-- 
Regards,
Mick

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] Printing phpmyadmin output

[Mick]

[-- Attachment #1: Type: Text/Plain, Size: 1916 bytes --]

On Wednesday 13 April 2011 19:54:51 Mick wrote:
> On Wednesday 13 April 2011 17:55:24 Peter Humphrey wrote:
> > On Wednesday 13 April 2011 15:58:46 Mick wrote:
> > > I assume that you use the "Print view" button at the bottom of the
> > > tables.
> > 
> > Ah! I hadn't spotted it; that does work - it prints one table description
> > per page.
> > 
> > > I've just looked at this demo site using print preview in Firefox and
> > > Opera:
> > > 
> > > http://demo.phpmyadmin.net/STABLE/index.php
> > > 
> > > FF will only show the first page of a table - this to me translates to
> > > a poorly written CSS for printing purposes, or lack of a print-CSS
> > > altogether.
> > 
> > I've filed a bug report; let's see what comes of it. It's phpmyadmin-
> > Bugs-3286026.
> > 
> > > In Opera the first print preview page is blank.  If I click on the
> > > print preview icon on the toolbar it will switch between successive
> > > frames.  The 3rd frame contains the table across 3 pages, so it should
> > > print the lot.  The CSS is not well written though because e.g. there
> > > is a blank page between the 1st page which just contains a header and
> > > the third page which starts right from the top (no margin) with the
> > > table.
> > 
> > I've tried Opera and Chrome; Chrome does the same as Firefox while Opera
> > shows one line giving the phpMyAdmin location and version number.
> 
> Yes, Opera's printing is a bit buggy in general compared to other browsers.

... and I was just advised by my other half (a web developer) that FF will 
follow a print-CSS if one is there, otherwise will follow the HTML code which 
may contain the frame and specify it to the size of the screen.  Hence, 
subsequent pages do not print.

You can't win!  ;-)

BTW, I don't know what Firefox 4 does, I haven't yet tried it out.  It may 
print things differently.
-- 
Regards,
Mick

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] Printing phpmyadmin output

[Peter Humphrey]

On Wednesday 13 April 2011 20:14:16 Mick wrote:

> ... and I was just advised by my other half (a web developer) that FF will
> follow a print-CSS if one is there, otherwise will follow the HTML code
> which may contain the frame and specify it to the size of the screen. 
> Hence, subsequent pages do not print.

So I'm going to have to rely on phpMyAdmin's built-in print script to print the 
data dictionary. Not really a problem now that you've pointed it out to me.

> You can't win!  ;-)

Just standing still is sometimes hard, as I'm sure Dale will attest.

> BTW, I don't know what Firefox 4 does, I haven't yet tried it out.  It may
> print things differently.

Sufficient unto the day [...] thereof.

-- 
Rgds
Peter

Re: [gentoo-user] Printing phpmyadmin output

[Stroller]

On 13/4/2011, at 8:14pm, Mick wrote:
>>> ...
>>> I've tried Opera and Chrome; Chrome does the same as Firefox while Opera
>>> shows one line giving the phpMyAdmin location and version number.

Works fine in Safari here. Maybe you could try another Webkit-based browser? Konqueror, maybe?

> ... and I was just advised by my other half (a web developer) that FF will 
> follow a print-CSS if one is there, otherwise will follow the HTML code which 
> may contain the frame and specify it to the size of the screen.

Have you guys tried right-clicking within the frame and "open frame in new window", then printing?

Stroller.

Re: [gentoo-user] Printing phpmyadmin output

[Mick]

On 14 April 2011 07:03, Stroller <stroller@stellar.eclipse.co.uk> wrote:
>
> On 13/4/2011, at 8:14pm, Mick wrote:
>>>> ...
>>>> I've tried Opera and Chrome; Chrome does the same as Firefox while Opera
>>>> shows one line giving the phpMyAdmin location and version number.
>
> Works fine in Safari here. Maybe you could try another Webkit-based browser? Konqueror, maybe?
>
>> ... and I was just advised by my other half (a web developer) that FF will
>> follow a print-CSS if one is there, otherwise will follow the HTML code which
>> may contain the frame and specify it to the size of the screen.
>
> Have you guys tried right-clicking within the frame and "open frame in new window", then printing?

Yes!  :-)  I forgot to try the obvious ...

Peter, if you right-click and select to see the frame in question
(while in 'Print View') and then select Print Preview in Firefox, you
can see all pages that the tables will spread across.

Thanks Stroller for pointing this out.
-- 
Regards,
Mick

Re: [gentoo-user] Printing phpmyadmin output

[Peter Humphrey]

On Thursday 14 April 2011 11:20:51 Mick wrote:

> > Have you guys tried right-clicking within the frame and "open frame in
> > new window", then printing?
> 
> Yes!  :-)  I forgot to try the obvious ...

Hmm. Well, it may be obvious to you, but it isn't obvious to me that the page 
even uses frames, never mind how to print them.

> Peter, if you right-click and select to see the frame in question
> (while in 'Print View') and then select Print Preview in Firefox, you
> can see all pages that the tables will spread across.

Actually I right-clicked in the original page and selected "Open in new tab". I 
got the same output as I get by clicking the Print button at the bottom of the 
original page, so I suppose we now know what that button does.

> Thanks Stroller for pointing this out.

Indeed.

-- 
Rgds
Peter

Re: [gentoo-user] Printing phpmyadmin output

[Mick]

[-- Attachment #1: Type: Text/Plain, Size: 726 bytes --]

On Thursday 14 April 2011 11:44:49 Peter Humphrey wrote:
> On Thursday 14 April 2011 11:20:51 Mick wrote:

> > Peter, if you right-click and select to see the frame in question
> > (while in 'Print View') and then select Print Preview in Firefox, you
> > can see all pages that the tables will spread across.
> 
> Actually I right-clicked in the original page and selected "Open in new
> tab". I got the same output as I get by clicking the Print button at the
> bottom of the original page, so I suppose we now know what that button
> does.

Not exactly ... the 'Print View' button uses a different stylesheet, but yes 
it has the same effect of making all pages of the table printable. 

-- 
Regards,
Mick

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]