-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathserver1.php
More file actions
51 lines (48 loc) · 1.6 KB
/
server1.php
File metadata and controls
51 lines (48 loc) · 1.6 KB
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
<?php
$srvr="localhost";
$db="test";
$usr="user";
$pswd="pass";
$cn = mysqli_connect ($srvr, $usr, $pswd, $db)
or die("connection failed");
if ($_GET['alltickets']) {
// mysqli_query($cn, "SELECT * FROM tickets")
// or die('failed to get table');
if ($res = mysqli_query($cn,'SELECT * FROM tickets')) {
$rows = [];
while($r = mysqli_fetch_assoc($res)) {
$rows[] = $r;
}
echo json_encode($rows);
}
} elseif ($_GET['ticketid']) {
$ticketid = mysqli_real_escape_string($cn, $_GET['ticketid']);
$messages = mysqli_query($cn, "SELECT * FROM `messages` WHERE ticketid = $ticketid");
$ticket = mysqli_query($cn, "SELECT * FROM `tickets` WHERE id = $ticketid");
$op = [];
$op['ticket'] = mysqli_fetch_assoc($ticket);
//$op[ticket] = 'hi';
$op['messages'] = [];
while($r = mysqli_fetch_assoc($messages)) {
$op['messages'][] = $r;
}
echo json_encode($op);
}
if ($_POST['new'] === 'msg' && $_POST['ticketid'] && $_POST['user'] && $_POST['content']) {
$ticketid = mysqli_real_escape_string($cn, $_POST['ticketid']);
$user = mysqli_real_escape_string($cn, $_POST['user']);
$content = mysqli_real_escape_string($cn, $_POST['content']);
$insert = "INSERT INTO messages (ticketid, user, content) VALUES ('$ticketid', '$user', '$content')";
if (mysqli_query($cn, $insert)) {
$id = mysqli_insert_id($cn);
$created = mysqli_query($cn, "SELECT * FROM `messages` WHERE id = $id");
http_response_code(201);
$res = mysqli_fetch_assoc($created);
$res = json_encode($res);
} else {
http_response_code(500);
$res = mysqli_error($db) . "Unable to save your message to database";
}
echo $res;
}
?>