-
Notifications
You must be signed in to change notification settings - Fork 9
/
Copy pathview_allbooks.php
116 lines (103 loc) · 4.41 KB
/
view_allbooks.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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<?php include 'header.php';?>
<?php include 'nav_viewallbooks.php';?>
<?php include 'dbcon.php';?>
<div class="container">
<!-- <div class="col-xs-12 col-sm-9"> -->
<div class="row">
<?php
$user_query=mysql_query("select isbn from book where status != 'Archive'")or die(mysql_error());
while($row=mysql_fetch_array($user_query)){
//针对 Xampp 上 php提示 true 未定义变量
error_reporting(0);
$book_isbn=$row['isbn'];
// 静态测试
// 调试代码 $book_isbn = "9787111305958";
// 调试代码 echo $row['isbn'];
// 调试代码 echo '<br>';
//调用豆瓣 api 开始
$apikey = "06c70ebcddf6849b14552c3699e38dd1";
// 待解码的 JSON 字符串，必须是 UTF-8 编码数据
$json = file_get_contents("https://api.douban.com/v2/book/isbn/:$book_isbn?apikey=$apikey");
// true返回对象类型
$data = json_decode($json,ture);
// 图书标题
$title = $data['title'];
// 图书副标题
$subtitle = $data['subtitle'];
// 作者信息
$author = $data['author'][0];
// 封面
$images_small = $data['images']['small'];
$images_medium = $data['images']['medium'];
$images_large = $data['images']['large'];
// 出版日期
$pubdate = $data['pubdate'];
// 出版社
$publisher = $data['publisher'];
// ISBN
$isbn13 = $data['isbn13'];
// author_intro
$author_intro = $data['author_intro'];
// summary
$summary = $data['summary'];
// 豆瓣直达
$alt = $data['alt'];
?>
<!-- HTML here -->
<!-- 预留 container -->
<div class="col-xs-6 col-lg-3">
<div class="thumbnail" style="width:280px;height:230px;">
<img src="<?php echo $images_medium;?>" alt="<?php echo $title." ".$subtitle;?> "class="img-responsive">
<div class="caption text-center" style="position:absolute; bottom:20px; left:30px">
<p class="text-center"><?php echo $title ?></p>
<a href="#" class="btn btn-primary" role="button">成员借阅</a>
<a target=_blank href="<?php echo $alt;?>" class="btn btn-success" role="button">豆瓣直达</a>
<a id="temp1" tabindex="0" class="btn btn-info" role="button" data-toggle="popover" title="<?php echo $title;?>">详情</a>
<!-- <a target=_blank href="book_info.php" class="btn btn-info" role="button">详情</a> -->
<!-- <?php echo $summary; ?> -->
</div>
</div>
</div>
<!-- 初始化 弹出框 javascript -->
<script>
$(function () {
$('[data-toggle="popover"]').each(function () {
var element = $(this);
var id = element.attr('id');
var txt = element.html();
element.popover({
trigger: 'manual',
placement: 'right', //top, bottom, left or right
title: txt,
html: 'true',
content: ContentMethod(txt),
}).on("mouseenter", function () {
var _this = this;
$(this).popover("show");
$(this).siblings(".popover").on("mouseleave", function () {
$(_this).popover('hide');
});
}).on("mouseleave", function () {
var _this = this;
setTimeout(function () {
if (!$(".popover:hover").length) {
$(_this).popover("hide")
}
}, 100);
});
});
});
function ContentMethod(txt) {
return '<table class="table table-bordered"><tr><td>' + txt + '</td><td>BB</td><td>CC</td><td>DD</td></tr>' +
'<tr><td>' + txt + '</td><td>BB</td><td>CC</td><td>DD</td></tr>' +
'<tr><td>' + txt + '</td><td>BB</td><td>CC</td><td>DD</td></tr>'+
'<tr><td><?php echo $title ?></td><td>BB</td><td>CC</td><td>DD</td></tr></table>';
}
</script>
<!-- while 循环结束 -->
<?php } ?>
<!-- end of row -->
</div>
<!-- end of col-xs-12 col-sm-9 -->
<!-- end of container -->
</div>