Example #1
0
 private static function selectIDWordFromObject()
 {
     $ArWord = self::$ArWord;
     if (empty($ArWord) || !is_array($ArWord)) {
         return array();
     }
     $ArWordDB = array();
     $ArIDWord = array();
     $StIN = "'" . implode("' , '", $ArWord) . "'";
     $StSQL = "SELECT IDWord, StWord\n       FROM Word \n     WHERE \n       StWord IN ({$StIN})\n     LIMIT 1000;";
     SearchHandler::getDBinstance();
     SearchHandler::$DBHandler->execSQL($StSQL);
     $ArResult = SearchHandler::$DBHandler->getResult("string");
     foreach ((array) $ArResult as $Row) {
         $ArIDWord[] = $Row['IDWord'];
         $ArWordDB[] = $Row['StWord'];
     }
     self::$ArNewWord = array_diff(self::$ArWord, $ArWordDB);
     self::$ArWordDB = $ArWordDB;
     self::$ArIDWord = $ArIDWord;
 }