-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.php
47 lines (38 loc) · 1.21 KB
/
index.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
<?php
require 'vendor/autoload.php';
require 'dbconfig.php';
$app = new Slim\App();
//slim application routes
$app->get('/', function ($request, $response, $args) {
$response->write("Welcome to RESTful API Webservices");
return $response;
});
$app->get('/demo', function ($request, $response, $args) {
$response->write("Hello Demo Content!");
return $response;
});
$app->get('/users', 'getUsers');
$app->get('/users/{id}', function ($request, $response, $args) {
getUser($args['id']);
});
$app->post('/users', 'addUser');
$app->put('/users/:id', 'updateUser');
$app->delete('/users/:id', 'deleteUser');
$app->run();
function getUsers() {
$sql_query = "select * FROM users ORDER BY user_name";
$dbCon = connect_db();
$sql_exe = $dbCon->query($sql_query);
$users = $sql_exe->fetch_all(MYSQLI_ASSOC);
$dbCon = null;
echo '{"users": ' . json_encode($users) . '}';
}
function getUser($id) {
$sql_query = "select * FROM users WHERE users_id=$id";
$dbCon = connect_db();
$stmt = $dbCon->query($sql_query);
$user = $stmt->fetch_all(MYSQLI_ASSOC);
$dbCon = null;
echo '{"user": ' . json_encode($user) . '}';
}
?>