Repository navigation
Expand file tree
/
Copy pathapi.php
More file actions
59 lines (52 loc) · 1.76 KB
/
Copy pathapi.php
File metadata and controls
59 lines (52 loc) · 1.76 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
52
53
54
55
56
57
58
59
<?php
header("Access-Control-Allow-Origin: " . ALLOWED_ORIGIN);
header("Content-Type: application/json; charset=UTF-8");
header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE');
header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");
include 'db.php';
$request = $_SERVER['REQUEST_METHOD'];
$data = json_decode(file_get_contents('php://input'), true);
switch ($request) {
case 'GET':
manageGet($pdo);
break;
case 'POST':
managePost($pdo, $data);
break;
case 'PUT':
managePut($pdo, $data);
break;
case 'DELETE':
manageDel($pdo, $data);
break;
default:
echo json_encode(['message' => 'Error request method']);
break;
}
function manageGet($pdo) {
$sql = "SELECT * FROM users";
$stmt = $pdo->prepare($sql);
$stmt->execute();
$items = $stmt->fetchAll(PDO::FETCH_ASSOC);
http_response_code(200);
echo json_encode($items);
}
function managePost($pdo, $input) {
$sql = "INSERT INTO users (name, email) VALUES (:name, :email)";
$stmt = $pdo->prepare($sql);
$stmt->execute(['name' => $input['name'], 'email' => $input['email']]);
echo json_encode(['message' => 'User created!']);
}
function managePut($pdo, $input) {
$sql = "UPDATE users SET name = :name, email = :email WHERE id = :id";
$stmt = $pdo->prepare($sql);
$stmt->execute(['name' => $input['name'], 'email' => $input['email'], 'id' => $input['id']]);
echo json_encode(['message' => 'User updated!']);
}
function manageDel($pdo, $input) {
$sql = "DELETE FROM users WHERE id = :id";
$stmt = $pdo->prepare($sql);
$stmt->execute(['id' => $input['id']]);
echo json_encode(['message' => 'User deleted!']);
}
?>