Re: PHP and printing
| From: | Michael Meinl | Date: | Wed, 28 Feb 2001 15:46:44 +0000 |
| Subject: | Re: PHP and printing | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-42018@lists.php.net to get a copy of this message | ||
> Hi, I'm working with php4 and mysql on a suse 6.3
> I made a program for an ISP that creates accounts, clients,
> payments, invoices.
> Everymonth they need to print like a quote (a list of every non paid
> thing) its ok, I could do that, I mean in the screen... Is it possible
> to print it in a printer automatically? I mean.. I dont want to view
> it on the screen.. I want it to print all the records alone
> Can you help me???
e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
Well, you could simply use a shell script....
use something like
mylsq -psomepassword dbname -H -e "SQL-QUERY" | html2ps | lpr
-H puts out HTML-format
-e executes the query in ""
html2ps formats the output to postscript, which is printed via lpr...
works fine with me...
you could simply include this in your crontab....