Esempi in PHP per SQLLexical::make_product_list

Esempio n. 1

File: Push_new_product_data_sql.php Progetto: Ruyka/Tam-An-Food-Store-Manager

 public function build_director()
 {
     $sql_builder = new SQLBuilder();
     $data = $this->get_data();
     $input = SQLLexical::make_product_list($data['list_product']);
     return $sql_builder->sql_insert('tam_an.product', array('Name', 'Bought', 'Price', 'Unit'))->sql_insert_values_recursive($input)->end_query()->to_string();
 }

Esempio n. 2

File: Push_alter_product_data_sql.php Progetto: Ruyka/Tam-An-Food-Store-Manager

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

Esempio n. 3

File: SQLBuilder.php Progetto: VinhDV/Tam-An-Food-Store-Manager

 public function alter_product_new_product_query($data)
 {
     $input = SQLLexical::make_product_list($data['list_product']);
     return $this->sql_insert('tam_an.product', array('Name', 'Bought', 'Price', 'Unit'))->sql_insert_values_recursive($input)->end_query()->to_string();
 }