Page 1 of 1

Databases - Which to choose for PHP-Based Stock System

Posted: Wed May 13, 2009 6:10 am
by Sephirangel
Hello all,

I am currently re-designing a stock system for a client. At the moment it is saving records into tabloes using PHP MyAdmin in WAMP Server 2.0.
Is this a feasible way of storing records or would another approach such as using separate .sql or .db files be better? The program runs locally on the clients machine so security is not much of a problem.

Another question while I think about it: is it better to use the mail() function to handle outward emails such as stock reports, or would it be more efficient to use the PEAR libraries? I know the differences between the 2 approaches but not the advantages.

Thanks in advance!

EDIT: Or even as .xml files?

Re: Databases - Which to choose for PHP-Based Stock System

Posted: Wed May 13, 2009 6:43 pm
by Christopher
Sephirangel wrote:I am currently re-designing a stock system for a client. At the moment it is saving records into tabloes using PHP MyAdmin in WAMP Server 2.0.
Is this a feasible way of storing records or would another approach such as using separate .sql or .db files be better? The program runs locally on the clients machine so security is not much of a problem.
If you are using phpMyAdmin then you could have the program saving the records directly using the PDO or mysqli libraries for PHP.
Sephirangel wrote:Another question while I think about it: is it better to use the mail() function to handle outward emails such as stock reports, or would it be more efficient to use the PEAR libraries? I know the differences between the 2 approaches but not the advantages.
I would recommend the Swift Mailer library. There is a forum for it here at DevNet.

Re: Databases - Which to choose for PHP-Based Stock System

Posted: Thu May 14, 2009 4:16 am
by Sephirangel
If you are using phpMyAdmin then you could have the program saving the records directly using the PDO or mysqli libraries for PHP.
May I ask what the PDO is? I may just continue to use phpMyAdmin, but ive been having a few problems with duplicate data entries and such. Will have to re-design field attributes
I would recommend the Swift Mailer library. There is a forum for it here at DevNet.
Ill check that out right away. Thanks very much!

Re: Databases - Which to choose for PHP-Based Stock System

Posted: Thu May 14, 2009 4:39 am
by Christopher
Sephirangel wrote:May I ask what the PDO is?
http://us.php.net/manual/en/book.pdo.php