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; }