Reaper/database.php at master · lawdalana/Reaper · GitHub

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
<?php
$host = "localhost";
$username = "root";
$password = 1234;
$tablename = "test";
$connection = mysqli_connect($host, $username, $password, $tablename);
// $sql = "select id, username, title, fav from result where title like '%".$_POST['search']."%'";
$sql = "select title, fav, chapter, visitor_all, visitor, id, username, choose
from result
where title like '%".$_POST['search']."%'
AND DATEDIFF(NOW(),updated)<=30
AND published=\"N\"
AND chapter>=28
order by result_value desc, fav desc";
$result = mysqli_query($connection, $sql);
$output = "<h4 alias='center'> Search Result</h4>";
if(mysqli_num_rows($result)>0){
  $output .= "<table class='table'
        <tr>
          <th>ID</th>
          <th>Username</th>
          <th>Title</th>
          <th>Fav</th>
          <th>Chapter</th>
          <th>Visitor_All</th>
          <th>Visitor</th>
          <th>Choose</th>
        </tr>
  ";
  while($tmp = mysqli_fetch_assoc($result)) {
    // Href Link
    $linkMyid = "https://my.dek-d.com/".$tmp["username"];
    $linkNovel = $linkMyid."/story/view.php?id=".$tmp["id"];

    // Data String show novel detail in html format
    if($tmp["choose"]==0){
      $output.="<tr class='statusNovel'>";
    }
    else if ($tmp["choose"]==1) {
      $output.="<tr class='statusNovel-bad'>";
    }
    else if ($tmp["choose"]==2) {
      $output.="<tr class='statusNovel-wait'>";
    }
    else if ($tmp["choose"]==3) {
      $output.="<tr class='statusNovel-good'>";
    }
    $output.="<td class='showid'>". $tmp["id"]. "</td>".
    "<td class='itemuser'><a target='_blank' href='".$linkMyid."'>". $tmp["username"] ."</a></td>".
    "<td class='itemtitle'><a target='_blank' href='".$linkNovel."'>". $tmp["title"] ."</a></td>".
    "<td class='showstat'>". $tmp["fav"]. "</td>".
    "<td class='showstat'>". $tmp["chapter"]. "</td>".
    "<td class='showstat'>". $tmp["visitor_all"]. "</td>".
    "<td class='showstat'>". $tmp["visitor"]. "</td>".

    // Create button
    "<td class='button-state'>".
    "<div class='btn-group' role='group'>".
      "<button type='button' class='btn btn-success glyphicon glyphicon-thumbs-up' id='good'></button>".
      "<button type='button' class='btn btn-warning glyphicon glyphicon-time' id='wait'></button>".
      "<button type='button' class='btn btn-danger glyphicon glyphicon-thumbs-down' id='bad'></button>".
    "</div></td></tr>";
}
    $output.="</table>";
    echo $output;
}
else{
  echo "Data not found<br>";
}
?>