Labels

[Blutch]

Is it possible to create a php page with labels on them 3 width and 6 heigh, and putting info from a MySQL database on them, so users can print labels right from the net??

 

[sleipnir214]

Yes, it is possible to do that.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

Sorry. I couldn't resist.

Anything you can output to the browser, your users can print. Printing from a web browser is problematic, though. No two browsers print a web page the same way.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Blutch]

OK, that's nice to know ..... :-(

How would you make this possible?

Thx for the advice

 

[sleipnir214]

It depends. What do you want to print out?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Blutch]

Well,

I have a database with names and addresses and so on ...

Now I want the users to be able to print those names and addresses directly onto labels so they can use them on envelopes.

Name Name Name
Address Address Address

Name Name Name
Address Address Address

and so on ...

 

[sleipnir214]

That is very tricky because printing from within a web browser is difficult to print in a specific location on a page.

You might try producing a PDF on the fly and letting your users download the generated document and printing that.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Blutch]

OK that would be good too, as long as they can print them I'm happy ...

How do you do that?

 

[sleipnir214]

I've never done it myself. But there are a lot of options described in the PHP online manual:

http://www.php.net/manual/en/ref.pdf.php,

including options that use PHP classes rather than the compiled-in PDFLib.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Vragabond]

Since it is more of a html question, designing the labels, note that with CSS you can use all sorts of units (e.g. centimeters, inches) so making a label shouldn't be so hard with that.

Check this thread for more info on html:
thread215-670782 you get the proper html outlook for one label you just loop the others.

Hope it helps.

 

[Blutch]

Vragabond,

I get the hang of css, and I can place a label like I want it to appear. Now I think I have to loop the records with a repeat region, but I don't know how I can get them placed in the right way (3 by 7).

In other words, one label is perfectly ok, but how do I place the others???

 

[sleipnir214]

Maintain a counter which keeps track of how many columns you have output in your table. When that counter gets to the number of columns you want to output, you start a new table row and reset the counter.



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!