News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

PHPBuilder.com:
Refactor Your PHP Site Using MySQL Procedures and Views
July 14, 2010 @ 08:46:13

On PHPBuilder.con today there's a new post from Jason Gilmore looking at using procedures and views in MySQL to refactor and simplify your site.

One particularly prominent mistake many programmers make is heavily intermingling the application logic and the domain model. PHP developers, for example, have a tendency to jam a tremendous amount of SQL into their website logic, resulting in undecipherable, unmaintainable code. [...] MySQL stored procedures and views can not only go a long way towards separating the logic and domain model, but they also can easily be integrated into PHP.

He includes several examples of how to create simple views in your database with tables from a possible e-commerce application holding order information and customer details.

2 comments voice your opinion now!
mysql view procedure tutorial refactor


blog comments powered by Disqus

Similar Posts

AirPair.com: Automating Laravel Deployments Using Capistrano

Lukas Smith's Blog: LAMP's success is spellings its own doom?

Padraic Brady's Blog: An Example Zend Framework Blog App - Part 3: A Simple Hello World Tutorial

Job Posting: SumEffect Software Seeks PHP/MySQL Programmer (Franklin, TN)

Stefan Mischook's Blog: Aprenda Programacion Orientada a Objetos en PHP


Community Events

Don't see your event here?
Let us know!


introduction library example voicesoftheelephpant php7 community version release opinion laravel5 language framework list security podcast laravel api extension interview series

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework