Skip to main content

Posts

Showing posts with the label delete

PHP: Merge/delete arrays with same subkeys

I'm writing a database class for my site based on a fluent interface. First, I collect all the meaningful terms then put them into the "stack", which is basically an array. Then, I sort them in order that they would appear in an actual SQL query. const stmt_select = 1; const stmt_insert = 2; const stmt_delete = 3; const sql_select = 10; const sql_from = 11; const sql_into = 12; const sql_where = 13; const sql_join = 14; const sql_group = 15; const sql_order = 16; const sql_limit = 17; For example, the query below (although in a total rubbish order, and purposely trying to throw the class off): Query::Select('name', 'age', 'height') ->Order('a') ->From('table') ->From('asd') ->Group('a') ->Execute(); .. produces: Array ( [0] => Array ( [0] => 10 [1] => Array ( [0] => name [1]