-
Notifications
You must be signed in to change notification settings - Fork 0
/
source.php
46 lines (33 loc) · 1.44 KB
/
source.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php # article.php
$page_title = '电子资源';
include ('./includes/header.html');
?>
<div class="uk-panel uk-panel-box">
<?php
require_once('includes/sql.php'); //sql
require ('mysqli_connect.php'); // Connect to the db.
// if(isset($_GET['aid'])&&filter_var($_GET['aid'],FILTER_VALIDATE_INT,array('min_rang'=>1))){
$aid = $_GET['aid'];
$aid = str_check($aid);
$aid = num_check($aid);
// Make the query:
$q = "SELECT CONCAT(s_name) AS title, CONCAT(s_text) AS art,CONCAT(s_pro) AS pro,CONCAT(s_src) AS src,CONCAT(s_date) AS dr FROM source WHERE ID=$aid";
$r = @mysqli_query ($dbc, $q); // Run the query.
// Count the number of returned rows:
$num = mysqli_num_rows($r);
if ($num > 0) { // If it ran OK, display the records.
$row = mysqli_fetch_array($r, MYSQLI_ASSOC);
//$page_title = '. $row['title'] .';
echo '<div class="uk-text-center"><h2>' . $row['title'] . '</h2><p><i class="uk-icon-clock-o"></i>'.$row['dr'].' | <i class="uk-icon-home"></i>厂商: '.$row['pro'].' | <a href="'.$row['src'].'"><i class="uk-icon-link"></i></a>'.$row['src'].'</p></div><p>'.$row['art'].'</p>';
echo ''; // Close the table.
mysqli_free_result ($r); // Free up the resources.
} else { // If no records were returned.
require ('./includes/login_functions.inc.php');
redirect_user('./404.php');
}
mysqli_close($dbc); // Close the database connection.
?>
</div>
<?php
include('./includes/footer.html');
?>