"></td> </tr> <?php } else { ?> <td>No image</td></tr> <?php } } ?> </tbody> </table> <?php if ($num_pages > 1) { echo generate_page_links($cur_page, $num_pages); } } else { ?> <p style="font-size:16px;font-color:red; font-weight:bold;">Please login to see the list</p><br /><br /> <a href="login.php">Login to continue</a> <?php } ?> </div> </div> </div> </div> </body> <?php require_once 'footer.php';
echo '</tr>'; // Connect to the database require_once 'connectvars.php'; $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Query to get the total results $query = build_query($user_search, $sort); $result = mysqli_query($dbc, $query); $total = mysqli_num_rows($result); $num_pages = ceil($total / $results_per_page); // Query again to get just the subset of results $query = $query . " LIMIT {$skip}, {$results_per_page}"; $result = mysqli_query($dbc, $query); while ($row = mysqli_fetch_array($result)) { echo '<tr class="results">'; echo '<td valign="top" width="20%">' . $row['titile'] . '</td>'; echo '<td valign="top" width="50%">' . substr($row['description'], 0, 100) . '...</td>'; echo '<td valign="top" width="10%">' . $row['state'] . '</td>'; echo '<td valign="top" width="20%">' . substr($row['date_posted'], 0, 10) . '</td>'; echo '</tr>'; } echo '</table>'; // Generate navigational page links if we have more than one page if ($num_pages > 1) { echo generate_page_links($user_search, $sort, $cur_page, $num_pages); } mysqli_close($dbc); ?> </body> </html>
<?php $query = "SELECT * FROM def where name = '{$keywords}'"; $result = mysqli_query($dbc, $query) or die('Error querying database.'); if ($row = mysqli_fetch_array($result)) { render_item($dbc, $row, $db_name); } //$query = "SELECT * FROM def where name like '%$keywords%' or def like '%$keywords%' ORDER BY name ASC LIMIT 0,10"; $query = build_query($keywords) . " LIMIT {$skip}, {$results_per_page}"; $result = mysqli_query($dbc, $query) or die('Error querying database.'); while ($row = mysqli_fetch_array($result)) { render_item($dbc, $row, $db_name); } if ($num_pages > 1) { generate_page_links($url, $cur_page, $num_pages); } ?> <p><font color="gray">获得约<?php echo $total; ?> 条结果。</font></p> <hr> </div> <div class="col-md-2"> <?php render_related($dbc, $db_name, $keywords); ?> </div> </div>
<?php $relation_tab_id = 'docs'; include_once "./relation_header.php"; //$query = "SELECT * FROM resource where title like '%$keywords%' or description like '%$keywords%' ORDER BY title ASC LIMIT 0,10"; // Calculate pagination information $cur_page = isset($_GET['page']) ? $_GET['page'] : 1; $results_per_page = 10; // number of results per page $skip = ($cur_page - 1) * $results_per_page; $total = get_total($docs, $dbc); $num_pages = ceil($total / $results_per_page); echo '<p></p>'; echo '<p><font color="gray">该语义关系出现于如下' . $total . '篇文献之中:</font></p>'; echo '<hr>'; $query = build_query($docs) . " LIMIT {$skip}, {$results_per_page}"; $result = mysqli_query($dbc, $query) or die('Error querying database.'); while ($row = mysqli_fetch_array($result)) { render_content($row); } if ($num_pages > 1) { generate_page_links($id, $cur_page, $num_pages); } ?> </div> <!-- Example row of columns --> <!-- /container --> <?php include_once "./foot.php";
//$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> <div class="col-md-4">