static function insert($this1, $table, $columns = null)
 {
     $str = "INSERT INTO " . Std::string($table);
     if ($columns !== null) {
         $str .= " (" . _hx_string_or_null(zcale_sys_db_SqlTools::joinColumns($columns)) . ")";
     }
     return $str;
 }
Пример #2
0
 static function joinValues($values)
 {
     $str = "";
     $_g = 0;
     while ($_g < $values->length) {
         $v = $values[$_g];
         ++$_g;
         $str .= "," . _hx_string_or_null(zcale_sys_db_SqlTools::evalValue($v));
         unset($v);
     }
     return _hx_substr($str, 1, null);
 }
Пример #3
0
 public function updateRecords()
 {
     $naw = new zcale_sys_db_tests_zcale_Naw();
     $sql = null;
     $this1 = null;
     $this2 = null;
     $this3 = null;
     $this4 = null;
     $this4 = zcale_sys_db_tests_DatabaseTest_3($this, $naw, $sql, $this1, $this2, $this3, $this4);
     $str1 = _hx_string_or_null($this4) . " SET " . Std::string($naw->naam) . "=" . _hx_string_or_null(zcale_sys_db_SqlTools::evalValue("Martinez Martinez"));
     $this3 = $str1;
     $str2 = _hx_string_or_null($this3) . " WHERE " . Std::string($naw->naam);
     $this2 = $str2;
     $str3 = _hx_string_or_null($this2) . "=" . _hx_string_or_null(zcale_sys_db_SqlTools::evalValue("Martinez"));
     $this1 = $str3;
     $sql = $this1;
     $this->cnx->request($sql);
     Sys::hprint("<br/>Record updated in " . Std::string($naw) . ": " . _hx_string_or_null($sql));
 }