function isSignature($idUser, $signature) { $sentence = ""; $pass = FilterSqlSentences::getCharFilter($signature); $sentence = Sentences::_getSentenceSelect("users", " * ", array('idUser' => $idUser, 'signature' => $signature)); if ($this->cnn->getNumberRows($sentence) > 0) { $data = $this->cnn->excecuteSelect($sentence); return true; } else { return 0; } }
public static function getUpdateWSentence($form, $table, $filter) { $query = ""; $count = 0; self::$sentence = ""; foreach ($form as $nameField => $valueField) { if ($count == count($form) - 1) { $query .= "`" . FilterSqlSentences::getCharFilter($nameField) . "` = '" . FilterSqlSentences::getCharFilter($valueField) . "'"; } else { $query .= "`" . FilterSqlSentences::getCharFilter($nameField) . "` = '" . FilterSqlSentences::getCharFilter($valueField) . "',"; } $count++; } self::$sentence = "UPDATE " . $table . " SET " . $query . $filter; return self::$sentence; }
public static function getCharFilter($word) { self::$sentence = $word; return self::$sentence; }