Example #1
0
 protected function Add()
 {
     $SKTDB = \CmsDev\Sql\db_Skt::connect();
     $queryProductFields = $queryProductValues = '';
     foreach ($_POST as $Field => $Value) {
         if (array_key_exists($Field, $this->ProductFields)) {
             $queryProductFields .= $Field . ',';
         }
     }
     foreach ($_POST as $Field => $Value) {
         if (array_key_exists($Field, $this->ProductFields)) {
             $queryProductValues .= self::DecodeValue(\GetSQLValueString($Value, $this->ProductFields[$Field])) . ',';
         }
     }
     $queryProductFieldsTrimed = trim($queryProductFields, ',');
     $queryProductValuesTrimed = trim($queryProductValues, ',');
     if (isset($_POST['PlanGift']) && $_POST['PlanGift'] == '1') {
         $User_plan = new \CmsDev\CRUD\ViewEditElementsAsList\Lists\User_plan\_classes();
         $User_plan->CountDown($_POST['IDUser']);
     }
     $query = "INSERT INTO " . \DB_PREFIX . "products ({$queryProductFieldsTrimed}) VALUES ({$queryProductValuesTrimed})";
     if ($queryProductFieldsTrimed) {
         $insert = $SKTDB->query($query);
     }
     if ($insert) {
         echo 'okay';
     } else {
         echo "error";
     }
 }