March 1, 2021
Hot Topics:

Add Refactoring to Your PHP Development with MySQL Stored Procedures and Views

  • By Jason Gilmore
  • Send Email »
  • More Articles »

A common programming mistake is heavily intermingling the application logic and the domain model. In particular, it's so easy to interact with a MySQL database via a PHP-driven website that developers fall prey to less-than-optimal coding strategies. For example, PHP developers who have MySQL on their backends tend to cram an inordinate amount of SQL into their website logic, resulting in undecipherable code that's impossible to maintainable. A number of products have emerged to help developers avoid this practice, most notably MVC frameworks such as the Zend Framework.

However, whether you use an MVC framework or write custom code, you can further separate your application logic from the domain model by taking advantage of MySQL's views and stored procedures. Both features enable you to bundle more of the domain model's logic within the database server itself, thereby minimizing the number of changes you'll need to make later due to code refactoring -- not to mention assigning more control over domain model-related matters to a database administrator when working in larger team environments.

In his PHPBuilder.com article, Jason Gilmore introduces MySQL stored procedures and views, and shows you how to use them for refactoring within your PHP development.

Read the full story at PHPBuilder:
Refactor Your PHP Site Using MySQL Stored Procedures and Views

This article was originally published on July 14, 2010

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date