php Programming Glossary: dataaccess

http://stackoverflow.com/questions/1820421/extending-the-mysqli-class

this question My suggestion is to create a Singleton DataAccess class instantiate that class in a global config file and call.. config file and call it in your Blog class like query DataAccess query SELECT FROM blog WHERE id . id . Look into the Singleton.. understand designpattern. Perfect for this situation. Your DataAccess class can have several methods like query fetchAssoc numRows..

How does one use the RDBMS in a performant way on top of Zend_Db_Table? (if at all…)

http://stackoverflow.com/questions/4997577/how-does-one-use-the-rdbms-in-a-performant-way-on-top-of-zend-db-table-if-at-a

model could be fed an instance of a custom BlogPostDataAccess which would be fed an instance of Zend_Db_Adapter . All your.. your optimized joins would reside within the BlogPost_DataAccess class. The SELECT queries in the DataAccess class could be written.. the BlogPost_DataAccess class. The SELECT queries in the DataAccess class could be written using soemthing like pseudocode select..