-
Notifications
You must be signed in to change notification settings - Fork 0
/
add-category.php
47 lines (35 loc) · 1.12 KB
/
add-category.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_once 'inc/headers.php';
require_once 'inc/functions.php';
$categoryName = filter_input(INPUT_POST, "categoryName");
if (!isset($categoryName) || empty($categoryName)) {
http_response_code(400);
print json_encode(array("message" => "Tuoteryhmän nimi puuttuu "));
exit;
}
try {
$db = openDB();
$responseMessage = checkCategory($db, $categoryName);
http_response_code(200);
print json_encode(array("message" => $responseMessage));
exit();
} catch (PDOException $error) {
returnError($error);
}
function checkCategory($db, $userInput) {
$sql = "SELECT `nimi` FROM `tuoteryhma` WHERE `nimi` = ?";
$pdoStatement = $db->prepare($sql);
$pdoStatement->bindParam(1, $userInput);
$pdoStatement->execute();
$categoryName = $pdoStatement->fetchColumn();
if(empty($categoryName)) {
$sqlCreate = "INSERT INTO tuoteryhma(nimi) VALUES (?)";
$pdoCreate = $db->prepare($sqlCreate);
$pdoCreate->bindParam(1, $userInput);
$pdoCreate->execute();
$categoryName = $pdoCreate-> fetchColumn();
return $userInput . " tuoteryhmä luotu";
}
return $userInput . " tuoteryhmä on jo luotu";
}
?>