Posts Tagged ‘statement’

Relationships

My initial thought was to break down an SQL statement into pieces. Seems like a fairly obvious idea so I am inclined to go with it. Let us assume these basic pieces: Statement Type, SELECT expression, FROM table references, JOIN clauses, INSERT/REPLACE/UPDATE values, WHERE clauses, and lastly and ORDER/GROUP/HAVING type clause. I think, and I […]

SQL Query Builder :: The Idea

Today I decided to create an SQL query builder class for PHP and MySQL. I am envisioning a single class interface with basic, easy to understand methods. The class should handle the vast majority of MySQL data manipulation statements including all JOIN configurations and nested queries. The class needs to provide a basic SQL statement […]