Printing from MySQL?

D

dbrogan

Registered
I'm looking at replacing some or all of our FileMaker databases with MySQL.

What are my options for printing invoices, statements, and reports from MySQL?

-Dan
 
You would have to write an application or PHP script to get the data out of MySQL.

It's not visual database like FileMaker is.
 
Of course you could still use FileMaker as a front end for the MySQL server, right?
 
That might be possible, if Filemaker can connect to other databases.

I haven't used it much, so I'm not sure.
 
OK, so let's say I'd like to try to avoid FileMaker entirely.

I get the data from MySQL with PHP. Now what are my options for make pretty reports and invoices with that data? Does PHP have the ability to do fairly complex formatting (involving fonts and EPS graphics) and printing to a PostScript device?

Many thanks.

-Dan
 
Since PHP is a web programming language, you can use it to output any HTML you want, including any image tags etc.
You would have to use these scripts in a web browser and print from that.

If you want to really get as close to Filemaker as you can, but want to use MySQL for the database, it might be better to make a Cocoa application that connects to the database instead.
 
Check out MacSQL that has just been released here

"MacSQL enables Web and application developers to hook into popular database systems. It provides spreadsheet-style viewing and editing of remote data, Applescript support, PHP and Perl script generation via an assistant, and much more. It runs natively in Mac OS 9 and X. "

Looks like it fits your needs pretty good.
 
You must log in or register to reply here.
Back
Top