-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathgetpic.php
102 lines (82 loc) · 4.21 KB
/
getpic.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
<?php
$id = $_POST["id"];
require_once("password.php");
$conn = new mysqli($servername , $username, $password);
if ($conn -> connect_error) {
die("ERROR CONNECTING" . $conn -> connect_error);
}
mysqli_select_db($conn , "yiyandingzhen");
$maxrandval = mysqli_fetch_array($conn -> query("SELECT MAX(pic_id) FROM yiyandingzhen"));
$rand = rand(0 ,(int)$maxrandval[0]);
$dbsql = 'SELECT * FROM yiyandingzhen';
$retvar = $conn -> query($dbsql);
$data = mysqli_fetch_all($retvar);
//避免结果不存在
while ((mysqli_fetch_array($conn -> query("SELECT COUNT(pic_id) FROM yiyandingzhen where pic_id ='$rand'")))[0] == 0){
$rand = rand(0 ,(int)$maxrandval[0] - 1);
}
if($id !== null){
$verified = mysqli_fetch_array($conn -> query("SELECT verified FROM yiyandingzhen WHERE pic_id = {$id}" ));
if ($verified[0] == 1){
$fore = mysqli_fetch_array($conn -> query("SELECT fore FROM yiyandingzhen WHERE pic_id = {$id}" ));
$mid = mysqli_fetch_array($conn -> query("SELECT mid FROM yiyandingzhen WHERE pic_id = {$id} " ));
$suffix = mysqli_fetch_array($conn -> query("SELECT suffix FROM yiyandingzhen WHERE pic_id = {$id} " ));
$picPath = mysqli_fetch_array($conn -> query("SELECT pic_path FROM yiyandingzhen WHERE pic_id = {$id} " ));
$picFolderPath = "pic";
$retarr[] = array(
'fore' => $fore,
'mid' => $mid,
'suffix' => $suffix,
'picpath' => $picPath,
'request-id' => $id,
'verified' => $verified);
echo json_encode($retarr);
}else{
$fore = mysqli_fetch_array($conn -> query("SELECT fore FROM yiyandingzhen WHERE pic_id = 301" ));
$mid = mysqli_fetch_array($conn -> query("SELECT mid FROM yiyandingzhen WHERE pic_id = 301 " ));
$suffix = mysqli_fetch_array($conn -> query("SELECT suffix FROM yiyandingzhen WHERE pic_id = 301 " ));
$picPath = mysqli_fetch_array($conn -> query("SELECT pic_path FROM yiyandingzhen WHERE pic_id = 301 " ));
$retarr[] = array(
'fore' => $fore,
'mid' => $mid,
'suffix' => $suffix,
'picpath' => $picPath,
'request-id' => $id,
'verified' => $verified);
echo json_encode($retarr);
}
}else{
$verified = mysqli_fetch_array($conn -> query("SELECT verified FROM yiyandingzhen WHERE pic_id = {$rand}" ));
if ($verified[0] == 1){
$fore = mysqli_fetch_array($conn -> query("SELECT fore FROM yiyandingzhen WHERE pic_id = {$rand} " ));
$mid = mysqli_fetch_array($conn -> query("SELECT mid FROM yiyandingzhen WHERE pic_id = {$rand} " ));
$suffix = mysqli_fetch_array($conn -> query("SELECT suffix FROM yiyandingzhen WHERE pic_id = {$rand} " ));
$picPath = mysqli_fetch_array($conn -> query("SELECT pic_path FROM yiyandingzhen WHERE pic_id = {$rand} " ));
$picFolderPath = "pic";
$retarr[] = array(
'fore' => $fore,
'mid' => $mid,
'suffix' => $suffix,
'picpath' => $picPath,
'rand_status' => $rand_status,
'rand' => $rand,
'request-id' => $id,
'verified' => $verified
);
echo json_encode($retarr);
}
else{
$fore = mysqli_fetch_array($conn -> query("SELECT fore FROM yiyandingzhen WHERE pic_id = 114514" ));
$mid = mysqli_fetch_array($conn -> query("SELECT mid FROM yiyandingzhen WHERE pic_id = 114514 " ));
$suffix = mysqli_fetch_array($conn -> query("SELECT suffix FROM yiyandingzhen WHERE pic_id = 114514 " ));
$picPath = mysqli_fetch_array($conn -> query("SELECT pic_path FROM yiyandingzhen WHERE pic_id = 114514 " ));
$retarr[] = array(
'fore' => $fore,
'mid' => $mid,
'suffix' => $suffix,
'picpath' => $picPath,
'verified' => $verified);
echo json_encode($retarr);
}
}
?>