[ciapug] On or Off ...

Dan Schlichting danjs at cpugeek.org
Tue Aug 23 09:11:21 CDT 2005


That link is broke. Should it be http://propel.phpdb.org?

Thanks

Dan
On Tue, 23 Aug 2005 08:54:35 -0500, Tony Bibbs wrote
> Carl Olsen wrote:
> > I got really deep into object oriented PHP this weekend and decided to start
> > with something a little more simple, so I'm creating a class for each table
> > with select, insert, update, and delete functions that all use prepared
> > statements.  I agree that the security blanket is great.
> 
> When you get done with all of this and have time to breathe, you 
> should really consider looking at Propel, http://prople.phpdb.org. 
>  That tool creates a set of object from your database (generally one 
> class per table).  These objects are pure PHP objects that the 
> Propel runtime can then use to do all your insert/update/delete 
> logic magically.  Thus you could have something like:
> 
> // Retrieve existing customer
> $customer = new Customer();
> $customer->setId(5);
> $customer->get();
> 
> // Create an order
> $order = new Order();
> $order->setProductCode(4);
> $order->setUnitPrice(20.00);
> $order->setQuantity(3);
> 
> // Assign order to customer
> $customer->addOrder($order);
> 
> // Save it all
> $customer->save();
> 
> This gets you out of the business of writing a lot of SQL and 
> underneath it uses prepared statements.
> 
> --Tony
> _______________________________________________
> ciapug mailing list
> ciapug at cialug.org
> http://cialug.org/mailman/listinfo/ciapug


-----------------------------------------------------
Dan J Schlichting
http://www.cpugeek.org
dan at cpugeek.org



More information about the ciapug mailing list