将MySQL代码与PHP代码分离是一种标准的常见做法吗？

Question

I've been told that it's a common practice to separate MySQL code from PHP code, is this true? Is this like a new coding standard? Are there any benefits of doing such?

Can someone direct me what are best coding practices (PHP/MySQL) when writing for masses (open source script for example).

Thanks!

Answer 1

Good question!

• I've been told that it's a common practice to separate MySQL code from PHP code, is this true?
  • absolutely true!
• Is this like a new coding standard?
  • and old old concept. there is no standard, but defacto exists
• Are there any benefits of doing such?
  • many benefits
  • benefits from de-coupling between Layers.
  • when business logic is de-coupled from Presentation logic, if requirement changes you can change it easily.
  • so not only separate sql from php, also separate HTML code from php logic

using sqlMap

in the Java world there is MyBatis SqlMapper. This is very commonly used and this is what you want exactly if you are Java programmer.

But in PHP, hard to find something like MyBatis, the only thing I have found is PRADO http://www.pradosoft.com/

using ORM

ORM = Object Relation Map. http://en.wikipedia.org/wiki/Object-relational_mapping This is also used. but i don't know there is ORM framework for PHP. if anyone knows, please let me know. @jszobody has suggested http://www.doctrine-project.org/projects/orm.html (Thanks)

thanks.