Databases - Which to choose for PHP-Based Stock System

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
Sephirangel
Forum Commoner
Posts: 45
Joined: Tue Jul 15, 2008 1:37 pm

Databases - Which to choose for PHP-Based Stock System

Post 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?
User avatar
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

Post 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.
(#10850)
Sephirangel
Forum Commoner
Posts: 45
Joined: Tue Jul 15, 2008 1:37 pm

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

Post 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!
User avatar
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

Post by Christopher »

Sephirangel wrote:May I ask what the PDO is?
http://us.php.net/manual/en/book.pdo.php
(#10850)
Post Reply