forked from TschiwenGu/MasterThesis
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsearch.php
136 lines (122 loc) · 4.23 KB
/
search.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
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Search Result - Microservice Migration Meta-Approach Web-based Tool</title>
<meta name="author" content="QiwenGu">
<link rel="icon" href="logo.png">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="css/style.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
<script type="text/javascript" src="frontend.js"></script>
</head>
<body>
<div class="container-fluid" style="padding:30px">
<div class="row">
<div class="col-md-12">
<h3><button onClick="self.close()" type="button" class="btn btn-link btn-lg"><< Back to Index Page</button></h3>
<div class="page-header" style="margin-top:20px">
<h1>
Search String: <small id="DefaultString"></small>
</h1>
<h3 id="ShowSearchString"></h3>
</div>
<div class="row" style="margin-top:20px">
<div class="col-md-12">
<h4 id="ResultCount">
Result list:
</h4>
</div>
</div>
<div class="row" style="margin-top:20px">
<div class="col-md-4 text-center">
<button class="btn btn-outline-success" name="sort" id="IDSort" value="IDSort" onclick="sortTable(0)">IDSort
</button>
</div>
<div class="col-md-4 text-center">
<button class="btn btn-outline-success" name="sort" id="YearSort" value="YearSort" onclick="sortTable(2)">YearSort
</button>
</div>
<div class="col-md-4 text-center">
<button class="btn btn-outline-success" name="sort" id="RelevanceSort" value="RelevanceSort" onclick="sortTable(5)">RelevanceSort
</button>
</div>
</div>
</div>
</div>
</div>
<div class="row" style="padding-left:30px ; padding-right:30px">
<div class="col-md-12">
<table class="table table-bordered" id="ResultTable">
<thead>
<tr class="table-success">
<th>
#
</th>
<th>
Title
</th>
<th>
Year
</th>
<th>
Author
</th>
<th>
Missing String
</th>
<th>
Recommendation(%)
</th>
</tr>
</thead>
<tbody>
<?php
include('functions.php');
$servername = "localhost";
$username = "user";
$password = "";
$dbname = "migration";
$resultArray = array();
//Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
//Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
//Call different method by different submit button
if (isset($_REQUEST['subject'])) {
/*# search-buttons were clicked
switch ($_REQUEST['subject']) {
case 'ShowAll':
$resultArray = showAll($conn);
break;
case 'Search':*/
$resultArray = search($conn);
/*break;
}*/
}
?>
</tbody>
</table>
</div>
</div>
<div class="row" style="padding:30px; margin-top:20px">
<div class="col-md-12">
<h4 id="ExcludedCount"></h4>
</div>
</div>
<?php
$excludedArray = searchExluded($conn);
$conn->close();
?>
<script>
$(document).ready(function() {
sortDescend(5) //Automatic sort table after page generated by match score
});
</script>
</body>
</html>