/** Gets TTranslationEntry object by property $property_name with value $property_value. * @return TTranslationEntry or NULL in case of error */ public static function getTranslationEntry($property_name, $property_value, $translation_obj = NULL) { global $LINK_DB; $query = "SELECT * FROM translation_entry WHERE `{$property_name}`='{$property_value}' order by id"; $result = $LINK_DB->query_e($query, "Query failed in " . __METHOD__ . " in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>"); if ($LINK_DB->query_count($result) == 0) { return NULL; } $translationEntry_arr = array(); while ($row = $result->fetch_object()) { if ($translation_obj == NULL) { $translation_obj = TTranslation::getByID($row->translation_id); } $translationEntry_arr[] = new TTranslationEntry($row->id, $translation_obj, TLang::getByID($row->lang_id), TWikiText::getByID($row->wiki_text_id)); } return $translationEntry_arr; }
/** Gets TRelation object by property $property_name with value $property_value. * @return TRelation or NULL in case of error */ public static function getRelation($property_name, $property_value, $meaning_obj = NULL) { global $LINK_DB; $query = "SELECT * FROM relation WHERE `{$property_name}`='{$property_value}' order by id"; $result = $LINK_DB->query_e($query, "Query failed in " . __METHOD__ . " in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>"); if ($LINK_DB->query_count($result) == 0) { return NULL; } $relation_arr = array(); while ($row = $result->fetch_object()) { /* if ($meaning_obj == NULL) $meaning_obj = TMeaning::getByID($row->meaning_id); */ $relation_arr[] = new TRelation($row->id, $meaning_obj, TWikiText::getByID($row->wiki_text_id), TRelationType::getByID($row->relation_type_id), $row->meaning_summary); } return $relation_arr; }
/** Gets TMeaning object by property $property_name with value $property_value. * @return TMeaning or NULL in case of error */ public static function getMeaning($property_name, $property_value, $lang_pos_obj = NULL) { global $LINK_DB; $query = "SELECT * FROM meaning WHERE `{$property_name}`='{$property_value}' order by id"; $result = $LINK_DB->query_e($query, "Query failed in " . __METHOD__ . " in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>"); if ($LINK_DB->query_count($result) == 0) { return NULL; } $meaning_arr = array(); while ($row = $result->fetch_object()) { /* if ($lang_pos_obj == NULL) $lang_pos_obj = TLangPOS::getByID($row->lang_pos_id); */ $meaning = new TMeaning($row->id, $lang_pos_obj, $row->lang_pos_id, $row->meaning_n, TWikiText::getByID($row->wiki_text_id), $row->wiki_text_id); $meaning->relation = TRelation::getByMeaning($row->id, $meaning); $meaning->translation = TTranslation::getByMeaning($row->id, $meaning); $meaning->label_meaning = TLabelMeaning::getByMeaning($row->id, $meaning); $meaning_arr[] = $meaning; } return $meaning_arr; }
echo $substring; ?> "></p> <p><input type="submit" name="view_list" value="view"></p> </form> <?php if (isset($view_list) && $view_list) { $query = "SELECT meaning.id as meaning_id, page_title, text FROM page, lang_pos, meaning, wiki_text WHERE lang_pos.page_id=page.id and meaning.lang_pos_id=lang_pos.id and meaning.wiki_text_id=wiki_text.id " . " and text like '%{$substring}%' order by text"; // LIMIT $limit $result = $link_db->query_e($query, "Query failed in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>"); print "<p>" . $link_db->query_count($result) . " definitions are found</p><table border=1>\n"; $counter = 0; while ($row = $result->fetch_object()) { // LABELS OF MEANING $label_name_arr = array(); /* $labelMeaning_arr = TMeaning::getByID($row->meaning_id)->getLabelMeaning(); if (is_array($labelMeaning_arr)) foreach ($labelMeaning_arr as $labelMeaningObj) $label_name_arr[] = "<span title=\"".$labelMeaningObj->getLabel()->getName()."\">".$labelMeaningObj->getLabel()->getShortName()."</span>"; */ $query = "SELECT id, short_name, name FROM label, label_meaning WHERE label_meaning.label_id=label.id and label_meaning.meaning_id=" . (int) $row->meaning_id; $res_label = $link_db->query_e($query, "Query failed in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>"); while ($row_label = $res_label->fetch_object()) { $label_name_arr[] = "<span title=\"" . $row_label->name . "\">" . $row_label->short_name . "</span>"; } print "<tr><td>" . ++$counter . ".</td><td>" . TPage::getURL($row->page_title) . "</td><td>" . join(', ', $label_name_arr) . "</td><td>" . TWikiText::selectText($row->text, $substring, "<span style='font-weight:bold; color:#FF00FF'>", "</span>") . "</td></tr>\n"; } print "</table><BR>"; } include LIB_DIR . "footer.php";
<?php require "../../config.php"; $string = '# выражает доведение объекта действия с помощью длительного и/или интенсивного действия, названного мотивирующим глаголом, до нежелательного состояния (крайней усталости, бессилия, исчерпанности) или состояния невозможности продолжения действия: убегаться, укачать, уреветься, уходиться.'; $substring = 'об%т'; print TWikiText::selectText($string, $substring);