public function build_director() { //get data from SQL $data = $this->get_data(); $input = SQLLexical::make_product_list($data['list_product']); //use sql builder $sql_builder = new SQLBuilder(); $id_array = array("Name", "Bought", "Price", "Unit"); foreach ($input as $key => $value) { $sql_builder->update('tam_an.product')->set($id_array, $value)->where()->equals('ID', $key)->end_query(); } return $sql_builder->to_string(); }