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();
}
