It would be a good idea to create a database abstaction class. This means that should you move your application to a different database you only have to replace your database class, instead of recoding everything with the new set of functions. It can also be neater than using the mysql functions directly.
You could use it as in a composite or an aggregated relationship. Check out http://www.phppatterns.com/index.php/article/articleview/15/1/1/ for some useful information. Also is it necessary to have $ponum sent to each function, how about creating an attrbute of the class and setting it in the constructor function. "Mike Smith" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I've been doing procedural coding for a few month's, but perceive the > need for OOP for some of the projects I've done. I'm starting out and > and would like some feedback, before I tread down the wrong path. The > books I'm looking at Professional PHP (Wrox), and Visual QuickStart PHP > have examples, but I seem to need something more concrete so I've > started a skeleton to rewrite a Purchase Order application. Here is the > layout: > > <?php //pocode.php > class PurchaseOrder > { > //Variables > var $ponum; //This will be a $_SESSION variable if that matters > var $item; > > function AddItem($ponum,$item){ > ...INSERT SQL CODE > } > > function DeleteItem($ponum,$item){ > ...DELETE SQL CODE > } > > function UpdateItem($ponum,$item){ > ...UPDATE SQL CODE > } > > function ListItems($ponum){ > ...SELECT SQL CODE, RETURN RESULTS (ie. > while($row=mssql_fetch_array($rst)){echo $row[0]....}) > } > > } > ?> > > I would then include that in my page, > and add items to a PO by doing something like > <?php > include('pocode.php'); > $po = new PO(); > > If($_POST['submit']=='Add'){ > //A HTML Button next to a text box to add a line item > $po->AddItem('12345','5063'); > } > > $po->ListItems('12345'); > > ?> > > Do I have the basic concept right? This is like relearning to code. > Perhaps I learned in a bad way if that's the case. Any especially good > tutorials or books to recommend? > > Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
