Printing Avery Labels from a web site

[FredBear]

I am just coming to grips with php, Dreamweaver and MySQL and I want to make
a facility available for the members of the group I am creating my web site
for. I want them to be able to print-out a list of address labels, using
standard Avery labels, on their home PC's using the data from my MySQL
tables. I am not yet sufficiently au fait with php to manage to code it
myself so I wondered if anybody knew of any Dreamweaver extensions, add-ins
or tutorials which would do the trick. I have had a good look at what is on
the web but I can't find very much about it.

Any ideas?
--


(\__/)
(='.'=)
(")_(")

[Sean]

"FredBear" <ThisIsNotMyAddress@Yahoo.com> wrote in message
news:13290j3c18spc85@corp.supernews.com...

>I am just coming to grips with php, Dreamweaver and MySQL and I want to
>make a facility available for the members of the group I am creating my web
>site for. I want them to be able to print-out a list of address labels,
>using standard Avery labels, on their home PC's using the data from my
>MySQL tables. I am not yet sufficiently au fait with php to manage to code
>it myself so I wondered if anybody knew of any Dreamweaver extensions,
>add-ins or tutorials which would do the trick. I have had a good look at
>what is on the web but I can't find very much about it.
>
> Any ideas?
> --
>
>
> (\__/)
> (='.'=)
> (")_(")
>

Presumably you just need to create a HTML table to match the dimensions of
the labels, that can then be printed...... as you can specify the column
widths and row heights in cm this should be fairly easy to construct.

Adding code in PHP to create this on the fly from a database would also be
fairly easy, as you are only looping through a recordset to insert the data
into the cells of the table.

[Peter Fox]

Following on from Sean's message. . .

>
>Presumably you just need to create a HTML table to match the dimensions of
>the labels, that can then be printed...... as you can specify the column
>widths and row heights in cm this should be fairly easy to construct.

Is the wrong answer.

Use PDF

--
PETER FOX Not the same since the adhesive company came unstuck
[email]peterfox@eminent.demon.co.uk.not.this.bit.no.html[/email]
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

[Sanders Kaufman]

Peter Fox wrote:

> Following on from Sean's message. . .

>>
>> Presumably you just need to create a HTML table to match the
>> dimensions of
>> the labels, that can then be printed...... as you can specify the column
>> widths and row heights in cm this should be fairly easy to construct.

> Is the wrong answer.
>
> Use PDF

Using PDF's in place of web pages is a sure sign of a badly
designed web site.

I've had to disable PDF's in the web browser due to their
inappropriate use on a variety of web pages.

In computers older than 2 or 3 years, the sudden appearance of
embedded PDF's frequently cause the system to slow down or even
crash the browser.

The better solution is to use CSS with the media set to print.

[Sean]

"Peter Fox" <peterfox@eminent.demon.co.uk.not.this.bit.no.html > wrote in
message news:gO2Y2LAAFKJGFwvd@eminent.demon.co.uk...

> Following on from Sean's message. . .

>>
>>Presumably you just need to create a HTML table to match the dimensions of
>>the labels, that can then be printed...... as you can specify the column
>>widths and row heights in cm this should be fairly easy to construct.

> Is the wrong answer.
>
> Use PDF
>
> --
> PETER FOX Not the same since the adhesive company came unstuck
> [email]peterfox@eminent.demon.co.uk.not.this.bit.no.html[/email]
> 2 Tees Close, Witham, Essex.
> Gravity beer in Essex <http://www.eminent.demon.co.uk>

Wrong? ... How?

PDF is an alternative to HTML, I would agree ... and would even concede that
it's a better alternative, IF the guy can find (or be given) the appropriate
code examples to complete the task, but HTML wouldn't be "wrong",
particularly if he's new to the coding that it would take to complete the
job.

[Peter Fox]

Following on from Sean's message. . .

>
>"Peter Fox" <peterfox@eminent.demon.co.uk.not.this.bit.no.html > wrote in
>message news:gO2Y2LAAFKJGFwvd@eminent.demon.co.uk...

>> Following on from Sean's message. . .

>>>
>>>Presumably you just need to create a HTML table to match the dimensions of
>>>the labels, that can then be printed...... as you can specify the column
>>>widths and row heights in cm this should be fairly easy to construct.

>> Is the wrong answer.
>>
>> Use PDF
>>
>> --
>> PETER FOX Not the same since the adhesive company came unstuck
>> [email]peterfox@eminent.demon.co.uk.not.this.bit.no.html[/email]
>> 2 Tees Close, Witham, Essex.
>> Gravity beer in Essex <http://www.eminent.demon.co.uk>

