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?
Databases - Which to choose for PHP-Based Stock System
Moderator: General Moderators
-
Sephirangel
- Forum Commoner
- Posts: 45
- Joined: Tue Jul 15, 2008 1:37 pm
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Databases - Which to choose for PHP-Based Stock System
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: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.
I would recommend the Swift Mailer library. There is a forum for it here at DevNet.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.
(#10850)
-
Sephirangel
- Forum Commoner
- Posts: 45
- Joined: Tue Jul 15, 2008 1:37 pm
Re: Databases - Which to choose for PHP-Based Stock System
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 attributesIf you are using phpMyAdmin then you could have the program saving the records directly using the PDO or mysqli libraries for PHP.
Ill check that out right away. Thanks very much!I would recommend the Swift Mailer library. There is a forum for it here at DevNet.
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Databases - Which to choose for PHP-Based Stock System
http://us.php.net/manual/en/book.pdo.phpSephirangel wrote:May I ask what the PDO is?
(#10850)