[newbie] application development suggestion

2005-02-04 Thread Q.H. Wang
Hi Folks,

A friend asked me something about developing a management program for his 
store (a small one but with two computers). He need to track the sales and 
print bills for customers on both computers. I wonder whether it can be done 
using mysql and php or perl in mandrake (I myself don't have any such 
experience). Any suggestion will be greatly appreciated.

Bests,

Q.H. 


Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com



Re: [newbie] application development suggestion

2005-02-04 Thread David G Stevenson
Q.H. Wang wrote:
Hi Folks,
A friend asked me something about developing a management program for his 
store (a small one but with two computers). He need to track the sales and 
print bills for customers on both computers. I wonder whether it can be done 
using mysql and php or perl in mandrake (I myself don't have any such 
experience). Any suggestion will be greatly appreciated.

Bests,
Q.H. 


I built a couple of systems like you mention. Basically I used perl/cgi, 
mysql  postfix.

I have a web layer which is a mixture of static html templates which are 
 merged at runtime with the Db content. The web layer drives the 
perl/cgi which interacts with the Db, triggering email/prints/invoices etc.

so...
Web | cgi/perl | mysql
 |
   postfix
Authentication can be driven by auth_mysql in apache so users can update 
there own passwords and you can provide groups etc. Use the http.consf 
files and .htaccess to provide group security to scripts etc.

I am sure you can do all this in php or any other language, but thats 
what make programming so much fun eh!

HTH
--
Thanks,
David


Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com



Re: [newbie] application development suggestion

2005-02-04 Thread Q.H. Wang
Many thanks David, I'm gonna give it a try.

Bests,

Q.H.


Want to buy your Pack or Services from MandrakeSoft? 
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com