>
>Wrong? ... How?

Try it yourself and you'll find out.

>
>PDF is an alternative to HTML, I would agree ... and would even concede that
>it's a better alternative, IF the guy can find (or be given) the appropriate
>code examples to complete the task, but HTML wouldn't be "wrong",
>particularly if he's new to the coding that it would take to complete the
>job.

HTML is not an alternative - it's a crap suggestion by somebody who
doesn't know what they're talking about.





--
PETER FOX Not the same since the exam marking business failed
[email]peterfox@eminent.demon.co.uk.not.this.bit.no.html[/email]
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>

[Sean]

>>Wrong? ... How?

> Try it yourself and you'll find out.

An HTML table to represent a sheet of Avery Labels (with PHP) could be done
in your sleep ... assuming that you have a "basic" knowledge of HTML and
PHP.

>>> Use PDF

Even with a PDF format you've still got to create some sort of table or
something in columns to match the layout.

>>PDF is an alternative to HTML, I would agree ... and would even concede
>>that
>>it's a better alternative, IF the guy can find (or be given) the
>>appropriate
>>code examples to complete the task, but HTML wouldn't be "wrong",
>>particularly if he's new to the coding that it would take to complete the
>>job.

> HTML is not an alternative - it's a crap suggestion by somebody who
> doesn't know what they're talking about.

There's nothing like being constructive ... and that's nothing like
constructive.

[Jerry Stuckle]

Sean wrote:

>>> Wrong? ... How?

>

>> Try it yourself and you'll find out.

>
> An HTML table to represent a sheet of Avery Labels (with PHP) could be done
> in your sleep ... assuming that you have a "basic" knowledge of HTML and
> PHP.
>

>>>> Use PDF

>
> Even with a PDF format you've still got to create some sort of table or
> something in columns to match the layout.
>

>>> PDF is an alternative to HTML, I would agree ... and would even concede
>>> that
>>> it's a better alternative, IF the guy can find (or be given) the
>>> appropriate
>>> code examples to complete the task, but HTML wouldn't be "wrong",
>>> particularly if he's new to the coding that it would take to complete the
>>> job.

>

>> HTML is not an alternative - it's a crap suggestion by somebody who
>> doesn't know what they're talking about.

>
> There's nothing like being constructive ... and that's nothing like
> constructive.
>
>
>

Sean,

The problem with HTML is it is a fluid layout, and he needs an
absolutely fixed one.

For instance, the user may not be using the default font size - on my
laptop with a high res screen, I use a larger than normal font. On my
desktop with it's 21" screen, I use a smaller than normal font. And my
default printer font is not the same.

Also, the printer size probably isn't exactly 8.5"x11" (assuming U.S.).
Most printers have an unprintable margin - and this margin varies in
size. The browser may attempt to shrink the page to fit in the margins,
or it may let the page overflow to the next one.

Lots of things like this can happen when you're using html. You can try
to force some of them - but html is only a *recommendation* on how to
display the page, not a *requirement*. You can't be sure you've got it
right.

A PDF, OTOH, is an exact layout and you can control the look of
everything to a very fine level. It's a much superior way to go when
you need exact placement like this.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[email]jstucklex@attglobal.net[/email]
==================

[Rami Elomaa]

Sean kirjoitti:

> "Peter Fox" <peterfox@eminent.demon.co.uk.not.this.bit.no.html > wrote in
> message news:gO2Y2LAAFKJGFwvd@eminent.demon.co.uk...

>> Following on from Sean's message. . .

>>> Presumably you just need to create a HTML table to match the dimensions of
>>> the labels, that can then be printed...... as you can specify the column
>>> widths and row heights in cm this should be fairly easy to construct.

>> Is the wrong answer.
>>
>> Use PDF
>>
>> --
>> PETER FOX Not the same since the adhesive company came unstuck
>> [email]peterfox@eminent.demon.co.uk.not.this.bit.no.html[/email]
>> 2 Tees Close, Witham, Essex.
>> Gravity beer in Essex <http://www.eminent.demon.co.uk>

>
> Wrong? ... How?
>
> PDF is an alternative to HTML, I would agree ... and would even concede that
> it's a better alternative, IF the guy can find (or be given) the appropriate
> code examples to complete the task, but HTML wouldn't be "wrong",
> particularly if he's new to the coding that it would take to complete the
> job.

