/** * Create a new order record and return the last inserted orderId * @return int */ protected function createOrderRecord() { $userId = $this->session->get('user_id'); $query = ' insert into aca_order (user_id, order_date) values (' . $userId . ', NOW())'; return $this->db->executeSql($query); }
public function createOrderRecord() { $userId = $this->session->get('user_id'); $query = ' insert into aca_order (user_id) values ("' . $userId . '")'; return $this->db->executeSql($query); // $this->db->insert('aca_order', // array( // 'user_id' => $userId, // 'order_date' => "NOW()" // )); // return $userId; }
public function delete($productId) { $query = ' delete from aca_cart_product where id = "' . $productId . '"'; return $this->db->executeSql($query); }