Re: getting to grips with pear

On Sat, 25 Sep 2004 12:59:37 +0100, George Pitcher <george.pitcher@ingenta.com> wrote: > Antoine, > > I use PEAR:DB to handle my php-MySQL sites, but no other PEAR modules. I've > found it really easy once I got to grips with the differences. > > I set up a confip.php file that gets loaded into every php script that needs > db access. That contains the db connection stuff and creates the $db > instance. > > I've changed my db structure so that I only use the following datatypes: > > varchar > int > tinyint > text > > I store dates as 8-digit ints in the yyyymmdd format and use functions to > encode/decode them from/to euro format dates. > > I would suggest that you get to grips with PEAR:DB and once you have that > sorted then think about integrating other PEAR modules. I also use templates > but prefer Smarty to the PEAR offering. > > The beauty of PHP is that there are so many options to choose from. > > Good luck and if you want to see any of my DB code, let me know off list. thanks for that. For the moment I am trying to get to grips with what is out there, and thought it might be nice to experiment on my own test site. Eventually I will be wanting to build some stuff to access our oracle db at work, which there is no possibility of changing. Are there problems with data types? I liked the idea of pear db because it would mean that it could access either an access version (for others at work when they are at home) or postgres version (me at home) with the change of a single line. At the moment the db is not visible to the net, and won't be until things are quite a way along. I think I understand if I turn all the portability features on, this shouldn't be a prob. I am not stuck on pear, and if there are other things out there then am more than happy to go investigating. I will have a look at smarty also. If you have any suggestions on what might be the best place to look for stuff (apart from php.net) then that would be most appreciated. Cheers Antoine ps. the idea for the beginning will be for customers to track their jobs (we do document stuff - photocopying, microfilm, scanning, destroying, ODR, etc). Eventually we will hopefully get a lot more online, like quotes, pricing, all that sort of stuff, and maybe eventually for regular customers have them interact directly with the db to cut out human contact (we are in France after all, and less work is always better ;-)) so they can do stuff 24/7. -- G System, The Evolving GUniverse - http://www.g-system.at