PHP indexation::calc_stem Examples

Example #1

File: indexation.class.php Project: hogsim/PMB

 public static function add_word($word, $lang)
 {
     global $dbh;
     $query = "select id_word from words where word = '" . $word . "' and lang = '" . $lang . "'";
     $result = pmb_mysql_query($query, $dbh);
     if (pmb_mysql_num_rows($result)) {
         $num_word = pmb_mysql_result($result, 0, 0);
     } else {
         $double_metaphone = indexation::calc_double_metephone($word, $lang);
         $stem = indexation::calc_stem($word, $lang);
         $element_to_update = "";
         if ($double_metaphone) {
             $element_to_update .= "double_metaphone = '" . $double_metaphone . "'";
         }
         if ($element_to_update) {
             $element_to_update .= ",";
         }
         $element_to_update .= "stem = '" . $stem . "'";
         $query = "insert into words set word = '" . $word . "', lang = '" . $lang . "'" . ($element_to_update ? ", " . $element_to_update : "");
         pmb_mysql_query($query, $dbh);
         $num_word = pmb_mysql_insert_id($dbh);
     }
     return $num_word;
 }