-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathadd.php
56 lines (50 loc) · 1.35 KB
/
add.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
<form action="/add.php" method="post">
<label>name</label>
<input type="text" name="name">
<label>model</label>
<input type="text" name="model">
<label>token</label>
<input type="text" name="token">
<label>ip</label>
<input type="text" name="ip">
<input type="submit">
</form>
<?php
use App\SQLite3Wrapper;
require_once __DIR__ . '/vendor/autoload.php';
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
$dotenv->load();
$checkRequiredParams = function ($requiredParams, $POST){
foreach($requiredParams as $requiredParam) {
if (!in_array($requiredParam, array_keys($POST)) || empty($POST[$requiredParam])) {
return false;
}
return true;
}
};
$requiredParams = [
'name',
'model',
'token',
'ip',
];
if ($checkRequiredParams($requiredParams, $_POST)) {
$stmt = SQLite3Wrapper::getInstance()->prepare(
"INSERT INTO devices (
'name',
'model',
'token',
'ip'
)
VALUES (
:name,
:model,
:token,
:ip
);
");
foreach($requiredParams as $requiredParam) {
$stmt->bindValue($requiredParam, $_POST[$requiredParam], SQLITE3_TEXT);
}
$stmt->execute();
}