// 2. get meaning.id by lang_pos_id
$query_meaning = "SELECT id FROM meaning WHERE lang_pos_id=" . $lang_pos_id;
$result_meaning = mysqli_query($LINK_DB, $query_meaning) or die("Query failed (line 58) in list_hypo.php: " . mysqli_error() . ". Query: " . $query_meaning);
while ($row_m = mysqli_fetch_array($result_meaning)) {
$meaning_id = $row_m['id'];
// 3. get relation by meaning_id
$query_relation = "SELECT wiki_text_id, relation_type_id FROM relation WHERE meaning_id=" . $meaning_id;
$result_relation = mysqli_query($LINK_DB, $query_relation) or die("Query failed (line 64) in list_hypo.php: " . mysqli_error() . ". Query: " . $query_relation);
while ($row_rel = mysqli_fetch_array($result_relation)) {
$relation_type_id = $row_rel['relation_type_id'];
$wiki_text_id = $row_rel['wiki_text_id'];
// 4. filter by relation type
if ($relation_type_id != $relation_type_id_hyponyms && $relation_type_id != $relation_type_id_hypernyms) {
continue;
}
$relation_type_name = TRelationType::getNameByID($relation_type_all, $relation_type_id);
// 5. get relation word by $wiki_text_id
$query_rwt = "SELECT text FROM wiki_text WHERE id=" . $wiki_text_id;
$result_rwt = mysqli_query($LINK_DB, $query_rwt) or die("Query failed (line 76) in list_hypo.php: " . mysqli_error() . ". Query: " . $query_rwt);
if ($row_rwt = mysqli_fetch_array($result_rwt)) {
$relation_wiki_text = $row_rwt['text'];
print "" . $lang_pos->pos->name . ";" . $lang_pos->page->page_title . ";" . $relation_type_name . ";" . $relation_wiki_text . "<BR>";
$counter++;
}
}
// eo relation
}
// eo meaning
// if($counter > 100)
// break;
}
<p><input type="submit" name="view_list" value="search"></p>
</form>
<?php
if (isset($view_list) && $view_list) {
$query_lang_pos = "SELECT lang_pos.id as id, page_title, relation_type_id, wiki_text.text as wiki_text FROM lang_pos, page, relation, meaning, wiki_text " . "WHERE lang_pos.page_id=page.id AND relation.meaning_id=meaning.id AND meaning.lang_pos_id=lang_pos.id AND relation.wiki_text_id=wiki_text.id AND wiki_text.text is not null";
if ($relation_type_id) {
$query_lang_pos .= " and relation_type_id=" . (int) $relation_type_id;
}
if ($lang_id) {
$query_lang_pos .= " and lang_id=" . (int) $lang_id;
}
if ($pos_id) {
$query_lang_pos .= " and pos_id=" . (int) $pos_id;
}
if ($page_title) {
$query_lang_pos .= " and page_title like '%{$page_title}%'";
}
$query_lang_pos .= " order by page_title, id";
//print $query_lang_pos;
$result_lang_pos = $link_db->query_e($query_lang_pos, "Query failed in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>");
$numAll = $link_db->query_count($result_lang_pos);
print "{$numAll} semantic relations (with these parameters) are found";
$result_lang_pos = $link_db->query_e($query_lang_pos . " LIMIT {$start_rec},{$limit}", "Query failed in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>");
print "<table border=1>\n";
$counter = $start_rec;
while ($row = $result_lang_pos->fetch_object()) {
print "<tr><td>" . ++$counter . ".</td><td>" . TPage::getURL($row->page_title) . "</td><td>" . TRelationType::getNameByID($row->relation_type_id) . "</td><td>" . $row->wiki_text . "</td></tr>\n";
}
print "</table><br />\n" . WForm::goNextStep($numAll, $limit, $php_self . "?lang_id={$lang_id}&pos_id={$pos_id}&relation_type_id={$relation_type_id}&page_title={$page_title}&view_list=1", 2, "Go to", $step_s);
}
include LIB_DIR . "footer.php";
