3 tier architeture

Anon

Hi there! Is it possible to create a 3 tier architeture with PHP? In our company´s server we run ASP and DLLs to access the DB It works like this:
The ASP code has all the code, but no SQL statment or connection to the DB.
All SQL statements are hidden in a DLL. As it is the only one that access the DB, we reduce a lot the number of simultaneos access to a DB.
In the ASP code we create an object set rs = Server.CreateObject("Dll.Class") this DLL is registred in another server. So the rs object contain all the recordset returned by a SQL. Even if the user get access to our ASP page he'll never know the server, password or even the SQL (tables, relationships) of our DB server.
I wonder if it is possible to use this approach within PHP.

Anon

Zend.com has some article on MVC (model-view-controller) architecture which is similar. You can pretty much do whatever you want in PHP. I have a set of classes that handle business logic & database access, a set of templates that handles the output (there is no HTML in any of my classes - it's all in the templates), and finally a set of "public" php scripts that bring it all together - import the business logic, perform the correct function, the spit data out to the templates which are in turn displayed to the browser. Of course, since I'm using templates, I can transform the data into any format I want (xml, html, csv, etc.).

van__

Wow, looks like Brian made a code base similar to mine, but I'm sure mines far superior 🙂

You can dispose of the 3-tier set up and enjoy faster execution time by purchasing teh Zend Optimizer at zend.com.

This allows your PHP classes and other source code to be stored as encrypted binaries, that allows you to enjoy higher levels of security for the codebase as the source code will not be readily viewable and thus, any hostname/username and passwords stored within will be nice and safe. Plus, you get the speed increase of not having to access a 2nd application to do the work that PHP can do excellently on it's own.