function setIssueId()
{
$dbh = openDBConnect();
$sql = "SELECT * FROM issues";
$result = $dbh->prepare($sql);
$result->execute();
return "TT-" . ($result->rowCount() + 1);
}
<?php
include 'dbhelper.php';
$dbh = openDBConnect();
$res = -1;
if (isset($_POST['issue']) && !empty($_POST['issue'])) {
$issue = json_decode($_POST['issue'], true);
$issueid = setIssueId();
$status = "todo";
$comment = 'kein kommentar';
$attachment = 'kein anhang';
//title attribute must not be empty
if ($issue['title'] != "") {
$sql = "INSERT INTO issues (_id, title, description, reporter, priority, status, assigned_to, category, comment, attachment) VALUES (:issueid, :title, :description, :reporter, :priority, :status, :assigned_to, :category, :comment, :attachment)";
$stmt = $dbh->prepare($sql);
$stmt->bindParam(':issueid', $issueid);
$stmt->bindParam(':title', $issue['title']);
$stmt->bindParam(':description', $issue['description']);
$stmt->bindParam(':reporter', $issue['reporter']);
$stmt->bindParam(':priority', $issue['priority']);
$stmt->bindParam(':status', $status);
$stmt->bindParam(':assigned_to', $issue['assigned_to']);
$stmt->bindParam(':category', $issue['category']);
$stmt->bindParam(':comment', $comment);
$stmt->bindParam(':attachment', $attachment);
$res = $stmt->execute();
} else {
$res = -2;
}
echo json_encode($res);
}