I would agree that pdf in this case would be more suited, since it's
better suited for printing than html. With pdf you can define better the
layout of the print, with html the results aren't as precise. Html is
suitable for publishing material that looks good or at least acceptable
in most media (screen, print, handheld, etc.). When the target medium is
print, then pdf is absolutely the best choice, because it's intended to
be used in printing. Furthermore, pdf is not an alternative to html.
They do have similarities, like they both are ways of presenting a
document, but they are suited for different media.

--
[email]Rami.Elomaa@gmail.com[/email]

"Wikipedia on vähän niinq internetin raamattu, kukaan ei pohjimmiltaan
usko siihen ja kukaan ei tiedä mikä pitää paikkansa." -- z00ze

[Michael Daly]

Sean wrote:

>> HTML is not an alternative - it's a crap suggestion by somebody who
>> doesn't know what they're talking about.

>
> There's nothing like being constructive ... and that's nothing like
> constructive.

Pdf is a better alternative - it's too bad that some people don't have
the communication skills required to say that without sounding like an
ass. But I guess an ass is bigger than a fox and that's what he values.

Mike

[Steve]

| Pdf is a better alternative - it's too bad that some people don't have
| the communication skills required to say that without sounding like an
| ass.

or he spoke his mind - 'ass' being relative to one's own sensitivity...which
i've already stated, more and more skins are thinning every day. buck up! i
believe he said almost word for word, 'pdf is a better alternative'...if no
one else got that because they got their feelings hurt, cry to momma.

jesus christ!

and quit it with the fucking cross posting...do you really think that
alt.php.sql could give a rat's ass about a presentation layer question?!!!

[Michael Daly]

Steve wrote:

> | Pdf is a better alternative - it's too bad that some people don't have
> | the communication skills required to say that without sounding like an
> | ass.
>
> believe he said almost word for word, 'pdf is a better alternative'

What he wrote _exactly_ (you can check it yourself) was

> > it's a crap suggestion by somebody who doesn't know what
> > they're talking about.

If you think that's effective communication, then you're no doubt the
same kind of ass.

> and quit it with the fucking cross posting...do you really think that
> alt.php.sql could give a rat's ass about a presentation layer question?!!!

cry to momma.

Cheers,
Mike

[Steve]

"Michael Daly" <MichaelDaly@foo.bar> wrote in message
news:JeydneKW2Yrv1rjbnZ2dnUVZ_j6dnZ2d@magma.ca...
| Steve wrote:
| > | Pdf is a better alternative - it's too bad that some people don't have
| > | the communication skills required to say that without sounding like an
| > | ass.
| >
| > believe he said almost word for word, 'pdf is a better alternative'
|
| What he wrote _exactly_ (you can check it yourself) was

what he wrote _exactly_ (you can check it yourself) was

'Use PDF'

in his first reply.

second reply...


| > > it's a crap suggestion by somebody who doesn't know what
| > > they're talking about.

and he's right.

| If you think that's effective communication, then you're no doubt the
| same kind of ass.

let's see, if 'crap' is offensive and 'doesn't know what they're talking
about' is too, would it be best - since everyone is so fucking
think-skinned - to say:

i'm so terrible sorry you're under the impression that html is less
problematic, even advantagous, to use in lieu of pdf. perhaps you simply
have overlooked some very important details that i will outline now...as
others have done, oh dear boy.

BULLSHIT !!! effective communication is like wit; the more direct and simply
stated, the more effective. sorry, sean obviously wants to stay in his
comfort zone by boasting of html, states he doesn't know how to generate
pdf's, yet 'thinks' he can be objective in his opinion without understanding
the benefits/detriments of *both*. THAT is bullshit...which leads to the
truth in:

| > > it's a crap suggestion by somebody who doesn't know what
| > > they're talking about.

'crap' by any other name? does sean know what he's talking about?

sorry...fox is right.

| > and quit it with the fucking cross posting...do you really think that
| > alt.php.sql could give a rat's ass about a presentation layer
question?!!!
|
| cry to momma.

exactly...lead the way, moron!

[Jerry Stuckle]

Michael Daly wrote:

> Steve wrote:

>> | Pdf is a better alternative - it's too bad that some people don't have
>> | the communication skills required to say that without sounding like an
>> | ass.
>>
>> believe he said almost word for word, 'pdf is a better alternative'

>
> What he wrote _exactly_ (you can check it yourself) was
>

> > > it's a crap suggestion by somebody who doesn't know what
> > > they're talking about.

