function render_related_docs($dbc, $file_id) { echo "<p class='lead'><strong>相关文献</strong></p>"; //$query = "SELECT * FROM resource where title like '%$keywords%' or description like '%$keywords%' ORDER BY title ASC LIMIT 0,10"; $recommended = array(); $metadata_query = "SELECT * FROM metadata where value = '" . $file_id . "'"; $metadata_result = mysqli_query($dbc, $metadata_query) or die('Error querying database:' . $metadata_query); while ($row = mysqli_fetch_array($metadata_result)) { $id = $row[subject]; $property = $row[property]; $value = $row[value]; if (array_key_exists($id, $recommended)) { $recommended[$id][] = array($property, $value); } else { $recommended[$id] = array(array($property, $value)); } } foreach ($recommended as $id => $pv) { $query = "SELECT * FROM resource where id = {$id}"; $result = mysqli_query($dbc, $query) or die('Error querying database:' . $query); if ($inner_row = mysqli_fetch_array($result)) { $title = $inner_row[title]; $def = $inner_row[description]; echo "<a href=\"resource_viewer.php?db_name={$db_name}&id={$id}\">{$title}</a><br>"; echo tcmks_substr($def) . '<br>'; echo '<font color="green">'; foreach ($pv as $pair) { echo '<strong>' . $pair[0] . ": " . $pair[1] . '</strong> '; } echo '</font>'; echo "<br><br>"; } } $query = build_query($file_id, array_keys($recommended)) . " LIMIT 0, 10"; $result = mysqli_query($dbc, $query) or die('Error querying database.'); while ($row = mysqli_fetch_array($result)) { $title = $row[title]; $doc_id = $row[id]; $def = $row[description]; echo "<a href=\"resource_viewer.php?db_name={$db_name}&id={$doc_id}\">{$title}</a><br>"; echo tcmks_substr($def) . "<br>"; echo "<br>"; } }
function render_value($dbc, $db_name, $name, $with_def = false) { if (strpos($name, $db_name . ':o') === 0) { $id = str_replace($db_name . ':o', "", $name); $query = "select * from def where id ='{$id}'"; $result = mysqli_query($dbc, $query) or die('Error querying database:' . $query); if ($row = mysqli_fetch_array($result)) { $pre_label = $row[name]; $def = $row[def]; $result = get_entity_link($id, get_type($dbc, $name) . ': ' . $pre_label, $db_name); if ($with_def && $def != '') { $result .= ' <em><small>(' . tcmks_substr($def) . ')' . '</small></em>'; } } else { $result = $name; } } else { $result = $name; } return $result; }
function render_graph($dbc, $name, $edit) { $query = "select * from graph where subject ='{$name}'"; if (!$edit) { $query .= " limit 10"; } $result = mysqli_query($dbc, $query) or die('Error querying database2.'); while ($row = mysqli_fetch_array($result)) { $property = $row[property]; $value = $row[value]; if (!$edit) { $value = tcmks_substr($value); } $id = $row[id]; echo "<p><strong>{$property}</strong>: {$value}"; if ($edit) { echo '<a href="' . $_SERVER['PHP_SELF'] . '?name=' . $name . '&delete_triple_id=' . $id . '"><i class="icon-remove-circle"></i></a>'; } echo "</p>"; } }
} echo '</div>'; echo '</div>'; } // Calculate pagination information //$query = "SELECT * FROM resource where title like '%$keywords%' or description like '%$keywords%' ORDER BY title ASC LIMIT 0,10"; $query = build_query($keywords, array_keys($recommended)) . " LIMIT {$skip}, {$results_per_page}"; $result = mysqli_query($dbc, $query) or die('Error querying database.'); while ($row = mysqli_fetch_array($result)) { $id = $row[id]; //if (!array_key_exists($id, $recommended)) { $title = $row[title]; $def = $row[description]; echo "<a class = 'lead' href=\"resource_viewer.php?db_name={$db_name}&id={$id}\">{$title}</a><br>"; echo '<font color="green">' . $row[creator] . ' ' . $row[source] . '</font><br>'; echo tcmks_substr($def); echo "<br><br>"; //} } if ($num_pages > 1) { generate_page_links($db_name, $keywords, $cur_page, $num_pages); } ?>
<div class="tab-pane" id="tab5"> <?php $url = 'http://s.wanfangdata.com.cn/sru/paper.ashx?operation=searchRetrieve&query=' . $keywords . '%20sortby%20relevance&maximumRecords=10&startRecord=1&version=1.2'; $xml = simplexml_load_file($url); $feed = file_get_contents($url); $feed = str_replace('srw_dc:dc xmlns:dc="info:srw/schema/1/dc-v1.1" xmlns:srw_dc="info:srw/schema/1/dc-v1.1"', 'srw', $feed); $feed = str_replace('srw_dc:dc', 'srw', $feed); $feed = str_replace('dc:', '', $feed); $xml = new SimpleXmlElement($feed); foreach ($xml->records->record as $r) { $x = $r->recordData->srw; $title = $x->title; $Identifier = $x->Identifier; echo '<h4><a href="http://d.wanfangdata.com.cn/' . $Identifier . '.aspx">' . $title . '</a></h4>'; echo '<p>' . $x->Creator . '等发表于' . $x->Date . '</p>'; echo "<p>" . tcmks_substr($x->Description, $word_count = 100) . "...</p>"; } ?> </div> <div class="tab-pane" id="tab6"> <?php $query = "SELECT * FROM `tcmks`.`images` WHERE name like '%{$keywords}%' or subject like '%{$keywords}%' or description like '%{$keywords}%'"; //echo $query; $result = mysqli_query($dbc, $query) or die('Error querying database.'); $row = mysqli_fetch_array($result); while ($row) { echo '<ul class = "thumbnails">'; for ($i = 0; $i < 4; $i++) { if (!$row) { break; }
function render_article_summary($dbc, $article_id, $word_count = 0) { $article_info = get_article_info($dbc, $article_id); echo "<h4><a href = \"article.php?id={$article_id}\">" . $article_info[title] . "</a></h4>"; echo "{$article_info['creators']}创建于{$article_info['create_time']}"; $abstract = get_abstract($dbc, $article_id); if ($word_count != 0) { $abstract = tcmks_substr($abstract); } echo '<p>' . $abstract . '</p>'; }
<button name ="submit" type="submit" class="btn btn-primary"> <i class="icon-search icon-white"></i> </button> </form> </div> <div class="accordion" id="accordion2"> <?php if (isset($keywords)) { $query = "SELECT * FROM segment where title like '%{$keywords}%' or content like '%{$keywords}%' "; $result = mysqli_query($dbc, $query) or die('Error querying database.'); while ($row = mysqli_fetch_array($result)) { //$article_id = $row[article_id]; //$article_info = get_article_info($dbc, $article_id); $segment_title = $row[title]; $segment_id = $row[id]; $segment_abstract = tcmks_substr($row[content]); $segment_content = $row[content]; echo "<div class = \"accordion-group\">"; echo "<div class = \"accordion-heading\">"; echo "<a class = \"accordion-toggle\" data-toggle = \"collapse\" data-parent = \"#accordion2\" href = \"#{$segment_id}\">"; echo $segment_title; echo "</a>"; echo $segment_abstract; echo "</div>"; echo "<div id = \"{$segment_id}\" class = \"accordion-body collapse\">"; echo "<div class = \"accordion-inner\">"; echo $segment_content; if ($_SESSION[id] == $row[user_id] && !is_segment_in_article($dbc, $article_id, $segment_id)) { echo "<a class = \"btn btn-success\" href=\"article.php?id={$article_id}&insert={$segment_id}&prev={$prev}\"><i class=\"icon-plus icon-white\"></i>将本段插入综述</a>"; } echo ' ';
$row_num = 1; $color = true; while ($row = mysqli_fetch_array($result)) { if ($color) { echo '<tr>'; } else { echo '<tr class="info">'; } $color = !$color; $segment_id = $row['id']; echo '<td>' . $row_num++ . '</td>'; echo '<td>'; echo "<a href=\"editor.php?act=edit&id={$segment_id}\">" . $row[title] . "</a>"; echo '</td>'; echo '<td>' . render_articles_by_seg($dbc, $row['id']) . '</td>'; echo '<td>' . tcmks_substr($row['content']) . '</td>'; echo '<td>' . render_tags($dbc, $row['id']) . '</td>'; echo '<td>' . $row[create_time] . '</td>'; echo '<td>'; if (!is_segment_used($dbc, $row['id'])) { echo '<a href="' . $_SERVER['PHP_SELF'] . '?delete_segment=' . $row['id'] . '"><i class="icon-trash"></i></a>'; } echo '</td>'; } ?> </tbody> </table> <?php } else { render_warning('没有可显示的综述段落!您可以创建新的综述段落。');