PHP 3 Tier Architecture

[Jeankeuh]

I'm analyzing a new webproject.

Is there a possibility to work in a 3 tier environment with php?

I suppose php will be the presentation layer and for example mysql the datalayer, but what about the business layer? Which language can i use for a business logic tier?

(For example: in a Microsoft environment you could use COM-components and Microsoft Transaction Server)

Where can i find some information about the PHP/MySQL data-architecture?

Can you use transactions in PHP?

How can i avoid database errors when multiple people are accessing/updating a same attribute in the database?

Thanks in advance.

[yelvington]

n-tiered application development is a matter of self-discipline, not technology.

You can write your business logic in PHP while isolating it from presentation logic.

You can use a templating system for presentation if you like, but that has always struck me as overkill.

<? include('logic.php') ?>
<h1><?=$my->headline?></h1>
... works just as well.

If you have enough server boxes, you can isolate PHP-based application services from the publicly accessible web server by using Apache's mod_proxy.