<pedrocorreia.net ⁄>
 

<PHP DataObjects: Simplifying Business Logic without SQL ⁄ >




clicks: 3213 3213 2006-09-26 2006-09-26 goto programacao myNews programacao  Bookmark This Bookmark This


I was recently talked into writing an article on building a simple ORM solution in PHP for a local developers group. As my reward is a number of free beers, I managed to finish this lengthy tutorial. So here it is for Devnetwork members to marvel at (and ask pointy questions!). Enjoy...

Introduction

The goal of this tutorial is to demonstrate a system for manipulating a database without writing SQL queries. I introduce a number of concepts including the DataObject and DataAccessObject which together allow developers focus on manipulating data without needing to write, or even know SQL. This kind of system can be referred to as Object Relational Mapping (ORM) where tables and rows in a database are represented by PHP objects which may be used to perform common database operations. It is a very simple system to use in practice, and has become a common component of many popular PHP frameworks.

In the tutorial I implement such a system integrating database abstraction, i.e. the ability to operate on several or more database management systems such as MySQL or PostgreSQL, using ADOdb Lite. The tutorial is not very complex, but does assume you are aware of Object Oriented Programming basics in PHP and are familiar with the basics of using a database in PHP.

So if using a system where you can manipulate a database without writing lines of SQL appeals to you, then read on...Smile.



este é só um excerto do artigo, para aceder ao artigo completo, clique no link em baixo:
this is just a small excerpt from the article, to access the full article please click in the link below:

http://forums.devnetwork.net/viewtopic.php?t=48499




Subscribe News RSS  Subscribe News Updates by E-mail





myNews <myNews show="rand" cat="programacao" ⁄>

RouterJs: easy routing for your ajax Web applications new ...

RouterJs is a simple router for your ajax web apps. It's build upon History.js which means that Rout (...)

clicks: 16201 16201 2012-05-14 2012-05-14 goto url (new window) haithembelhaj.g... goto myNews programacao


Backbone computed properties new ...

This gist shows one way to implement read- and write-enabled computed properties on a Backbone Model (...)

clicks: 16024 16024 2012-05-13 2012-05-13 goto url (new window) https://gist.gi... goto myNews programacao


Android Query new ...

Android-Query (AQuery) is a light-weight library for doing asynchronous tasks and manipulating UI el (...)

clicks: 16254 16254 2012-05-12 2012-05-12 goto url (new window) code.google.com... goto myNews programacao


HTML5 jQuery Paint Plugin new ...

Websanova Paint is a HTML5 canvas based jQuery plugin. It allows you to free paint on a canvas area (...)

clicks: 26795 26795 2012-05-12 2012-05-12 goto url (new window) websanova.com/t... goto myNews programacao


Create Instagram Filters With PHP new ...

In this tutorial, I'll demonstrate how to create vintage (just like Instagram does) photos with PHP (...)

clicks: 15696 15696 2012-05-12 2012-05-12 goto url (new window) net.tutsplus.co... goto myNews programacao


Sass vs. LESS vs. Stylus: Preprocessor Shootout new ...

CSS3 preprocessors are languages written for the sole purpose of adding cool, inventive features to (...)

clicks: 15415 15415 2012-05-11 2012-05-11 goto url (new window) net.tutsplus.co... goto myNews programacao


Real-time Applications With Node.js and Socket.IO new ...

Hey everyone! Sorry about the long pause since the last blog post, life has been quite hectic for th (...)

clicks: 16101 16101 2012-05-11 2012-05-11 goto url (new window) codingcookies.c... goto myNews programacao


15 Handpicked jQuery Drop Down Menus Tutorials new ...

Here we are presenting another brilliant collection of 15 jQuery navigation menu that you can downlo (...)

clicks: 15208 15208 2012-05-10 2012-05-10 goto url (new window) smashingapps.co... goto myNews programacao