>
> If you think that's effective communication, then you're no doubt the
> same kind of ass.
>
>

>> and quit it with the fucking cross posting...do you really think that
>> alt.php.sql could give a rat's ass about a presentation layer
>> question?!!!

>
> cry to momma.
>
> Cheers,
> Mike

Mike,

Don't worry about the reject from alt.anal.orifices. He's just a troll.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[email]jstucklex@attglobal.net[/email]
==================

[FredBear]

Thanks for all the input, People, but I am now running out of the will to
live reading through it all so I have devised a new strategy.

I am going to do a mail merge in MS Word and upload it to my web site each
time I add a new name to the database.

The users can then print their Avery address labels straight from the Word
Document. Not an entirely elegant solution but one which will work.


(\__/)
(='.'=)
(")_(")

[Steve]

"FredBear" <ThisIsNotMyAddress@Yahoo.com> wrote in message
news:132bv2dffo07325@corp.supernews.com...
| Thanks for all the input, People, but I am now running out of the will to
| live reading through it all so I have devised a new strategy.
|
| I am going to do a mail merge in MS Word and upload it to my web site each
| time I add a new name to the database.
|
| The users can then print their Avery address labels straight from the Word
| Document. Not an entirely elegant solution but one which will work.

if you're server is windows and you have office installed, just use COM()
and create a word object. perform whatever operations need to take place.
then, set the headers appropriately for the browser and echo word's results.
you don't need to break out of php to do any of that.

cheers.

[PA Bear]

On Tue, 17 Apr 2007 20:01:26 -0500, "Steve" <no.one@example.com>
wrote:

>"Michael Daly" <MichaelDaly@foo.bar> wrote in message
>news:JeydneKW2Yrv1rjbnZ2dnUVZ_j6dnZ2d@magma.ca. ..
>| Steve wrote:
>| > | Pdf is a better alternative - it's too bad that some people don't have
>| > | the communication skills required to say that without sounding like an
>| > | ass.
>| >
>| > believe he said almost word for word, 'pdf is a better alternative'
>|
>| What he wrote _exactly_ (you can check it yourself) was
>
>what he wrote _exactly_ (you can check it yourself) was
>
>'Use PDF'
>
>in his first reply.
>
>second reply...
>
>
>| > > it's a crap suggestion by somebody who doesn't know what
>| > > they're talking about.
>
>and he's right.
>
>| If you think that's effective communication, then you're no doubt the
>| same kind of ass.
>
>let's see, if 'crap' is offensive and 'doesn't know what they're talking
>about' is too, would it be best - since everyone is so fucking
>think-skinned - to say:
>
>i'm so terrible sorry you're under the impression that html is less
>problematic, even advantagous, to use in lieu of pdf. perhaps you simply
>have overlooked some very important details that i will outline now...as
>others have done, oh dear boy.
>
>BULLSHIT !!! effective communication is like wit; the more direct and simply
>stated, the more effective. sorry, sean obviously wants to stay in his
>comfort zone by boasting of html, states he doesn't know how to generate
>pdf's, yet 'thinks' he can be objective in his opinion without understanding
>the benefits/detriments of *both*. THAT is bullshit...which leads to the
>truth in:
>
>| > > it's a crap suggestion by somebody who doesn't know what
>| > > they're talking about.
>
>'crap' by any other name? does sean know what he's talking about?
>
>sorry...fox is right.
>
>| > and quit it with the fucking cross posting...do you really think that
>| > alt.php.sql could give a rat's ass about a presentation layer
>question?!!!
>|
>| cry to momma.
>
>exactly...lead the way, moron!
>

We must all hope you get better quite soon.
Robear Dyer (PA Bear)
MS MVP-Windows (IE, OE, Security, Shell/User)
AumHa VSOP & Admin; DTS-L.org

[Steve]

| >| > and quit it with the fucking cross posting...do you really think that
| >| > alt.php.sql could give a rat's ass about a presentation layer
| >question?!!!
| >|
| >| cry to momma.
| >
| >exactly...lead the way, moron!
| >
|
| We must all hope you get better quite soon.
| Robear Dyer (PA Bear)

oh robear...yet another. lest i say it again, the opportunists who show up
at a feeding frenzy come bearing teeth. i believe you left your too, in the
small cup of water on the sink in your bathroom. not only did you leave your
teeth, you are how many days late? this thread has been dead for quite some
time. does that mean you only eat off scraps? no, i imagine you are a bottom
feeder - requiring neither teeth nor timing.

:)