addCoding.php

<?php

include("connection.php");

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    echo "Coding not registered.";
    die("Connection failed: " . mysql_error());
}
if ($_POST["type"]=="i") {
    $boundaries = $_POST["x1"] . ":" . $_POST["y1"] . ":" . $_POST["x2"] . ":" . $_POST["y2"];
    }
if ($_POST["type"]=="v") {
    $boundaries = $_POST["x1"] . ":" . $_POST["y1"];
    }

$sql = "INSERT INTO sourceCoding (source_id, codes_id, boundaries, owner, status, memo) VALUES ('" . $_POST["source_id"] . "','" . $_POST["codes_id"] . "','" . $boundaries . "','" . $_POST["owner"] . "','" . $_POST["status"] . "','" . $_POST["memo"] ."')";

if (mysqli_query($conn, $sql)) {
    echo "New coding registered!";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>