$value) {
if ($key != "") {
array_push($keys, "[" . htmlspecialchars($key) . "]");
array_push($values, htmlspecialchars($value));
$count++;
}
}
array_push($values, $_SESSION['UserID']); //將 [uploaderID] 放入
$placeholder = $placeholder . str_repeat(",?", $count - 1);
$params = implode(",", $keys);
$sql = "IF NOT EXISTS (SELECT [APIName] FROM [API_Table] WHERE [APIName] = '{$_POST["APIName"]}')
BEGIN
INSERT INTO [API_Table]
(
" . $params . ",[uploaderID]
)
VALUES
(" . $placeholder . ",?);
END";
$stmt = sqlsrv_query($conn, $sql, $values);
if ($stmt === false) {
if (($errors = sqlsrv_errors()) != null) {
foreach ($errors as $error) {
echo "SQLSTATE: " . $error['SQLSTATE'] . "
";
echo "code: " . $error['code'] . "
";
echo "message: " . $error['message'] . "
";
}
}
} else {
include("api_video_tool.php");
}
} else
echo "Upload folder name is empty";
} else
echo "Upload files is empty";